Connect to db using variables dont work with mysqli

Question

Im trying to get modern and use mysqli like this

$connect = mysqli_connect($servername, $username, $password);
mysql_select_db($dbname);

but it dosent work,

This works

$connect = mysql_connect($servername, $username, $password);
mysql_select_db($dbname);

am i just tired or is it completly wrong?

you need to use `mysqli_select_db` when you are using mysqli_ — Maximus2012, Apr 20 '15 at 19:16

Keep Coding · Accepted Answer · 2015-04-20T19:25:26.763

2

The mistake is in your select database line, you did mix it with mysql_* when you should use mysqli_*

Your should use mysqli_select_db for selecting database using mysqli_* extension.

Your final code would be something like this:

$connect = mysqli_connect($servername, $username, $password);
mysqli_select_db($connect, $dbname);

edited Apr 20 '15 at 19:25

answered Apr 20 '15 at 19:16

Keep Coding

*" You should do: $connect = mysqli_connect($servername, $username, $password); mysqli_select_db($dbname); "* - they should do this because of? plus this will fail. who upvoted this? read up on the function http://php.net/manual/en/mysqli.select-db.php – Funk Forty Niner Apr 20 '15 at 19:17
http://php.net/manual/en/mysqli.select-db.php `bool mysqli_select_db ( mysqli $link , string $dbname )` – Funk Forty Niner Apr 20 '15 at 19:23
Thanks for mentioning Sir @Fred-ii-. I will keep in mind your recommendations for future.. – Keep Coding Apr 20 '15 at 19:26
1

You're welcome ;-) now the OP will be well on their way; *cheers* – Funk Forty Niner Apr 20 '15 at 19:27
1

you very welcome. Glad I could help you well. @user3437732 – Keep Coding Apr 20 '15 at 19:34

1 Answers1