use mysqli_connect and mysql_select_db

Question

This code works correctly!

$con=mysqli_connect("localhost","root","","laboratory");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT * FROM test");

while($row = mysqli_fetch_array($result))
  {
  echo $row['name'];
  echo "<br>";
  }

mysqli_close($con);

But when I remove database_name from mysqli_connect I would use the mysql_select_db, the following error occurs "Warning: mysql_select_db() expects parameter 2 to be resource, object given in"

Code after change:

$con=mysqli_connect("localhost","root","");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$db_selected = mysql_select_db("laboratory", $con);

if (!$db_selected)
  {
  die ("Can\'t use laboratory : " . mysql_error());
  }

$result = mysqli_query($con,"SELECT * FROM test");

while($row = mysqli_fetch_array($result))
  {
  echo $row['name'];
  echo "<br>";
  }

mysqli_close($con);

You cannot call mysql* functions on mysqli* resources. And it is not required as there is `mysqli_select_db` — hek2mgl, Sep 28 '13 at 09:14

score 4 · Answer 1 · answered Sep 28 '13 at 09:14

4

Replace Your Code:

$db_selected = mysqli_select_db("laboratory", $con); instead of

$db_selected = mysql_select_db("laboratory", $con);

answered Sep 28 '13 at 09:14

Guru

621
1
4
12

kworr · Accepted Answer · 2013-09-28T09:24:15.913

2

Please, don't mix mysqli and mysql as they are different modules.

In your second code block you are using mysql_select_db and mysql_error, the first one requires mysql connection, not mysqli connection.

edited Sep 28 '13 at 09:24

answered Sep 28 '13 at 09:13

kworr

3,579
1
21
33

1

@Daniyal did you change $db_selected = mysql_select_db("laboratory", $con); to use mysqli equivalent instead? – OIS Sep 28 '13 at 09:23

score -1 · Answer 3 · edited May 05 '19 at 18:38

-1

The order of the parameters has been changed from:

mysql_select_db($Database, $Connection);

to:

mysqli_select_db($Connection, $Database);

edited May 05 '19 at 18:38

Wendelin

2,354
1
11
28

answered May 05 '19 at 14:53

Zardiw

11
10

use mysqli_connect and mysql_select_db

3 Answers3

Linked