GMgKe586q6suSQnyqZLlGCooeWM

Pages

Search

Friday, March 18, 2011

PHP - SQLite3

<?php

// automatically created if doesn't exist
$db = new SQLite3("data.db");

$db->execute("CREATE TABLE data ( name STRING)");
$db->execute("INSERT INTO data (name) VALUES ('Lady Gaga')");

$result = $db->query("SELECT name FROM data");
print_r($result->fetchArray());         // equiv mysql_fetch_array
Share/Bookmark

No comments:

Post a Comment