PHP Database::_exec Examples

Example #1

File: index.php Project: khalel/PHP_SQLite_Database_Helper

<?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.');