PHP/MySQL Database/sqlite column

Материал из Web эксперт
Перейти к: навигация, поиск

sqlite_column.php

   <source lang="html4strict">

<?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) 
"; sqlite_close($sqldb);

?>

 </source>