Create new database in php with SQLite3

Question

How to create a new database in PHP with SQLite3?

$db = new SQLite3($dbname);

just opens the db, but I want to create if not exist.

ggorlen · Accepted Answer · 2023-05-14 23:01:11Z

18

To create you do use the new statement:

// create or open (if exists) the database
$database = new SQLite3('myDatabase.sqlite');

If you have named a database that doesn't exist it should get created.

edited May 14, 2023 at 23:01

ggorlen

59.3k8 gold badges119 silver badges173 bronze badges

answered May 6, 2015 at 19:06

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

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

7 Comments

François MENTEC Over a year ago

try{ $db = new SQLite3($dbname); } catch(Exception $exception){ echo $exception->getMessage(); } give me : Unable to open database: unable to open database file

Jay Blanchard Over a year ago

Have you checked the permissions of the folder where you're trying to create the new database?

François MENTEC Over a year ago

Thinked I already granted permissions, my bad :-( , thanks you for your help

user4271704 Over a year ago

And how to create table with fields in it?

MindRoasterMir Over a year ago

@user4271704 $table_create_query = "create table books(id integer pirmary key, name text, jild int, comment text)"; $db->exec($table_create_query);

|

Collectives™ on Stack Overflow

Create new database in php with SQLite3

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related