-
Notifications
You must be signed in to change notification settings - Fork 0
/
select.php
69 lines (65 loc) · 1.84 KB
/
select.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
<?php
$conn = @mysqli_connect("localhost","root","") or die("Connetion not established");
if($conn){
mysqli_select_db($conn,"sft_tutorial") or die("Database not found");
}
if(isset($_GET['delId'])){
$Id = $_GET['delId'];
$query = "DELETE FROM sft_user WHERE Id='".$Id."'";
$result = mysqli_query($conn,$query) or die("Insert query problem");
if($result){
header("location:select.php?msg=Record deleted successfully");
}
}
if(isset($_GET['msg'])){
echo $_GET['msg'];
}
$selQuery = "SELECT * FROM sft_user";
$response = mysqli_query($conn,$selQuery) or die("Error: Select Query problem");
$num = mysqli_num_rows($response);
if($num > 0){ ?>
<table cellpadding="10" border="1">
<tr>
<th>Id</th>
<th>Name</th>
<th>Contact</th>
<th>Email Id</th>
<th>Gender</th>
<th>Address</th>
<th>Hobby</th>
<th>Register Date</th>
<th>Status</th>
<th>DELETE</th>
<th>EDIT</th>
</tr>
<?php
while($data = mysqli_fetch_object($response))
{
?>
<tr>
<td><?php echo $data->Id; ?></td>
<td><?php echo $data->Name; ?></td>
<td><?php echo $data->Contact_No; ?></td>
<td><?php echo $data->Email_Id; ?></td>
<td><?php echo $data->Gender; ?></td>
<td><?php echo $data->Address; ?></td>
<td><?php echo $data->Hobby; ?></td>
<td><?php echo $data->Register_Date; ?></td>
<td><?php echo $data->isActive==1?"Active":"Deactive"; ?></td>
<td>
<a href="?delId=<?php echo $data->Id; ?>">DELETE</a>
</td>
<td>
<a href="database.php?editId=<?php echo $data->Id; ?>">EDIT</a>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
else {
echo "There are no records";
}
?>