Skip to content

Instantly share code, notes, and snippets.

@ElectApp

ElectApp/delete-user.php

Last active Mar 18, 2019
Embed
What would you like to do?
<?php
//Thank SQL: https://www.w3schools.com/sql/sql_delete.asp
// https://www.tutorialspoint.com/mysqli/mysqli_delete_query.htm
$servername = "localhost"; //ใช้ localhost กรณี server อยู่บน online
$username = "พิมพ์ที่นี่"; //username ของ DirectAdmin
$password = "พิมพ์ที่นี่"; //password ของ DirectAdmin
$dbname = "test"; //ชื่อ database
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//Get data from app
$userId = $_POST['userId'];
//Filter on DB
$sql = "DELETE FROM user_login_test WHERE id='$userId'";
//Check result
if ($conn->query($sql) === TRUE) {
echo "Delete successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment