Jump to content

Archived

This topic is now archived and is closed to further replies.

Darno

PHP MySQL Alter and Delete Script

Recommended Posts

Sir/Ma'am,

    I'm newbie programmer in php. I'm working with a Purchasing System using a php and MySQL. I have created a delete script in a said System but it could only delete 1 record...Please give some suggestions or ideas on How do I delete a record one by one and give some scripts in altering a record..tnx a lot.. :) 

Share this post


Link to post
Share on other sites
Your question is not at all clear to me.

You state that you have been able to delete a record. So you know how to do this. Just repeat it (with a different WHERE clause of course) for the other records you want to delete.

About altering: you can ALTER a database or ALTER a table, but what do you mean by ALTERing a row?

Ronald  8)

Share this post


Link to post
Share on other sites
Suppose you have listed several items from a table, and have a checkbox on each row to indicate which items are to be deleted
[pre]
Item              Qty        Delete

Widget            25          (x)
Wotsit              1          ( )
Gizmo              10          (x)

                (Delete selected)[/pre]
               
Define each c/box with a name ending with "[]" and with a value = the id of the listed item
EG
[code]echo "<input type='checkbox' name='delitem[]' value='$id'>";[/code]

When the form is submitted you want to create a query like

DELETE FROM item WHERE id IN (1,3)

which will delete the 2 items shown above.

[code]<?php
$items = join (',' , $_POST['delitem']);
mysql_query ("DELETE FROM item WHERE id IN ($items)");

echo "Selected items deleted";
?>
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.