01.<?php
02. $connect = mysqli_connect("localhost", "root", "", "event");
03. if(!empty($_POST))
04. {
05. $output = '';
06. $message = '';
07. $status = mysqli_real_escape_string($connect, $_POST["status"]);
08. $name = mysqli_real_escape_string($connect, $_POST["name"]);
09.
10. if($_POST["users_id"] != '')
11. {
12. $query = "UPDATE users SET status='$status' WHERE id='".$_POST["users_id"]."'";
13. $message = 'Data Updated';
14. }
15.
16.
17. if(mysqli_query($connect, $query))
18. {
19. $output .= '<label class="text-success">' . $message . '</label>';
20. $select_query = "SELECT * FROM users ORDER BY id DESC";
21. $result = mysqli_query($connect, $select_query);
22. $output .= '
23. <table class="table table-bordered">
24. <tr>
25. <th width="70%">Employee Name</th>
26. <th width="15%">Edit</th>
27. <th width="15%">View</th>
28. </tr>
29. ';
30. while($row = mysqli_fetch_array($result))
31. {
32. $output .= '
33. <tr>
34. <td>' . $row["status"] . '</td>
35. <td><input type="button" name="edit" value="Edit" id="'.$row["id"] .'" class="btn btn-info btn-xs edit_data" /></td>
36. <td><input type="button" name="view" value="view" id="' . $row["id"] . '" class="btn btn-info btn-xs view_data" /></td>
37. </tr>
38. ';
39. }
40. $output .= '</table>';
41. }
42. echo $output;
43. }
44. ?>
