<?php
echo "Salam, Mohd Nizam ...<br><br>" ;
$servername = "localhost";
$username = "root";
$password = "";
$database = "tutorial";
// Create connection
$conn = new mysqli($servername, $username, $password, $database);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully <br><br>";
?>
api.php
<?php
include('api.php');
$sql = "SELECT * FROM users";
$result = mysqli_query($conn, $sql);
$all = mysqli_fetch_all($result, MYSQLI_ASSOC);
echo json_encode($all);
$conn->close();
?>
read.php
<?php
include('api.php');
$id = 5;
$sql = mysqli_query($conn,"DELETE FROM users WHERE id=".$id);
echo "Delete successfully";
$conn->close();
?>
delete.php