DaniWeb Forum Index > Web Development > PHP

Database function fail

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 29

Reputation: grr is an unknown quantity at this point

Solved Threads: 0

grr

Offline

Light Poster

Database function fail

Oct 11th, 2009

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
function fafaconnect($db_host, $db_user, $db_pass, $db_name) {
	@mysql_connect($db_host, $db_user, $db_pass);
	@mysql_select_db($db_name);
}
 
if ($link = @mysql_connect("localhost", "admin", "pass")) {
	echo "pass-";
} else {
	echo "fail-";
}
if ($select = @mysql_select_db("zushee")) {
	echo "pass-";
} else {
	echo "fail-";
}
 
if ($newlink = fafaconnect("localhost", "admin", "pass", "zushee")) {
	echo "pass";
} else {
	echo "fail";
}
function fafaconnect($db_host, $db_user, $db_pass, $db_name) {
	@mysql_connect($db_host, $db_user, $db_pass);
	@mysql_select_db($db_name);
}

if ($link = @mysql_connect("localhost", "admin", "pass")) {
	echo "pass-";
} else {
	echo "fail-";
}
if ($select = @mysql_select_db("zushee")) {
	echo "pass-";
} else {
	echo "fail-";
}

if ($newlink = fafaconnect("localhost", "admin", "pass", "zushee")) {
	echo "pass";
} else {
	echo "fail";
}

This returns pass-pass-fail. Any ideas?

Last edited by grr; Oct 11th, 2009 at 10:04 pm.

•

Join Date: Aug 2007

Posts: 801

Reputation: darkagn has a spectacular aura about

Solved Threads: 110

darkagn

Offline

Practically a Posting Shark

Oct 11th, 2009

From the PHP Documentation:

•

Note: Whenever you specify "localhost" or "localhost:port" as server, the MySQL client library will override this and try to connect to a local socket (named pipe on Windows). If you want to use TCP/IP, use "127.0.0.1" instead of "localhost". If the MySQL client library tries to connect to the wrong local socket, you should set the correct path as Runtime Configuration in your PHP configuration and leave the server field blank.

Try changing localhost to 127.0.0.1 and see if this fixes your problem. If not, try echo'ing mysql_error() instead of "fail" as this will give you more details as to why your connect call is failing.

There are no stupid questions, only those too stupid to ask for help.
echo is a web developer's best friend.

•

Join Date: Jun 2007

Posts: 1,439

Reputation: evstevemd has a spectacular aura about

Solved Threads: 128

evstevemd

Offline

Nearly a Posting Virtuoso

Oct 12th, 2009

I guess this have the second argument(connection) missing:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
mysql_select_db($db_name)
mysql_select_db($db_name)

try something like this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$conn = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name, $conn);
$conn = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name, $conn);

Atheist: God is man made imagination, he doesn't exist!
Theist: It's okay, can you imagine anything else that doesn't exist?
---- Python, C++ PHP and Java ----