Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (isset($_GET['id']) && is_numeric($_GET['id']))
- {
- $id = $_GET['id'];
- $name = "SELECT name FROM images WHERE id=$id";
- $name=mysql_fetch_assoc($name);
- $name=$name['name'];
- if ($stmt = $con->prepare("DELETE FROM images WHERE id = ? LIMIT 1"))
- {
- $stmt->bind_param("i",$id);
- $stmt->execute();
- unlink("../upload/" . $name);
- $stmt->close();
- }
- else
- {
- echo "ERROR: could not prepare SQL statement.";
- }
- $con->close();
- header("Location: images_delete.php");
- }
- else
- {
- header("Location: images_delete.php");
- }
- if (isset($_GET['id']) && is_numeric($_GET['id']))
- {
- $id = $_GET['id'];
- $name = "SELECT * FROM images WHERE id=$id" or die(mysqli_error($con));
- $res = mysqli_query($con, $name);
- $row = mysqli_fetch_assoc($res);
- $name1 = $row['name'];
- //print_r($name1);
- if ($stmt = $con->prepare("DELETE FROM images WHERE id = ? LIMIT 1"))
- {
- $stmt->bind_param("i",$id);
- $folder = 'C:wampwwwupload';
- chown($folder,465);
- //var_dump($name1);
- unlink($_SERVER['DOCUMENT_ROOT'] . "/upload/$name1");
- $stmt->execute();
- $stmt->close();
- }
- else
- {
- echo "ERROR: could not prepare SQL statement.";
- }
- $con->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement