Requirements

Setup

Examples

<?phpinclude"ssql.php";//Connect to MySQL with new SSQL($host[, $user[, $password[, $database]]])$ssql =newSSQL("localhost","root","root","db");//Connect to SQLite with just the first argument$ssql =newSSQL("db.sqlite3");//Use $ssql->q($q[, $a]) to execute a raw SQL query$ssql->q("SELECT * FROM `users`");//You can use wildcards for escaping$ssql->q("SELECT * FROM `users` WHERE `username`=%0 OR `nickname`=%1", [$name,$nick]);//You can use queries as methods$ssql->getUser ="SELECT * FROM `users` WHERE `username` = '%0' OR `nickname` = '%1'";$user =$ssql->getUser($name,$nick);//Use $ssql->read($table[, $cond][, $flags]) for simple reading$users =$ssql->read("users");// Access the username of a specific user with $users[$index]->username$users =$users->data();// If you need a raw array, for example for json_encode($users)$user =$ssql->read("users", ['uid' =>$id]);// You can access the username with $user->username if only one result is returned//You can use the DEBUG flag to print this query before execution$user =$ssql->read("users", ['uid' =>$id],SQ::DEBUG);//Or you can set the object‐wide $debug property to print all queries$ssql->debug =true;//You can use more conditions$user =$ssql->read("users", ['username' =>$name,'password' =>$pass]);//You can use the COND_OR flag to use the OR operator instead of AND$user =$ssql->read("users", ['username' =>$name,'nickname' =>$nick],SQ::COND_OR)[0];//You can use custom conditions$users =$ssql->read("users","`sign_up_time` >" .bcsub(time(),3600));//You can use more of them$users =$ssql->read("users", ["`sign_up_time` >" .bcsub(time(),3600),"`nickname` IS NOT NULL"]);//Use $ssql->get($table[, $options][, $flags]) for more complex data retrieval$users =$ssql->get("users", ['order' =>"sign_up_time",'cols' => ['id' =>"uid",'name' =>"username","sign_up_time","nickname"],'limit' =>10],SQ::ORDER_DESC);$user =$ssql->get("users", ['cond' => ['uid' =>$id],'order' =>"name",'cols' => ['id' =>"uid",'name' =>"username","sign_up_time",'nick' =>"nickname"]]);//You can print the result of a ->read() or ->get() call as an HTML tableprint$ssql->read("users");//Insert with $ssql->put($table, $values[, $flags])$ssql->put("users", [$id,$name,$pass,time(),NULL]);//You can use array keys as col names$ssql->put("users", ['username' =>$name,'password' =>$pass,'sign_up_time' =>time()]);//You can use INSERT_RETURN_ID flag for returning the first auto increment col value (depends on the database type)$id =$ssql->put("users", ['username' =>$name,'password' =>$pass,'sign_up_time' =>time()],SQ::INSERT_RETURN_ID);//Use $ssql->put($table, $values, $cond[, $flags]) to update rows$ssql->put("users", ['nickname' =>$nick], ['uid' =>$id]);//You can delete rows by supplying NULL to the $values argument$ssql->put("users",NULL, ['uid' =>$id]);$ssql->put("users",NULL);//Delete all users?>

Flags

More examples

<?php//You can extend the SSQL classclass MySSQLextendsSSQL {protected$host ="localhost";protected$user ="root";protected$password ="root";protected$db ="db";//Optional    };//And then create an instance$ssql =newMySSQL();//If $db is not set, you can set it afterwards$ssql->changeDb("newDB");//Join$result =$ssql->get("users", ['join' =>"messages",'on' => ['from_user' =>'uid'],'order' =>"time",'limit' =>5],SQ::ORDER_DESC);//Use JOIN_LEFT, JOIN_RIGHT and JOIN_FULL flags for other types of JOIN$result =$ssql->get("users", ['join' =>"messages",'on' => ['from_user' =>'uid'],'cond' => ['from_user' =>$uid]]);//Table creation and deletion//For basic table creation use $ssql->createTable($table, $params[, $primary[, $flags]])$ssql->createTable("myTable", ['number' => ['type' =>"int",'NULL' =>false        ],'text' => ['type' =>"varchar",'size' =>64,'NULL' =>true        ]    ],"number");// Primary key//Use $ssql->deleteTable($table[, $flags]) to delete a table$ssql->deleteTable("myTable");//To see a list of all tables in your database use $ssql->tableList([$flags])print_r($ssql->tableList());//Advanced conditions//You can use more advanced conditions with $ssql->cond(), this will select users that have the same username and nickname signed up in the last hour$ssql->read("users",$ssql->cond()->eq("username","nickname")->gte("sign_up_time",time() -3600));//Use arrays to differentiate string values from column names and to specify more alternatives, the COND_OR flag is also supported//This will select users that have username either "ratajs" or "admin" or that have nickname "RatajS"$ssql->read("users",$ssql->cond()->eq("username", ["ratajs","admin"])->eq("nickname", ["RatajS"],SQ::COND_OR));//->not() negates the condition, this will select users with usernames other than admin$ssql->read("users",$ssql->cond()->eq("username", ["admin"])->not());//You can also pass another condition to it, this will select users that don’t have any nickname with username other than "admin" or "root".$ssql->read("users",$ssql->cond()->eq("nickname", [""])->not($ssql->cond()->eq("username", ["admin","root"])));//Supported conditions: ->eq(), ->lt(), ->gt(), ->lte(), ->gte(), ->like(), ->between(), ->begins(), ->ends(), ->contains() and ->in()//Transactions$ssql->beginTransaction();//...$ssql->endTransaction();//Or $ssql->rollBackTransaction()?>