how to delete record from database through html form

I am using Windows XP as my OS and apache server. I have successfully inserted new records into database using forms and now want to delete the records from the database through using radio buttons.

Any record i'll select with radio button should be deleted on submit.

Expand|Select|Wrap|Line Numbers

 
<?

//connect to mysql

//change user and password to your mySQL name and password

mysql_connect("localhost","root","root");
 
//select which database you want to edit

mysql_select_db("mydb");
 
//If cmd has not been initialized

if(!isset($cmd))

{

   //display all the news

   $result = mysql_query("select * from stuinfo order by FirstName");
 
   //run the while loop that grabs all the news scripts

   while($r=mysql_fetch_array($result))

   {

      //grab the title and the ID of the news

      //$title=$r["title"];//take out the title

      $FirstName=$r["FirstName"];//take out the id
 
     //make the title a link

      echo "<a href='delete.php?cmd=delete&FirstName=$FirstName'></a>";

      echo "<br>";

    }

}

?>

Expand|Select|Wrap|Line Numbers

 
<HTML>

<HEAD>

 <TITLE>New Document</TITLE>

</HEAD>

<BODY>

<? php
 
if($_GET["cmd"]=="delete")

{

    $sql = "DELETE FROM stuinfo WHERE FirstName=$FirstName";

    $result = mysql_query($sql);

    echo "Row deleted!";

}

?>

</BODY>

</HTML>

Jan 23 '10 #1

Subscribe Post Reply

✓ answered by kovik

You'd want to use the ID of the database records as the "value" attribute of your form element. Then, use the selected ID to delete the row with that ID.

Personally, I don't feel that deletion should be a one-step process. I always provide an extra "Are you sure?" form that allows the user to change their mind, and protects them from accidental clicks.

12599

johny10151981

1,059

1GB

Both of these page are unrelated
You would have to do
mysql_connect and mysql_close in every unrelated page. In the second page you didnt do the mysql connection. without connection you cant delete from database.

Regards,
JOHNY

Jan 23 '10 #2

dgreenhouse

250

Expert 100+

What you'd probably want is a record id included with the list of displayed rows.

Here's a simple example of one approach:

Expand|Select|Wrap|Line Numbers

 
?php

// Delete rows test

if (isset($_POST['submit'])) {

  $sql = 'delete from table_x where id in (';

  foreach ($_POST['id'] as $a) {

    $sql .= $a . ',';

  }

  $sql = substr($sql,0,strripos($sql,',')) . ')';

  print $sql;

}

?>

<html>

  <head><title>Test deleting records</title></head>

  <body>

    <form action="" method="post">

      <table border="1">

        <thead><th>Delete?</th><th>Record Detail</th></thead>

        <?php

          for ($i=0;$i<10;$i++) {

            // Note the variable name id[] is an array...

            print '<tr><td><input type="checkbox" name="id[]" value="'.$i.'" /></td>';

            print "<td><p>Record#$i</p></td></tr>";

          }

        ?>

      </table>

      <input type="submit" name="submit" value="Delete Record(s)!" />

    </form>  

  </body>

</html>

Jan 23 '10 #3

kovik

1,044

Expert 1GB

Jan 23 '10 #4

dgreenhouse

250

Expert 100+

@kovik
I agree...

In addition, it would be best that the user that is initiating the deletion operation is authenticated and probably done via an https page.

Also, it might be advisable to have a 'roll back' table set up in case the user changes their mind after the deletions are made.

i.e.
The records are pushed into a 'deletion history' table before being deleted from the main table. This table should contain additional columns such as: datetime, userid, and possibly more.

To generalize this operation, it might be best that this table is setup with a BLOB field so the records can be serialized/de-serialized versus duplicating the structure of the main table.

If this is done, an additional column should be added called something like: tablename.

That way, a general function could be constructed that would allow deletion of records from any table in the system.

Of course if there are table relations and constraints are in place that would automatically delete 'child' records, things get a bit more complicated

But I'm getting way ahead of myself here....

Jan 23 '10 #5

kovik

1,044

Expert 1GB

Or all deletable items should have an "is_deleted" flag and an expiration date. That's the easier solution for the "Undo" function. It allows for periodic database purging, and an easily programmed Undo capability.

But, like you said, getting ahead of ourselves.

Jan 23 '10 #6

dgreenhouse

250

Expert 100+

@kovik
Yep... Much better... And yep... that's the normal way of doing it...

Jan 24 '10 #7

by: Uwe Range | last post by:

Hi to all, I am displaying a list of records in a subform which is embedded in a popup main form (in order to ensure that users close the form...

Microsoft Access / VBA

How to synchronize current record in the form with value selected in a combobox ?

by: Zlatko Matiæ | last post by:

There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox....

Microsoft Access / VBA

delete record from ms access database

by: Phi | last post by:

Hi, I hope somebody could help me with this problem. I would like to make a form to add and delete records from my ms access database. I've...

Visual Basic .NET

Delete Record Button and Getting a "compile error"

by: JHNielson | last post by:

This is a very simple question.... I have a form that looks up Records for an unbound drop-down list. It has worked just fine up until last...

Microsoft Access / VBA

Deletion of Current Record in Main Form & Subform

by: solargovind | last post by:

Hi, I have one Form in which i have one subform also which links together by one common_id(Payment_id). When i display record, I need to delete...

Microsoft Access / VBA

Deleting the Record(FROM THE FORM)

by: pukhton | last post by:

Just a quick question? I want to delete the record from my form. I have a command button in the footer area. When ever I click on the delete...

Visual Basic 4 / 5 / 6

Update row via HTML form

by: keeps21 | last post by:

A little problem I've run into is the following. I have a script that allows a user to edit a story. I have an HTML form for title and...

PHP

Delete Record In Parent Form

by: MyWaterloo | last post by:

HI, When a new record is opened in a main form / sub form, how do I prevent the main form from saving data if the sub form is not filled? Or how...

Microsoft Access / VBA

Delete record from main form and related records in subform

by: mseo | last post by:

hi, I need to delete the record in form and all the related record from the subform I don't know how to do so. thanks

Microsoft Access / VBA

Deleting record from bound form

by: gershwyn | last post by:

In Access 2007, I am trying to add a button to my sata entry split form that will delete the current record, after prompting, but I am running into a...

Microsoft Access / VBA

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

PHP

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

General

how to delete record from database through html form

✓ answered by kovik

Similar topics