sqlite3class
Sqlite 3 class
Simple to use sqlite3 php class
to use include it like this
include './sqlite_class.php';
to create a db
$db = new DB("mydb.db"); // you can use txt or db as extension
to create a table use an array here is an example
$values = array(
"TABLE" => "jugadores", // table name
"id" => "INTEGER PRIMARY KEY",
"oro" => "INTEGER(11)",
"plata" => "INTEGER(11)",
"cobre" => "INTEGER(11)"
);
$db->CreateTable($values);
easily insert data with an array
$fields = array(
"id" => 1,
"oro" => 100,
"plata" => 0,
"cobre" => 0
);
$db->Insert("jugadores", $fields);
selecting data use an array
$values = array(
"ROWS" => "*", //row names
"TABLE" => "jugadores",
"WHERE" => array("oro" => 100, "plata" => 0), //use an array for more than 1, here is the sql: WHERE oro = 100 AND plata = 0
"ORDER" => "id"
);<br>
$rows = $db->Select($values); // here it returns an array with the selected rows<br>
if you want to show the tables in database
$db->showTables();
$db->close(); // finally close the database