php sqlite_fetch_array函数的二个例子

2. /**
3. * sqlite_fetch_array函数取结果集
4. * by bbs.it-home.org
5. */
6. $sqldb = sqlite_open("mydatabase.db");
7. $results = sqlite_query($sqldb, "SELECT * FROM employee");
8. while ($row = sqlite_fetch_array($results,SQLITE_BOTH)) {
9. echo "Name: $row[1] (Employee ID: ".$row['empid'].")
   ";
10. }
11. sqlite_close($sqldb);
12. ?>

复制代码

例2，sqlite_fetch_array函数、list函数循环输出结果集

2. /***
3. * sqlite_fetch_array函数输出结果集
4. * by bbs.it-home.org
5. */
6. $sqldb = sqlite_open("mydatabase.db");
7. $results = sqlite_query($sqldb, "SELECT * FROM employee");
8. while (list($empid, $name) = sqlite_fetch_array($results)) {
9. echo "Name: $name (Employee ID: $empid)
   ";
10. }
11. sqlite_close($sqldb);
12. ?>

复制代码