Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host="************"; // Host name
- $username="********"; // Mysql username
- $password="*************"; // Mysql password
- $db_name="************"; // Database name
- $tbl_name="request"; // Table name
- // Connect to server and select databse.
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- $pw = md5("dickamortis");
- $pw1 = $_GET['pw'];
- $del = $_POST['delete'];
- $query="SELECT * FROM request";
- $result=mysql_query($query);
- $num=mysql_numrows($result);
- mysql_close();
- if ($pw == $pw1) {
- echo '<html>
- <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>';
- $i=0;
- while ($i < $num) {
- $vent=mysql_result($result,$i,"vent_name");
- $song=mysql_result($result,$i,"song");
- $ipadd=mysql_result($result,$i,"ip");
- echo'<tr><td>'.$vent.'</td>
- <td>'.$song.'</td>
- <td>'.$ipadd.'</td>
- <td><input type="submit" value="delete" name="{$vent}"></td>
- </tr>';
- $i++;
- }
- }
- echo '</tr></table></center></html>';
- if (isset($del))
- {
- $SQL = "DELETE FROM table WHERE vent_name='".$vent."'";
- $query = mysql_query($SQL) or die(mysql_error());
- }
- //else {
- //echo "Bad Or Missing Password";
- //}
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement