diff options
Diffstat (limited to 'php/Database.php')
-rw-r--r-- | php/Database.php | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/php/Database.php b/php/Database.php new file mode 100644 index 0000000..81ce669 --- /dev/null +++ b/php/Database.php | |||
@@ -0,0 +1,26 @@ | |||
1 | <?php | ||
2 | // php/Database.php | ||
3 | |||
4 | // connexion avec PDO_sqlite | ||
5 | try | ||
6 | { | ||
7 | $db = new PDO('sqlite:' . $db_name . '.sqlite'); | ||
8 | $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | ||
9 | } | ||
10 | catch (Exception $e) | ||
11 | { | ||
12 | die('Erreur : '.$e->getMessage()); | ||
13 | } | ||
14 | |||
15 | |||
16 | // requêtes SQL | ||
17 | class SQL | ||
18 | { | ||
19 | // créer les tables si elles n'existent pas encore | ||
20 | static function create_tables() | ||
21 | { | ||
22 | //$db->exec("CREATE TABLE IF NOT EXISTS matable (ID INTEGER PRIMARY KEY, champ1 INTEGER, champ2 TEXT);"); | ||
23 | // | ||
24 | // | ||
25 | } | ||
26 | } | ||