[ Posted by Tejram ] pdo sqlite database

fiddle_054514.php

<?php

/**
 * PDO SQLite initial code
 * 
 * Using phpLiteAdmin to admin SQLite3 and SQLite2 database : inclibs/util/sqlite3.db, inclibs/util/sqlite2.db
 * 
 * @package			PhpFiddle
 * @link			http://phpfiddle.org
 * @since			2012
*/

require_once "dBug!.php";

// for SQLite3 database
$dsn = "sqlite:inclibs/util/sqlite3.db";

$connect = new PDO($dsn);

//get all tables and column information in the database
$sql = "SELECT * FROM sqlite_master WHERE type = 'table'";

//SQL statement for a table data
//$sql = "SELECT * FROM Products WHERE ProductID <= 10";	

$result = $connect->prepare($sql);

//bind parameter(s) to variable(s)
//$result->bindParam( . . . );

$result->execute();

$rows = $result->fetch();

//for one-time query, this line is same with code from line 19 to 24
//$result = $connect->query($sql);

$results = array();

//convert query result into an associative array
foreach($rows as $row)
{
	$results[] = $row;
}

//dump all data from associative array converted from query result
new dBug($results);

$connect = null;


?>