AppInventor: Menyiapkan Server Apache dan MySQL - Revision history

Unknown user at 12:33, 14 January 2024

2024-01-14T12:33:30Z

← Older revision		Revision as of 12:33, 14 January 2024
Line 27:		Line 27:
	<?php		<?php
	// Retrieve data from the POST request		// Retrieve data from the POST request
	$id = $_POST['id'];		$iotID = $_POST['iotID'];
	$~~newName~~ = $_POST['~~newName~~'];		$iottime = $_POST['iottime'];
	$~~newEmail~~ = $_POST['~~newEmail~~'];		$iotsensor = $_POST['iotsensor'];
			$iotdata = $_POST['iotdata'];

	// Database connection parameters		// Database connection parameters
	$servername = "~~your_mysql_server~~";		$servername = "127.0.0.1";
	$username = "~~your_mysql_username~~";		$username = "iot";
	$password = "~~your_mysql_password~~";		$password = "iot";
	$dbname = "~~your_database_name~~";		$dbname = "iot";

	// Create connection		// Create connection
Line 46:		Line 47:

	// Update data in the database		// Update data in the database
	$sql = "UPDATE ~~your_table_name~~ SET ~~name~~='$~~newName~~', ~~email~~='$~~newEmail~~' WHERE id=$id";		$sql = "UPDATE iot SET iottime='$iottime', iotsensor='$iotsensor', iotdata='$iotdata' WHERE iotid=$iotid";

	if ($conn->query($sql) === TRUE) {		if ($conn->query($sql) === TRUE) {

2024-01-14T12:28:01Z

2024-01-14T12:26:49Z

2024-01-14T12:26:39Z

2024-01-14T12:23:25Z

← Older revision		Revision as of 12:23, 14 January 2024
Line 12:		Line 12:
	exit		exit


			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 . "<br>" . $conn->error;
			}

			$conn->close();
			?>


	==Pranala Menarik==		==Pranala Menarik==

2024-01-14T12:20:01Z

← Older revision		Revision as of 12:20, 14 January 2024
Line 4:		Line 4:
	apt update		apt update
	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



	==Pranala Menarik==		==Pranala Menarik==

2024-01-14T12:15:48Z

← Older revision		Revision as of 12:15, 14 January 2024
Line 4:		Line 4:
	apt update		apt update
	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



			==Pranala Menarik==

2024-01-14T12:15:30Z

Created page with "Instalasi sudo su apt update apt install apache2 php php-common php-mysql libapache2-mod-php mariadb-server"

New page

Instalasi

sudo su
apt update
apt install apache2 php php-common php-mysql libapache2-mod-php mariadb-server