deletedata.php

<?php

//THIS FILE IS FOR PART-VII:- https://youtu.be/q49tws8jiXQ

header("Access-Control-Allow-Origin: *");

//Your server name, it will be same for all 000webhost accounts
$servername = "localhost";

//Your DB username
$username = "id13654930_cj_creations";

//Your DB password
$password = "gU6mX<eL->uCnW>G";

//Your DB name, required if you have two DB and want to connect to a specific one
$dbname = "id13654930_cjcreations";

//Connect to MySQL
$mysql = mysqli_connect($servername, $username, $password, $dbname);

$first_name = "";
$last_name = "";
$email = "";

//Here you will send the type which you want to do first, like, we should first check that the data we have to delete is present in DB or not and then we have to delete it
$type = $_POST["type"];

//getData type will check that the data is present or not
if($type == "getData"){
    getData($mysql);
    
    //deleteData type will delete the data
} else if($type == "deleteData"){
    deleteData($mysql);
}

//This will check if the data is present in DB or not
function getData($mysql){

if(empty($_POST["firstname"]) || empty($_POST["lastname"]) ||  empty($_POST["email"])){

echo "Your firstname or lastname or email seems to be empty, please fill all the details.\n";


} else {

//This will contain firstname which will be sended by the API with a key forstname
$first_name = $_POST["firstname"];

//This will contain lastname, received from API with key as lastname
$last_name = $_POST["lastname"];

//This will contain email, where key is email
$email = $_POST["email"];

$check1 = $mysql->query("SELECT 1 FROM users WHERE firstname = '$first_name' LIMIT 1");
$check2 = $mysql->query("SELECT 1 FROM users WHERE lastname = '$last_name' LIMIT 1");
$check3 = $mysql->query("SELECT 1 FROM users WHERE email = '$email' LIMIT 1");

if($check1->fetch_row() && $check2->fetch_row() && $check3->fetch_row()){

$data = "SELECT * FROM users WHERE email ='". $email."'";
    $result = $mysql->query($data);

if ($result->num_rows > 0) {
    // output data of each row
    $row = $result->fetch_assoc(); 
    
    //Here your data will be checked that if it is present in DB or not.
        if($first_name == $row["firstname"] && $last_name == $row["lastname"] && $email == $row["email"]){
        
        //If it is present the. u will be given access to update it with a id associated with it
            echo "delete accessed id=".$row["id"]."\n";
        } else {
            echo "delete denied id=null\n";
        }
} else {
    echo "0 results";
}
} else {
echo "data null\n";
}
}
}

//On calling this function, it will delete the data associated with the particular ID in DB
function deleteData($mysql){
    $id = $_POST["id"];
   
   //This command will delete your data
    $delete = "DELETE FROM users WHERE id='$id'";
    
    if ($mysql->query($delete) === TRUE) {
    echo "Record deleted successfully";
    } else {
    echo "Error deleting record: " . $delete->error;
    }
    

}

?>