// Add some users, two steps since must use salt as created before. // $sql = <<<EOD UPDATE {$options['table_prefix']}{$tableName} SET password = md5(concat(salt, ?)) WHERE username = ?; EOD; $db->execute($sql, ['doe', 'doe']); $db->execute($sql, ['admin', 'admin']); // // Check whats in the db // $db->select("*")->from($tableName); $res = $db->executeFetchAll(); echo "<pre>" . print_r($res, 1) . "</pre>"; // // Check password for each user // $db->select("username")->from($tableName)->where("username = ?")->andWhere("password = md5(concat(salt, ?))"); $res = $db->executeFetchAll(['doe', 'doe']); echo "<pre>" . print_r($res, 1) . "</pre>"; // // Check password for each user // $db->select("username")->from($tableName)->where("username = ?")->andWhere("password = md5(concat(salt, ?))"); $res = $db->executeFetchAll(['admin', 'admin']); echo "<pre>" . print_r($res, 1) . "</pre>"; //
$db->update('test', ['age' => 22, 'text' => "Mumintrollet", 'text2' => "Mumindalen"], "id = 2"); echo "<pre>" . $db->getSQL() . "</pre>"; // // Update a single row using two arrays // $db->update('test', ['age', 'text', 'text1'], [22, "Mumintrollet", "Mumindalen"], "id = 2"); echo "<pre>" . $db->getSQL() . "</pre>"; // // Update a single row into table using one array (rest will be sent as parameters) // $db->update('test', ['age', 'text', 'text1'], "id = ?"); echo "<pre>" . $db->getSQL() . "</pre>"; // // Select from database // $db->select("age, text, text1")->from('test')->where("id = 2"); echo "<pre>" . $db->getSQL() . "</pre>"; $db->orderBy("id ASC"); echo "<pre>" . $db->getSQL() . "</pre>"; // // Select and join from database // $db->select("t1.*, t2.*")->from('test AS t1')->join('test AS t2', 't1.id = t2.id'); echo "<pre>" . $db->getSQL() . "</pre>"; $db->select("t1.*, t2.*, t3.*")->from('test AS t1')->join('test AS t2', 't1.id = t2.id')->join('test AS t3', 't1.id = t3.id'); echo "<pre>" . $db->getSQL() . "</pre>"; // // Select, limit and offset // $db->select("*")->from('test')->limit('1'); echo "<pre>" . $db->getSQL() . "</pre>";
<?php // Get environment & autoloader. require __DIR__ . '/config.php'; $db = new \Mos\Database\CDatabaseBasic(); $options = (require "config_mysql.php"); $db->setOptions($options); $db->connect(); $db->setVerbose(); // Set verbose mode to on $db->select()->from('test')->orderBy("id ASC"); $db->execute();