sqlite_column.php : sqlite_column « MySQL Database « PHP

1. PHP
2. MySQL Database
3. sqlite_column

sqlite_column.php

 
<?php
    $sqldb = sqlite_open("mydatabase.db");
    $results = sqlite_query($sqldb,"SELECT * FROM employee WHERE empid = '1'");
    $name = sqlite_column($results,"name");
    $empid = sqlite_column($results,"empid");
    echo "Name: $name (Employee ID: $empid) <br />";
    sqlite_close($sqldb);
?>
  
  

Related examples in the same category