[RESOLVED] mysql_connect crashes

nosenseofhumor1

hi, whats wrong with my terrible script?? im new at this

i blocked out the stuff thats sensitive with X's

it gets to test3, but test4 doesnt show up

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Cp1252">
<title>phptest</title>
</head>
<body>
test1
<?php
        echo "test2";
        $username='XXXX';
        $password='XXXX';
        $database='XXXX;

    echo "test3";
    $conn=mysql_connect('localhost',$username,$password) or die ("cant connect");
    echo "test4";
    @mysql_select_db($database,$conn) or die("oops, sql died");

    echo "test5";

    $query = "SELECT path FROM files";
    $result=mysql_query($query);
    $num=mysql_numrows($result);
    $i=0;
    echo "test6 $i";
    while ($i < $num) {
            $path=mysql_result($result,$i,"path");
            echo "<b>$path<hr><br>";
            $i++;
    }
?>
test7
</body>
</html>

dalecosp

Try quoting (double quotes) around the $username and $password values ... ?

dalecosp

Incidentally, something like this:

die("can't connect: ".mysql_error());

might be helpful as well.

nosenseofhumor1

thanks for the quick response.
i tried it with regular quotes too, also i tried every combination of localhost in quotes, in single quotes and not in quotes at all but in all cases the

or die

half the of the statement never executes.

the only thing that appears on the page is
test1test2test3

is there a way to run the mysql_connect command outside of the php script and get more info out of it?

i mean, i can connect to the server fine from the shell with

mysql --user=XXXX--password=XXXX

maybe my mysql config is not allowing connections from php or something??

this is a new php+mysql+apache on gentoo setup im playing with

dalecosp

Well, throw in some more tests, I guess. Remove the "@" up there ... not sure, but I think error suppression wouldn't allow the die() statement to work there ... might be wrong. OTOH, I'm sure it's generally a bad idea to use "@" when debugging, like we are here.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Cp1252">
<title>phptest</title>
</head>
<body>
test1
<?php
        echo "test2";
        $username='XXXX';
        $password='XXXX';
        $database='XXXX;

    echo "test3";
    $conn=mysql_connect("localhost","$username","$password") or die ("cant connect".mysql_error());
    if (!$conn) die("Dying: connect variable returned false");
    echo "test4";
    $sel=mysql_select_db($database,$conn) or die("oops, sql died".mysql_error());
    if (!$sel) die("Dying: select variable returned false");
    echo "test5";

    $query = "SELECT path FROM files";
    $result=mysql_query($query);
    if (!$result) die("Dying: result variable returned false");
    $num=mysql_numrows($result);
     if (!$num) die("Dying: numrows call returned false");
    $i=0;
    echo "test6 $i";
    while ($i < $num) {
            $path=mysql_result($result,$i,"path");
            echo "<b>$path<hr><br>";
            $i++;
    }
?>
test7
</body>
</html>

Hmm, if you can connect in the shell, but not here, is there something wrong in php.ini??

dalecosp

Lol, looky there : missing a quote after your db variable 😉

Could that be it?

nosenseofhumor1

:rolleyes: i wish... no i saw that too and fixed it, but even this one yeilds
test1 test2test3... it doesnt even fail the connection string! the php is right, right? it has to be a config thing on my system?

bradgrafelman

Is display_errors set to On and error_reporting set to E_ALL? I'm betting that the [man]mysql[/man] extension isn't even installed, thus calling mysql_connect() (an undefined function) will cause a fatal error.

nosenseofhumor1

yeah, you nailed it

test1 test2test3 Fatal error: Call to undefined function mysql_connect() in /var/www/localhost/htdocs/phptest.php on line 61

so how do i get the mysql extension installed on gentoo? i followed a step by step guide for installing php+apache+mysql on gentoo and i guess that step wasnt in it!

bradgrafelman

nosenseofhumor1;10974460 wrote:
so how do i get the mysql extension installed on gentoo?

[man]mysql.installation[/man]

However, note that the 'mysql' library is rather outdated and it is generally recommended that new projects switch to using something more up to date, such as [man]MySQLi[/man], [man]PDO[/man], etc.

nosenseofhumor1

Got it.

i had already added php and mysql to my use variable in make.conf and reran emerge php, but it didnt work. However, when i ran

USE="php mysql" emerge php

and restarted apache, now everything works like a charm.

Heads up gentoo users!