AppInventor: Menyiapkan Server Apache dan MySQL

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();
?>