Create Database If Not Exists with PDO

Question

I'm trying to create a database-install PHP file that first attempts to create a database if it does not already exist using a PDO prepared statement that I execute, and then I would like to connect to this. Is this how I would do it? Or is there something I'm missing here?

$mysql = new PDO("mysql:host=localhost", $dbusername, $dbpassword);
$pstatement = $mysql->prepare("CREATE DATABASE IF NOT EXISTS $dbname");
$pstatment->execute();
$dbconn = new PDO("mysql:host=localhost;dbname=$dbname", $dbusername, $dbpassword);

why would do you want to create a database with PDO? Do you understand that you are NOT using prepared statement here (although you can't but anyway)? — Your Common Sense
– Your Common Sense, Commented Nov 14, 2013 at 18:46
@Your Common Sense Normally I would just use phpMyAdmin to actually create the database but for some random reason our professor wants us to do it this way. — Logan Shire
– Logan Shire, Commented Nov 14, 2013 at 18:48
Okay, but I'm in agreement with @YourCommonSense. I can't think of a time when you would need to create this way. — George
– George, Commented Nov 14, 2013 at 18:52
If you are creating a new database for a new user on your web app (as an example), you might want to use PDO to create the database. Not because it allows for prepared statements here (because it doesn't) but because you're using PDO for the rest of the entire project. There's no point in making different kinds of connections, or mixing up code. If you're going to use PDO to interact with the database, you might as well use PDO to create the database. — Jeff Vdovjak
– Jeff Vdovjak, Commented Mar 21, 2015 at 18:45

Your Common Sense · Accepted Answer · 2013-11-14 18:57:40Z

29

Slightly more sensible and safe code.

$pdo = new PDO("mysql:host=localhost", $dbusername, $dbpassword);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$dbname = "`".str_replace("`","``",$dbname)."`";
$pdo->query("CREATE DATABASE IF NOT EXISTS $dbname");
$pdo->query("use $dbname");

answered Nov 14, 2013 at 18:57

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

1 Comment

Logan Shire Over a year ago

I just tried mine and it worked, but I'm gonna give this to you because yours is safer.

Collectives™ on Stack Overflow

Create Database If Not Exists with PDO

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related