Error while trying to create database with PHP PDO

Question

I am new to PDP PDO, this is my code to create a database named "title"

<?php
$servername = "localhost";
$username = "username";
$password = "password";

try {
    $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "CREATE DATABASE title";
    // use exec() because no results are returned
    $conn->exec($sql);
    echo "Database created successfully<br>";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage(); // THIS IS LINE NUMBER 17
    }

$conn = null;
?>

But this is the error, which i get, while i try to run the script

Notice: Undefined variable: sql in C:\xampp\htdocs\website\database\createdb.php on line 17

SQLSTATE[HY000] [1049] Unknown database 'myDB'

What is wrong?

@Epodax Sorry, it is 'myDB' not movie. I edited the question. — Rahul Sharma, Jun 01 '17 at 11:11
I got this code from w3schools, their should not be any error. — Rahul Sharma, Jun 01 '17 at 11:11
Yes error doesn't fit it might be at `$conn = new PDO("mysql:host=$servername;dbname=movie", $username, $password);` — Adder, Jun 01 '17 at 11:12
btw; are you trying to create a database or a table? Two different animals here. — Funk Forty Niner, Jun 01 '17 at 11:16
You can't create a "database" within an "existing database", only a "table" in an "existing database". People have the misconception between both (different animals). — Funk Forty Niner, Jun 01 '17 at 11:25

score 0 · Accepted Answer · answered Jun 01 '17 at 11:12

0

You connect to a db that is not existend here:

$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);

remove the dbname:

$conn = new PDO("mysql:host=$servername", $username, $password);

answered Jun 01 '17 at 11:12

Jens

67,715
15
98
113

This one worked, thanks. But i got the code from w3schools.com. And it is really very good website. It is their fault?? – Rahul Sharma Jun 01 '17 at 11:14
@RahulSharma I can not say it without seeing the code – Jens Jun 01 '17 at 11:15
https://www.w3schools.com/php/php_mysql_create.asp – Rahul Sharma Jun 01 '17 at 11:15
@RahulSharma No, it is your fault. You were trying to access a database that didn't exist. – Jim Wright Jun 01 '17 at 11:15
But the page says "Create a DB with PDO", why they wrote a code to access a DB? We can create a DB inside a DB? – Rahul Sharma Jun 01 '17 at 11:17
@RahulSharma There are more than one example. The one you refer assumes that a db `myDB` exist – Jens Jun 01 '17 at 11:17
@RahulSharma No you can not have a DB inside of a db. But You can create an other DB if you loggin in with one DB – Jens Jun 01 '17 at 11:18
@Jens [This is what I asked the OP earlier...](https://stackoverflow.com/questions/44305894/error-while-trying-to-create-database-with-php-pdo#comment75617199_44305894) - am not quite sure what they really want to do here. – Funk Forty Niner Jun 01 '17 at 11:20
Ok thanks a lot bro. Will select your answer as the best, once the time limit gets removed – Rahul Sharma Jun 01 '17 at 11:21

score 0 · Answer 2 · answered Jun 01 '17 at 11:13

You are getting the SQL error on line #7 because you are trying to access myDB which doesn't exist yet and is throwing an exception.

You are getting the undefined variable error because the code in the try statement is failing before $sql is assigned to anything.

Error while trying to create database with PHP PDO

2 Answers2