costaM Posted June 2, 2013 Share Posted June 2, 2013 Dear Larry, I wish to request a full path to the mysql client using XAMPP in order to text procedures given in the book. The system of XAMPP is meeting the requirement for running procedures. I am using XAMPP, so, how can I do to have a figure 8.2 and test again the procedure created? Link to comment Share on other sites More sharing options...
Larry Posted June 4, 2013 Share Posted June 4, 2013 What operating system are you using and where did you install XAMPP? Link to comment Share on other sites More sharing options...
costaM Posted June 6, 2013 Author Share Posted June 6, 2013 Dear Larry, My OS is XP Pack 3 and I installed my XAMPP on E partition as C partition has some problem. Is in E partition I installed my OS. Link to comment Share on other sites More sharing options...
Larry Posted June 8, 2013 Share Posted June 8, 2013 Well, you didn't say exactly where XAMPP was installed, but see this: http://stackoverflow.com/questions/698914/how-can-i-access-the-mysql-command-line-with-xampp-for-windows ANd then replace c:\ with e:\ Link to comment Share on other sites More sharing options...
costaM Posted June 13, 2013 Author Share Posted June 13, 2013 Thank you Larry! Link to comment Share on other sites More sharing options...
shah Posted July 14, 2013 Share Posted July 14, 2013 I have uploaded my files to my hosting account but when i uploaded the sql it shows an error that #1227 - Access denied; you need the SUPER privilege for this operation.How can I get the super privilige. But if i remove the procedures from this sql file then it uploads perfectly. Link to comment Share on other sites More sharing options...
shah Posted July 14, 2013 Share Posted July 14, 2013 I am getting this error An error occurred in script '/home/bizsoft/public_html/hassaan/websol/ex2/html/index.php' on line 14:include() [function.include Please check it here http://hassaan.bizsofttech.com/websol/ex2/html/index.php Link to comment Share on other sites More sharing options...
margaux Posted July 14, 2013 Share Posted July 14, 2013 Your script can't find the mysql.inc.php file which is why you're getting the other errors. You need to specify in your include statement the full path to mysql_inc.php using relative or absolute paths. You might want to consider defining a BASE_URL and BASE_URI which is explained in this book. Also you may need to alter the permissions on your files - I think on windows you do so in the Properties/Security tab, but I'm not really familiar with windows. Link to comment Share on other sites More sharing options...
shah Posted July 14, 2013 Share Posted July 14, 2013 thanks alot for your reply.Please see here is my config file settings. // Determine location of files and the URL of the site://define ('BASE_URI', 'E:/wamp/www/ex2/'); when i was using this on wamp this was working on wamp.define ('BASE_URL', 'http://hassaan.bizsofttech.com/websol/ex2/'); but now i use my hosting server this is showing the above errordefine ('MYSQL', BASE_URL . 'mysql.inc.php'); hassaan.bizsofttech.com/websol/ex2/ is my url.what is the problem here please guide. Link to comment Share on other sites More sharing options...
margaux Posted July 14, 2013 Share Posted July 14, 2013 I'm not sure why my post didn't display? Try using just hassaan.bizsofttech.com/websol/ex2/ as the BASE_URL definition. If you can sign into your cpanel, you should see the file path to your root directory - its often displayed on the left side under Home Directory. Link to comment Share on other sites More sharing options...
Larry Posted July 15, 2013 Share Posted July 15, 2013 Not sure what happened, Margaux. The problem here is that the poster is confusing HTTP references with file system references. Shah, this book does assume complete comfort with PHP and MySQL. I worry that you're going to struggle with the rest of the material until you get better with the basics of PHP & MySQL Web development. Link to comment Share on other sites More sharing options...
shah Posted July 15, 2013 Share Posted July 15, 2013 Dear larry I am a web developer.I have developed custom websites with php but unable to get your method of developing websites.We make our database without defining procedures and I had not modified .htaccess file before.These topics are new for me that's why i am stuck over here. Dear margaux This is my file path in cpanel public_html/hassaan/websol/ex2 Link to comment Share on other sites More sharing options...
Larry Posted July 15, 2013 Share Posted July 15, 2013 Okay. I didn't mean any offense. I can understand that you've have done stored procedures or used .htaccess before. That's understandable enough for a reader of this book in my opinion. My concern was about the inability to include a file and the difference between using HTTP and the file system for that. Again, no offense meant. If you have a page in folder X and mysql.inc.php is in the x/includes folder, then you can just use 'includes/mysql.inc.php' for the value of the MYSQL folder, except when you get to a subdirectory (such as an admin folder). Link to comment Share on other sites More sharing options...
Recommended Posts