PHP - Delete A File Using Unlink Does Not Work

any help with this please? it works fine with deleting database results but the unlink wont unlink file from dir?

Code: [Select]
else if($action=="del")
{
    $id = $_GET["id"];
    $cls = $_GET["cls"];
    $dir = "gallery/$cls";
  echo "<p align=\"center\">";
 
  $owner = mysql_fetch_array(mysql_query("SELECT uid FROM gallery WHERE id='".$id."'"));
  if(mod(getuid_id($id))||getuid_id($id)==$owner[0])
  {
    $res = mysql_query("DELETE FROM gallery WHERE id='".$id."'");
$res2 = mysql_query("DELETE FROM comments WHERE pid='".$id."'");
$res3 = mysql_query("DELETE FROM rate WHERE pid='".$id."'");

    if($res||res2||res3 || unlink($dir))
        {
            echo "Photo Deleted From Gallery<br/>";
        }else{
          echo "Database Error!<br/>";
        }
  }else{
    echo "You can't delete this Photo";
  }

Dear forum

I'm new to this forum and since I'm doing more and more php development, you'll probably going to see me more. 

For now I got this problem and I hope you guys can help me out =(.

I'm building an administartion panel for a website. On this panel the administrator can upload pictures for a gallery. This part works, so normally permissions shouldn't be a problem.
The file names are stored in my mysql database for example "pic2.jpg", "pic2.jpg", ...

Now I got this form to delete pictures from a specific gallery. It deletes from the database but it just wont delete the files. I'm using a local xampp server.

I got the following code:

Code:
$merk = $_POST["MerkLeegMaken"];
      $sql = "SELECT * FROM catalogus WHERE merkId=" . $merk;
      $resultSet = mysql_query($sql);
      while ( $row = mysql_fetch_array($query) )
         {
            $url = "../uploads/" . $row["foto"]; // this url is f.e. "../uploads/picture1.jpg", and I'm currently in "/administrationPanel/form.php
            fclose($url);
            unlink($url);
         }
           
     
      $sql = "DELETE FROM catalogus WHERE merkId=" . $merk;
      mysql_query($sql);
      $message = "<p class='success'>Het huidig merk is succesvol leeggemaakt.</p>";


(I got in my root dir the directory /uploads and the directory /administartionPanel, so ../uploads should be correct right?"


I also tried to delete with "c:/xampp/xampp/htdocs/uploads/pic1.jpg" but that didn't work either. But shouldn't "../uploads/pic1.jpg" work anyway, since I use that same url as the source of an Image below the form.

All my different url attempts didn't work. I kept finding the files in my windows explorer =(

Hope someone can help.


www.phpkode.com

Hi,
I dont know what doing wrong
Code: [Select]
<form ...

<?php 

if($_POST['DeleteActor']) {
mysql_query( 'DELETE FROM `n_dramaact`
WHERE `n_dramaact_id` = "' . $_POST['n_dramaact_id'] . '"');
}

// Reload from dBase
$QueryDramActReturn = mysql_query( 'SELECT
`n_dramaact`.`n_dramaact_id`,
`n_dramaact`.`n_dramaact_dramid`,
`n_dramaact`.`n_dramaact_dramact`,
`n_actor`.`n_actor_id`,
`n_actor`.`n_actor_fname`,
`n_actor`.`n_actor_name`,
`n_drama`.`n_drama_id`,
`n_drama`.`n_drama_title`
FROM
`n_dramaact`
Inner Join `n_actor` ON `n_actor`.`n_actor_id` = `n_dramaact`.`n_dramaact_dramact`
Inner Join `n_drama` ON `n_drama`.`n_drama_id` = `n_dramaact`.`n_dramaact_dramid`
WHERE `n_drama`.`n_drama_id` = "' . $REQUEST['n_drama_id'] . '"
ORDER BY `n_actor_fname` ASC
');

// Check query
if(!$QueryDramActReturn) { echo mysql_error(); exit; }

// Request query
while($REQUESTDR = mysql_fetch_array ($QueryDramActReturn)) {

?>
<div style="display: block; float: left; margin-left: 5px; margin-bottom: 5px;">
<?php echo $REQUESTDR['n_actor_fname'] . ' ' . $REQUESTDR['n_actor_name'];?>
<input type="submit" name="DeleteActor" value="<-X" class="SubmitDelActor" />
<input type="hidden" name="n_dramaact_id" value="<?php echo $REQUESTDR['n_dramaact_id'];?>" />
</div>
<?php }?>

....</form>
I dont understand why when a push one of the listed DeleteActor submit button delete the last n_dramaact_id from table - every listed Submit button have the own (hidden) n_dramaact_id?

thanx in advanced

T

Hi, Im using a button to delete each entry from my database, however it doesnt. I have tried it with linking to a delete page and works fine with the same mysql query, but i need to hve the button to delete and not a URL.

Can someone please help me to see what is wrong?

thanks in advance guys


<?php

include ("../include/global.php");
include ("../include/function.php");

if (loggedin()==FALSE)
{
Header("Location: ../login.php");
exit();
}

$_SESSION['username']=='$username';
$username=$_SESSION['username'];

$getid=mysql_query("SELECT id FROM users WHERE username='$username'");
while($row=mysql_fetch_array($getid))
{
$usersid=$row['id'];
}


if (isset($_POST['add']) && $_POST['add'])
    {

$subject = addslashes(strip_tags($_POST['subject']));
$text = addslashes(strip_tags($_POST['text']));

$update=mysql_query("INSERT INTO users_notes (user_id, subject, note) VALUES ('$usersid','$subject','$text')");
}

if (isset($_POST['remove']) && $_POST['remove'])
    {

$delete=mysql_query("DELETE FROM users_notes WHERE user_id='$usersid' AND  AND id='$id'");
}
?>

<html>
<head>
<script type="text/javascript" src="/js/jquery.js"></script>
<script type="text/javascript" src="/js/jquery.validate.js"></script>


<script type="text/javascript">
$(document).ready(function(){

$("#form").validate();

});
</script>
</head>
<body>

<p>You are logged in! <a href="logout.php">Log out</a>
  
</p>
<p>&nbsp;</p>
<p><td><? $getmsg=mysql_query("SELECT * FROM users_notes WHERE user_id='$usersid'");
while($row=mysql_fetch_array($getmsg))
{
$id=$row['id'];
$msgsubject=$row['subject'];
$msgnotes=$row['note'];

echo"<table width='800' border='1'>";
 echo" <tr>

    <td width='50'>".$msgsubject."</td>
    <td width='50'>".$msgnotes."</td>

    <td width='40'><form id='form' method='post' action=''>

      <input type='submit' name='remove' value='remove' />

      </form></td>
  <td>
  
  </td>
  </tr>
  ";

}

echo "</table>";
?>
</td>
</p>
<p>&nbsp;</p>
<form action="" method="POST" id="form">
  <p>
  Subject: <br/>
    <input type="text" name="subject" class="required">
  </p>
  <p>
Your Note: <br/>
    <textarea name="text" id="text" cols="45" rows="15" class="required"></textarea>
  </p>
  <p>
    <input type="submit" name="add" value="Add" >
  </p>
</form>
</body>

I have some code which deletes a record from my database (which has been selected from the previous page). Only problem is, it comes up with error code, but still deletes from the database?

Error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/110mb.com/t/h/e/b/l/a/c/k/theblackwatch/htdocs/150749deleted.php on line 28

Code:
Code: [Select]
<?php
$id = $_GET[id];
// Start the connection to the database
$conn = mysql_pconnect("***", "***", "***");
// Select the database to use
mysql_select_db("***", $conn);
// Create the MySQL command to retrieve all records
$sql = "DELETE FROM **** WHERE id ='$id'";
$result = mysql_query($sql, $conn);
$array = mysql_fetch_array($result);
// Echo each entry as the value of the text boxes. This brings in the current info in the database
echo "<p>Entry has been deleted.</p>";
?>
Any way round it?

Hello Everyone,

I am writing a simple CMS system for someone. I am having trouble getting the delete function to work. I pick the user that I want to remove from the system. I verify that this is the right person to remove. Then the record is deleted from the database.

The part that picks the person and verifies that it is the right person to remove from the database work fine. It is the part that actually deletes the record. It takes me back to the pick_user.php.

If someone could help me with this I would appreciate it

This is the code from the show_user_del.php

<?php

if (!$_POST[id]) {
header ("LOCATION: pick_user.php");
exit;
}

if ($_COOKIE[auth] != "ok") {
header("Location: ../login.php");
}

require('../includes/auth_user.php');

//build and issue query
$sql = "SELECT * FROM $table WHERE id = '$_POST[id]'";
$result = mysql_query($sql, $connection) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
$f_name = $row['f_name'];
$l_name = $row['l_name'];
$username = $row['username'];
$password = $row['password'];
}

?>

<!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>Add Classified Ad</title>
</head>
<body>
<h2><em>Delete user from Database</em></h2>
<h3>User being deleted <?php echo "$f_name $l_name"; ?></h3>
<form method="POST" action="do_delete_user.php">
<input type="hidden" name="id" value="<?php echo "$_POST[id]"; ?>" />
<input type="hidden" name="f_name" value="<?php echo "$f_name"; ?>" />
<input type="hidden" name="l_name" value="<?php echo "$l_name"; ?>" />
<p> <strong>Name:</strong> <?php echo "$f_name $l_name"; ?>
   </p>
   <p> <strong>Username:</strong> <?php echo "$username"; ?>
   </p>
   <p> <strong>Password:</strong> <?php echo "$password"; ?>
   </p>
   <p>
      <input type="submit" name="submit" id="name" value="Delete User" />
   </p>
</form>
<p><a href="../admin_menu.php">Return to Administration Menu</a></p>
</body>
</html>


When the submit button is clicked in the above code. It is supposed to bring you to the page below saying that the record was deleted. When the submit button is clicked it sends you back to the pick user page.


<?php
if ((!$_POST[f_name]) || (!$_POST[l_name])) {
header ("LOCATION: show_user_del.php");
exit;
}

if ($_COOKIE[auth] != "ok") {
header("Location: ../login.php");
}

require('../includes/auth_user.php');

$sql = "DELETE FROM $table WHERE id = '$_POST[id]'";
$result = mysql_query($sql, $connection) or die(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>
<h1>User has been removed</h1>
<h2><em>User <?php echo "$_POST[f_name] $_POST[l_name]"; ?> has been deleted
      from the <?php echo "$table"; ?> table</em></h2>
<p><a href="pick_user.php">Delete another person</a></p>
<p><a href="../admin_menu.php">Administration Menu</a></p>
</body>
</html>

Hi guys can any one see hy tis won't work 

<?php 

require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if (!$db_server)
{
  die ("Unabl to connect to MySQL" . mysql_error());
}

mysql_select_db($db_database, $db_server) or die("Unable to connect to database: " . mysql_error());

if (isset($_POST['author'])&& isset($_POST['title'])&& isset($_POST['category'])&& isset($_POST['year'])&& isset($_POST['isbn']))
{
$author  = get_post('author');
$title  = get_post('title');
$category  = get_post('category');
$year  = get_post('year');
$isbn  = get_post('isbn');

  if (isset($_POST['delete']) && $isbn != "")
  {
$query = "DELETE FROM tblCLassics WHERE isbn='$isbn'";

if (!mysql_query($query, $db_server))
{
  echo "DELETE failed: $query<br />" . mysql_error() . "<br /><br />";
}
  }
  else
  {
$query = "INSERT INTO tblClassics VALUES" .
"('$author','$title','$category','$year','$isbn')";

if (!mysql_query($query, $db_server))
{
  echo "INSERT Failed: $query<br />" .
  mysql_error() . "<br /><br />";
}
  }

}
echo <<<_END
<!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>Welcome to the Book Club</title>
</head>

<body>
<form action="connectionTest.php" method="post"><pre>
Author: <input type="text" name="author" />
Title: <input type="text" name="title" />
Category: <input type="text" name="category" />
Year: <input type="text" name="year" />
ISBN: <input type="text" name="isbn" />
<input type="submit" value="ADD RECORD" /></pre>
</form>
_END;

$query = "SELECT * FROM tblClassics";
$results = mysql_query($query);

if (!$results)
{
die("Database access failed: " . mysql_error());  
}

$rows = mysql_num_rows($results);

for ($j = 0; $j < $rows ; ++$j)
{
$row = mysql_fetch_row($results);
echo <<<_END
<pre>
Author: $row[0]
Title: $row[1]
Category: $row[2]
Year: $row[3]
ISBN: $row[4]
</pre>
<form action="connectionTest.php" method="post">
<input type="hidden" name="delete" value="yes" />
<input type="hidden" name="isbn" value="$row[4]" />
<input type="submit" value="DELETE RECORD" />
</form>
_END;
}

echo "</body>";
echo "</html>";


mysql_close($db_server);

function get_post($var)
{
return mysql_real_escape_string($_POST[$var]);
}

?>
cheers.

I am attempting to build an online shopping cart, however I have a problem with the Delete /Remove Item function.
Add New and Update Item work perfectly fine, just the Remove Item doesn't.
It seems to be mirroring the same functionality as Update Item.

http://www.tottonc.co.nz to see my problem in action.


Any help or solutions would be much appreciated...

Not sure how to go about making it so that I can delete and edit a post..

So I am stumped on how to make it to delete and edit post. The key factor for getting the information is the id field. And I am able to get it and display it, but how can I get it to work between all my functions?

This is what I have so far.


<?php
include 'test.php';
function connection()
{

$connection = @mysql_connect('localhost','root','') or die('could not connect to mysql');

$select_db = @mysql_select_db('tutorials') or die('could not connect to database');
}

function delete_post($id)
{

connection();

$query = "DELETE FROM `posts` WHERE `id` = '$id'";

$result = mysql_query($query);
}

function find_posts()
{

connection();

$query = 'SELECT `posts`.`title`, `posts`.`body`, `posts`.`id`, `users`.`username` FROM `posts`, `users` WHERE `posts`.`user_id` = `users`.`id`';

$result = mysql_query($query);

while ($row = mysql_fetch_array($result))

{

$id = $row['id'];

echo '<b>' . $row['title'] . '</b>'  .'<a href=/practice/model/posts.php?action=delete>[delete]</a> <a href=/practice/model/posts.php?action=edit>[edit]</a>' . '<br/>';

echo $row['body'] . '<br/>';

echo $row['username'] . '<p>';

}

}

function find_post($id)
{

connection();

$query = "SELECT `posts`.`title`, `posts`.`body`, `posts`.`id`, `users`.`username` FROM `posts`, `users` WHERE `posts`.`user_id` = `users`.`id` AND `posts`.`id` = '$id'";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

echo '<b>' . $row['title'] . '</b>' . '<br/>';

echo $row['body'] . '<br/>';

echo $row['username'] . '<p>';
}

function create_post()
{

connection();

$title = $_POST['title'];

$body = $_POST['body'];

$query = "INSERT INTO `posts` SET `title` = '$title', `body` = '$body', `created_at` = NOW(), `user_id` = 53";

$result = mysql_query($query);

if(!$result)

{

echo mysql_error();

}
}

delete_post(7);
find_posts();

?>



<?php
$action = $_GET['action'];


switch ($action)
{

case 'create':

echo 'created' . '<br/>';

create_post();

break;

case 'delete':

echo 'deleted' . '<br/>';

delete_post($id);

break;
}

?>



<form action="/practice/model/posts.php?action=create" method="POST">

<input type="text" col="40" name="title" /><br/>

<textarea cols="30" rows="5" name="body"> </textarea><br/>

<input type="submit" name="submit" />
</form>


So yea, I am not sure how to get the 'id' parameters linked between everything that needs it. Sorry for the vague description, but its kind of hard to put it into words. If you need a more detailed description please let me know and I will try to. Pretty much want to be able to delete and edit my posts.

Thank you!

I can't seem to figure this out.  The queries seem to need to be in the foreach loop.  The queries will then work but they update every blog post in my table.  I only want it to update the 1 that has the button associated with it.  So for instance... only delete the blog post where post_id = ${post['id']}

Do I make the queries be outside of the foreach?  If I do that then MySQL fails because my foreach is using the $post variable.

Code: [Select]
<?php

if (isset($_POST['approve']))
{
$sql = "
UPDATE `blog_posts` SET
`approved` = 1
WHERE `post_id` = '${post['id']}'
";

mysql_query($sql) or die(mysql_error());
}
else if (isset($_POST['deny']))
{
$sql = "
UPDATE `blog_posts` SET
`approved` = -1
WHERE `post_id` = '${post['id']}'
";
}
else if (isset($_POST['delete']))
{
mysql_query("DELETE FROM `blog_posts` WHERE `post_id` = {$post['id']}") or die(mysql_error());
}

foreach ($posts as $post)
{
?>
<div class="post" id="post<?php echo $post['id']; ?>">
<form action="blog.php" method="post" id="blogform" class="man">
<fieldset class="mvs buttonfield">
<span class="button">
<label>
<input type="submit" id="starttop" name="approve" class="invis dark_grey" value="Approve" />
</label>
</span>
<span id="smarktop" class="button disabled">
<label>
<input type="button" id="marktop" name="deny" class="invis dark_grey" value="Deny" disabled="disabled" />
</label>
</span>
<span id="sdeletetop" class="button disabled">
<label>
<input type="submit" id="deletetop" name="delete" class="invis dark_grey" value="Delete" disabled="disabled" />
</label>
</span>
</fieldset>
</form>
</div>
<?php
}

?>

i need help trying to get this delete feature to work its not deleting from the database (by the way i took out my database names and passwords at the top of the file)

is it possible someone could help me, ive been working on this for like a week and cant figure out the problem. thanks! you can email me at spr_spng@yahoo.com


picture 2.png is showing what it looks like




Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database_name"; // Database name
$tbl_name="table_name"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this // edited
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

Hey guys!
Everytime i upload something to the server theres a files created called Resource id #10 (number increments after eachj upload)
From what i can ubserve, those are the TMP file ... but for somereason it's staying there and piles up and takes out a lot of space.

Is there a way to delete them when the upload is finished?

Hi,

I have built a captcha system that saves the captcha to a temp folder with the file name captcha_CURRENT_TIME_STAMP where CURRENT_TIME_STAMP is the unix time.

I want to delete images older than 5mins old by reading the time stamp on the file name. My question is this:

How can i loop through the image folder and read the time stamps on the file name and delete all images older than 5mins?

Thanks

i want to delete a file from FOXML directory. I had tried this code but no use...

<?php
$path="/srv/fedora/tomcat/webapps/formConfirm_1/WEB-INF/classes/FOXML";
$dh = opendir($path);
while ($temp = readdir($dh)) {
if ($temp!='.' && $temp!='..' && $temp!='.htaccess') chmod($temp,777); }


$filename = "/srv/fedora/tomcat/webapps/formConfirm_1/WEB-INF/classes/FOXML/myfile.xml";
unlink($filename);
?>

any suggestions??

hi friends!!
in php > 5 i use "session_regenerate_id(TRUE)" in order to generate a new session file and delete old one.
In php 4.x the TRUE parameter doesn't exist: old files will be accumulated until the garbage collector will cleans all.
How can I delete old session file in php 4.x having regenerated the new one?