delete images

[searls03]

ok, so I need to know how I can write a code for this

<?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site FROM pictures where id='".$_GET['id']."'";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site) = $row;
  
      $content .= "<input name=\"check[]\" type=\"checkbox\" value=\"\" /><li><img src='$image'/></a></li>";
   }
	  

   

?>

so that when the checkbox is checked, the image that it is by will delete when I select a button called delete(not in code yet).  I am pretty sure I need an array, but I am not good with arrays.  Could you help me with this?

[searls03]

oh yea, one more thing.....it deletes from table called "pictures", which contains a url to the picture on this site, but if I could get the url and the picture to delete, in a directory called "images".......that would be the best!!!!!

[lordshoa]

Would you not have to put the value in the checkbox value ?

value= '.$row['id'].'

 

So you want some one to write you the code 

[searls03]

sorry, I would have put that in later.....but yes, I would have.  sorry about that.  any other help?

 

[lordshoa]

Try writing the code in full then come back because you are asking for some one to write the code for you and not even trying.

[searls03]

if you couldn't read, I am not good at array codes.......could you please post a link to the phpmanual as to where to start.....I searched arrays on it but it comes back with too many links and I don't know what to choose.  please help

[searls03]

so here is what I have come up with.......and I don't know how to write the delete query.

 

   <?php
    if ($_POST[submit]){
  foreach ($_POST[check] as $key => $value) {
       
       $checkup = $_POST['check'][$key];
             
   
   
  $q =  "UPDATE pictures SET";
$sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());}
}
?>

 

but like I said, I have no idea how to write arrays, this is just based off an example I found.

[lordshoa]

Hard to know but will be like that for delete everything from that row had to make up variables because you have no code or datasbase feilds for me to work with.

 

 

$q =  "DELETE * FROM  pictures WHERE id ='.$id.' AND LIMIT = '1'";

[searls03]

sorry bout that.......just trying to get a template worked out......

[searls03]

i don't know where the last picid comes from.....here should show what you need.....what should picid be?

 

<?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site FROM pictures where id='".$_GET['id']."'";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site) = $row;
  
      $content .= "<input name=\"check[]\" type=\"checkbox\" value=value='".$row['userid']."' /><li><img src='$image'/></a></li>";
   }
   ?>
   <?php
    if ($_POST[submit]){
  foreach ($_POST[check] as $key => $value) {
       
       $checkup = $_POST['check'][$key];
             
   
   
$q =  "DELETE * FROM  pictures WHERE id ='.$id.' AND LIMIT = '1'";
$sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());}
}
?>

[lordshoa]

Sorry my fault not reading back again

$q =  "DELETE * FROM  pictures WHERE id ='.$id.' AND LIMIT = '1'";

[searls03]

I do still need some help with making it delete from the server, I have no idea or anything on how this code would look.  sorry.  could you help me with code or give me some links or something?

[searls03]

so here is entire code:

<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="/login.php">log in</a> to access your account';
   exit(); 
}

//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
$userid = $row["userid"];

}

?>
<?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site FROM pictures where id='".$_GET['id']."'";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site) = $row;
  
      $content .= "<input name=\"check[]\" type=\"checkbox\" value='".$row['id']."' /><img src='/$image' width='190' height='150'/></a><br />
";}
   ?>
   <?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site FROM pictures GROUP BY event";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site) = $row;
  
      
  $content1 .= "<option value=\"$id\">$event </option></li>";
   }
   ?>
   <?php
    if ($_POST[submit]){
  foreach ($_POST[check] as $key => $value) {
       
       $checkup = $_POST['check'][$key];
             
   
   
$q =  "DELETE * FROM  pictures WHERE id ='".$row['id']."'";
$sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="picsman.php" method="get">
  <select name="id">
  <?php echo $content1; ?>
</select>
  <input type="submit" name="select" id="select" value="Select Event" />
</form>
<form action="picsman.php" method="post">
<?php
echo $content; 
?>
<input type="submit" value="delete images" />
</form>
</body>
</html>

It is not deleting anything so could you please help me?

[wildteen88]

This code

if ($_POST[submit]){
  foreach ($_POST[check] as $key => $value) {
       
       $checkup = $_POST['check'][$key];
             
   
   
$q =  "DELETE * FROM  pictures WHERE id ='".$row['id']."'";
$sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());}
}

needs to be

    if (isset($_POST['delete_images']))
    {
        if(is_array($_POST['check']))
        {
            $ids = implode(',', $_POST['check']);

            $q =  "DELETE * FROM  pictures WHERE id = IN($ids)";
            $sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());

        }
}

 

And name your delete images button

<input type="submit" name="delete_images" value="delete images" />

[searls03]

Wold that delete all the pictures that I select?????  Also how do I delete from server???

[searls03]

