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; } } } } }