php sqlite_fetch_array函數的二個例子

/**
* sqlite_fetch_array函数取结果集
* by bbs.it-home.org
*/
   $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'].")";
   }
   sqlite_close($sqldb);
?>

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

/***
* sqlite_fetch_array函数输出结果集
* by bbs.it-home.org
*/
   $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)";
   }
   sqlite_close($sqldb);
?>