Jump to content
Forums are read-only ×
Larry Ullman's Book Forums

armlocker

Members
 View Profile  See their activity

  • Posts

    83

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by armlocker

    Goodies Link Missing (Page 209)

    in Effortless E-Commerce with PHP and MySQL

    Posted

    Thanks Larry, I have managed to set up the mod_rewrite working within the site, but fluke - I don't know what I did except play around in hosting and viola, the Goodies link now works too :D

     

    Fix mod_rewrite and you fix the Goodies link (www...../shop/goodies)

     

    and the other thing found out in the forum is making all links begin with a /, as opposed to .. (like in the beginers php).

     

    PS: everything after page 210 is falling into place really easily for once and the whole shop is nearly up!!

     

    Cheers

    Goodies Link Missing (Page 209)

    in Effortless E-Commerce with PHP and MySQL

    Posted

    Hi there.

     

    Problem:

    The Goodies link doesn't; but the Coffee link works.

     

    I appreciate there could be various possibilities as to why this is happening, thus not sure how to tell you what I think should be done.

     

    One question on page 175 I don't understand is: How to turn on mod_rewrite? How do you know its working? (I'm only up to page 209, so anything after that is above me)

     

    Guidance much appreciated!

    Stored Procedure Error Message

    in Effortless E-Commerce with PHP and MySQL

    Posted

    All sorted. My web hosting company didn't support Stored Procedures so I found a alternative php script written by the one and only LU is some of his blogs; here are the links for future references:

     

     

    CHAPTER 8 ALTERNATIVE TO STORED PROCEDURES = shop.php / browse.php / sales.php / index.php
     
    CHAPTER 9 ALTERNATIVE TO STORED PROCEDURES = cart.php / wishlist.php
     
    CHAPTER 10 ALTERNATIVE TO STORED PROCEDURES = checkout.php / billing.php / final.php

    The Classic Problem

    in Effortless E-Commerce with PHP and MySQL

    Posted

    Dear All -- last nights support was awesome!

    I have found the questions to my answers and here they are:

     

     

     

    CHAPTER 8 ALTERNATIVE TO STORED PROCEDURES = shop.php / browse.php / sales.php / index.php
     
    CHAPTER 9 ALTERNATIVE TO STORED PROCEDURES = cart.php / wishlist.php
     
    CHAPTER 10 ALTERNATIVE TO STORED PROCEDURES = checkout.php / billing.php / final.php
    • Upvote 1

    The Classic Problem

    in Effortless E-Commerce with PHP and MySQL

    Posted

    Anotonio, are Nowegians always this kind? I really appreciate your call, and if you were in London I would pat you on the back and buy a Heineken.

     

    I do want to learn this thoroughly with a view to designing a really cool website. So what I want to do in this case is research another host: (HostGator; iPage; DreamHost; Go Daddy, etc) and at the same time find out how to convert stored procedures to standard PHP MySql, which I will set up a new post for, because my original problem has now escalated to level 10!!

     

    Thanks, Best Regards, London, UK

    The Classic Problem

    in Effortless E-Commerce with PHP and MySQL

    Posted

    I can't believe it but my hosting provider Fatcow doesn't support stored procedures!

    I am truly snookered because I can't proceed further with the exercises in the book and a quick trawl online shows it will cost an arm and a leg to join a hosting company that supports stored procedures.

     

    There must be another way around this, I should reall post this under a different heading really.

    The Classic Problem

    in Effortless E-Commerce with PHP and MySQL

    Posted

    nope - that didn't work either Please see this:

    in the meantime I am still waiting for my hosting provider to get me about this "Create Routines" permissions as mentioned in the "big man's" book.

     

     

     

    Error

    SQL query:

    DELIMITER $$;
     

    MySQL said: b_help.png

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$' at line 1 

    The Classic Problem

    in Effortless E-Commerce with PHP and MySQL

    Posted

    Well well, I have been going round the blocks trying work out how to put this Stored Procedure into PHPMYaDMIN, and have been at loggerheads as to what is "Create Routines" permissions with the hosting company.

     

    For example, I am trying to do this (page 201) in the SQL box:

     

     

    DELIMITER $$
    CREATE PROCEDURE remove_from_wish_list (uid CHAR(32), type VARCHAR(6), pid MEDIUMINT)
    BEGIN
    DELETE FROM wish_lists WHERE user_session_id=uid AND product_type=type AND product_id=pid;
    END$$
    DELIMITER ;

     

     

     

    But all I keep getting is this error:

     

     

     

     

    Error

    SQL query:

    DELIMITER $$ CREATE PROCEDURE remove_from_wish_list( uid CHAR( 32 ) , TYPE VARCHAR( 6 ) , pid MEDIUMINT ) BEGIN DELETEFROM wish_lists WHERE user_session_id = uid AND product_type = TYPE AND product_id = pid;
     

    MySQL said: b_help.png

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
    CREATE PROCEDURE remove_from_wish_list (uid CHAR(32), type VARCHAR' at line 1 

    The Classic Problem

    in Effortless E-Commerce with PHP and MySQL

    Posted

    Hi there - the most hated problem has occurred (for amateurs at least)

     

    can't connect to database message

    An error occurred in script '/hermes/waloraweb004/b1384/moo.laissezfairelondonco/wolfcut.co.uk/views/home.html' on line 14:
    mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

     

     

    index.php line 14

    // Require the database connection:

    require ('../mysql.inc.php');

     

     

    folder structure

    mysql.inc.php (outside web root)

     

    beans (folder) --------- > index.php (with the error message)

                           --------- > billing.php

                           --------- > browse.php

                           --------- > etc...

     

     

    Stored Procedure Error Message

    in Effortless E-Commerce with PHP and MySQL

    Posted

    Dear All - can anyone see what the syntax error is in the following stored procedure error?

    Thanks

     

     

     

    SQL query:

    DELIMITER $$ CREATE PROCEDURE select_categories( TYPE VARCHAR( 6 ) ) BEGIN IF TYPE = 'coffee' THEN SELECT *
    FROM general_coffees
    ORDER BY category;
     

    MySQL said:

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
    CREATE PROCEDURE select_categories (type VARCHAR(6))
    BEGIN
    IF ty' at line 1
     

    Connection Error Message

    in PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition)

    Posted

    Hiya all

     

    I'm using a hosted server (FatCow).

     

     

    Folder Layout

    ecommerce (folder) ----> admin (folder) ----> add_print.php / add_artist.php

     
    mysqli_connect.php

     

    Add_print.php

    // This page allows the administrator to add a print (product).

     

    require ('../../mysqli_connect.php');
     
    // Create a temporary file name:
    $temp = '../../uploads/' . md5($_FILES['image']['name']);
     

     

    Error message:

    Could not connect to MySQL: Access denied for user 'tango'@'cgi1801.int.bizland.net' (using password: YES)

    Sql Error

    in PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition)

    Posted

    Can anyone see why PHPMYADMIN is spitting out this error message:

     

    MySQL said: 

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL,
    price DECIMAL(6,2) UNSIGNED NOT NULL,
    size VARCHAR(60) DEFAULT NULL,' at line 5

     

    Error
    SQL query:

    CREATE TABLE prints(

    print_id INT UNSIGNED NOT NULL AUTO_INCREMENT ,
    artist_id INT UNSIGNED NOT NULL ,
    print_name VARCHAR( 60 ) DEFAULT NOT NULL ,
    price DECIMAL( 6, 2 ) UNSIGNED NOT NULL ,
    size VARCHAR( 60 ) DEFAULT NULL ,
    description VARCHAR( 255 ) DEFAULT NULL ,
    image_name VARCHAR( 60 ) NOT NULL ,
    PRIMARY KEY ( print_id ) ,
    INDEX ( artist_id ) ,
    INDEX ( print_name ) ,
    INDEX ( price )
    ) ENGINE = MYISAM ;

     

     

    Much appreciated

    Chapter 5: Add_Pdf. Problem Locating Pdfs File In 'Config' File

    in Effortless E-Commerce with PHP and MySQL

    Posted

    I've amended the config fig to take care of that missing '/'.

     

    values now read like this:

     

      [HTTP_POST_FILES] => Array
							 (
								 [pdf] => Array
									 (
										 [name] => transformers 2 poster.PDF.pdf
										 [type] => application/pdf
										 [tmp_name] => /tmp/phpumhDHE
										 [error] => 0
										 [size] => 971389
									 )

						    )

					    [_REQUEST] => Array
							 (
								 [MAX_FILE_SIZE] => 1048576
								 [title] => tra
								 [description] => sdfasdf
								 [submit_button] => Add This PDF
								 [phpSESSID] => 08877f9689982589d29fefa1f4ac1137
							 )

					    [live] => 1
						 [contact_email] => jizzwit@gmail.com
						 [HTTP_SESSION_VARS] => Array
							 (
								 [reg_user_id] => 5
								 [user_admin] => 1
								 [user_id] => 5
								 [username] => Armlocker0358
								 [pdf] => Array
									 (
										 [tmp_name] => 81a11224ad91f1fecb9d5c01ac664dce51a4cd7d
										 [size] => 949
										 [file_name] => transformers 2 poster.PDF.pdf
									 )

						    )

					    [_SESSION] => Array
							 (
								 [reg_user_id] => 5
								 [user_admin] => 1
								 [user_id] => 5
								 [username] => Armlocker0358
								 [pdf] => Array
									 (
										 [tmp_name] => 81a11224ad91f1fecb9d5c01ac664dce51a4cd7d
										 [size] => 949
										 [file_name] => transformers 2 poster.PDF.pdf
									 )

						    )

					    [reg_user_id] => 5
						 [user_admin] => 1
						 [user_id] => 5
						 [username] => Armlocker0358
						 [dbc] => mysqli Object
							 (
							 )

					    [page_title] => Add a PDF
						 [pages] => Array
							 (
								 [Home] => index.php
								 [About] => #
								 [Contact] => #
								 [Register] => register.php
							 )

					    [this_page] => add_pdf.php
						 [v] => register.php
						 [k] => Register
						 [add_pdf_errors] => Array
							 (
							 )

					    [t] => tra
						 [d] => sdfasdf
						 [file] => Array
							 (
								 [name] => transformers 2 poster.PDF.pdf
								 [type] => application/pdf
								 [tmp_name] => /tmp/phpumhDHE
								 [error] => 0
								 [size] => 971389
							 )

					    [size] => 949
						 [tmp_name] => 81a11224ad91f1fecb9d5c01ac664dce51a4cd7d
						 [dest] => ./pdfs81a11224ad91f1fecb9d5c01ac664dce51a4cd7d_tmp
						 [fn] => transformers 2 poster.PDF.pdf
						 [q] => INSERT INTO pdfs (tmp_name, title, description, file_name, size) VALUES ('81a11224ad91f1fecb9d5c01ac664dce51a4cd7d', 'tra', 'sdfasdf', 'transformers 2 poster.PDF.pdf', 949)
						 [r] =>
					 )

		    )

    )

   [1] => Array
	 (
		 [file] => /hermes/waloraweb004/b1384/moo.laissezfairelondonco/wolfcut/add_pdf.php
		 [line] => 134
		 [function] => trigger_error
		 [args] => Array
			 (
				 [0] => The PDF could not be added due to a system error. We apologize for any inconvenience.
			 )

    )

)

    Chapter 5: Add_Pdf. Problem Locating Pdfs File In 'Config' File

    in Effortless E-Commerce with PHP and MySQL

    Posted

    yep slowly but surely.... I didn't know I had to give these guys values:

     

      $tmp_name = sha1($file['name'] . uniqid('',true));

  // Move the file to its proper folder but add _tmp, just in case:
  $dest =  PDFS_DIR . $tmp_name . '_tmp';
  if (move_uploaded_file($file['tmp_name'], $dest)) {

   // Store the data in the session for later use:
   $_SESSION['pdf']['tmp_name'] = $tmp_name;
   $_SESSION['pdf']['size'] = $size;
   $_SESSION['pdf']['file_name'] = $file['name'];

     

    ===================

     

    On a brighter note, I've complete everything else on knowledge is power, including the paypal side. If you have time, check it out at www.wolfcut.co.uk I'd really like to say thank you again for all your help..... onto Coffee Shop next :)

×
×
  • Create New...