Fatal error: Uncaught mysqli_sql_exception: Unknown database 'test_db'. I keep getting this error even though I programatically created the database

Question

Here is the code

<?php
$servername = "localhost";
$usrname   = "root";
$pwd = "";
$db = "test_db";
// connect to the database
$conn= mysqli_connect($servername, $usrname, $pwd,$db);
if (!$conn){
    die('connection failed' . mysqli_connect_error());
}
// Create database
$sql = "CREATE DATABASE IF NOT EXISTS test_db";
    if (mysqli_query($conn, $sql)) {
    echo "Database created successfully<br>";
} else {
  echo "Error creating database: " . mysqli_error($conn);
}
?>

I am not sure what is going on as I am sure i made no errors while typing. As it keeps showing me that there is an unknown database despite the fact i made a CREATE DATABASE statement. I do not know if there is something else i need to do but by all measures the code should work. It is supposed to echo the "Database created successfully" or the error message.

You can not create database when you connection is null or setup is failed. Create database using shell or connect to other database to create MySQL connection. — I'm NOT a programmer
– I'm NOT a programmer, Commented Nov 25, 2022 at 3:51
Don't connect with a DB parameter mysqli_connect($servername,$usrname,$pwd), then use mysqli_select_db($db) once the DB exists, assuming your credential has permission to call CREATE DATABASE — Scuzzy
– Scuzzy, Commented Nov 25, 2022 at 3:54
What have you tried to resolve the problem? Where are you stuck? — Nico Haase
– Nico Haase, Commented Nov 25, 2022 at 5:09

Your Common Sense · Accepted Answer · 2023-09-30 14:40:28Z

0

<?php
$servername = "localhost";
$usrname   = "root";
$pwd = "";
$db = "test_db";

// connect to the database
$conn= mysqli_connect($servername, $usrname, $pwd);

// Create database
$sql = "CREATE DATABASE $db";
mysqli_query($conn, $sql);

Your code is fine, You just have to remove $db from mysqli_connect(). Because you are trying to use a database "test_db" which doesn't exist yet.

edited Sep 30, 2023 at 14:40

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

answered Nov 25, 2022 at 5:18

Hitesh Narola

241 bronze badge

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

Comments

Underdeveloper · Accepted Answer · 2022-11-25 05:06:16Z

-3

$conn= mysqli_connect($servername, $usrname, $pwd,$db);

You are trying to connect to a database that did not initially exist, so you get a fatal error.

Try creating new database using try catch blocks

try{
$conn= mysqli_connect($servername, $usrname, $pwd,$db);
}cath(Exception $e){
//your code
}

edited Nov 25, 2022 at 5:06

answered Nov 25, 2022 at 5:02

Underdeveloper

465 bronze badges

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Fatal error: Uncaught mysqli_sql_exception: Unknown database 'test_db'. I keep getting this error even though I programatically created the database

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related