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

geomorillo/sqlite3class

sqlite3class