-
Notifications
You must be signed in to change notification settings - Fork 12
/
view.php
68 lines (61 loc) · 1.37 KB
/
view.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
<?php
require_once('dbconfig.php');
global $con;
$query = $con->prepare("SELECT * FROM userinfo order by id DESC");
$query->execute();
mysqli_stmt_bind_result($query, $id, $name, $username, $password);
?>
<table class="table table-bordered">
<tr class="info">
<th>ID</th>
<th>Name</th>
<th>Username</th>
<th>Password</th>
<th>Action</th>
</tr>
<?php
while(mysqli_stmt_fetch($query))
{
echo '
<tr>
<td>'.$id.'</td>
<td>'.$name.'</td>
<td>'.$username.'</td>
<td>'.$password.'</td>
<td><button id="'.$id.'" class="edit btn btn-info">Edit</button> <button class="del btn btn-danger" id="'.$id.'">Delete</button></td>
</tr>';
}
echo '</table>';
?>
<script type="text/javascript">
$('.del').click(function() {
var id = $(this).attr('id');
$.ajax({
url : "delete.php",
type: "POST",
data : { id: id },
success: function(data)
{
$('#records_content').fadeOut(1100).html(data);
$.get("view.php", function(data)
{
$("#table_content").html(data);
});
}
});
}); // delete close
$('.edit').click(function() {
var id = $(this).attr('id');
$('#show-add').hide();
$.ajax({
url : 'edit.php',
type: 'POST',
data : { id: id },
success: function(data)
{
$("#link-add").html(data);
$('#link-add').show();
}
});
}); // edit close
</script>