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

From OnnoWiki
Jump to navigation Jump to search
Line 11: Line 11:
 
  FLUSH PRIVILEGES;
 
  FLUSH PRIVILEGES;
 
  exit
 
  exit
 +
 +
 +
mysql -u root -p123456
 +
CREATE TABLE iot (
 +
    iotID int,
 +
    iottime varchar(100),
 +
    iotsensor varchar(255),
 +
    iotdata varchar(255)
 +
);
  
  

Revision as of 19:26, 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
CREATE TABLE iot (
   iotID int,
   iottime varchar(100),
   iotsensor varchar(255),
   iotdata varchar(255)
);


Edit /var/www/html/put_data.php

<?php
  // Retrieve data from the POST request
  $id = $_POST['id'];
  $newName = $_POST['newName'];
  $newEmail = $_POST['newEmail'];
  // Database connection parameters
  $servername = "your_mysql_server";
  $username = "your_mysql_username";
  $password = "your_mysql_password";
  $dbname = "your_database_name";
  // 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 your_table_name SET name='$newName', email='$newEmail' WHERE id=$id";

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


Pranala Menarik