-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy patheCheck.php
More file actions
33 lines (25 loc) · 848 Bytes
/
Copy patheCheck.php
File metadata and controls
33 lines (25 loc) · 848 Bytes
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
<?php
include_once('connect.php');
?>
<?php
$db_handle = mysql_connect($server, $username, $password) or die('Error : ' . mysql_error());
$db_found = mysql_select_db($database, $db_handle) or die('Error : ' . mysql_error());
$e = isset($_GET['e']) ? $_GET['e'] : 'a';
$i = isset($_GET['i']) ? intval($_GET['i']) : 0;
$response_array = array();
$query = "SELECT COUNT(*) as count FROM wishdata WHERE email='". $e ."' AND i=". $i;
$results = mysql_query($query);
$rsCount = mysql_fetch_array($results);
$response_array['status'] = $rsCount['count'];
if ($rsCount['count'] == 1){
$sql="DELETE FROM wishdata WHERE i=" . $i;
$result=mysql_query($sql);
if($result){
$response_array['delete'] = 'Done';
mysql_close($link);
}else{
$response_array['delete'] = 'Fail';
}
}
echo json_encode($response_array);
?>