PHP / PDO : Delete image on server

Question

The purpose of the following script is to delete an entry in my annonces table using provided "id".

I would like also delete a file with name $imageAnnonce which is stored in the following folder : /uploads

How can i do that using PHP ?

<?php

$PARAM_hote='aaaaaaaa'; 
$PARAM_port='3306';
$PARAM_nom_bd='bbbbbbbbbbb'; 
$PARAM_utilisateur='cccccccccccc'; 
$PARAM_mot_passe='ddddddddddddd';
// Create connexion to BDD
$connexion = new PDO('mysql:host='.$PARAM_hote.';port='.$PARAM_port.';dbname='.$PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe);

try {

    // GET POST DATA
    $idAnnonce = $_POST['idAnnonce'];
    $imageAnnonce = $_POST['imageAnnonce'];

    // PREPARE DELETE ON TABLE
    $sqlInsert = "DELETE FROM annonces WHERE id=:idAnnonce ";
    $resultats = $connexion->prepare($sqlInsert);
    $resultats->bindValue(':idAnnonce', $idAnnonce, PDO::PARAM_INT);
    $resultats->execute();

    // Now, i would like to delete image with name = $imageAnnonce in the folder /uploads
    // ... ??

    // How many row have been impacted ?
    echo $resultats->rowCount();

} catch(Exception $e) {
    echo 'Erreur : '.$e->getMessage().'<br />';
    echo 'N° : '.$e->getCode();
}



?>

php delete file

moonwave99
– moonwave99

2014-06-11 13:34:53 +00:00
Commented Jun 11, 2014 at 13:34 — moonwave99
– moonwave99, Commented Jun 11, 2014 at 13:34

ElendilTheTall · Accepted Answer · 2014-06-11 13:30:12Z

3

Use unlink to delete a file:

unlink(pathtofile);

So in your case:

unlink ('uploads/'.$imageAnnonce);

answered Jun 11, 2014 at 13:30

ElendilTheTall

1,50219 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mathieu Bour · Accepted Answer · 2014-06-11 13:31:16Z

2

Try unlink() function: http://php.net/manual/fr/function.unlink.php.

For you, it will be:

unlink("uploads/$imageAnnonce");

answered Jun 11, 2014 at 13:31

Mathieu Bour

7066 silver badges23 bronze badges

Collectives™ on Stack Overflow

PHP / PDO : Delete image on server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related