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) {         $table .= 	    "<tr>"             "<tr><th>gpio #</th><th>gpio description</th><th>status</th><th>action</th><th>edit</th></tr>" 	    if [ "$direction4" == "out" ]; 	            echo "" > /sys/class/gpio/gpio4/direction 	            if [ "$status4" == "1" ];                             $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg"; 		            $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('1', 'red led', 2014/07/02 19:19, '') > /sys/class/gpio/gpio4/value 		            echo "" 	            else 			    $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg"; 		            $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('1', 'red led', '', '2014/07/02 19:30') > /sys/class/gpio/gpio4/value 		            echo "" 	            fi             else 	            echo "" > /sys/class/gpio/gpio4/direction             fi             if [ "$direction17" == "out" ];                     echo "" > /sys/class/gpio/gpio17/direction 	            if [ "$status17" == "1" ]; 			    $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('2', 'blue led', 2014/07/02 20:19, '') > /sys/class/gpio/gpio17/value 		            echo ""                     else                             $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('2', 'blue led', '', 2014/07/02 20:30) > /sys/class/gpio/gpio17/value 		            echo ""                     fi             else                             echo "" > /sys/class/gpio/gpio17/direction             fi             if [ "$direction18" == "out" ];                     echo "" > /sys/class/gpio/gpio18/direction 	            if [ "$status18" == "1" ];             		    $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('3', 'green led', 2014/07/02 21:19, '') > /sys/class/gpio/gpio18/value 		            echo ""                     else 			    $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('3', 'green led', '', 2014/07/02 21:30) > /sys/class/gpio/gpio18/value 		            echo ""                     fi             else                     echo "" > /sys/class/gpio/gpio18/direction             fi             if [ "$direction21" == "out" ];                     echo "" > /sys/class/gpio/gpio21/direction 	            if [ "$status21" == "1" ]; 			    $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('4', '', '', '') > /sys/class/gpio/gpio21/value 		            echo ""                     else 			    $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('4', '', '', '') > /sys/class/gpio/gpio21/value 		            echo ""                      fi             else                      echo "" > /sys/class/gpio/gpio21/direction             fi             if [ "$direction22" == "out" ];                     echo "" > /sys/class/gpio/gpio22/direction 	            if [ "$status22" == "1" ]; 			    $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('5', '', '', '') > /sys/class/gpio/gpio22/value 		            echo ""                     else 			    $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('5', '', '', '') > /sys/class/gpio/gpio22/value 		            echo ""                     fi             else                     echo "" > /sys/class/gpio/gpio22/direction             fi             if [ "$direction23" == "out" ];                     echo "" > /sys/class/gpio/gpio23/direction 	            if [ "$status23" == "1" ]; 			    $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('6', '', '', '') > /sys/class/gpio/gpio23/value 		            echo ""                     else 			    $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('6', '', '', '') > /sys/class/gpio/gpio23/value 		            echo ""                     fi             else                     echo "" > /sys/class/gpio/gpio23/direction             fi             if [ "$direction24" == "out" ];                     echo "" > /sys/class/gpio/gpio24/direction 	            if [ "$status24" == "1" ]; 			    $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('7', '', '', '') > /sys/class/gpio/gpio24/value 		            echo ""                     else 			    $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('7', '', '', '') > /sys/class/gpio/gpio24/value 		            echo ""                     fi             else                     echo "" > /sys/class/gpio/gpio24/direction             fi             if [ "$direction25" == "out" ];                     echo "" > /sys/class/gpio/gpio25/direction 	            if [ "$status25" == "1" ]; 			    $buttonvalue = "turn off"; 			    $action = "turnoff"; 			    $image = "on.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('8', '', '', '') > /sys/class/gpio/gpio25/value 		            echo ""                     else 			    $buttonvalue = "turn on"; 			    $action = "turnon"; 			    $image = "off.jpg";                             $db->exec("insert sensor (id, sensor, switch on log, switch off log) values ('8', '', '', '') > /sys/class/gpio/gpio25/value 		            echo ""                     fi             else                     echo "" > /sys/class/gpio/gpio25/direction             fi     }     // print screen     print "<h2>sensor data log</h1>";     print "<table border=1> $table </table>";      // query db     $result = $db->query('select * sensor');         // repeat each row in result set     foreach ($result $row) {         $table1 .= 	    "<tr><td>" . $row['id'] . "</td>" .              "<td>" . $row['sensor'] . "</td>" . 	    "<td>" . $row['switch on log'] . "</td>" .             "<td>" . $row['swicth off log'] . "</td></tr>";     }          // finish table , print screen     print "<h2>sensor data log</h1>";     print "<table border=1> $table1 </table>";          // close database connection     $db = null; } catch(pdoexception $e) {     // else there problem     print "exception : " . $e->getmessage(); } ?> </body> </html> 

hope guys me out possible, in advance, guys.

it's broken here

code: select all

    $table .=    "<tr>"         "<tr><th>gpio #</th><th>gpio description</th><th>status</th><th>action</th><th>edit</th></tr>"    if [ "$direction4" == "out" ];            echo "" > /sys/class/gpio/gpio4/direction            if [ "$status4" == "1" ];                         $buttonvalue = "turn off";          $action = "turnoff";          $image = "on.jpg";

line starting $table missing concatenate "." operator.
delimiter if statement in php parentheses "()" not brackets "[]".

haven't looked beyond first 2 broken statements.

php under apache error messages written /var/log/apache2/error.log.

basic syntax on place (you've written in shell script format).

code: select all

if ($somevariable == "somestring") {   /* code here */ } else {   /* complete opposite here */ }

raspberrypi