sqlite_fetch_array.php : sqlite_fetch_array « MySQL Database « PHP

1. PHP
2. MySQL Database
3. sqlite_fetch_array

sqlite_fetch_array.php

 
<?php
   $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);
?>
  
  

Related examples in the same category