Issues with PHP to SQLite in Raspberry PI - Raspberry Pi Forums
hi guys, seek on storing data sqlite database using php. have designed web control interface , wanted store data of time been switch on or off whenever user click on turn on button. somehow after start implement write method sqlite database, php display white page , nothing else been shown, not mention nothing been store sqlite database. i'm using raspberry pi hardware. php code: code: select all <?php try { // open database (creates if not present) // put in absolute path file: // e.g. 'sqlite:/data/db_file.db' (the extension not important) $db = new pdo('sqlite:/var/www/sensordb.db'); // output data simple html table... $table = "<tr><th>id</th><th>sensor</th><th>switch on log</th><th>switch off log</th></tr>"; // query db $result = $db->query('select * sensor'); // repeat each row in result set foreach ($result $row) { ...
