PHP Search & Delete

[Frostie]

Tweet

I have left my PHP bible at home today, but desperately need to create a PHP form that has a single field, and when someone completes it and clicks on a button, it searches a database and where there is a record that matches the entry, it deletes it.

Anyone have the code quickly to hand?

[haggul]

Do you just need the SQL ?

$sql = "DELETE FROM tblTable WHERE ID=" . $_POST["FormField] ;
mysql_query($sql,$mylink);

That assumes the matching field is numeric - if text then :

$sql = "DELETE FROM tblTable WHERE Field='" . $_POST["FormField] . "'";
mysql_query($sql,$mylink);

putting single quotes round the value.

[Frostie]

Nah its the whole lot I need, the Form, field, how its passed to the SQL statement etc

May have to go home to get my bible and bash it out

[Fraser]

Chris - can you piece something together from this

http://www.createafreewebsite.net/phpmysql/delete.html

and this

http://www.createafreewebsite.net/ph...e.html#example

If I had any spare time today I could have put together a full example but that's the best I can offer at the moment

[haggul]

How about a self calling page as such (you'll need to setup your conn string in the $mylink variable :

<?php
if($_POST["mode"]=="doit")
{
$sql = "DELETE FROM tblTable WHERE Field='" . $_POST["FormField] . "'";
mysql_query($sql,$mylink);
}
?>

<form action="mypage.php" method="post">
<input type="hidden" name="mode" value="doit">
<input type="text" name="FormField" size="5" maxlength="5">
<input type="submit" name="Submit" value="Submit">
</form>

[Frostie]

This is what I have so far;

<FORM METHOD=POST ACTION="<? echo "$PHP_SELF"; ?>">
<TABLE BORDER="0" CELLSPACING="3" CELLPADDING="3">
<TR>
    <TD VALIGN="TOP"><font size=2>Your details:</font></TD>
    <TD VALIGN="TOP"><INPUT TYPE="text" NAME="leave"></TD>
</tr>
<TR>
    <TD VALIGN="TOP" COLSPAN="2"><INPUT
TYPE="submit" NAME="actionbutton" VALUE="Leave"></TD>
</TR>
</TABLE>
</FORM>

<?php 
$user="user_name";
$password="password";
$database="data_base";
$host="localhost";

$connection = mysql_connect($host,$user,$password) or die ("Error: connection");
$db = mysql_select_db($database,$connection) or die ("Error: db");

$querydelete = "DELETE FROM table WHERE field='$leave'";
mysql_query($sql,$mylink);
$resultdelete = mysql_query($querydelet);

?>

[haggul]

That all looks OK except the php will execute regardless so add the if condition and hidden field.

Also not sure if you need the last line.

Change

mysql_query($sql,$mylink);

to

mysql_query($querydelete,$connection);

[Frostie]

Got it working

OK, so now it deletes the record, but whats the best way to get it to go to a different page now once its completed? Its been a while since I last scripted anything as you can tell lol

[haggul]

Oh right - either just get the form to go to that page in it's action parameter and move the deletion code into that page - or just add :

header("Location: diffpage.php");