CODEWITHSUNDEEP
phpdatabasesqlitepdo
Alix Axel
Alix Axel

Reputation: 154623

Creating new SQLite DBs with PDO

I want to provide a setup feature in my next project and I'm wondering if it's possible to create a SQLite 3 database from scratch with PDO or I'm just stuck at connecting to existing databases via DSN?

If it isn't possible with PDO is there any way to create a new DB via PHP?

Upvotes: 18

Views: 12865

Answers (1)

Tor Valamo
Tor Valamo

Reputation: 33769

A new sqlite database is created when you open a connection to one that doesn't exist. You can just check if the file exists, and then if it doesn't, then just create a new database connection and insert the tables.

Upvotes: 24

Related Questions