Call to undefined function mysql_connect()

[mikeandike22]

I have seen a couple solutions to this problem but none have worked so far.

here is the error.
Fatal error: Call to undefined function mysql_connect() in C:\wamp\www\login.php on line 12

and the code
[PHP]<?php
// connect to the mysql server
$link = mysql_connect(localhost, root, admin)
or die ("Could not connect to mysql because ".mysql_error());

// select the database
mysql_select_db(members)
or die ("Could not select database because ".mysql_error());

$match = "select id from members where username = '".$_POST['username']."'
and password = '".$_POST['password']."';";

$qry = mysql_query($match)
or die ("Could not match data because ".mysql_error());
$num_rows = mysql_num_rows($qry);

if ($num_rows > 0) {
setcookie("loggedin", "TRUE", time()+(3600 * 24));
setcookie("mysite_username", "$username");
echo "You are now logged in!
";
echo "Continue to the members section.";
}
else {
echo "Sorry, there is no username: $username with the specified password.
";
echo "Try again";
exit;
}
?>[/PHP]

now does it make a difference that I am using WAMP server instead of having just configured the php and mysql by hand. It worked yesterday now today nothing.

[zippee]

Not sure this is the solution, but you do not quote the value for your variables.
[PHP]// connect to the mysql server
$link = mysql_connect('localhost', 'root', 'admin')
or die ("Could not connect to mysql because ".mysql_error());

// select the database
mysql_select_db('members')
or die ("Could not select database because ".mysql_error());[/PHP]

[mikeandike22]

yea it had something to do with my php setup so i reinstalled WAMP and just added in my backup files so pretty much i just replaced php and its extensions.

[Puckdropper]

Is the MYSQL functionality being loaded in the PHP.INI that's being used?

[tanya_ivanova]

Hi

I have been struggling with this for two days now !!!

And here is what the problem on my machine was:

In httpd.conf (in the conf folder of my Apache installation), the path to php.ini was incomplete, so i corrected it like so:

PHPIniDir "C:\Program Files (x86)\PHP\"

AND it miraculously worked !! (it is NOT to be believed :D had started thinkin this thing AINT made to be workin at all!!)

lol

[BzzBee]

have a look

http://www.php.net/function.mysql-connect