PDO plupload veri kaydememe

Kolay gelsin plupload resim yükleme motorunu kullanıyorum php siteme yerleştirdim. resimleri dosyaya aktarıyor ama veri tabanına kayıt yapamadım bir türlü pdo yeni öğreniyorum yardımlarını bekliyorum şimdiden teşekkürler. post yolladığım id yi kategoriye kaydetmek istiyorum.

--------plupload.php---------

<?php
session_start();
include("../../includes/config.php");
if(!isset($_SESSION['uname'])){
echo '';
}else{
include("login.php");
}

?>

<?php
error_reporting(0);
session_start();
function kodYarat(){
$havuz = "q1w2e3r4t5y6u7o8p9a0s0d9f8g7h6h5j4k3l2i1z2x3c4v5b6n7m890";
$kod="";
for ($i=0; $i<=25; $i++)
$kod .= $havuz[rand(0,55)];
return $kod;
}
/**
* upload.php
*
* Copyright 2013, Moxiecode Systems AB
* Released under GPL License.
*
* License:https://www.plupload.com/license
* Contributing:https://www.plupload.com/contributing
*/

#!! IMPORTANT:
#!! this file is just an example, it doesn't incorporate any security checks and
#!! is not recommended to be used in production environment as it is. Be sure to
#!! revise it and customize to your needs.

// Make sure file is not cached (as it happens for example on iOS devices)
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");

// Settings
$targetDir = ini_get("upload_tmp_dir") . DIRECTORY_SEPARATOR . "plupload";
$targetDir = '../../album/';

$cleanupTargetDir = true; // Remove old files
$maxFileAge = 5 * 3600; // Temp file age in seconds

// 5 minutes execution time
@set_time_limit(5 * 60);

// Chunking might be enabled
$chunk = isset($_REQUEST["chunk"]) ? intval($_REQUEST["chunk"]) : 0;
$chunks = isset($_REQUEST["chunks"]) ? intval($_REQUEST["chunks"]) : 0;
$fileName = isset($_REQUEST["name"]) ? $_REQUEST["name"] : '';

// Clean the fileName for security reasons
$fileName = $dosya_adi= kodYarat().".jpg";

// Make sure the fileName is unique but only if chunking is disabled
if ($chunks < 2 && file_exists($targetDir . DIRECTORY_SEPARATOR . $fileName)) {
$ext = strrpos($fileName, '.');
$fileName_a = substr($fileName, 0, $ext);
$fileName_b = substr($fileName, $ext);

$count = 1;
while (file_exists($targetDir . DIRECTORY_SEPARATOR . $fileName_a . '_' . $count . $fileName_b))
$count++;

$fileName = $fileName_a . '_' . $count . $fileName_b;
}

$filePath = $targetDir . DIRECTORY_SEPARATOR . $fileName;

// Create target dir
if (!file_exists($targetDir))
@mkdir($targetDir);

// Remove old temp files
if ($cleanupTargetDir) {
if (is_dir($targetDir) && ($dir = opendir($targetDir))) {
while (($file = readdir($dir)) !== false) {
$tmpfilePath = $targetDir . DIRECTORY_SEPARATOR . $file;

// Remove temp file if it is older than the max age and is not the current file
if (preg_match('/\.part$/', $file) && (filemtime($tmpfilePath) < time() - $maxFileAge) && ($tmpfilePath != "{$filePath}.part")) {
@unlink($tmpfilePath);
}
}
closedir($dir);
} else {
die('{"jsonrpc" : "2.0", "error" : {"code": 100, "message": "Failed to open temp directory."}, "id" : "id"}');
}
}

// Look for the content type header
if (isset($_SERVER["HTTP_CONTENT_TYPE"]))
$contentType = $_SERVER["HTTP_CONTENT_TYPE"];

if (isset($_SERVER["CONTENT_TYPE"]))
$contentType = $_SERVER["CONTENT_TYPE"];
// Handle non multipart uploads older WebKit versions didn't support multipart in HTML5
if (strpos($contentType, "multipart") !== false) {
if (isset($_FILES['file']['tmp_name']) && is_uploaded_file($_FILES['file']['tmp_name'])) {
// Open temp file
$out = @fopen("{$filePath}.part", $chunk == 0 ? "wb" : "ab");
if ($out) {
// Read binary input stream and append it to temp file
$in = @fopen($_FILES['file']['tmp_name'], "rb");

if ($in) {
while ($buff = fread($in, 4096))
fwrite($out, $buff);
} else
die('{"jsonrpc" : "2.0", "error" : {"code": 101, "message": "Failed to open input stream."}, "id" : "id"}');
@fclose($in);
@fclose($out);
@unlink($_FILES['file']['tmp_name']);
} else
die('{"jsonrpc" : "2.0", "error" : {"code": 102, "message": "Failed to open output stream."}, "id" : "id"}');
} else
die('{"jsonrpc" : "2.0", "error" : {"code": 103, "message": "Failed to move uploaded file."}, "id" : "id"}');
} else {
// Open temp file
$out = @fopen("{$filePath}.part", $chunk == 0 ? "wb" : "ab");
if ($out) {
// Read binary input stream and append it to temp file
$in = @fopen("php://input", "rb");

if ($in) {
while ($buff = fread($in, 4096))
fwrite($out, $buff);
} else
die('{"jsonrpc" : "2.0", "error" : {"code": 101, "message": "Failed to open input stream."}, "id" : "id"}');

@fclose($in);
@fclose($out);
} else
die('{"jsonrpc" : "2.0", "error" : {"code": 102, "message": "Failed to open output stream."}, "id" : "id"}');
}

// Check if file has been uploaded
if (!$chunks || $chunk == $chunks - 1) {
// Strip the temp .part suffix off
rename("{$filePath}.part", $filePath);

$uzanti=explode('.',$fileName);
$uzanti=end($uzanti);
$dosyaadi=str_replace('.'.$uzanti,'',$fileName);
$dosyaadi=uniqid().'.'.$uzanti;
rename('../../album/'.$fileName,'../../album/'.$dosyaadi);

$id = $_GET["sayfa"];

if($_POST){
$dosyaadi = $_POST["resim"];
$id = $_POST["kategori"];

$ekle=$db->prepare("INSERT INTO properyt_gallery SET resim=:resim, kategori=:id");
$ekle->execute(array(":resim" => $dosyaadi, ":kategori" => $id, ));

if($ekle ){
echo "<font color=\"red\" ><h5><b><i>      EKLENMİŞTİR.</i></b></h5></font>" ;
}else{

echo "<font color=\"red\" ><h5><b><i>     EKLEME BAŞARISIZ. :(</i></b></h5></font>";
}
}

}

die('{"jsonrpc" : "2.0", "result" : null, "id" : "id"}');

------------

---database-----

1 id Birincil int(11)
2 isim varchar(400)
3 kategori varchar(400)

Benzer içerikler