<?php
require 'SQLite3_DB_Helper.php';
$db = new Database();
$sql = "\nDELETE FROM CONTACT_LIST;\nINSERT INTO CONTACT_LIST (LNAME, FNAME, PHONE, EMAIL)\nVALUES ('DELA CRUZ', 'JUAN', '123456789', '*****@*****.**');\nINSERT INTO CONTACT_LIST (LNAME, FNAME, PHONE, EMAIL)\nVALUES ('CLARA', 'MARIA', '987654321', '*****@*****.**');\n";
$result = $db->_exec($sql);
if (!$result) {
$db->_console_log($this->database->lastErrorMsg());
} else {
$db->_console_log('Records created successfully.');
}
$sql = "\nSELECT * FROM CONTACT_LIST;\n";
$result = $db->_query($sql);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
echo "ID = " . $row['ID'] . "\n";
echo "LNAME = " . $row['LNAME'] . "<br/>";
echo "FNAME = " . $row['FNAME'] . "<br/>";
echo "PHONE = " . $row['PHONE'] . "<br/>";
echo "EMAIL = " . $row['EMAIL'] . "<br/><br/>";
}
$db->_console_log('Operation SELECT done successfully.');
<?php
define('DBNAME', 'keytosecurity');
define('DBHOST', 'localhost');
define('DBUSER', 'root');
define('DBPASSWORD', '');
require_once dirname(dirname(__DIR__)) . '/core/Database.class.php';
Database::_init();
$req = "SELECT * FROM `quizzs` ORDER BY RAND() LIMIT 0,6";
$quizzs = array();
foreach (Database::_query($req) as $v) {
$q = new stdClass();
$q->id = $v['id'];
$q->question = $v['question'];
$q->answers = json_decode($v['answers'], true);
$q->correct = $v['correct'];
$quizzs[$q->id] = $q;
}
echo json_encode($quizzs);
/**
* Resets the internal cache for various things that are needed on a
* per-query basis.
*/
protected static function _reset_cache()
{
self::$_query = '';
self::$_query_type = '';
self::$_where = array();
self::$_variable_binds = array();
self::$_query_data = array();
}
