Delete Record

**Jamie_Garland** · Oct 14th, 2008, 07:17 AM

How would i go about deleteing a record from my database, i use this html form to send the data.?

<html>
<head>
<title>Request</title>
<link rel="stylesheet" type="text/css" href="style.css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<form method="post" action="process.php">
<td align="center" valign="top">
<?php if(isset($_GET["ip"]) == "sent") { echo "<font color=\"red\">Ip has been added to band list, thank you.</font>"; } else {}?>
<br>
<table width="40%" border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#000000">
<tr align="left" valign="top">
<td width="20%"> IP:</td>
<td width="80%"> <input name="ip" type="text" id="ip"></td>
</tr>
<tr align="left" valign="top">
<td>Reason:</td>
<td> <textarea name="Reason" cols="25" rows="4" id="Reason"></textarea></td>
</tr>
<tr align="left" valign="top">
<td> </td>
<td> <input type="submit" name="Submit" value="Submit to server">
</td>
</tr>
</table> </td>
</tr>
</table>
<div align="center"><br>
<font size="-2">*Please do not abuse the request box. Your IP will be logged
for security purposes. </font></div>
</form>
</body>
</html>

Process.php code.

PHP Code:


<?php

$ip = $_POST["ip"];

$Reason = $_POST["Reason"];



if($ip == "" OR $Reason == ""){

    echo "Your name or message was blank! Please go back and fix this";

    die();

} else {}



include("config.php");





    mysql_connect("$host", "$username", "$password");

    mysql_select_db($db) or die(mysql_error());



mysql_query("INSERT INTO `ip` ( `ip` , `Reason`  ) VALUES ( '$ip' , '$Reason')")

or die ("Could not insert into database.");



header("Location: add.php?ip=sent");



?>

**dclamp** · Oct 16th, 2008, 12:03 AM

like this:

PHP Code:


$ip = '127.0.0.1';

mysql_query("DELETE FROM `ip` WHERE ip='{$ip}'");

Thread: Delete Record

Thread Tools

Display

Delete Record

Re: Delete Record

Posting Permissions