Ad:

PHP Discussion Thread
Unsolved
Views: 358

Oct 11th, 2009

Database function fail

Expand Post »

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.

Similar Threads

How to incorporate Database into C++ ? in C++
Do I need to use strotime for making a birthday notification. in PHP
help to write a function in C
VB.NET Database Connection Problem in VB.NET
Problems retrieving from database in VB.NET

grr

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Jun 2008

Permalink

Oct 11th, 2009

Re: Database function fail

From the PHP Documentation:

Quote ...

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.

darkagn

Reputation Points: 395

Solved Threads: 192

Veteran Poster

Offline

1,136 posts
since Aug 2007

Permalink

Oct 12th, 2009

Re: Database function fail

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

php Syntax (Toggle Plain Text)
mysql_select_db($db_name)
mysql_select_db($db_name)

try something like this:

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);

evstevemd

Reputation Points: 462

Solved Threads: 392

Senior Poster

Offline

3,681 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in

Next Thread in PHP Forum Timeline: Export .php to pdf(with table)

DaniWeb Message

Cancel Changes

User Name
Password