PHP mysql_connect not returning boolean

Question

I have the following PHP code:

$con = mysql_connect("localhost","name","pass") or die(mysql_error());

$db = "db";

mysql_select_db($db,$con);

Now in my experience, $con should be true or false. When I echo $con I get:

Resource id #25

If I do the following code, the echo never fires (as to be expected after the above statement):

if($con) { echo "it worked"; }

When I run a query against this connection, everything works as expected. Is there a reason why this $con will not be true or false?

What am I doing wrong?

Thanks

Returns a MySQL link identifier on success or FALSE on failure. . Also, judging by the big red warning box on mysql_connect's docs you should probably use mysqli or pdo. — Supericy
– Supericy, Commented Jan 23, 2013 at 6:44

Community · Accepted Answer · 2020-06-20 09:12:55Z

5

Check mysql_connect Return Values :

Returns a MySQL link identifier on success or FALSE on failure.

So to check the connection:

if($con !== false) { echo "it worked"; }

or to quit in case of an error:

if (!$con) {
    die('Could not connect: ' . mysql_error());
}

A word of advice though, better to use the MySQLi or PDO_MySQL instead of mysql_connectsince it will soon be deprecated:

Warning

This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

mysqli_connect()

PDO::__construct()

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 23, 2013 at 6:44

Kuf

17.9k7 gold badges69 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1717480 · Accepted Answer · 2013-01-23 06:47:20Z

0

Its simply b/c of the or or die(mysql_error()); at the end.

Give this a shot:

<?php
$con = mysql_connect("localhost","name","pass");
$db = "db";
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db($db,$con);
?>

answered Jan 23, 2013 at 6:47

user1717480

Comments

Mark · Accepted Answer · 2013-01-23 06:48:00Z

-1

I think it is because of the or die(mysql_error()); part. I should be the $con = mysql_connect("localhost","name","pass") only. Then you can check like this: if (!$con).

answered Jan 23, 2013 at 6:48

Mark

8,47115 gold badges52 silver badges81 bronze badges

1 Comment

Adri C.S. Over a year ago

@tereško, why the -1 for linking to w3schools, if I may ask?

Collectives™ on Stack Overflow

PHP mysql_connect not returning boolean

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related