Call to undefined function mysql_connect()
 

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!<br>";
echo "Continue to the <a href=members.php>members</a> section.";
}
else {
echo "Sorry, there is no username: $username with the specified password.<br>";
echo "<a href=login.html>Try again</a>";
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.

Re: Call to undefined function mysql_connect()
 

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]

Re: Call to undefined function mysql_connect()
 

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.

Re: Call to undefined function mysql_connect()
 

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

Re: Call to undefined function mysql_connect()
 

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

Re: Call to undefined function mysql_connect()
 

have a look

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