| | |
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 |
# 5.2.10 access action address alexa apache api array auto autoincrement broken cakephp checkbox class classes clean clients cms code cron curl database date dehasher destroy directory dissertation domain dropdown dynamic echo$_get[x]changingitintovariable... email encode error errorlog fairness fatalerror file folder form function functions google href htaccess html image include indentedsubcategory ip javascript joomla legislation limit link load local login masterthesis memberships menu multiple multipletables mysql mysqlquery newsletters oop open passwords paypal pdf persist php popup provider query radio random script search secure server sessions simple sockets source space spam sql system table tutorial upload url user variable voteup web youtube






