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); ?> 複製代碼

