Php & SQL

Mr. Long · 01-14-2009, 11:02 AM

Ok I have a server with Apache2, PHP 5, and SQL 5.

I cannot get it to connect to the SQL server via PHP, and phpinfo() isnt showing SQL.

I have taken out the ; extension=mysql.so, in the php.ini. i have also verified that the extension dir is correct. and restarted the server. Any other ideas??

Cottsay · 01-14-2009, 10:17 PM

Can we get some more information? Distribution? Were they compiled or installed as packages? What type of SQL?

Also, verify that SQL is working. In MySQL, you just use the mysql command and enter your username and password...

--scott

Mr. Long · 01-15-2009, 08:36 AM

Fedora Core 6, mysql, yes SQL is working i have already made a database. as far as compiled or installed as packages i dont know cause i didnt install them

Cottsay · 01-15-2009, 10:02 AM

Alright, cool. Can you post the PHP script you're using to attempt to connect? I haven't had FC6 installed on a system for a while, but my F10 box doesn't have an extension entry in the php.ini for mysql. Also, you may want to try looking into your error log for apache

--scott

Mr. Long · 01-15-2009, 03:09 PM

<?php
$link = mysql_connect('192.168.0.5', 'usr', 'passwd') or die('Could not connect: ' . mysql_error());result($result);
?>

i have also tried localhost where the ip is

i have looked at the apache logs but the last error it shows was from 2 months ago (unless i am looking at the wrong log)

i have also tried phpMyAdmin and it says there is an error loading mysql, and to check php.ini..

Mr. Long · 01-15-2009, 03:26 PM

Ok i was looking at the wrong log, i have some errors, the mysql fatal error but that hasnt been showing anymore it is just a blank white screen now

TB0ne · 01-15-2009, 03:32 PM

Quote:

Originally Posted by Mr. Long

Ok i was looking at the wrong log, i have some errors, the mysql fatal error but that hasnt been showing anymore it is just a blank white screen now

Well, yeah....all your php script is doing is connecting to the database. You're not doing anything else, so what would you expect to see, other than a white screen???

Put some output in there...run a query or two, and print the results. Check the connection and echo back "Yes I connected!", and you'll see something.

Mr. Long · 01-15-2009, 03:57 PM

Quote:

Originally Posted by TB0ne

Well, yeah....all your php script is doing is connecting to the database. You're not doing anything else, so what would you expect to see, other than a white screen???

Put some output in there...run a query or two, and print the results. Check the connection and echo back "Yes I connected!", and you'll see something.

i used this code i found online (i dont know anything about php or sql)
<?php
$link = mysql_connect('localhost', 'usr', 'pass');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

and still white screen

TB0ne · 01-16-2009, 08:16 AM

Quote:

Originally Posted by Mr. Long

i used this code i found online (i dont know anything about php or sql)
<?php
$link = mysql_connect('localhost', 'usr', 'pass');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

and still white screen

Ok...have you check the Apache and/or PHP logs? Are you getting any errors???

Mr. Long · 01-16-2009, 09:05 AM

in the logs all i get is

sysname - - [16/Jan/2009:09:03:44 -0600] "POST /webpath HTTP/1.1" 200 -

in apache2 logs not php...there isnt anything in the php log