Re: [PHP-DB] Re: Newbie Setup Trouble
Mike, There is no database sepcified in your code anywhere. The line: $result = mysql_query($sql); does not specify which database you are connecting to either. You can specify the database in the line: $link = mysql_connect($host,$user,$password,$database);//or in a separate line with the function mysql_select_db(database name,$link)//where $link is the connection info above And then use in the line: $result = mysql_query($link, $sql); //this enable the query to find the connection and the code. I hope this makes sense. I have only been doing this a couple of weeks. Some books have the ($link,$sql) order reversed which will also give you an error. IN ADDITION, if you are using mysqli you need to enter this ext in the PHP.ini file. I can only connect using mysqli and not mysql. Good luck, jzf This should help you. Mike Rondeau wrote: Hello, I have just begun study of using PHP, MySQL and Apache server. Right now I'm following a book, PHP and MySQL For Dummies and am having trouble already. I must be a REAL dummy! I have installed all 3 programs but something is not right somewhere. Being so new to this I am having a real time trying to figure out which program is messed up. Certain things work, but others don't. For instance, my book told me how to make a phpinfo.php page, which works fine. But it also tells me to create some other pages to test if PHP and MySQL are working or not. I followed the scripts provided exactly but keep getting syntax errors, even though the script is just what the authors wrote. For instance, it said to make a page and call it mysql_up.php. Here's the script for it: html headtitleTest MySQL/title/head body !-- mysql_up.php -- ?php $host=localhost; $user=blablablabla; $password=blablabla; mysql_connect($host,$user,$password); $sql=show status; $result = mysql_query($sql); if ($result == 0) { echo bError . mysql_errno() . : . mysql_error() . /b; } else { ? !-- Table that displays the results -- table border=1 trtdbVariable_name/b/tdtdbValue/b /td/tr ?php for ($i = 0; $i mysql_num_rows($result); $i++) { echo TR; $row_array = mysql_fetch_row($result); for ($j = 0; $j mysql_num_fields($result); $j++) { echo TD . $row_array[$j] . /td; } echo /tr; } ? /table ?php } ? /body/html But when I open it in my browser I get this error: Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10 Could anyone of you smart people point me in the right direction? I'd be pulling my hair out if I had any left :) I can't make any progress with this study until I know my 3 programs are talking to eachother properly, but my book gives no info on this error. Thanks a millionfold for any advice, and I appologise for the length of this post. Sincerely, Mike Rondeau -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Newbie Setup Trouble
Its very likely that he has installed the latest versions of mysql and php and is using the incorrect library to try and make it go...change to the latest mysqli librabry and try again basiten From: Stefan Reimers [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Re: Newbie Setup Trouble Date: Mon, 07 Feb 2005 16:17:45 +0100 Hi! first of all, the fatal error indicates that the mysql extension is missing or just disabled. To find out what's wrong check for the file php_mysql.(so|dll) [using *nix|Windows] in the php-extension directory. If present, then open the php.ini file and search for the string extension=php_mysql and delete the ; in front of it, if present. Stop and start webserver and try again. Alternatively you should install XAMPP or similar which installs Apache, PHP and MySQL at once. This makes life easier for beginners. Stefan Mike Rondeau wrote: Hello, I have just begun study of using PHP, MySQL and Apache server. Right now I'm following a book, PHP and MySQL For Dummies and am having trouble already. I must be a REAL dummy! I have installed all 3 programs but something is not right somewhere. Being so new to this I am having a real time trying to figure out which program is messed up. Certain things work, but others don't. For instance, my book told me how to make a phpinfo.php page, which works fine. But it also tells me to create some other pages to test if PHP and MySQL are working or not. I followed the scripts provided exactly but keep getting syntax errors, even though the script is just what the authors wrote. For instance, it said to make a page and call it mysql_up.php. Here's the script for it: html headtitleTest MySQL/title/head body !-- mysql_up.php -- ?php $host=localhost; $user=blablablabla; $password=blablabla; mysql_connect($host,$user,$password); $sql=show status; $result = mysql_query($sql); if ($result == 0) { echo bError . mysql_errno() . : . mysql_error() . /b; } else { ? !-- Table that displays the results -- table border=1 trtdbVariable_name/b/tdtdbValue/b /td/tr ?php for ($i = 0; $i mysql_num_rows($result); $i++) { echo TR; $row_array = mysql_fetch_row($result); for ($j = 0; $j mysql_num_fields($result); $j++) { echo TD . $row_array[$j] . /td; } echo /tr; } ? /table ?php } ? /body/html But when I open it in my browser I get this error: Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10 Could anyone of you smart people point me in the right direction? I'd be pulling my hair out if I had any left :) I can't make any progress with this study until I know my 3 programs are talking to eachother properly, but my book gives no info on this error. Thanks a millionfold for any advice, and I appologise for the length of this post. Sincerely, Mike Rondeau -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Newbie Setup Trouble
To all, I am sorry the correct line is: mysql_select_db($link,database name) If you are missing the database name you will get an error concerning undefined function. jzf J. Connolly wrote: Mike, There is no database sepcified in your code anywhere. The line: $result = mysql_query($sql); does not specify which database you are connecting to either. You can specify the database in the line: $link = mysql_connect($host,$user,$password,$database);//or in a separate line with the function mysql_select_db(database name,$link)//where $link is the connection info above And then use in the line: $result = mysql_query($link, $sql); //this enable the query to find the connection and the code. I hope this makes sense. I have only been doing this a couple of weeks. Some books have the ($link,$sql) order reversed which will also give you an error. IN ADDITION, if you are using mysqli you need to enter this ext in the PHP.ini file. I can only connect using mysqli and not mysql. Good luck, jzf -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php