PHP - Selecting database from MySQL doesn't work

Question

I have read a lot about this but it still doesn't work.
I'm just trying to select a database to create a new table in, I try:

$db = mysqli_select_db("test");
if(!$db) {
echo "error: " . mysqli_error($db);
}

But I still get an error (and mysqli_error($db) doesn't seem to work).

Of course I have already connected to it:

$con=mysqli_connect("localhost", "administrator", "****");

On phpMyAdmin I have these databases:

enter image description here

Why can't I select "test" ?
And creating a database doesn't work because I don't have the rights, as you can see.

have you actually connected to the database before this line with mysqli_connect or new mysqli? — bizzehdee
– bizzehdee, Commented Jul 5, 2013 at 21:02
do you have the rights to access the database? what's the error message? — Karoly Horvath
– Karoly Horvath, Commented Jul 5, 2013 at 21:02
you can select the database by writing its name in the mysqli_connect() — Ali Almoullim
– Ali Almoullim, Commented Jul 5, 2013 at 21:09

complex857 · Accepted Answer · 2013-07-05 21:11:32Z

4

The procedular signature of this function is:

 bool mysqli_select_db ( mysqli $link , string $dbname )

So you will have to provide the resource you got back from the mysqli_connect() to make it work. Something like this:

$con = mysqli_connect("localhost", "administrator", "****");
$success = mysqli_select_db($con, "test");

Alternatively you could specify the database on the connect call with a 4th argument:

$con = mysqli_connect("localhost", "administrator", "***", "test");

See the examples on mysqli_connect().

edited Jul 5, 2013 at 21:11

answered Jul 5, 2013 at 21:04

complex857

20.9k6 gold badges54 silver badges56 bronze badges

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

4 Comments

Big_Chair Over a year ago

Wow...this was actually it. Thank you, and sorry if the question was too obvious, I read so much about this and didn't find this...

complex857 Over a year ago

Btw, you could select the db with the mysqli_connect() too.

Marcel Korpel Over a year ago

@Big_Chair Just read the documentation linked to: it's the fourth parameter.

complex857 Over a year ago

Added to the answer anyway (-:

vee · Accepted Answer · 2013-07-05 21:04:54Z

1

mysqli_select_db function requires two parameters link and dbname. Please refer to the documentation:

http://php.net/manual/en/mysqli.select-db.php

You are only passing link and no database name in your call:

$db = mysqli_select_db("test");

answered Jul 5, 2013 at 21:04

vee

38.7k7 gold badges76 silver badges80 bronze badges

1 Comment

vee Over a year ago

@Big_Chair, yes, noticed that, I guess I was typing the answer when complex857 submitted the answer. I don't want to delete this post for the documentation link :)

Collectives™ on Stack Overflow

PHP - Selecting database from MySQL doesn't work

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related