LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-21-2014, 05:49 AM   #1
aoiregion
LQ Newbie
 
Registered: Jul 2014
Posts: 11

Rep: Reputation: Disabled
Need help on Insert data to mySQL database


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 can works but cannot store in mySQL database.

This is my control.php:
PHP Code:
<?php
error_reporting
(E_ALL);
ini_set('display_errors','On');

session_start();

$MySQLUsername "gpio";
$MySQLPassword "kang";

$MySQLHost "localhost";
$MySQLDB "gpio";

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($resetResultMYSQL_ASSOC);
                
$resetHash hash('sha256'$salt hash('sha256'$password));
                
$hash hash('sha256'$password);
                function 
createSalt(){
                        
$string md5(uniqid(rand(), true));
                        return 
substr($string0, <img src="./images/smilies/icon_cool.gif" alt="8)" title="Cool" />;
                }
                
$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($loginResultMYSQL_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'];
                
$storing $_POST['storing'];
                
$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 (
$storing == "turnOn"){
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '1', 'Red LED', NOW(), '') FROM pinStatus WHERE pinNumber='4';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '2', 'Blue LED', NOW(), '') FROM pinStatus WHERE pinNumber='17';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '3', 'LED', NOW(), '') FROM pinStatus WHERE pinNumber='18';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '4', 'LED', NOW(), '') FROM pinStatus WHERE pinNumber='21';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '5', 'LED', NOW(), '') FROM pinStatus WHERE pinNumber='22';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '6', 'Green LED', NOW(), '') FROM pinStatus WHERE pinNumber='23';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '7', 'LED', NOW(), '') FROM pinStatus WHERE pinNumber='24';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '8', 'LED', NOW(), '') FROM pinStatus WHERE pinNumber='25';");
                        
mysql_close();
                        
header('Location: control.php');
                } else If (
$storing == "turnOff"){
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '1', 'Red LED', '', NOW()) FROM pinStatus WHERE pinNumber='4';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '2', 'Blue LED', '', NOW()) FROM pinStatus WHERE pinNumber='17';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '3', 'LED', '', NOW()) FROM pinStatus WHERE pinNumber='18';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '4', 'LED', '', NOW()) FROM pinStatus WHERE pinNumber='21';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '5', 'LED', '', NOW()) FROM pinStatus WHERE pinNumber='22';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '6', 'Green LED', '', NOW()) FROM pinStatus WHERE pinNumber='23';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '7', 'LED', '', NOW()) FROM pinStatus WHERE pinNumber='24';");
                        
mysql_query("INSERT INTO 'gpio'.'sensor' ('id', 'sensorId', 'sensor', 'switchOnLog', 'switchOffLog') VALUES (NULL, '8', 'LED', '', NOW()) FROM pinStatus WHERE pinNumber='25';");
                        
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>
        '
;
}
?>
This is my pinDirection SQL database:
Code:
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 ;
This is my pinStatus SQL database:
Code:
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 ;
This is my sensor SQL database:
Code:
CREATE TABLE IF NOT EXISTS `sensor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sensorId` int(11) NOT NULL,
  `sensor` text COLLATE utf8_unicode_ci NOT NULL,
  `switchOnLog` datetime DEFAULT NULL,
  `switchOffLog` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

Last edited by aoiregion; 07-21-2014 at 10:26 PM.
 
Old 07-21-2014, 04:35 PM   #2
angel115
Member
 
Registered: Jul 2005
Location: France / Ireland
Distribution: Debian mainly, and Ubuntu
Posts: 528

Rep: Reputation: 78
Stupid question maybe but, did you check the right of your user "gpio"?
What does your logs say?
Do you get any error messages?
 
Old 07-21-2014, 09:54 PM   #3
aoiregion
LQ Newbie
 
Registered: Jul 2014
Posts: 11

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by angel115 View Post
Stupid question maybe but, did you check the right of your user "gpio"?
What does your logs say?
Do you get any error messages?
Sorry angel115, please bear with me if you don't mind.
I have found out my mistake already but don't know how to fix it cause I want to do subqueries and don't know how to implement it.

This is my new edited code:
PHP Code:
<?php
error_reporting
(E_ALL);
ini_set('display_errors','On');

session_start();

$MySQLUsername "MySQLUsername";
$MySQLPassword "MySQLPassword";

