note 82875 added to book.sqlite
| From: | saivert at saivert dot com | Date: | Wed, 30 Apr 2008 07:02:30 +0000 |
| Subject: | note 82875 added to book.sqlite | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-138926@lists.php.net to get a copy of this message | ||
How to open a database, create a table if it doesn't exist and inserting initial value.
<?php
if ($db = new SQLiteDatabase('filename')) {
$q = @$db->query('SELECT requests FROM tablename WHERE id = 1');
if ($q === false) {
$db->queryExec('CREATE TABLE tablename (id int, requests int, PRIMARY KEY (id)); INSERT
INTO tablename VALUES (1,1)');
$hits = 1;
} else {
$result = $q->fetchSingle();
$hits = $result+1;
}
$db->queryExec("UPDATE tablename SET requests = '$hits' WHERE id = 1");
} else {
die($err);
}
?>
Use this as boilerplate code for any new project using SQLite.
----
Server IP: 62.73.196.231
Probable Submitter: 84.211.82.64
----
Manual Page -- http://www.php.net/manual/en/book.sqlite.php
Edit -- https://master.php.net/note/edit/82875
Del: integrated -- https://master.php.net/note/delete/82875/integrated
Del: useless -- https://master.php.net/note/delete/82875/useless
Del: bad code -- https://master.php.net/note/delete/82875/bad+code
Del: spam -- https://master.php.net/note/delete/82875/spam
Del: non-english -- https://master.php.net/note/delete/82875/non-english
Del: in docs -- https://master.php.net/note/delete/82875/in+docs
Del: other reasons-- https://master.php.net/note/delete/82875
Reject -- https://master.php.net/note/reject/82875
Search -- https://master.php.net/manage/user-notes.php