Advertising
y u no do it?

Advertising (learn more)
Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

Starts at just $1 per CPM or $0.10 per CPC.

Need help on Insert data to phpMyAdmin mySQL database

Discussion in 'PHP' started by aoiregion, Jul 18, 2014.

aoiregion Peon

Messages:: 5

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 1

Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method. After I implemented insert method to my control.php and execute it, it cannot works and cannot store.

This is my control.php:


<?php
session_start();

$MySQLUsername = "MySQLUsername";
$MYSQLUsersensor = "MYSQLUsersensor";
$MySQLPassword = "MySQLPassword";


$MySQLHost = "localhost";
$MySQLDB = "gpio";
$MYSQLDBsensor = "sensor";

If (($MySQLUsername == "USERNAME HERE") || ($MySQLPassword == "PASSWORD HERE")){
    print 'ERROR - Please set up the script first';
    exit();
}

$dbConnection = mysql_connect($MySQLHost, $MySQLUsername, $MySQLPassword);
mysql_select_db($MySQLDB, $dbConnection);
If (isset($_POST['action'])){
    If ($_POST['action'] == "setPassword"){
        $password1 = $_POST['password1'];
        $password2 = $_POST['password2'];
        If ($password1 != $password2){
            header('Location: control.php');
        }
        $password = mysql_real_escape_string($_POST['password1']);
        If (strlen($password) > 28){
            mysql_close();
            header('location: control.php');
        }
        $resetQuery = "SELECT username, salt FROM users WHERE username = 'admin';";
        $resetResult = mysql_query($resetQuery);
        If (mysql_num_rows($resetResult) < 1){
            mysql_close();
            header('location: control.php');
        }
        $resetData = mysql_fetch_array($resetResult, MYSQL_ASSOC);
        $resetHash = hash('sha256', $salt . hash('sha256', $password));
        $hash = hash('sha256', $password);
        function createSalt(){
            $string = md5(uniqid(rand(), true));
            return substr($string, 0, 8);
        }
        $salt = createSalt();
        $hash = hash('sha256', $salt . $hash);
        mysql_query("UPDATE users SET salt='$salt' WHERE username='admin'");
        mysql_query("UPDATE users SET password='$hash' WHERE username='admin'");
        mysql_close();
        header('location: control.php');
    }
}
If ((isset($_POST['username'])) && (isset($_POST['password']))){
    $username = mysql_real_escape_string($_POST['username']);
    $password = mysql_real_escape_string($_POST['password']);
    $loginQuery = "SELECT UserID, password, salt FROM users WHERE username = '$username';";
    $loginResult = mysql_query($loginQuery);
    If (mysql_num_rows($loginResult) < 1){
        mysql_close();
        header('location: control.php?error=incorrectLogin');
    }
    $loginData = mysql_fetch_array($loginResult, MYSQL_ASSOC);
    $loginHash = hash('sha256', $loginData['salt'] . hash('sha256', $password));
    If ($loginHash != $loginData['password']){
        mysql_close();
        header('location: control.php?error=incorrectLogin');
    } else {
        session_regenerate_id();
        $_SESSION['username'] = "admin";
        $_SESSION['userID'] = "1";
        mysql_close();
        header('location: control.php');
    }
}
If ((!isset($_SESSION['username'])) || (!isset($_SESSION['userID']))){
    print '
    <html>
    <head>
    <title>GPIO Control - Login</title>
    </head>
    <body>
    <table border="0" align="center">
    <form name="login" action="control.php" method="post">
    <tr>
    <td>Username: </td><td><input type="text" name="username"></td>
    </tr>
    <tr>
    <td>Password: </td><td><input type="password" name="password"></td>
    </tr>
    <tr>
    <td colspan="2" align="center"><input type="submit" value="Log In"></td>
    </tr>
    </form>
    </table>
    </body>
    </html>
    ';
    die();
}
If (isset($_GET['action'])){
    If ($_GET['action'] == "logout"){
        $_SESSION = array();
        session_destroy();
        header('Location: control.php');
    } else If ($_GET['action'] == "setPassword"){
        print '
        <form name="changePassword" action="control.php" method="post">
        <input type="hidden" name="action" value="setPassword">
        <p>Enter New Password: <input type="password" name="password1">  Confirm: <input type="password" name="password2"><input type="submit" value="submit"></p>
        </form>
        ';
    } else {
                $now = new DateTime();
        $action = $_GET['action'];
        $pin = mysql_real_escape_string($_GET['pin']);
        if ($action == "turnOn"){
            $setting = "1";
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='4';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('1', 'Red LED', $now, '')");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='17';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('2', 'Blue LED', $now, '')");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='18';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('3', 'Green LED', , '')");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='21';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('4', 'LED', $now, '')");
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='22';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('5', 'LED', $now, '')");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='23';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('6', 'LED', $now, '')");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='24';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('7', 'LED', $now, '')");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='25';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('8', 'LED', $now, '')");
            mysql_close();
            header('Location: control.php');
        } else If ($action == "turnOff"){
            $setting = "0";
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='4';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('1', 'Red LED', '', $now)");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='17';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('2', 'Blue LED', '', $now)");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='18';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('3', 'Green LED', '', $now)");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='21';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('4', 'LED', '', $now)");
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='22';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('5', 'LED', '', $now)");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='23';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('6', 'LED', '', $now)");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='24';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('7', 'LED', '', $now)");
            mysql_close();
            mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='25';");
            $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
            mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
            mysql_query("INSERT INTO sensor('8', 'LED', '', $now)");
            mysql_close();
            header('Location: control.php');
        } 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 '
            <html><head><title>Update Pin ' . $pin . '</title></head><body>
            <table border="0">
            <form name="edit" action="control.php" method="get">
            <input type="hidden" name="action" value="update">
            <input type="hidden" name="pin" value="' . $pin . '">
            <tr>
            <td><p>Description: </p></td><td><input type="text" name="description" value="' . $description . '"></td><td><input type="submit" value="Confirm"></td>
            </tr>
            </form>
            </table>
            </body></html>
            ';
            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';");
            header('Location: control.php');
        } else {
            header('Location: control.php');
        }
    }
} else {
    print '
        <html>
        <head>
        <title>GPIO Control</title>
        </head>
        <font face="verdana">
        <p><h1>Sensors</h1></p>
        ';
        $query = mysql_query("SELECT pinNumber, pinStatus FROM pinStatus;");
        $query2 = mysql_query("SELECT pinNumber, pinDescription FROM pinDescription;");
        $totalGPIOCount = mysql_num_rows($query);
        $currentGPIOCount = 0;
        print '<table name="GPIO" border="1" cellpadding="5">';
        print '<tr><th>GPIO #</th><th>GPIO Description</th><th>Status</th><th>Action</th><th>Edit</th></tr>';
        while ($currentGPIOCount < $totalGPIOCount){
            $pinRow = mysql_fetch_assoc($query);
            $descRow = mysql_fetch_assoc($query2);
            $pinNumber = $pinRow['pinNumber'];
            $pinStatus = $pinRow['pinStatus'];
            $pinDescription = $descRow['pinDescription'];
            If ($pinStatus == "0"){
                $buttonValue = "Turn On";
                $action = "turnOn";
                $image = "off.jpg";
            } else {
                $buttonValue = "Turn Off";
                $action = "turnOff";
                $image = "on.jpg";
            }
            print '<tr>';
            print '<td align="center">' . $pinNumber . '</td><td>' . $pinDescription . '</td><td align="center"><img src="' . $image . '" width="50"></td><td align="center" valign="middle"><form name="pin' . $pinNumber . 'edit" action="control.php" method="get"><input type="hidden" name="action" value="' . $action . '"><input type="hidden" name="pin" value="' . $pinNumber . '"><input type="submit" value="' . $buttonValue . '"></form></td><td><form name="pin' . $pinNumber . '" action="control.php" method="get"><input type="hidden" name="action" value="edit"><input type="hidden" name="pin" value="' . $pinNumber . '"><input type="submit" value="Edit"></form></td>';
            print '</tr>';
            $currentGPIOCount ++;
        }
        print '</table>';
        mysql_close();
    print '
    <br><br>
    <a href="control.php?action=logout">Log Out</a>
    </font>
    </html>
    ';
}
?>