$MySQLHost "localhost";
$MySQLDB "gpio";

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($resetResultMYSQL_ASSOC);
        
$resetHash hash('sha256'$salt hash('sha256'$password));
        
$hash hash('sha256'$password);
        function 
createSalt(){
            
$string md5(uniqid(rand(), true));
            return 
substr($string08);
        }
        
$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($loginResultMYSQL_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';");
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '1', 'Red LED', NOW(), NULL) SELECT '4' FROM pinStatus WHERE pinNumber='4';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '2', 'Blue LED', NOW(), NULL) SELECT '17' FROM pinStatus WHERE pinNumber='17';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '3', 'LED', NOW(), NULL) SELECT '18' FROM pinStatus WHERE pinNumber='18';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '4', 'LED', NOW(), NULL) SELECT '21' FROM pinStatus WHERE pinNumber='21';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '5', 'LED', NOW(), NULL) SELECT '22' FROM pinStatus WHERE pinNumber='22';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '6', 'Green LED', NOW(), NULL) SELECT '23' FROM pinStatus WHERE pinNumber='23';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '7', 'LED', NOW(), NULL) SELECT '24' FROM pinStatus WHERE pinNumber='24';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '8', 'LED', NOW(), NULL) SELECT '25' FROM pinStatus WHERE pinNumber='25';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
mysql_close();
            
header('Location: control.php');
        } else If (
$action == "turnOff"){
            
$setting "0";
            
mysql_query("UPDATE pinStatus SET pinStatus='$setting' WHERE pinNumber='$pin';");
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '1', 'Red LED', NULL, NOW()) SELECT '4' FROM pinStatus WHERE pinNumber='4';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '2', 'Blue LED', NULL, NOW()) SELECT '17' FROM pinStatus WHERE pinNumber='17';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '3', 'LED', NULL, NOW()) SELECT '18' FROM pinStatus WHERE pinNumber='18';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '4', 'LED', NULL, NOW()) SELECT '21' FROM pinStatus WHERE pinNumber='21';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '5', 'LED', NULL, NOW()) SELECT '22' FROM pinStatus WHERE pinNumber='22';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '6', 'Green LED', NULL, NOW()) SELECT '23' FROM pinStatus WHERE pinNumber='23';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '7', 'LED', NULL, NOW()) SELECT '24' FROM pinStatus WHERE pinNumber='24';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
$success=mysql_query("INSERT INTO sensor VALUES(NULL, '8', 'LED', NULL, NOW()) SELECT '25' FROM pinStatus WHERE pinNumber='25';");
            if (!
$success) {
                die(
'Could not Insert: ' mysql_error());
            }
            
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>
    '
;
}
?>
This is my error message for mySQL:
Could not Insert: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT '4' FROM pinStatus WHERE pinNumber='4'' at line 1

Last edited by aoiregion; 07-21-2014 at 09:55 PM.
 
Old 07-22-2014, 02:44 AM   #4
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 804

Rep: Reputation: 186Reputation: 186
(1)
Column names shouldn't be enclosed in quotes.
For example, please try
mysql_query("INSERT INTO 'gpio'.'sensor' (id, sensorId, sensor, switchOnLog, switchOffLog) VALUES (NULL, '1', 'Red LED', '', NOW())
FROM pinStatus WHERE pinNumber='4';");

(2)
Since the data you want to list are not direct values like (NULL, 1, Red LED, now() ) etc, the syntax you want would be simply
INSERT INTO TABLE (field list) values (data list) (See http://dev.mysql.com/doc/refman/5.6/en/insert.html for the full syntax).

I don't understand your thinking of 'gpio'.'sensor'
If these are input partition.tables, then you should use the from clause in sql but I'm mot sure that's what you mean.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help on Insert data to phpMyAdmin mySQL database aoiregion Linux - Newbie 4 07-18-2014 05:18 AM
MySQL insert database problem macaronij Linux - Server 3 07-22-2010 04:38 AM
using perl to insert special characters into mysql database ihopeto Programming 5 12-25-2006 05:08 PM
Insert Data by FORM in MYSQL gruger Linux - Software 0 07-16-2003 01:50 PM
After insert data, Database is empty ivankong Linux - Software 2 06-16-2003 08:35 AM


All times are GMT -5. The time now is 04:22 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration