Call to undefined function mysql_connect()
Please support our PHP advertiser: Free Online Load Test - How many visitors can your web site handle?
![]() |
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.
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.
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]
[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]
Ecommerce-Web-Store.com Building Your e-Business.
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.
•
•
Posts: 491
Reputation:
Solved Threads: 20
Is the MYSQL functionality being loaded in the PHP.INI that's being used?
www.uncreativelabs.net
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
•
•
Posts: 1
Reputation:
Solved Threads: 0
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
had started thinkin this thing AINT made to be workin at all!!)
lol
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
had started thinkin this thing AINT made to be workin at all!!)lol
•
•
Posts: 204
Reputation:
Solved Threads: 29
BzzBee
Website Design, Web Development, Internet Marketing Company, SEO & Online Promotion Solutions in Dublin,Ireland
http://www.etrix.ie/
http://www.etrixlimited.com/
Website Design, Web Development, Internet Marketing Company, SEO & Online Promotion Solutions in Dublin,Ireland
http://www.etrix.ie/
http://www.etrixlimited.com/
![]() |
Similar Threads
Other Threads in the PHP Forum
- Problems with PHP and the mysql_connect() command. (PHP)
- can't install Apache-many tries (Linux Servers and Apache)
- php mysql help (PHP)
Other Threads in the PHP Forum
- Previous Thread: HELP:quiz management system
- Next Thread: Dates in drop down box
•
•
•
•
Views: 6712 | Replies: 5 | Currently Viewing: 1 (0 members and 1 guests)






Linear Mode