<?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(); }