-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdelete.php
88 lines (79 loc) · 2.59 KB
/
delete.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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
<?php
// Create connection
$con=mysqli_connect("localhost","arena","arena","arena");
echo "<body bgcolor=\"FFDAB9\">";
// Check connection
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
echo "\n";
}
else
{
echo "Connection to database established...<br><br>";
}
$nume="";
$prenume="";
$adresa="";
$email="";
$tel1="";
$tel2="";
$info="";
$ifbool=0;
echo "The records were deleted.<br><br>";
if($_POST['nume']=="") ;//echo "nume null<br>";
else {
$nume=" WHERE nume='".$_POST['nume']."'";
$ifbool=1;
}
if($_POST['prenume']=="") ;//echo "prenume null<br>";
else if($ifbool==1) $prenume=" AND prenume='".$_POST['prenume']."'";
else {
$prenume=" WHERE prenume='".$_POST['prenume']."'";
$ifbool=1;
}
if($_POST['adresa']=="") ;//echo "adresa null<br>";
else if($ifbool==1) $adresa=" AND adresa='".$_POST['adresa']."'";
else {
$adresa=" WHERE adresa='".$_POST['adresa']."'";
$ifbool=1;
}
if($_POST['email']=="") ;//echo "email null<br>";
else if($ifbool==1) $email=" AND email='".$_POST[email]."'";
else {
$email=" WHERE email='".$_POST['email']."'";
$ifbool=1;
}
if($_POST['tel1']=="") ;//echo "tel1 null<br>";
else if($ifbool==1) $tel1=" AND tel1='".$_POST['tel1']."'";
else {
$tel1=" WHERE tel1='".$_POST['tel1']."'";
$ifbool=1;
}
if($_POST['tel2']=="") ;//echo "tel2 null<br>";
else if($ifbool==1) $tel1=" AND tel2='".$_POST['tel2']."'";
else {
$tel2=" WHERE tel2='".$_POST['tel2']."'";
$ifbool=1;
}
if($_POST['info']=="") ;//echo "info null<br>";
else if($ifbool==1) $info=" AND info=".$_POST['info'];
else {
$info=" WHERE info='".$_POST['info']."'";
$ifbool=1;
}
//echo "SELECT * FROM users ".$nume.$prenume.$adresa.$email.$tel1.$tel2.$info;
mysqli_query($con,"DELETE FROM users ".$nume.$prenume.$adresa.$email.$tel1.$tel2.$info);
$result = mysqli_query($con,"SELECT * FROM users");
echo "Remaining records:<br><br>";
$noresults=0;
while($row = mysqli_fetch_array($result))
{
$noresults=$noresults+1;
if($noresults==1) echo "<table border=\"1\" bgcolor=\"FFFFFF\"><tr><td> ID </td><td> Nume </td><td> Prenume </td><td> Email </td><td> Adresa </td><td> Telefon 1 </td><td> Telefon 2 </td><td> Info </td></tr>";
echo "<tr><td>". $row['id']. "</td><td> " .$row['nume'] . " </td><td> " . $row['prenume']. " </td><td> " . $row['email']. " </td><td> " . $row['adresa']. " </td><td> " . $row['tel1']. " </td><td> " . $row['tel2']. " </td><td> " . $row['info']." </tr>";
}
if($noresults==0) echo "<b>No record deleted. Retry search.</b><br>";
else echo "</table>";
mysqli_close($con);
?>