mirror of
https://github.com/php/presentations.git
synced 2026-03-25 08:02:07 +01:00
16 lines
464 B
PHP
16 lines
464 B
PHP
<?php
|
|
$db = new sqlite_db(dirname(__FILE__)."/db.sqlite");
|
|
$res = $db->query("SELECT * FROM auth_tbl");
|
|
|
|
/* return number of rows selected */
|
|
echo "Rows Fetched: " . $res->num_rows() . "<br />\n";
|
|
|
|
/* determine the number of columns in the result set */
|
|
echo "Columns per row " . ($n_cols = $res->num_fields()) . "<br />\n";
|
|
|
|
for ($i = 0; $i < $n_cols; $i++) {
|
|
/* fetch column names */
|
|
echo "Column Names: " . $res->field_name($i) . "<br />\n";
|
|
}
|
|
?>
|