PDO_Connect("sqlite:{$db_file}");
//Fetch data from DB
$All = PDO_FetchAll("SELECT * FROM users WHERE age < :age", array("age" => 20000));
//Array ( [0] => Array ( [name] => dasd [age] => 2000 ) )
// Selects all elements till 20000.
//print_r($All);
//echo "<br>";
$age = PDO_FetchOne("SELECT age FROM users WHERE name = :name", array("name" => "omt"));
//Select one column from the row with some specific details know.
//print_r($age);
//echo "<br>";
$rowdetails = PDO_FetchRow("SELECT * FROM users WHERE name = :name", array("name" => "omt"));
// Select complete row from a table
//print_r($rowdetails);
//echo "<br>";
$association = PDO_FetchAssoc("SELECT name, age FROM users");
//print_r($association);
//echo "<br>";
//Insert or update to DB
PDO_Execute("INSERT INTO users (name, age) VALUES (:name, :age)", array("name" => "apple", "age" => 150));
PDO_Execute("UPDATE users SET age = 200 WHERE name = 'apple'");
//Last Insert ID
//$id = PDO_LastInsertId();
//print_r($id);
?>
<?php
echo "<br> Using variables in statements ";
$name = "omt";
$tablename = "users";
function list_tables($views_mode = false)
{
// @tables
// @views
global $db_driver, $db_link, $db_name;
if ($views_mode && !views_supported()) {
return array();
}
static $cache_tables;
static $cache_views;
if ($views_mode) {
if (isset($cache_views)) {
return $cache_views;
}
} else {
if (isset($cache_tables)) {
return $cache_tables;
}
}
static $all_tables;
// tables and views
if ('mysql' == $db_driver) {
if (!isset($all_tables)) {
$all_tables = db_assoc("SHOW FULL TABLES");
// assoc: table name => table type (BASE TABLE or VIEW)
}
// This chunk of code is the same as in pgsql driver.
if ($views_mode) {
$views = array();
foreach ($all_tables as $view => $type) {
if ($type != 'VIEW') {
continue;
}
$views[] = $view;
}
$cache_views = $views;
return $views;
} else {
$tables = array();
foreach ($all_tables as $table => $type) {
if ($type != 'BASE TABLE') {
continue;
}
$tables[] = $table;
}
$cache_tables = $tables;
return $tables;
}
} else {
if ('pgsql' == $db_driver) {
if (!isset($all_tables)) {
$query = "SELECT table_name, table_type ";
$query .= "FROM information_schema.tables ";
$query .= "WHERE table_schema = 'public' ";
$query .= "AND (table_type = 'BASE TABLE' OR table_type = 'VIEW') ";
$query .= "ORDER BY table_name ";
$all_tables = db_assoc($query);
}
// This chunk of code is the same as in mysql driver.
if ($views_mode) {
$views = array();
foreach ($all_tables as $view => $type) {
if ($type != 'VIEW') {
continue;
}
$views[] = $view;
}
$cache_views = $views;
return $views;
} else {
$tables = array();
foreach ($all_tables as $table => $type) {
if ($type != 'BASE TABLE') {
continue;
}
$tables[] = $table;
}
$cache_tables = $tables;
return $tables;
}
} else {
if ("sqlite" == $db_driver) {
if ($views_mode) {
$views = PDO_FetchAssoc("SELECT name FROM sqlite_master WHERE type = 'view' AND name NOT LIKE 'sqlite_%' ORDER BY name");
$cache_views = $views;
return $views;
} else {
$tables = PDO_FetchAssoc("SELECT name FROM sqlite_master WHERE type = 'table' AND name NOT LIKE 'sqlite_%' ORDER BY name");
$cache_tables = $tables;
return $tables;
}
}
}
}
}
