Unable to select database using mysqli_select_db

Question

<?php // sqltest.php
$db_hostname='localhost';
$db_database='book';
$db_username='';
$db_password='';

$db_server = mysqli_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die("Unable to connect to MySQL: " . mysqli_error());
mysqli_select_db($db_server,$db_database )
or die("Unable to select database: " . mysqli_error($db_server));

I am using localhost:8080 and localhost:8080/phpMyAdmin to access the whole thing. Now I have code which runs like you see above and getting error message unable to select database. What should I do to remove the error.

@EugeneSmith Do you expect the OP to put the username and password on a public place like Stack Overflow? — Praveen Kumar Purushothaman
– Praveen Kumar Purushothaman, Commented May 26, 2016 at 13:59

Praveen Kumar Purushothaman · Accepted Answer · 2016-05-26 13:56:26Z

2

You don't do mysql_select_db. You do this way:

$db_server = mysqli_connect($db_hostname, $db_username, $db_password, $db_database);

See the manual:

Note: This function should only be used to change the default database for the connection. You can select the default database with 4th parameter in mysqli_connect().

answered May 26, 2016 at 13:56

Praveen Kumar Purushothaman

167k27 gold badges215 silver badges261 bronze badges

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

Collectives™ on Stack Overflow

Unable to select database using mysqli_select_db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related