function delete($table, $paramConditions)
{
// Atribui a instrução SQL construida no método
$sql = buildDelete($table, $paramConditions);
$conn = dbConnect();
extract($paramConditions);
$id = antiInjection($id);
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, 'i', $id);
if (!mysqli_stmt_execute($stmt)) {
$return = false;
} else {
$return = true;
}
mysqli_stmt_close($stmt);
dbClose($conn);
return $return;
}
<?php
include_once "dbconnect.php";
include_once "query_builder.php";
//Get type (table to access)
$type = $_GET["type"];
//if there is no type, return error
if ($type == null) {
echo "noTypeError";
} else {
//Get connection to database
$conn = db_connect();
//if there is no connection returned, die
if ($conn == null) {
die("Connection error");
}
//Get SQL Query/Queries for $type
$sql = buildDelete($type);
//Query the database
$result = mysqli_multi_query($conn, $sql);
//If result is returned, signal a success
if ($result) {
echo "success";
} else {
echo "fail";
}
//Disconnect from database
db_disconnect($conn);
}
