delete function and upload
- by Jesper Petersen
it must be said that I download the database and all my function is in class.
That's how I was incredible pleased function and think they are nice ..
That's how I'm going to build a gallery where the id of the upload to the site if it fits with the id_session is log in page, you have the option to delete it. and so it must just go back to / latest pictures / when it delete it from the folder and database. but it comes up with an error as you can see here;
Fatal error: Call to a member function bind_param () on a non-object in / home / jesperbo / public_html / mebe.dk / function / function.php on line 411
It is such that I am also in the process of building an upload system where the underlying database and make it smaller after what I have now set it and when it did the 2 things must send me back to / latest-images / but it do not reach the only available picture up on the server and do it with the picture but it will not go back in some way at all. So to / latest-images /
Where wrong with it to delete, etc. I lie just here,
$stm1->bind_param('i', $id_gallery);
function img_slet_indhold(){
if($_SESSION["logged_in"] = true && $_SESSION["rank"] == '1' || $_SESSION["rank"] == 2)
{
if($stmt = $this->mysqli->prepare('SELECT `title` FROM `gallery` WHERE `id_gallery` = ?'))
{
$stm1->bind_param('i', $id_gallery);
$id_gallery = $_GET["id_gallery"];
$stm1->execute();
$stm1->store_result();
$stm1->bind_result($title);
$UploadDir = "/gallery/";
//ligger i toppen af documentet, evt som en define
if($stm1->fetch())
{
$tmpfile = $UploadDir . "" . $title;
if(file_exists($tmpfile))
{
unlink($tmpfile);
}
$tmpfile = $UploadDir . "lille/" . $title;
if(file_exists($tmpfile))
{
unlink($tmpfile);
}
$tmpfile = $UploadDir . "store/" . $title;
if(file_exists($tmpfile))
{
unlink($tmpfile);
}
}
$stm1->close();
}
else
{
/* Der er opstået en fejl */
echo 'Der opstod en fejl i erklæringen: ' . $mysqli->error;
}
}
if($stmt = $this->mysqli->prepare('DELETE FROM `gallery` WHERE `id_gallery` = ?' ))
{
$stmt->bind_param('i', $id);
$id = $_GET["id_gallery"];
$stmt->execute();
header('Location: /nyeste-billeder/');
$stmt->close();
}
else
{
/* Der er opstået en fejl */
echo 'Der opstod en fejl i erklæringen: ' . $mysqli->error;
}
}
So into the file as it should delete from, I have chosen to do so here;
<?php
session_start();
require_once ("function/function.php");
$mebe = new mebe;
$db = $mebe->db_c();
error_reporting(E_ERROR);
$img_slet_indhold = $mebe->img_slet_indhold();
?>
So when I upload image to folder and database, and just after can be returned when uploading
function img_indhold(){
if($_SESSION["logged_in"] = true && $_SESSION["rank"] == '1' || $_SESSION["rank"] == 2)
{
include "function/class.upload.php";
$handle = new Upload($_FILES["filename"]);
if($handle->uploaded)
{
//lidt mere store billeder
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 220;
$handle->Process("gallery/store");
//til profil billede lign..
$handle->image_resize = true;
$handle->image_ratio_crop = true;
$handle->image_y = 115;
$handle->image_x = 100;
$handle->Process("gallery");
//til profil billede lign..
$handle->image_resize = true;
$handle->image_ratio_crop = true;
$handle->image_y = 75;
$handle->image_x = 75;
$handle->Process("gallery/lille");
$pb = $handle->file_dst_name;
}
if($stmt = $this->mysqli->prepare('INSERT INTO `gallery` (`title`, `id_bruger`) VALUES (?, ?)'))
{
$stmt->bind_param('si', $title, $id_bruger);
$title = $pb;
$id_bruger = $_SESSION["id"];
$stmt->execute();
header('Location: /nyeste-billeder/');
$stmt->close();
}
}
}
So when I call it on the page when it is required to do so do it like this;
<?php
session_start();
require_once ("function/function.php");
$mebe = new mebe;
$db = $mebe->db_c();
error_reporting(E_ERROR);
$img_slet_indhold = $mebe->img_slet_indhold();
?>
it is here as to when I will upload to the site and show gallery / pictures on the page
function vise_img(){
if ($stmt = $this->mysqli->prepare('SELECT `id_gallery`, `title`, `id_bruger` FROM `gallery` ORDER BY `gallery`.`id_gallery` DESC')) {
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($id_gallery, $title, $id_bruger);
while ($stmt->fetch()) {
echo "<div id=\"gallery_box\">";
echo "<a href=\"/profil/$id_bruger/\"><img src=\"/gallery/$title\" alt=\"\" height=\"115\" width=\"100\" border=\"0\"></a>";
if($_SESSION["logged_in"])
{
if($id_bruger == $_SESSION["id"])
{
echo "<ul>";
echo "<li><a href=\"/nyeste-billeder-slet/$id_gallery/\">Slet</a></li>";
echo "</ul>";
}
}
echo "</div>";
}
/* Luk statement */
$stmt->close();
} else {
/* Der er opstået en fejl */
echo 'Der opstod en fejl i erklæringen: ' . $mysqli->error;
}
}
function upload_img(){
if($_SESSION["logged_in"] = true && $_SESSION["rank"] == '1' || $_SESSION["rank"] == 2)
{
?>
<form name="opslag" method="post" action="/nyeste-ok/" enctype="multipart/form-data">
<input type="file" name="filename" id="filename" onchange="checkFileExt(this)">
<input name="upload" value="Upload" id="background_indhold" onclick="return check()" type="submit">
</form>
<?php
}
elseif ($_SESSION["logged_in"] != true && $_SESSION["rank"] != '1' || $_SESSION["rank"] != 2)
{
echo "<p>Du har ingen mulighed for at upload billeder på siden</p>";
}
}
Really hope you are able to help me further!
