Encapsulated Sqlite3 simple operation class
Encapsulated Sqlite3 simple operation class
The encapsulated Sqlite3 simple operation class, which is written based on Sqlite3 extension. its usage is the same as that of the previous Mysql.
Note that if the database does not exist, one is automatically created, but the type of the database is Sqlite2.
Url = $ url; $ this-> open ($ url);} function check_input ($ value) {if (get_magic_quotes_gpc () {$ value = sqlite_escape_string ($ value );} return $ value;} function create ($ table, $ name, $ type = null) {$ SQL = 'create table '. $ table. '('; if ($ type = null) {$ arrname = array_keys ($ name); $ arrtype = array_values ($ name );} else {$ arrname = explode ("|", $ name); $ arrtype = explode ("|", $ type) ;}for ($ I = 0; $ I
Query ($ SQL); if ($ re) {return true;} else {return fasle;} function drop ($ table) {$ SQL = 'drop table '. $ table. '; $ re = $ this-> query ($ SQL); if ($ re) {return true;} else {return false;} function insert ($ table, $ name, $ value = null) {$ SQL = "INSERT ". $ table. '('; if ($ value = null) {$ arrname = array_keys ($ name); $ arrvalue = array_values ($ name );} else {$ arrname = explode ('|', $ name); $ arrvalue = explode ('|', $ value) ;}for ($ I = 0; $ I
Query ($ SQL); if ($ re) {return true;} else {return false;} function delete ($ table, $ Conditionsname, $ Conditionsvalue = null) {if ($ Conditionsvalue! = Null) {$ SQL = "DELETE FROM ". $ table. "WHERE ". $ Conditionsname. "= '". $ Conditionsvalue. "';";} else {$ SQL = "DELETE FROM ". $ table. "WHERE"; $ arrname = array_keys ($ Conditionsname); $ arrvalue = array_values ($ Conditionsname); for ($ I = 0; $ I
Query ($ SQL); if ($ re) {return true;} else {return false;} function select ($ table, $ name, $ Conditionsname, $ Conditionsvalue = null) {if ($ Conditionsvalue! = Null) {$ SQL = "SELECT ". $ name. "FROM ". $ table. "WHERE ". $ Conditionsname. "= '". $ Conditionsvalue. "';";} else {$ SQL = "SELECT ". $ name. "FROM ". $ table. "WHERE"; $ arrname = array_keys ($ Conditionsname); $ arrvalue = array_values ($ Conditionsname); for ($ I = 0; $ I
Query ($ SQL); $ row = $ ret-> fetchArray (SQLITE3_ASSOC); return $ row [$ name];} function update ($ table, $ name, $ value, $ Conditionsname, $ Conditionsvalue = null) {if ($ Conditionsvalue! = Null) {$ SQL = "UPDATE ". $ table. "SET ". $ name. "= '". $ value. "'Where ". $ Conditionsname. "= '". $ Conditionsvalue. "';";} else {$ SQL = "UPDATE ". $ table. "SET ". $ name. "= '". $ value. "'Where"; $ arrname = array_keys ($ Conditionsname); $ arrvalue = array_values ($ Conditionsname); for ($ I = 0; $ I
Query ($ SQL); if ($ re) {return true;} else {return false;} function group ($ table, $ name) {$ SQL = "SELECT ". $ name. "FROM ". $ table. ";"; $ return = array (); $ ret = $ this-> query ($ SQL); while ($ row = $ ret-> fetchArray (SQLITE3_ASSOC )) {array_push ($ return, $ row [$ name]);} return $ return;} function fecthall ($ SQL) {$ return = array (); $ ret = $ this-> query ($ SQL); while ($ row = $ ret-> fetchArray (SQLITE3_ASSOC) {array_push ($ return, $ row );} return $ return ;}}
The above is the content of the encapsulated Sqlite3 simple operation class. For more information, please follow the PHP Chinese network (www.php1.cn )!