Re: Some PHP - mySQL help please ... new to both
Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Lou Picciano / Essex SystemsTo: MySQL List [EMAIL PROTECTED], [EMAIL PROTECTED] Omnis@comcast cc: .netSubject: Re: Some PHP - mySQL help please ... new to both 03/08/2002 07:14 PM Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
A quick diagnostic? Try the page phpinfo.php in the phpMyAdmin directory - this will give you the 'whole picture' in terms of your php installation... Even easier? Any php page which contains the code: ? phpinfo(); Will give you this full info report. Very useful! Lou Picciano Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some PHP - mySQL help please ... new to both
I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some PHP - mySQL help please ... new to both
Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some PHP - mySQL help please ... new to both
Is the syntax of the statement correct ? ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Todd | || Williamsen | || todd@williams| || en.net | ||| || 03/08/02 12:32| || PM| ||| |+ -| | | | To: 'Daniel Negron/KBE' [EMAIL PROTECTED], [EMAIL PROTECTED]| | cc: | | Subject: RE: Some PHP - mySQL help please ... new to both | -| Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some PHP - mySQL help please ... new to both
Did you check the mysql db, host, and user tables to make sure that 'localhost' and 'administrator' have appropriate permissions to use your desired database? This issue caused me much frustration until I had things set right. You should see something like the following. I'm assuming that your PHP application and your mysql db live on the same box. If it's a PHP issue, then I don't know what to advise you since I don't know PHP. mysql use mysql; mysql select * from user; +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | localhost | administrator | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | mysql select * from host; +-+---+-+-+- +-+-+---++-- ---+++ | Host| Db| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+---+-+-+- +-+-+---++-- ---+++ | localhost | your_db_name | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | mysql select * from db; +-+-+--+-+-- ---+-+-+-+---++- +++ | Host| Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+-+--+-+-- ---+-+-+-+---++- +++ | localhost (you could try % if the box isn't visible to anyone but you) | your_db_name | administrator | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing
Some PHP - mySQL help please ... new to both (Along same lines)
Along the same lines, I have run some scripts that give a similar error that time out is there something in php.ini or mysql that will alow the timing to not stop after 60seconds or 30seconds or something. Had a script to run and pull keywords from a massive db, and it kept timing out. Hope that make since, thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
If you're going to post this much information please use: mysql SELECT * FROM user \G so that this is actually readable. Thanks # Nathan - Original Message - From: Brian Warn [EMAIL PROTECTED] To: 'Daniel Negron/KBE' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 08, 2002 10:51 AM Subject: RE: Some PHP - mySQL help please ... new to both Did you check the mysql db, host, and user tables to make sure that 'localhost' and 'administrator' have appropriate permissions to use your desired database? This issue caused me much frustration until I had things set right. You should see something like the following. I'm assuming that your PHP application and your mysql db live on the same box. If it's a PHP issue, then I don't know what to advise you since I don't know PHP. mysql use mysql; mysql select * from user; +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | localhost | administrator | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | mysql select * from host; +-+---+-+-+- +-+-+---++-- ---+++ | Host| Db| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+---+-+-+- +-+-+---++-- ---+++ | localhost | your_db_name | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | mysql select * from db; +-+-+--+-+-- ---+-+-+-+---++- +++ | Host| Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+-+--+-+-- ---+-+-+-+---++- +++ | localhost (you could try % if the box isn't visible to anyone but you) | your_db_name | administrator | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try
Re: Some PHP - mySQL help please ... new to both
Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php