Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <h2><?php echo "User list"; ?></h2>
- <table border="0" cellpadding="0" cellspacing="0">
- <tr bgcolor="#f87820">
- <td><img src="img/blank.gif" alt="" width="10" height="25"></td>
- <td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo "first name"; ?></b></td>
- <td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo "lastname name"; ?></b></td>
- <td class="tabhead"><img src="img/blank.gif" alt="" width="150" height="6"><br><b><?php echo "member id"; ?></b></td>
- <td class="tabhead"><img src="img/blank.gif" alt="" width="50" height="6"><br><b><?php echo "delete"; ?></b></td>
- <td><img src="img/blank.gif" alt="" width="10" height="25"></td>
- </tr>
- <?php
- }
- $result=mysql_query("SELECT member_id,firstname,lastname,login FROM members ORDER BY firstname");
- $i = 0;
- while($row = mysql_fetch_array($result)) {
- if ($i > 0) {
- echo "<tr valign='bottom'>";
- echo "<td bgcolor='#ffffff' height='1' style='background-image:url(img/strichel.gif)' colspan='6'></td>";
- echo "</tr>";
- }
- echo "<tr valign='middle'>";
- echo "<td class='tabval'><img src='img/blank.gif' alt='' width='10' height='20'></td>";
- echo "<td class='tabval'><b>".$row['lastname']."</b></td>";
- echo "<td class='tabval'>".$row['firstname']." </td>";
- echo "<td class='tabval'>".$row['member_id']." </td>";
- echo "<td class='tabval'><a onclick="return </span></a></td>";
- echo "<td class='tabval'></td>";
- echo "</tr>";
- $i++;
- }
- ?>
- </table>
- in this i wanna add tho more things in the table 1 to delete a member and 2 to have approved or denied option for that i made two functiom
- below code is to delete
- if($_REQUEST['action']=="del")
- {
- $memberId = mysql_real_Escape_string($_REQUEST['member_id']);
- mysql_query("DELETE FROM members WHERE member_id=$memberId");
- }
- echo '<td><a href="http://yourwebsite/yourscriptname.php?action=del&member_id='
- . htmlspecialchars($row['member_id']) . '">Delete</a>';
- if ($row['approved'] == 0) {
- echo ' <a href="http://yourwebsite/yourscriptname.php?action=approve&member_id='
- . htmlspecialchars($row['member_id']) . '">Approve</a>';
- }
- echo '</td>';
- $member_id = 0;
- if (isset($_GET['member_id'])) $member_id = intval($_GET['member_id']);
- $action = '';
- if (isset($_GET['action'])) $action = $_GET['action'];
- $sql = '';
- switch($action) {
- case 'approve':
- $sql = "UPDATE members SET approval = 1 WHERE member_id = $member_id";
- break;
- case 'delete':
- $sql = "DELETE FROM member WHERE member_id = $member_id";
- break;
- }
- if (!empty($sql) && !empty($member_id)) {
- // execute the sql.
- }
Add Comment
Please, Sign In to add comment