网页无法显示phpselect数据库sqlite3里的东西。

  Select a task:

  MATH

  ENGLISH

 

 













我的php文件叫getuser.php 如下

   














$q = intval($_GET['q']);



class MyDB extends SQLite3{

    function _construct(){

        $this->open(‘CS1962.db’);

        }

    }

}

$db = new MyDB();

if(!$db){

    echo $db->lastErrorMsg();

}  else{

    echo "Opened database successfully\n";

}



$sql =<<
    SELECT * FROM MYTIME WHERE id = '".$q."'

EOF;



$ret = $db->query($sql);













echo "













";



while($row = $ret->fetchArray(SQLITE3_ASSOC) ) {

    echo "";

    echo "";

    echo "";

    echo "";

    echo "";

   

    echo "";

}

echo "

TASK	TAG	DURATION	DATE
" . $row['TASK'] . "	" . $row['TAG'] . "	" . $row['DURATION'] . "	" . $row['DATE'] . "

";

$db->close();

?>