Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.97 KB | None | 0 0
  1. <?php
  2.     ob_start();
  3.     session_start();
  4.     if(!isset($_SESSION['sess_admin']))
  5.     {
  6.         header("Location: login.php");
  7.         exit;
  8.     }
  9. ?>
  10. <table><tr><td height="400" width="450" style="background-color: #ffffff" valign="top">
  11. <?php
  12.     $objConn = mysql_connect ('localhost', 'olof_admin', 'xxx');
  13.     mysql_select_db('olof_dev');   
  14.  
  15.     if(isset($_GET['edit']))
  16.     {
  17.         echo ("hej här redigerar man!");
  18.         $strQuery = mysql_query("SELECT * FROM userlist WHERE user_id = " . $_GET['id'] . "") or exit(mysql_error());
  19.         $r = mysql_fetch_array($strQuery);
  20.     }
  21.     else
  22.     {
  23.         if(isset($_GET['remove']))
  24.         {
  25.             echo ("användaren har blivit borttagen");
  26.             $strQuery = mysql_query("
  27.             DELETE FROM userlist
  28.             WHERE user_id = ".$_GET['id']."
  29.             ") or exit(mysql_error());
  30.          }
  31.    }
  32. ?>
  33. <table style="font-size: 12px">
  34. <tr>
  35. <th style="font-size: 12px;" align="left"><b>Mail</b></th>
  36. <th style="font-size: 12px;"><b>Företag</b></th>
  37. <th style="font-size: 12px;"><b>Kommentar</b></th>
  38. <th style="font-size: 12px;"><b>Användar-id</b></th>
  39. <th style="font-size: 12px;" colspan="4"><b>Administration</b</th>
  40. </tr>
  41. <?php
  42.  
  43.     $objConn = mysql_connect ('localhost', 'olof_admin', 'xxx');
  44.     mysql_select_db('olof_dev');   
  45.    
  46.     $sql = "SELECT * FROM userlist";
  47.     $result = mysql_query($sql);
  48.    
  49.     while($row = mysql_fetch_assoc($result))
  50.     {
  51.         echo "<tr><td >" . $row['email'] . "</td>
  52.                   <td>" . $row['company'] . "</td>
  53.                   <td>" . $row['comment'] . "</td>
  54.                   <td>" . $row['user-id'] . "</td>
  55.                   <td><a href='adminsys?edit&id=" . $row['user_id'] . "'>Redigera</a></td>
  56.                   <td><a href='adminsys?remove&id=" . $row['user_id'] . "'>Ta bort</a></td>
  57.                   <td><a href='adminsys?mail&id=" . $row['user_id'] . "'>Maila</a></td>
  58.  
  59.               </tr>";
  60.     }  
  61.     mysql_close($objConn);
  62.     ?>
  63. </table><br>
  64. <a href="add_user.html"><b><u>Lägg till en användare</u></b></a>
  65. <a href="logout.php"><b><u>Logga ut</u></b></a>
  66. </td></tr></table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement