mysql_connect stalls on call

[treble54]

I'm trying to learn some MySQL4.0.20a-nt + PHP5 and when the mysql_connect function is called, it hangs / stalls and nothing else after the statement call works. I can do echo "This is a string."; and it'll print that out just fine (but only before the mysql_connect call). I know the host / user / password are correct and I know I can connect to MySQL on DOS prompt and with MySQL Administrator. Maybe I installed PHP incorrectly? I know "echo" works and including other files works so I must have done something write with the installation of PHP. Any suggestions on what the problem might be?

Also, I'm just learning still. I don't know much about MySQL or PHP and I'd like to learn some more so don't slam me for something I have not caught yet that most PHP / MySQL'ers catch easily. Thanks.

[maxor]

try something like this

mysql_connect($host, $user, $password) or die(mysql_error()); 

[treble54]

try something like this

 mysql_connect($host, $user, $password) or die(mysql_error()); 

Ok I tried this:

 <?php
     echo ("...");
     $host = "localhost";
     $user = "root";
     $pass = "root_password";
     $dbcnx = mysql_connect($host, $user, $pass) or die(mysql_error());
 ?>

and I got the same odd occurence. If I'm using an unknown function, what should happen? I randomly changed mysql_connect() to mysql_conne() just to see if it would do anything and it did the same stalling thing.

[maxor]

When you say the script 'stalls' do you mean that it actually fails or dies, or it's hung up. How do you know that it's 'stalling'?

What happens when you execute this code...

<?php

$i = 1;

while( $i < 20 ){

  if($i == 10){
    $dbcnx = mysql_connect("localhost", "root", "root_password") or die(mysql_error());
    }

echo 'The Value of I is : '.$i.'<br />';

$i ++;

}
?>

[treble54]

It displays nothing.

When you say the script 'stalls' do you mean that it actually fails or dies, or it's hung up. How do you know that it's 'stalling'?

By stalling, I mean it doesn't do anything. Any amount of "echo" statements after the mysql_connect() call are not displayed. It only goes to the mysql_connect() call and then doesn't execute the rest of the code. I hope thats a good enough explaination. Let me know if I'm still confusing you.

By the way, thanks for helping.

[maxor]

I think you've got error reporting off.

Do you have access to your php.ini file?

What is the value of the 'display_errors' directive?

[treble54]

It's currently set to "Off." I suppose I should change it to "On"? I'll go ahead and try it and see what happens.

EDIT: I changed it to "On" and it still doesn't do anything different.

[maxor]

What does the following code display...

echo 'Before the connection';

// Add your connection here

echo 'After the connection'; 

[treble54]

It just outputs "Before the connection".

[lieut_data]

It just outputs "Before the connection".

Try:

  ini_set('display_errors', 1);
  error_reporting(E_ALL); 

At the top of your script.

[treble54]

Ah! That helped! I got this:

Before the connection
Fatal error: Call to undefined function mysql_connect() in X:\My Documents\htdocs\test.php on line 9

And Line 9 refers to:
$dbcnx = mysql_connect($host, $user, $pass) or die(mysql_error());
with $host, $user, and $pass all correctly set. Maybe that helps fix the problem. I think I've seen a similar problem elsewhere.

[ol4pr0]

see you are using php5 (latest release ? )
did you include php_mysql.dll or php_mysqli.dll ???

for the fun of it.

#try
$dbcnx = mysqli_connect($host, $user, $pass) or die(mysql_error()); 

[treble54]

Yes I know, I wrote that in the beginning of the first post of this thread. How do I include that file?

[ol4pr0]

Thats done in ure php.ini

around line 565, replace that line with the following

extension=php_mysql.dll

Than restart ure apache

<?
#see if mysql shows up anywhere
phpinfo();
?>

[treble54]

Ok well I uncommented that line in the php.ini file. Now where does the php_mysql.dll go? I suppose it goes in the C:\Windows\ directory. Forgive my dumbfoundedness. I'm new to all of this.

When I restart it, it says it can't find the './php_mysql.dll' file.

[treble54]

see you are using php5 (latest release ? )
did you include php_mysql.dll or php_mysqli.dll ???

for the fun of it.

 #try
 $dbcnx = mysqli_connect($host, $user, $pass) or die(mysql_error()); 

The mysqli_connect() call didn't work either.

[wallyweb]

I know this thread has been quiet for a while (since 2004?) but I found it when doing a search for a similar issue.
I resolved my problem and I wonder if that is what was happening here.
I was testing my file on localhost and the php was not php'ing (new word? credit me )
The same code was working in another file. What was the difference?
It took a jug of coffee and 3 packs of cigarettes before I clued in:

Loading into my browser:

Bad file:

file:///J:/Apache%20Group/Apache2/htdocs/foo

Good file:

http://localhost:8080/foo

Hope this helps someone else (next year?)