ok, so here is some new code with added pieces:

<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="/login.php">log in</a> to access your account';
   exit(); 
}

//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
$userid = $row["userid"];

}

?>
<?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site, pic_id FROM pictures where id='".$_GET['id']."'";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site, $pic_id) = $row;
  
      $content .= "<input name=\"check[]\" type=\"checkbox\" value='".$row['pic_id']."' /><img src='/$image' width='190' height='150'/></a><br />
";}
   ?>
   <?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site, pic_id FROM pictures GROUP BY event";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site, $picid) = $row;
  
      
  $content1 .= "<option value=\"$id\">$event </option></li>";
   }
   ?>
   <?php
   if (isset($_POST['delete_images']))
    {
        if(is_array($_POST['check']))
        {
            $ids = implode(',', $_POST['check']);

   
   
$q =  "DELETE * FROM  pictures WHERE pic_id = IN($ids)";
$sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="picsman.php" method="get">
  <select name="id">
  <?php echo $content1; ?>
</select>
  <input type="submit" name="select" id="select" value="Select Event" />
</form>
<form action="picsman.php" method="post">
<?php
echo $content; 
?>
<input type="submit" name="delete_images" value="delete images" /></form>
</body>
</html>

 

but even with that code or the unmodified code that I was given, I get......

Problem with the query: DELETE * FROM pictures WHERE pic_id = IN()

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM pictures WHERE pic_id = IN()' at line 1

[Pikachu2000]

That isn't correct syntax for a DELETE query. MySQL manual entry.

[searls03]

thats what I was given by somebody, I hadn't thought it was.

[jcbones]

Pik is saying that the delete query should be:

$q =  "DELETE FROM  pictures WHERE pic_id IN($ids)";

 

If you want to delete the image file, then use unlink().

[searls03]

here is what I have now:

<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="/login.php">log in</a> to access your account';
   exit(); 
}

//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
$userid = $row["userid"];

}

?>
<?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site, pic_id FROM pictures where id='".$_GET['id']."'";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site, $pic_id) = $row;
  
      $content .= "<input name=\"check[]\" type=\"checkbox\" value='".$row['pic_id']."' /><img src='/$image' width='190' height='150'/></a><br />
";}
   ?>
   <?php
include_once "connect_to_mysql.php";

// if no id is specified, list the available articles


   $query = "SELECT image, event, name, id, site, pic_id FROM pictures GROUP BY event";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($image, $event, $name, $id, $site, $picid) = $row;
  
      
  $content1 .= "<option value=\"$id\">$event </option></li>";
   }
   ?>
   <?php
if (isset($_POST['delete_images']))
    {
        if(is_array($_POST['check']))
        {
            $ids = implode(',', $_POST['check']);

             
   



   
$q =  "DELETE FROM  pictures WHERE pic_id IN($ids)";$sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());}



}
   
   

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="picsman.php" method="get">
  <select name="id">
  <?php echo $content1; ?>
</select>
  <input type="submit" name="select" id="select" value="Select Event" />
</form>
<form action="picsman.php" method="post">
<?php
echo $content; 
?>
<input type="submit" name="delete_images" value="delete images" /></form>
</body>
</html>

 

but now I get this error......

Problem with the query: DELETE FROM pictures WHERE pic_id IN()

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

[teynon]

Example of how to use unlink:

 

<?php
	function outputDir($dir) {
	$handle=opendir($dir);
	while (FALSE!==($file=readdir($handle))) {
		if (($file != "..")&&($file!=".")) {
			if (is_dir($dir."/".$file)) {
				outputDir($dir."/".$file);
			}
			else {
				unlink ($dir."/".$file);
                                        echo $dir."/".$file."<br />";
			}
		}
	}
}
outputDir("C:/ARSENAL/www/Drupal-7.0");
?>

 

Just kidding. Don't run this.

[searls03]

what would this do???????

 

Example of how to use unlink:

 

<?php
	function outputDir($dir) {
	$handle=opendir($dir);
	while (FALSE!==($file=readdir($handle))) {
		if (($file != "..")&&($file!=".")) {
			if (is_dir($dir."/".$file)) {
				outputDir($dir."/".$file);
			}
			else {
				unlink ($dir."/".$file);
                                        echo $dir."/".$file."<br />";
			}
		}
	}
}
outputDir("C:/ARSENAL/www/Drupal-7.0");
?>

 

Just kidding. Don't run this.

[jcbones]

Your query has no 'ids' in it.  That is the problem.  You need to make sure you are getting them.

echo '<pre>'; print_r($_POST['check']); echo '</pre>';

[jcbones]

It will delete every file in your directory that you give it.

[teynon]

searls03, output the delete sql and see what the query is sending.

 

echo $q;

 

-- As for my not so humerous comment. It would delete everything.