xcrider2

Thanks very much HartleySan, Yes, this is tricky, but your suggestion works perfectly. I did notice that I had to put an extra \ in there because just one winds up escaping the single quote on the end. So, I settled on 'C:\xampp\htdocs\\' Hopefully, this thread will help others who come straight over from Larry's PHP6 And MySQL5 Quick Pro Guide with their handy Xampp installation. To these folks, I also recommend that you use the mysql Client from the command line interface, rather than phpMyAdmin, to set up the stored procedures. This was another tricky part for me, since phpMyAdmin doesn't seem to work consistently with stored procedures.

Ok, Thanks very much for the thorough explanation Terry... So, for an Xampp instalation with default settings, I believe that my BASE_URI for this excercise is: C:\xampp\htdocs\ex2\ Is there a practical way to test and confirm that the BASE_URI is correct? I suppose that if the application has access to the database, then the BASE_URI must be right, since the path to MYSQL is defined as: BASE_URI . 'mysqli.inc.php'

Thanks Larry, This is a good excuse to go back and learn to use the command line mysql client. phpMyAdmin is great for beginners, and I am going to miss using it as I go through this book, but I am sure there are other advantages to learning how to use mysql client. I found that mysql client is covered in chapter 4 of your PHP6 And MySQL5 Quick Pro Guide. I am good to go.

Thanks Terry, I am just using my local host and it is running mysqli. The procedures that I entered into the SQL command box are stored in the database, it is just that phpmyadmin doesn't recognize them at all. They don't show up on the main admin area with all the tables. You can't test them. You can't even tell that they are there unless you try to enter one again and it gives you an error that the procedure already exists. Or, if you run an information schema query it shows them, but you cannot edit them at all. I did a google search and found that it is a common, inconsistent problem. No clear solutions except using something other than phpmyadmin.... This is a shame, phpmyadmin is easy to learn and use.

I have the same lack of understanding of the URI and this thread is very helpful. Thanks. I think I now understand how to set it up on a hosted server, where you have a file structure like: /Users/Username/Sites/ex2/. This is how Larry's example is laid out in the downloadable code. How about for those working on a local host with Xampp for example? I am just unsure how far back we have to go to define the base URI of the site. I did not find any specific BASE_URI answer in phpinfo(). The "Document Root" is C:/xampp/htdocs So would the BASE_URI be something like C:/xampp/htdocs/ex2/ ? Or would it be /xampp/htdocs/ex2/ ? The REQUEST_URI when I ran php_info was /ex2/php_info.php So could the BASE_URI for those of us using a local host just be /ex2/ ? Or would you start with /Users/ when working on your local host as well? Thanks again for the helpful thread.....

Hello all, I am starting the stored procedures in chptr 8 and having difficulty testing them. I have always used phpMyAdmin, but it seems that this might not be the best thing for working with stored procedures. I can verify that the procedure exists with SELECT * FROM information_schema.routines; but I cannot edit them through the phpMyAdmin interface. Further, when I call a stored procedure to test it, I just get booted out of the ecommerce2 database and wind up on the phpMyAdmin homepage. Any suggestions would be greatly appreciated. phpMyAdmin Version information: 3.2.4 MySQL client version: 5.1.41 Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1