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
