Difference between revisions of "AppInventor: Menyiapkan Server Apache dan MySQL"

From OnnoWiki
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
  apt install apache2 php php-common php-mysql libapache2-mod-php mariadb-server
 
  apt install apache2 php php-common php-mysql libapache2-mod-php mariadb-server
  
 +
mysql -u root -p123456
 +
CREATE DATABASE iot;
 +
CREATE USER 'iot' IDENTIFIED BY 'iot';
 +
GRANT ALL PRIVILEGES ON iot.* TO 'iot';
 +
FLUSH PRIVILEGES;
 +
exit
 +
 +
 +
mysql -u root -p123456
 +
USE iot;
 +
CREATE TABLE iot (
 +
    iotID int,
 +
    iottime varchar(100),
 +
    iotsensor varchar(255),
 +
    iotdata varchar(255)
 +
);
 +
exit
 +
 +
Edit /var/www/html/put_data.php
 +
 +
<?php
 +
  // Retrieve data from the POST request
 +
  $iotID    = $_POST['iotID'];
 +
  $iottime  = $_POST['iottime'];
 +
  $iotsensor = $_POST['iotsensor'];
 +
  $iotdata  = $_POST['iotdata'];
 +
 +
  // Database connection parameters
 +
  $servername = "127.0.0.1";
 +
  $username  = "iot";
 +
  $password  = "iot";
 +
  $dbname    = "iot";
 +
 +
  // Create connection
 +
  $conn = new mysqli($servername, $username, $password, $dbname);
 +
 +
  // Check connection
 +
  if ($conn->connect_error) {
 +
      die("Connection failed: " . $conn->connect_error);
 +
  }
 +
 +
  // Update data in the database
 +
  $sql = "UPDATE iot SET iottime='$iottime', iotsensor='$iotsensor', iotdata='$iotdata' WHERE iotid=$iotid";
 +
 +
  if ($conn->query($sql) === TRUE) {
 +
      echo "Data updated successfully";
 +
  } else {
 +
      echo "Error: " . $sql . "<br>" . $conn->error;
 +
  }
 +
 +
  $conn->close();
 +
?>
  
  
 
==Pranala Menarik==
 
==Pranala Menarik==

Latest revision as of 19:33, 14 January 2024

Instalasi

sudo su
apt update
apt install apache2 php php-common php-mysql libapache2-mod-php mariadb-server
mysql -u root -p123456
CREATE DATABASE iot;
CREATE USER 'iot' IDENTIFIED BY 'iot';
GRANT ALL PRIVILEGES ON iot.* TO 'iot';
FLUSH PRIVILEGES;
exit


mysql -u root -p123456
USE iot;
CREATE TABLE iot (
   iotID int,
   iottime varchar(100),
   iotsensor varchar(255),
   iotdata varchar(255)
);
exit

Edit /var/www/html/put_data.php

<?php
  // Retrieve data from the POST request
  $iotID     = $_POST['iotID'];
  $iottime   = $_POST['iottime'];
  $iotsensor = $_POST['iotsensor'];
  $iotdata   = $_POST['iotdata'];
  // Database connection parameters
  $servername = "127.0.0.1";
  $username   = "iot";
  $password   = "iot";
  $dbname     = "iot";
  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
  }

  // Update data in the database
  $sql = "UPDATE iot SET iottime='$iottime', iotsensor='$iotsensor', iotdata='$iotdata' WHERE iotid=$iotid";

  if ($conn->query($sql) === TRUE) {
      echo "Data updated successfully";
  } else {
      echo "Error: " . $sql . "
" . $conn->error; } $conn->close(); ?>


Pranala Menarik