sqlite_fetch_array函数的两个例子
sqlite_fetch_array函数示例
<?php /** * sqlite_fetch_array函数取结果集 * by www.junphp.com */ $sqldb = sqlite_open("mydatabase.db"); $results = sqlite_query($sqldb, "SELECT * FROM employee"); while ($row = sqlite_fetch_array($results, SQLITE_BOTH)) { echo "Name: $row[1] (Employee ID: " . $row['empid'] . ")<br />"; } sqlite_close($sqldb); ?>sqlite_fetch_array函数、list函数循环输出结果集
<?php
/***
* sqlite_fetch_array函数输出结果集
* by www.junphp.com
*/
$sqldb = sqlite_open("mydatabase.db");
$results = sqlite_query($sqldb, "SELECT * FROM employee");
while (list($empid, $name) = sqlite_fetch_array($results)) {
echo "Name: $name (Employee ID: $empid)<br />";
}
sqlite_close($sqldb);
?>
上一篇:
php连接数据库的四种方法
下一篇:
php创建SQLite数据库
友情提示:垃圾评论一律封号...