Location: PHPKode > scripts > SQLite DB Handler > sqlite-db-handler/example1.php
<?php
require_once("sqlite_class.php");


#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#
# Database and table process with class db from package "SQLITE DB HANDLER"
# Author : Guto Ferreira
# Web :    http://onidesk.sytes.net
#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

//{{{{ instanciates the class
$db = new db;
///}}}}}


// {{{ makes the  connection with seted database file
$db->database("database.txt");
//}}}}


//{{{  informing the array that will pass the values to generate table name and table rows and data type
$values = array("TABLE" => "novidades",   // on this line just alter the table name (on this example the table name is novidades)
                "id"     => "INTEGER PRIMARY KEY",
                "titulo" => "VARCHAR(40)",
                "artigo" => "TEXT(100)",
                "autor"  => "TEXT(16)",
                "data"   => "NUMERIC(12)");
/// passing the values as a parameter to the method "Create_Table"
$db->Create_Table($values);

//}}}}


//{{{ Close the connection with database
$db->Close();




?>
Return current item: SQLite DB Handler