Store records from Raspberry PI's Web Control - Raspberry Pi Forums

hi guys, seek on storing records time been switch on or off sql database whenever switch on or off. uses phpmyadmin store web control stuff. hardware raspberry pi , led.

gpioserver.sh

code: select all

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 		echo "gpio 4 turned on" 	else 		echo "0" > /sys/class/gpio/gpio4/value 		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                 echo "gpio 17 turned on"         else                 echo "0" > /sys/class/gpio/gpio17/value                 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                 echo "gpio 18 turned on"         else                 echo "0" > /sys/class/gpio/gpio18/value                 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                 echo "gpio 21 turned on"         else                 echo "0" > /sys/class/gpio/gpio21/value                 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                 echo "gpio 22 turned on"         else                 echo "0" > /sys/class/gpio/gpio22/value                 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                 echo "gpio 23 turned on"         else                 echo "0" > /sys/class/gpio/gpio23/value                 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                 echo "gpio 24 turned on"         else                 echo "0" > /sys/class/gpio/gpio24/value                 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                 echo "gpio 25 turned on"         else                 echo "0" > /sys/class/gpio/gpio25/value                 echo "gpio 25 turned off"         fi else         echo "in" > /sys/class/gpio/gpio25/direction fi #complete loop sleep $waittime done 

hope guys me out possible, in advance, guys.

raspberrypi