-
Notifications
You must be signed in to change notification settings - Fork 1
/
del.php
56 lines (46 loc) · 1.96 KB
/
del.php
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
50
51
52
53
54
55
56
<?php
require 'connect.inc.php';
require 'core.inc.php';
$uid=trim($_GET['uid']);$pid=trim($_GET['pid']);
echo $uid;
$queryx="update solved set status=3 where trim(uid)='$uid' and trim(pid)='$pid' ";
mysqli_query($con,$queryx);
$query="delete from answers where trim(uid)='$uid' and trim(pid)='$pid'";
$query1= "SELECT * FROM `puzzle` where id = $pid ";
$query3="select email from userinfo where trim(id)='$uid'";
$result3 = mysqli_query($con,$query3);
$row3=mysqli_fetch_assoc($result3);
if( $query_run1 = mysqli_query($con,$query1) )
{
$result1 = $con->query($query1);
if ($result1->num_rows > 0)
{
while($row1 = $result1->fetch_assoc())
{
if($query_run = mysqli_query($con,$query))
{
?>
<script type="text/javascript">
alert("Deleted Successfully..");
</script>
<?php
$email=$row3['email'];
$subject="Submission Result";
$message = "Your answer for ".$row1['title']."was incorrect...You can try it again..";
$headers="From: itspuzzlepedia@gmail.com";
mail($email,$subject,$message,$headers);
header("Refresh:0.3 url=evaluate.php");
}
else
{
?>
<script type="text/javascript">
alert("Sorry, Something went wrong..");
</script>
<?php
header("Refresh:0.3 url=evaluate.php");
}
}
}
}
?>