[php] 3
Viewer
- <?php
- $conn = mysqli_connect("localhost", "root", "", "uts");
- function tampil($query)
- {
- global $conn;
- $result = mysqli_query($conn, $query);
- $rows = [];
- while ($row = mysqli_fetch_assoc($result)) {
- $rows[] = $row;
- }
- return $rows;
- }
- function ubah($data)
- {
- global $conn;
- $id = $data["idSensor"];
- $namaMeja = $data["noMeja"];
- $statusMeja = $data["statusTombol"];
- $query = "UPDATE meja SET
- noMeja = '$namaMeja',
- statusTombol = '$statusMeja'
- WHERE idSensor = $id
- ";
- mysqli_query($conn, $query);
- return mysqli_affected_rows($conn);
- }
- function ubahPasien($data)
- {
- global $conn;
- $id = $data["idSensor"];
- $query = "UPDATE sensor_warungmakan SET
- statusTombol = 1
- WHERE idSensor = $id
- ";
- mysqli_query($conn, $query);
- return mysqli_affected_rows($conn);
- }
Editor
You can edit this paste and save as new: