| | |
Call to undefined function mysql_connect()
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
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.
•
•
Join Date: Jul 2004
Posts: 494
Reputation:
Solved Threads: 21
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.
•
•
Join Date: May 2009
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
![]() |
Similar Threads
- 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
| Thread Tools | Search this Thread |
advanced ajax apache api array basics beginner binary broken cakephp check checkbox class cms code combobox cookies cron curl database date datepart display dynamic echo email error file files folder form forms function functions google head href htaccess html image include includingmysecondfileinthechain insert integration ip java javascript job joomla js limit link login loop mail menu mlm multiple mysql oop parse password paypal pdf php problem procedure query radio random recursion regex remote script search server sessions smarty smash sms soap source space sql stored syntax system table traffic tutorial unicode update upload url validator variable video web xml youtube






