mysql_select_db not working on localhost

Question

I have installed wamp server and am working on localhost.I am trying to connect database with following code

 <?php

$servername = "localhost";
$username = "";
$password = "";
$database ="weddingapp";
// Create connection
$conn = mysqli_connect($servername, $username, $password);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
mysqli_select_db("$database", $conn);
echo "Connected successfully";

?>

Connected successfully is coming along with error

Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\wamp\www\Wedding-app\config.php on line 13

I am new to PHP help me in this Thanks in advance

you are mixing `mysql_*` and `mysqli` all together. You should use `mysqli_*` only. — Keep Coding, Apr 17 '15 at 07:12
Since the error message and your code doesn't match you don't show us your real code here! — Rizier123, Apr 17 '15 at 07:18
change mysqli_select_db("$database", $conn); to mysqli_select_db($conn, $database ); — Arun, Apr 17 '15 at 07:20

score 1 · Answer 1 · answered Apr 17 '15 at 07:17

1

Its clearly showing an error

mysql_select_db("$database", $conn);
                ^^^^^^^^^^^^^^^^^^

It must be

mysql_select_db($conn,$database);

Try to learn the function

mysqli_select_db ( mysqli $link , string $dbname )

SideNote: You were using deprecated mysql version start using mysqli or PDO

answered Apr 17 '15 at 07:17

Narendrasingh Sisodia

21,247
6
47
54

Glad to help. But before asking question try to google it or check what's wrong with your code. You can learn it from [PHP.NET/MANUAL](http://php.net/manual/en/) – Narendrasingh Sisodia Apr 17 '15 at 07:22

score 0 · Answer 2 · answered Apr 17 '15 at 07:14

0

$conn = mysqli_connect($servername,$username,$password,$database) or die("Error " . mysqli_error($conn));

answered Apr 17 '15 at 07:14

Muhammad Ahmed

481
2
14

Developer wants to choose (decice) database later on.. – animaacija Apr 17 '15 at 07:15

score 0 · Answer 3 · answered Apr 17 '15 at 07:16

0

you are not giving user name, change to $username = "root";

answered Apr 17 '15 at 07:16

Noor

99
2
12

score -3 · Answer 4 · answered Apr 17 '15 at 07:14

-3

try with this

Code:-

<?php

$servername = "localhost";
$username = "";
$password = "";
$database ="weddingapp";
// Create connection
$conn = mysql_connect($servername, $username, $password);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
mysql_select_db($database, $conn);
echo "Connected successfully";

?>

Mistake is you have given "$database" in line num:13 remove.

answered Apr 17 '15 at 07:14

RaMeSh

3,330
2
19
31

Did you check your code before posting as answer? – Keep Coding Apr 17 '15 at 07:15

mysql_select_db not working on localhost

4 Answers4