www.webdeveloper.com
Results 1 to 2 of 2

Thread: Delete image from folder

  1. #1
    Join Date
    Dec 2006
    Posts
    15

    Delete image from folder

    Hi
    i was wondering if anyone can help me with a small problem im having. I have this script that will let users delete there messages from my database by checking a checkbox of the message they want to delete witch is working great. With each message they save to my database, they have to upload a image witch will save the path of the image in the database and save the image to a folder. Is there anyway when they delete a message it will also delete the image in the folder by grabbing the path from the selected message there trying to delete? i have tried using unlink($image); but have no idea how to go about adding this thanks...

    My code:
    PHP Code:
    <?php
    include("db.php");
    $user       mysql_real_escape_string($_SESSION['id']);
    $sql "SELECT * FROM messages WHERE  
    user = '
    {$user}'";
    $result=mysql_query($sql$conn
    or die(
    'Error in query:<br>'$sql .'<br>'.mysql_error($conn).'<br>Time of Error: '.date("l F j, Y, G:i:s T"));
    $count=mysql_num_rows($result);
    ?>
    <table width="938" border="0" cellspacing="1" cellpadding="0">
    <tr>
    <td><form name="form1" method="post" action="">
    <table width="938" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000">
    <tr>
    <td align="left" bgcolor="#3576B4" width="26"><font color="#FFFFFF" size="2"><strong></strong></td>
    <td align="left" bgcolor="#3576B4" width="102"><font color="#FFFFFF" size="2"><strong>Subject:</strong></font></td>
    <td align="left" bgcolor="#3576B4" width="271"><font color="#FFFFFF" size="2"><strong>Message:</strong></font></td>
    </tr>
    <?php
    while($rows=mysql_fetch_array($result)){
    ?>
    <tr>
    <td align="center" bgcolor="#f8f8f8" width="26">
    <input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo htmlentities($rows['id']); ?>" style="float: left"></td>
    <td bgcolor="#f8f8f8" width="102"><font size="2"><?php echo htmlentities($rows['subject']); ?></font></td>
    <td bgcolor="#f8f8f8" width="271"><font size="2"><?php echo htmlentities($rows['message']); ?></font></td>
    </tr>
    <?php
    }
    ?>
    <tr>
    <td colspan="6" align="center" bgcolor="#f8f8f8">
    <input name="delete" type="submit" id="delete" value="Delete" style="float: left"></td>
    </tr>
    <?php
    $checkbox 
    $_POST['checkbox'];
    $delete    mysql_real_escape_string(strip_tags($_POST['delete']));
    $user       mysql_real_escape_string($_SESSION['id']);
    if(
    $delete){
        for(
    $i=0;$i&lt;$count;$i++){
            
    $del_id $checkbox[$i];
            
    $sql "DELETE FROM messages
            WHERE id = '
    {$del_id}'
            And user = '
    {$user}'";
            
    mysql_query($sql$conn)
            or die(
    'Error in query:<br>'$sql .'<br>'.mysql_error($conn).'<br>Time of Error: '.date("l F j, Y, G:i:s T"));
        }
        if(
    $result){
            echo 
    "&lt;meta http-equiv=\"refresh\" content=\"0\"&gt;\n";
        }
    }
    mysql_close();
    ?>
    </table>
    </form>
    </td>
    </tr>
    </table>
    Last edited by ycpc55; 07-20-2012 at 10:25 AM.

  2. #2
    Join Date
    Jan 2004
    Posts
    484
    you'll need to use

    PHP Code:
    $imagename "image.jpg";
    unlink($imagename); 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles