Insert data to phpMyAdmin mySQL database from Shell Script - Raspberry Pi Forums

sorry disturb guys, seek on inserting data whenever switch on or off phpmyadmin mysql database shell script. i'm using raspberry pi hardware , have follow link: http://www.instructables.com/id/web-con ... /?allsteps create own web control interface. have created mysql database , insert phpmyadmin. after implemented insert method gpioserver.sh , execute it, shell script can't work @ all, led never light , never store mysql database.

gpioserver.sh:

code: select all

#!/bin/sh  mysqlusername="username here" mysqlpassword="password here"  #set  refresh echo "how long want wait time be?" read waittime  #invoke gpio echo "4" > /sys/class/gpio/export echo "17" > /sys/class/gpio/export echo "18" > /sys/class/gpio/export echo "21" > /sys/class/gpio/export echo "22" > /sys/class/gpio/export echo "23" > /sys/class/gpio/export echo "24" > /sys/class/gpio/export echo "25" > /sys/class/gpio/export  #start loop while : #read mysql data #direction direction4=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='4'";) direction17=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='17'";) direction18=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='18'";) direction21=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='21'";) direction22=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='22'";) direction23=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='23'";) direction24=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='24'";) direction25=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pindirection pindirection pinnumber='25'";) #status status4=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='4'";) status17=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='17'";) status18=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='18'";) status21=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='21'";) status22=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='22'";) status23=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='23'";) status24=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='24'";) status25=$(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword gpio -e "select pinstatus pinstatus pinnumber='25'";)  #run commands if [ "$direction4" == "out" ];     echo "out" > /sys/class/gpio/gpio4/direction     if [ "$status4" == "1" ];         echo "1" > /sys/class/gpio/gpio4/value         $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("1","red led", datetime,"")";)         echo "gpio 4 turned on"     else         echo "0" > /sys/class/gpio/gpio4/value         $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("1","red led", "", datetime)";)         echo "gpio 4 turned off"     fi else     echo "in" > /sys/class/gpio/gpio4/direction fi if [ "$direction17" == "out" ];         echo "out" > /sys/class/gpio/gpio17/direction     if [ "$status17" == "1" ];                 echo "1" > /sys/class/gpio/gpio17/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("2","blue led", datetime,"")";)                 echo "gpio 17 turned on"         else                 echo "0" > /sys/class/gpio/gpio17/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("2","blue led", "", datetime)";)                 echo "gpio 17 turned off"         fi else         echo "in" > /sys/class/gpio/gpio17/direction fi if [ "$direction18" == "out" ];         echo "out" > /sys/class/gpio/gpio18/direction     if [ "$status18" == "1" ];                 echo "1" > /sys/class/gpio/gpio18/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("3","green led", datetime,"")";)                 echo "gpio 18 turned on"         else                 echo "0" > /sys/class/gpio/gpio18/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("3","green led", "", datetime)";)                 echo "gpio 18 turned off"         fi else         echo "in" > /sys/class/gpio/gpio18/direction fi if [ "$direction21" == "out" ];         echo "out" > /sys/class/gpio/gpio21/direction     if [ "$status21" == "1" ];                 echo "1" > /sys/class/gpio/gpio21/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("4","yellow led", datetime,"")";)                 echo "gpio 21 turned on"         else                 echo "0" > /sys/class/gpio/gpio21/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("4","yellow led", "", datetime)";)                 echo "gpio 21 turned off"         fi else         echo "in" > /sys/class/gpio/gpio21/direction fi if [ "$direction22" == "out" ];         echo "out" > /sys/class/gpio/gpio22/direction     if [ "$status22" == "1" ];                 echo "1" > /sys/class/gpio/gpio22/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("5","led", "","")";)                 echo "gpio 22 turned on"         else                 echo "0" > /sys/class/gpio/gpio22/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("5","led", "", "")";)                 echo "gpio 22 turned off"         fi else         echo "in" > /sys/class/gpio/gpio22/direction fi if [ "$direction23" == "out" ];         echo "out" > /sys/class/gpio/gpio23/direction     if [ "$status23" == "1" ];                 echo "1" > /sys/class/gpio/gpio23/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("6","led", "","")";)                 echo "gpio 23 turned on"         else                 echo "0" > /sys/class/gpio/gpio23/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("6","led", "", "")";)                 echo "gpio 23 turned off"         fi else         echo "in" > /sys/class/gpio/gpio23/direction fi if [ "$direction24" == "out" ];         echo "out" > /sys/class/gpio/gpio24/direction     if [ "$status24" == "1" ];                 echo "1" > /sys/class/gpio/gpio24/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("7","led", "","")";)                 echo "gpio 24 turned on"         else                 echo "0" > /sys/class/gpio/gpio24/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("7","led", "", "")";)                 echo "gpio 24 turned off"         fi else         echo "in" > /sys/class/gpio/gpio24/direction fi if [ "$direction25" == "out" ];         echo "out" > /sys/class/gpio/gpio25/direction     if [ "$status25" == "1" ];                 echo "1" > /sys/class/gpio/gpio25/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("8","led", "","")";)                 echo "gpio 25 turned on"         else                 echo "0" > /sys/class/gpio/gpio25/value                 $(mysql -b --disable-column-names --user=$mysqlusername --password=$mysqlpassword sensor -e "insert sensor values("8","led", "", "")";)                 echo "gpio 25 turned off"         fi else         echo "in" > /sys/class/gpio/gpio25/direction fi #complete loop sleep $waittime done 

sensor mysql database in phpmyadmin:

code: select all

create table if not exists `sensor` (   `id` int(11) not null,   `sensor` text not null,   `switchonlog` datetime not null,   `switchofflog` datetime not null,   primary key (`id`) ) engine=innodb default charset=latin1; 

error screenshot got when executing gpioserver.sh:

error.png (54.59 kib) viewed 1856 times

result should getting sensor mysql database if success:

debug result.png (4.01 kib) viewed 1847 times

hope guys me out possible, in advance, guys.

for me easier have php-cli script accepted input

i.e temp1= $_request['temp1'];

pdo statement insert it.

raspberrypi