MySQL: no database selected error

Question

hi i have an sql error says: no database selected this is my KK.php file:

$user_name = "root";
$password = "";
$database = "MyDB";
$server = "localhost";

// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// escape variables for security
$message = mysqli_real_escape_string($link, $_POST['input1']);

$sql="INSERT INTO demo (message)
VALUES ('$message')";

if (!mysqli_query($link,$sql)) {
die('Error: ' . mysqli_error($link));
 }
echo "1 record added";

 mysqli_close($link);
 ?>

my database is "MyDB", and my demo.php file:

<form action="KK.php" method="post" />
<p>Message: <input type="text" name="input1" /></p>
<input type="submit" value="Submit" />
</form>

so what is the problem?, how do i select database?

You have no mysqli_connect statement before mysqli_connect_errno(). Thus you have not selected a database to work with. — Ne Ma
– Ne Ma, Commented May 7, 2014 at 14:40
You need to connect to Mysql followed by selecting a DB which is missing in the code php.net/manual/en/function.mysqli-connect.php php.net/manual/en/mysqli.select-db.php — Abhik Chakraborty
– Abhik Chakraborty, Commented May 7, 2014 at 14:41

John Boker · Accepted Answer · 2014-05-07 14:41:10Z

2

Are you forgetting to call the mysqli_connect to get your connection?

ie:

$con = mysqli_connect("localhost","my_user","my_password","my_db");

answered May 7, 2014 at 14:41

John Boker

83.8k17 gold badges101 silver badges130 bronze badges

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

Comments

Ne Ma · Accepted Answer · 2014-05-07 14:42:42Z

1

Further to my comment above here is the code you are missing.

$user_name = "root";
$password = "";
$database = "MyDB";
$server = "localhost";

// This
$link = mysqli_connect($server,$user_name,$password,$database); // This
// This

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

answered May 7, 2014 at 14:42

Ne Ma

1,70913 silver badges22 bronze badges

Comments

Harikrishnan · Accepted Answer · 2014-05-07 14:41:24Z

0

You didn't call mysqli_connect

$con = mysqli_connect("localhost","my_user","my_password","my_db");

answered May 7, 2014 at 14:41

Harikrishnan

10k11 gold badges89 silver badges131 bronze badges

Collectives™ on Stack Overflow

MySQL: no database selected error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related