[RESOLVED] Problem with selecting and deleting multiple database entries

@roondogMar 12.2008

I am working on a gallery that allows a user to upload and delete pictures. So far I have the uploading working fine but have had various problems with deleting. My idea is to have a form with all the pictures showing and each one having a check box. The problem i’ve had is getting more than one picture to delete. Is there a special way to handle checkboxes. I can’t find my code at the moment ( I might have deleted it in frustration) but will post it when I do find it/ re-do it.

to post a comment

PHP

@sanchez_1960Mar 12.2008 — #Use input boxes to post the id numbers of the each image. The input boxes can be can be named id, and then echo the $i of your loop.

Then on the POST loop through the values and execute the query for every id.

@roondogauthorMar 12.2008 — #this is my code

[code=php]
 <?php
 $con = mysql_connect("localhost","******","*****");
 if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }
 mysql_select_db("******", $con);
 
 $picture = $POST_[delete_picture];
 
 mysql_query("DELETE FROM delete WHERE img_name = $picture");
 
 
 mysql_close($con);
 ?>
 [/code]

and for the form

[code=php]
 <html>
 <body>
 <form action='delete.php' method='post'>
 <?php
 $con = mysql_connect("localhost","******","******");
 if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }
 
 mysql_select_db("*******", $con);
 
 $result = mysql_query("SELECT * FROM delete");
 
 while($row = mysql_fetch_array($result))
 {
 echo "<img src='".$row['img_name']."' alt='image' />";
 echo "<input type='checkbox' name='delete_picture[]' value='".$row['img_name']."'>";
 }
 mysql_close($con);
 ?>
 <input type='submit'>
 </form>
 </body>
 </html>[/code]

@ss1289Mar 12.2008 — #

[code=php]$picture = $POST_[delete_picture];
 
 foreach($picture as $name) {
 mysql_query("DELETE FROM delete WHERE img_name = $name"); 
 }[/code]

This might work.

@roondogauthorMar 12.2008 — #Not sure whats happening. I've added

[code=php]
 echo $name."<br />";
 [/code]

which shows the image names but it's not deleting. I'll have to do more investigating

@roondogauthorMar 12.2008 — #got it working just a little syntax error.

[RESOLVED] Problem with selecting and deleting multiple database entries

5 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

[RESOLVED] Problem with selecting and deleting multiple database entries

5 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

5 Comments(s) _↴

Also in #PHP _↴