{ Snipperize }

How to use the SQLite Objetct Oriented Interface

↑ Grab this Headline Animator

This is a PHP snippet, talking about sqlite and oop

PHP: sqlite, oop

MongoHub

Versions

r104173

How to use the SQLite Objetct Oriented Interface Add to Favorite

<?php

if (!$bd = new SQLiteDatabase('database.sqlite', 0666, $error))
    die($error);
$sql = "SELECT * FROM table_name";
$data = $db->query($sql);
$data_count = $data->numRows();
if ($data_count != 0) {
    for ($i=0; $i<$data_count; $i++) {
        echo "$data->fieldName($i)";
    }
    while ($tuple = $data->fetch()) {
        echo "$tuple['name']<br>";
        echo "$tuple['description']<br>";
        echo "$tuple['prize']<br>";
    }
}
unset($bd);

?>

SQLite Object Oriented Interface for PHP

Created by ThePeppersStudio (259 days, 8.22 hours ago)

Do you want to leave a message? Please login first.

Home
New Snippet
Languages