-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdeleteAll.php
More file actions
49 lines (40 loc) · 1.14 KB
/
Copy pathdeleteAll.php
File metadata and controls
49 lines (40 loc) · 1.14 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<?php
$id = $_POST["id"];
//$id = $_POST["id"];
//$pw = $_POST["pw"];
if($id==null){
echo "_GET ERROR<br>";
exit();
}
$host = 'localhost';//ip ÁÖ¼Ò
$user = 'wuddlaa';
$pw = 'roqkfwk!2';
$dbName = 'wuddlaa';
$conn = mysqli_connect($host, $user, $pw, $dbName); //µðºñ ¿¬°á¹× ¼±ÅÃ
if (!$conn) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
$sql = "DELETE FROM Pallet_Theme WHERE id='$id';";
$result = mysqli_query($conn,$sql);
$data = array();
if(!$result)
echo json_encode($data["theme"] = "false");
else
echo json_encode($data["theme"] = "true");
$sql = "DELETE FROM Pallet_Library WHERE id='$id';";
$result = mysqli_query($conn,$sql);
if(!$result)
echo json_encode($data["library"] = "false");
else
echo json_encode($data["library"] = "true");
$sql = "DELETE FROM Pallet_Account WHERE id='$id';";
$result = mysqli_query($conn,$sql);
if(!$result)
echo json_encode($data["account"] = "false");
else
echo json_encode($data["account"] = "true");
mysqli_close($conn);
?>