尝试使用php在sqlite数据库中选择一条记录


Trying to SELECT a record in an sqlite database using php

我正试图从tblTermDate表中选择一条记录。我只得到了两者的输出1。字段中输入了数据,两个日期的格式均为VARCHAR。任何帮助都将不胜感激。谢谢!

<?php
// create or open database called TimeTable.sqlite
$db = @sqlite_open("TimeTable.sqlite");
//Get Start Date from Table
$StartDate = @sqlite_exec($db, "SELECT fldStartDate FROM tblTermDate WHERE fldTerm_Name ='Christmas 1st Half' ");
//Print Start Date
echo $StartDate;
echo "<br> </br>";
//Get Start Date from Table
$EndDate = @sqlite_exec($db, "SELECT fldEndDate FROM tblTermDate WHERE fldTerm_Name ='Christmas 1st Half' ");
//Print End Date
echo $EndDate;
//Database Close
@sqlite_close($db);
?>

sqlite_exec执行SQL语句,不返回任何行。如果语句执行成功,则返回值为true,否则返回值为false。因此,您的"输出"为1。您要查找的是sqlite_query方法:http://www.php.net/manual/en/function.sqlite-query.php