PHP:

This is my pinDirection SQL database:


DROP TABLE IF EXISTS `pinDirection`;
CREATE TABLE IF NOT EXISTS `pinDirection` (
  `pinID` int(11) NOT NULL AUTO_INCREMENT,
  `pinNumber` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `pinDirection` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`pinID`),
  UNIQUE KEY `pinNumber` (`pinNumber`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

Code (markup):

This is my pinStatus SQL database:


DROP TABLE IF EXISTS `pinStatus`;
CREATE TABLE IF NOT EXISTS `pinStatus` (
  `pinID` int(11) NOT NULL AUTO_INCREMENT,
  `pinNumber` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `pinStatus` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`pinID`),
  UNIQUE KEY `pinNumber` (`pinNumber`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

Code (markup):

This is my sensor SQL database:


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;

Code (markup):

Hope you guys could help me out with it as soon as possible, thanks in advance, guys

aoiregion, Jul 18, 2014 IP

PoPSiCLe Illustrious Member

Messages:

4,623

Likes Received:

725

Best Answers:

152

Trophy Points:

470

#2

First off, you should look into not using mysql_ - use mysqli_ or PDO to connect to the database, and prepared queries - first off, they're a lot safer, and the amount of code needed is quite a bit less.
Second, you should provide proper error-messages instead of just reloading files and such. For a login-script, the better is to just have the processing and the form in the same file, displaying error-messages if there's an error during login (wrong password, or similar).

PoPSiCLe, Jul 18, 2014 IP
aoiregion Peon

Messages:

5

Likes Received:

0

Best Answers:

0

Trophy Points:

1

#3

PoPSiCLe said: ↑

First off, you should look into not using mysql_ - use mysqli_ or PDO to connect to the database, and prepared queries - first off, they're a lot safer, and the amount of code needed is quite a bit less.
Second, you should provide proper error-messages instead of just reloading files and such. For a login-script, the better is to just have the processing and the form in the same file, displaying error-messages if there's an error during login (wrong password, or similar).
Click to expand...

Quite complicated, PoPSiCLe.
Could you guide me if you don't mind cause I'm lost now, PoPSiCLe.

aoiregion, Jul 18, 2014 IP

aoiregion Peon

Messages:: 5

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 1

This is my latest edited code where I found out that I set my POST in GET and I have amended it already but the problem is still there.


<?php
session_start();

$MySQLUsername = "MySQLUsername";
$MYSQLUsersensor = "MYSQLUsersensor";
$MySQLPassword = "MySQLPassword";


$MySQLHost = "localhost";
$MySQLDB = "gpio";
$MYSQLDBsensor = "sensor";

If (($MySQLUsername == "USERNAME HERE") || ($MySQLPassword == "PASSWORD HERE")){
   print 'ERROR - Please set up the script first';
   exit();
}

$dbConnection = mysql_connect($MySQLHost, $MySQLUsername, $MySQLPassword);
mysql_select_db($MySQLDB, $dbConnection);
If (isset($_POST['action'])){
   If ($_POST['action'] == "setPassword"){
     $password1 = $_POST['password1'];
     $password2 = $_POST['password2'];
     If ($password1 != $password2){
       header('Location: control.php');
     }
     $password = mysql_real_escape_string($_POST['password1']);
     If (strlen($password) > 28){
       mysql_close();
       header('location: control.php');
     }
     $resetQuery = "SELECT username, salt FROM users WHERE username = 'admin';";
     $resetResult = mysql_query($resetQuery);
     If (mysql_num_rows($resetResult) < 1){
       mysql_close();
       header('location: control.php');
     }
     $resetData = mysql_fetch_array($resetResult, MYSQL_ASSOC);
     $resetHash = hash('sha256', $salt . hash('sha256', $password));
     $hash = hash('sha256', $password);
     function createSalt(){
       $string = md5(uniqid(rand(), true));
       return substr($string, 0, 8);
     }
     $salt = createSalt();
     $hash = hash('sha256', $salt . $hash);
     mysql_query("UPDATE users SET salt='$salt' WHERE username='admin'");
     mysql_query("UPDATE users SET password='$hash' WHERE username='admin'");
     mysql_close();
     header('location: control.php');
   }
}
If ((isset($_POST['username'])) && (isset($_POST['password']))){
   $username = mysql_real_escape_string($_POST['username']);
   $password = mysql_real_escape_string($_POST['password']);
   $loginQuery = "SELECT UserID, password, salt FROM users WHERE username = '$username';";
   $loginResult = mysql_query($loginQuery);
   If (mysql_num_rows($loginResult) < 1){
     mysql_close();
     header('location: control.php?error=incorrectLogin');
   }
   $loginData = mysql_fetch_array($loginResult, MYSQL_ASSOC);
   $loginHash = hash('sha256', $loginData['salt'] . hash('sha256', $password));
   If ($loginHash != $loginData['password']){
     mysql_close();
     header('location: control.php?error=incorrectLogin');
   } else {
     session_regenerate_id();
     $_SESSION['username'] = "admin";
     $_SESSION['userID'] = "1";
     mysql_close();
     header('location: control.php');
   }
}
If ((!isset($_SESSION['username'])) || (!isset($_SESSION['userID']))){
   print '
   <html>
   <head>
   <title>GPIO Control - Login</title>
   </head>
   <body>
   <table border="0" align="center">
   <form name="login" action="control.php" method="post">
   <tr>
   <td>Username: </td><td><input type="text" name="username"></td>
   </tr>
   <tr>
   <td>Password: </td><td><input type="password" name="password"></td>
   </tr>
   <tr>
   <td colspan="2" align="center"><input type="submit" value="Log In"></td>
   </tr>
   </form>
   </table>
   </body>
   </html>
   ';
   die();
}
If (isset($_GET['action'])){
   If ($_GET['action'] == "logout"){
     $_SESSION = array();
     session_destroy();
     header('Location: control.php');
   } else If ($_GET['action'] == "setPassword"){
     print '
     <form name="changePassword" action="control.php" method="post">
     <input type="hidden" name="action" value="setPassword">
     <p>Enter New Password: <input type="password" name="password1">  Confirm: <input type="password" name="password2"><input type="submit" value="submit"></p>
     </form>
     ';
   } else {
     $action = $_GET['action'];
     $pin = mysql_real_escape_string($_GET['pin']);
     if ($action == "turnOn"){
       $setting = "1";
       mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='$pin';");
       mysql_close();
       header('Location: control.php');
     } else If ($action == "turnOff"){
       $setting = "0";
       mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='$pin';");
       mysql_close();
       header('Location: control.php');
     } 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 '
       <html><head><title>Update Pin ' . $pin . '</title></head><body>
       <table border="0">
       <form name="edit" action="control.php" method="get">
       <input type="hidden" name="action" value="update">
       <input type="hidden" name="pin" value="' . $pin . '">
       <tr>
       <td><p>Description: </p></td><td><input type="text" name="description" value="' . $description . '"></td><td><input type="submit" value="Confirm"></td>
       </tr>
       </form>
       </table>
       </body></html>
       ';
       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';");
       header('Location: control.php');
     } else {
       header('Location: control.php');
     }
   } else {
  $now = new DateTime();
     $action = $_POST['action'];
     $pin = mysql_real_escape_string($_POST['pin']);
     $dbConnectionSensor = mysql_connect($MySQLHost, $MySQLUserSensor, $MySQLPassword);
     mysql_select_db($MySQLDBSensor, $dbConnectionSensor);
     if ($action == "turnOn" && "4"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('1', 'Red LED', $now, '')");
     } else If ($action == "turnOn" && "17"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('2', 'Blue LED', $now, '')");
     } else If ($action == "turnOn" && "18"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('3', 'Green LED', $now, '')");
     } else If ($action == "turnOn" && "21"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('4', 'LED', $now, '')");
     } else If ($action == "turnOn" && "22"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('5', 'LED', $now, '')");
     } else If ($action == "turnOn" && "23"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('6', 'LED', $now, '')");
     } else If ($action == "turnOn" && "24"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('7', 'LED', $now, '')");
     } else If ($action == "turnOn" && "25"){
       $setting = "1";
       mysql_query("INSERT INTO sensor('8', 'LED', $now, '')");
       mysql_close();
       header('Location: control.php');
     } else If ($action == "turnOff" && "4"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('1', 'Red LED', '', $now)");
     } else If ($action == "turnOff" && "17"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('2', 'Blue LED', '', $now)");
     } else If ($action == "turnOff" && "18"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('3', 'Green LED', '', $now)");
     } else If ($action == "turnOff" && "21"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('4', 'LED', '', $now)");
     } else If ($action == "turnOff" && "22"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('5', 'LED', '', $now)");
     } else If ($action == "turnOff" && "23"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('6', 'LED', '', $now)");
     } else If ($action == "turnOff" && "24"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('7', 'LED', '', $now)");
     } else If ($action == "turnOff" && "25"){
       $setting = "0";
       mysql_query("INSERT INTO sensor('8', 'LED', '', $now)");
       mysql_close();
       header('Location: control.php');
     }
   }
} else {
   print '
     <html>
     <head>
     <title>GPIO Control</title>
     </head>
     <font face="verdana">
     <p><h1>Sensors</h1></p>
     ';
     $query = mysql_query("SELECT pinNumber, pinStatus FROM pinStatus;");
     $query2 = mysql_query("SELECT pinNumber, pinDescription FROM pinDescription;");
     $totalGPIOCount = mysql_num_rows($query);
     $currentGPIOCount = 0;
     print '<table name="GPIO" border="1" cellpadding="5">';
     print '<tr><th>GPIO #</th><th>GPIO Description</th><th>Status</th><th>Action</th><th>Edit</th></tr>';
     while ($currentGPIOCount < $totalGPIOCount){
       $pinRow = mysql_fetch_assoc($query);
       $descRow = mysql_fetch_assoc($query2);
       $pinNumber = $pinRow['pinNumber'];
       $pinStatus = $pinRow['pinStatus'];
       $pinDescription = $descRow['pinDescription'];
       If ($pinStatus == "0"){
         $buttonValue = "Turn On";
         $action = "turnOn";
         $image = "off.jpg";
       } else {
         $buttonValue = "Turn Off";
         $action = "turnOff";
         $image = "on.jpg";
       }
       print '<tr>';
       print '<td align="center">' . $pinNumber . '</td><td>' . $pinDescription . '</td><td align="center"><img src="' . $image . '" width="50"></td><td align="center" valign="middle"><form name="pin' . $pinNumber . 'edit" action="control.php" method="get"><input type="hidden" name="action" value="' . $action . '"><input type="hidden" name="pin" value="' . $pinNumber . '"><input type="submit" value="' . $buttonValue . '"></form></td><td><form name="pin' . $pinNumber . '" action="control.php" method="get"><input type="hidden" name="action" value="edit"><input type="hidden" name="pin" value="' . $pinNumber . '"><input type="submit" value="Edit"></form></td>';
       print '</tr>';
       $currentGPIOCount ++;
     }
     print '</table>';
     mysql_close();
   print '
   <br><br>
   <a href="control.php?action=logout">Log Out</a>
   </font>
   </html>
   ';
}
?>

PHP:

aoiregion, Jul 19, 2014 IP

(You must log in or sign up to reply here.)

Log in or Sign up

Advertising (learn more)

Need help on Insert data to phpMyAdmin mySQL database

aoiregion Peon

PoPSiCLe Illustrious Member

aoiregion Peon

aoiregion Peon

Log in or Sign up

Advertising (learn more)

Need help on Insert data to phpMyAdmin mySQL database

aoiregion Peon

PoPSiCLe Illustrious Member

aoiregion Peon

aoiregion Peon

Useful Searches