Advertisement
Guest User

Untitled

a guest
Jul 6th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.38 KB | None | 0 0
  1. <?php
  2. $host="************"; // Host name
  3. $username="********"; // Mysql username
  4. $password="*************"; // Mysql password
  5. $db_name="************"; // Database name
  6. $tbl_name="request"; // Table name
  7.  
  8. // Connect to server and select databse.
  9. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  10. mysql_select_db("$db_name")or die("cannot select DB");
  11. $pw = md5("dickamortis");
  12. $pw1 = $_GET['pw'];
  13. $del = $_POST['delete'];
  14.  
  15. $query="SELECT * FROM request";
  16. $result=mysql_query($query);
  17. $num=mysql_numrows($result);
  18. mysql_close();
  19. if ($pw == $pw1) {
  20. echo '<html>
  21. <link href="style.css" rel="stylesheet" type="text/css" /><form id="loginForm" name="loginForm" method="post" action="'.$_SERVER['PHP_SELF'].'"><center><table border="1"><tr><th>Vent Username</th><th>Song Requested</th><th>IP Address</th><th>Delete Entry</th></tr>';
  22. $i=0;
  23. while ($i < $num) {
  24. $vent=mysql_result($result,$i,"vent_name");
  25. $song=mysql_result($result,$i,"song");
  26. $ipadd=mysql_result($result,$i,"ip");
  27. echo'<tr><td>'.$vent.'</td>
  28. <td>'.$song.'</td>
  29. <td>'.$ipadd.'</td>
  30. <td><input type="submit" value="delete" name="{$vent}"></td>
  31. </tr>';
  32.  
  33. $i++;
  34. }
  35. }
  36. echo '</tr></table></center></html>';
  37. if (isset($del))
  38. {
  39.     $SQL = "DELETE FROM table WHERE vent_name='".$vent."'";
  40.     $query = mysql_query($SQL) or die(mysql_error());
  41. }
  42. //else {
  43. //echo "Bad Or Missing Password";
  44. //}
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement