PHP My_sqlite::fetchAll Examples

Example #1

File: index.php Project: vihoangson/Program_lesson

require_once "class/lesson5.php";
$sqlite = new My_sqlite();
$lesson5 = new Lesson5($sqlite);
if ($_POST["ajax"]) {
    //
    // Security mod filter variable before save (true|false)
    //
    $security_mod = true;
    if ($security_mod) {
        $text = base64_encode($_POST["text"]);
    } else {
        $text = $_POST["text"];
    }
    $sql = "SELECT * FROM text_tb where text_id=1 ";
    $rs = $sqlite->query($sql);
    $data = $sqlite->fetchAll($rs);
    if (count($data) == 0) {
        $sql = 'INSERT INTO text_tb("text_id","text_c") VALUES (1,"' . $text . '");';
    } else {
        $sql = 'UPDATE text_tb SET	text_c	= "' . $text . '"	WHERE text_id=1';
    }
    if (!$sqlite->exec($sql)) {
        $error = true;
        echo 0;
    } else {
        $error = false;
        echo 1;
    }
    die;
} else {
    $sql = "SELECT * FROM text_tb where text_id=1 ";