Delete Image File retrieving name from MySQL

[jomagi]

Hi there! My first topic, I'm noob, don't know too much.

Thanks to all in advance!!! Sorry my english!

 

I'm building a dynamic website from scratch, all run well till now, in the catalog administrative page I can upload data to MySQL and upload a image file to server, works fine, now I can delete data from MySQL but the question is how to delete image file from server too??? I'm using PHP+MySQL and DREAMWEAVER

 

Table name = destaques

Fields names = id -> Integer(AutoInc) / editora -> Varchar15 / artista -> Varchar20 / disco -> Varchar35 / ref -> Varchar20 / imagem -> Text / estilo -> Varchar10

 

This is the file to delete data from mysql that pick id row and delete:

 

<?php require_once('Connections/destaques.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

 

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;   

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

 

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {

  $deleteSQL = sprintf("DELETE FROM destaques WHERE id=%s",

                      GetSQLValueString($_GET['id'], "int"));

 

  mysql_select_db($database_destaques, $destaques);

  $Result1 = mysql_query($deleteSQL, $destaques) or die(mysql_error());

 

  $deleteGoTo = "admin_destaques.php";

  if (isset($_SERVER['QUERY_STRING'])) {

    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";

    $deleteGoTo .= $_SERVER['QUERY_STRING'];

  }

  header(sprintf("Location: %s", $deleteGoTo));

}

?>

 

Can anyone help me???

 

Thanks to all

 

[Philip]

If you're wanting to delete the actual file, take a look at unlink()

[jomagi]

Yes, searching internet I find unlink() to be the right way, but can't make the correct add to my script to do the action. Can help me??? Thks

[jomagi]

Can anyone help me with the code? Thanks

[jomagi]

Nobody can help me? Thks

[landavia]

hmm.. i can't see this script gone into

well.. we might help.

 

1. where you put your image

2. what condition you delete ur image

 

if i'm not mistaken.. nothing in your script contain about image, upload image or sort of

[jomagi]

Hi and thanks!

 

The script above is to delete data from de sql and it works fine, now I need to add the script to delete image file from the server, the image are in a subfolder called "destaques". I need to catch the "id" of the product given in the previous delete action and with this "id" pick on the table (MySQL) the image name (is stored like a TEXT field example: "destaques/xxx.jpg") and delete this file from the server.

 

Thanks

[jomagi]

Can anyone help me with the add script, I can't find the right one that pick the right id! Thanks

[DjMikeS]

http://nl.php.net/unlink...

 

So...in your script that would be...

<?php
unlink ("/destaques/". $_GET['id'] .");
?>

 

Notice that I used the code tags...you should do so to!

[lordshoa]

Do not know the feild so guessed but you will work it out from the it will be from the mysql result

 

$variable  =  $query_row['image']
unlink($variable);

[jomagi]

Thanks guys!!!

 

I just add the following script and finally it works fine!!!

 

  $query = sprintf("SELECT * FROM destaques WHERE id=%s",
                       GetSQLValueString($_GET['id'], "int"));
  $result = mysql_query($query);
  $row = mysql_fetch_array($result);
  $imagename = $row["imagem"];
  unlink("./$imagename");

 

Problem solved! Thanks

 

[landavia]

horay... the problem solved

please add to above (topic title) Solved

 

sry 4 late respond..