Enter New Password: Confirm:

'; } else { $action = $_GET['action']; $pin = mysql_real_escape_string($_GET['pin']); if ($action == "turnOn"){ $setting = "1"; exec("gpio -g mode $pin out"); exec("gpio -g write $pin $setting"); mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='$pin';"); goto mostrar_pagina; } else if ($action == "turnOff"){ $setting = "0"; exec("gpio -g mode $pin out"); exec("gpio -g write $pin $setting"); mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='$pin';"); goto mostrar_pagina; } else if ($action =="edit"){ $pin = mysql_real_escape_string($_GET['pin']); $query = mysql_query("SELECT pinDescription FROM pinDescription WHERE pinNumber='$pin';"); $descRow = mysql_fetch_assoc($query); $description = $descRow['pinDescription']; print '

Descripción:

'; mysql_close(); } else IF ($action =="update"){ $pin = mysql_real_escape_string($_GET['pin']); $description = mysql_real_escape_string($_GET['description']); mysql_query("UPDATE pinDescription SET pinDescription='$description' WHERE pinNumber='$pin';"); goto mostrar_pagina; } else { goto mostrar_pagina; } } } else { mostrar_pagina: print ' '; $query = mysql_query("SELECT pinNumber, pinStatus FROM pinStatus;"); $query2 = mysql_query("SELECT pinNumber, pinDescription FROM pinDescription;"); $totalGPIOCount = mysql_num_rows($query); $currentGPIOCount = 0; print ''; print ''; while ($currentGPIOCount < $totalGPIOCount){ $pinRow = mysql_fetch_assoc($query); $descRow = mysql_fetch_assoc($query2); $pinNumber = $pinRow['pinNumber']; //$pinStatus = $pinRow['pinStatus']; exec("gpio -g mode $pinNumber out"); $pinStatus = exec("gpio -g read $pinNumber"); $pinDescription = $descRow['pinDescription']; If ($pinStatus == "0"){ $buttonValue = "Encender"; $action = "turnOn"; $image = "off.jpg"; } else { $buttonValue = "Apagar"; $action = "turnOff"; $image = "on.jpg"; } print ''; print ''; print ''; $currentGPIOCount ++; } print '

GPIO #	GPIO Descripción	Estado	Acción	Editar
' . $pinNumber . '	' . $pinDescription . '

'; mysql_close(); print '

'; } ?>