[ Поиск ] - [ Пользователи ] - [ Календарь ]
Полная Версия: Помогите с проблемой
leonweb
Всем привет!
есть проблема с Загрузкой изображение в базу данных
не могу ни как прикрепить код SQL выдаёт ошибку
Помогите пожалуйста
вот код

<?php
/*
* jQuery File Upload Plugin PHP Example 5.5
*
https://github.com/blueimp/jQuery-File-Upload
*
* Copyright 2010, Sebastian Tschan
*
https://blueimp.net
*
* Licensed under the MIT license:
*
http://www.opensource.org/licenses/MIT
*/

include 'db.php';


error_reporting(E_ALL | E_STRICT);

class UploadHandler
{
private $options;

function __construct($options=null) {
$this->options = array(
'script_url' => $this->getFullUrl().'/'.basename(__FILE__),
'upload_dir' => dirname(__FILE__).'/gallery/big/',
'upload_url' => $this->getFullUrl().'/gallery/big/',
'param_name' => 'files',
// The php.ini settings upload_max_filesize and post_max_size
// take precedence over the following max_file_size setting:

'max_file_size' => null,
'min_file_size' => 1,
'accept_file_types' => '/.+$/i',
'max_number_of_files' => null,
// Set the following option to false to enable non-multipart uploads:
'discard_aborted_uploads' => true,
// Set to true to rotate images based on EXIF meta data, if available:
'orient_image' => false,
'image_versions' => array(
// Uncomment the following version to restrict the size of
// uploaded images. You can also add additional versions with
// their own upload directories:


'large' => array(
'upload_dir' => dirname(__FILE__).'/gallery/big/',
'upload_url' => dirname($_SERVER['PHP_SELF']).'/gallery/big/',
'max_width' => 800,
'max_height' => 600
),

'thumbnail' => array(
'upload_dir' => dirname(__FILE__).'/gallery/small/',
'upload_url' => $this->getFullUrl().'/gallery/small/',
'max_width' => 80,
'max_height' => 80
)
)
);

if ($options) {
$this->options = array_replace_recursive($this->options, $options);
}
}


function getFullUrl() {
return
(isset($_SERVER['HTTPS']) ? 'https://' : 'http://').
(
isset($_SERVER['REMOTE_USER']) ? $_SERVER['REMOTE_USER'].'@' : '').
(
isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : ($_SERVER['SERVER_NAME'].
(
isset($_SERVER['HTTPS']) && $_SERVER['SERVER_PORT'] === 443 ||
$_SERVER['SERVER_PORT'] === 80 ? '' : ':'.$_SERVER['SERVER_PORT']))).
substr($_SERVER['SCRIPT_NAME'],0, strrpos($_SERVER['SCRIPT_NAME'], '/'));
}

private function get_file_object($file_name) {
$file_path = $this->options['upload_dir'].$file_name;
if (is_file($file_path) && $file_name[0] !== '.') {
$file = new stdClass();
$file->name = $file_name;
$file->size = filesize($file_path);
$file->url = $this->options['upload_url'].rawurlencode($file->name);
foreach($this->options['image_versions'] as $version => $options) {
if (is_file($options['upload_dir'].$file_name)) {
$file->{$version.'_url'} = $options['upload_url']
.
rawurlencode($file->name);
}
}

$file->delete_url = $this->options['script_url']
.
'?file='.rawurlencode($file->name);
$file->delete_type = 'DELETE';
return $file;
}
return null;
}

private function get_file_objects() {
return array_values(array_filter(array_map(
array($this, 'get_file_object'),
scandir($this->options['upload_dir'])
)));

}

private function create_scaled_image($file_name, $options) {
$file_path = $this->options['upload_dir'].$file_name;
$new_file_path = $options['upload_dir'].$file_name;
list($img_width, $img_height) = @getimagesize($file_path);
if (!$img_width || !$img_height) {
return false;
}
$scale = min(
$options['max_width'] / $img_width,
$options['max_height'] / $img_height
);
if ($scale > 1) {
$scale = 1;
}
$new_width = $img_width * $scale;
$new_height = $img_height * $scale;
$new_img = @imagecreatetruecolor($new_width, $new_height);
switch (strtolower(substr(strrchr($file_name, '.'), 1))) {
case 'jpg':
case 'jpeg':
$src_img = @imagecreatefromjpeg($file_path);
$write_image = 'imagejpeg';
break;
case 'gif':
@imagecolortransparent($new_img, @imagecolorallocate($new_img, 0, 0, 0));
$src_img = @imagecreatefromgif($file_path);
$write_image = 'imagegif';
break;
case 'png':
@imagecolortransparent($new_img, @imagecolorallocate($new_img, 0, 0, 0));
@imagealphablending($new_img, false);
@imagesavealpha($new_img, true);
$src_img = @imagecreatefrompng($file_path);
$write_image = 'imagepng';
break;
default:
$src_img = $image_method = null;
}
$success = $src_img && @imagecopyresampled(
$new_img,
$src_img,
0, 0, 0, 0,
$new_width,
$new_height,
$img_width,
$img_height
) && $write_image($new_img, $new_file_path);
// Free up memory (imagedestroy does not delete files):
@imagedestroy($src_img);
@imagedestroy($new_img);
return $success;
}

private function has_error($uploaded_file, $file, $error) {
if ($error) {
return $error;
}
if (!preg_match($this->options['accept_file_types'], $file->name)) {
return 'acceptFileTypes';
}
if ($uploaded_file && is_uploaded_file($uploaded_file)) {
$file_size = filesize($uploaded_file);
} else {
$file_size = $_SERVER['CONTENT_LENGTH'];
}
if ($this->options['max_file_size'] && (
$file_size > $this->options['max_file_size'] ||
$file->size > $this->options['max_file_size'])
)
{
return 'maxFileSize';
}
if ($this->options['min_file_size'] &&
$file_size < $this->options['min_file_size']) {
return 'minFileSize';
}
if (is_int($this->options['max_number_of_files']) && (
count($this->get_file_objects()) >= $this->options['max_number_of_files'])
)
{
return 'maxNumberOfFiles';
}
return $error;
}

private function trim_file_name($name, $type) {
// Remove path information and dots around the filename, to prevent uploading
// into different directories or replacing hidden system files.
// Also remove control characters and spaces (\x00..\x20) around the filename:

$file_name = trim(basename(stripslashes($name)), ".\x00..\x20");
// Add missing file extension for known image types:
if (strpos($file_name, '.') === false &&
preg_match('/^image\/(gif|jpe?g|png)/', $type, $matches)) {
$file_name .= '.'.$matches[1];
}
return $file_name;
}

private function orient_image($file_path) {
$exif = exif_read_data($file_path);
$orientation = intval(@$exif['Orientation']);
if (!in_array($orientation, array(3, 6, 8))) {
return false;
}
$image = @imagecreatefromjpeg($file_path);
switch ($orientation) {
case 3:
$image = @imagerotate($image, 180, 0);
break;
case 6:
$image = @imagerotate($image, 270, 0);
break;
case 8:
$image = @imagerotate($image, 90, 0);
break;
default:
return false;
}
$success = imagejpeg($image, $file_path);
// Free up memory (imagedestroy does not delete files):
@imagedestroy($image);
return $success;
}

private function handle_file_upload($uploaded_file, $name, $size, $type, $error) {
$file = new stdClass();
$file->name = $this->trim_file_name($name, $type);
$file->size = intval($size);
$file->type = $type;
$error = $this->has_error($uploaded_file, $file, $error);
if (!$error && $file->name) {
$file_path = $this->options['upload_dir'].$file->name;
$append_file = !$this->options['discard_aborted_uploads'] &&
is_file($file_path) && $file->size > filesize($file_path);
clearstatcache();
if ($uploaded_file && is_uploaded_file($uploaded_file)) {
// multipart/formdata uploads (POST method uploads)
if ($append_file) {
file_put_contents(
$file_path,
fopen($uploaded_file, 'r'),
FILE_APPEND
);
} else {
move_uploaded_file($uploaded_file, $file_path);
}
}
else {
// Non-multipart uploads (PUT method support)
file_put_contents(
$file_path,
fopen('php://input', 'r'),
$append_file ? FILE_APPEND : 0
);
}
$file_size = filesize($file_path);
if ($file_size === $file->size) {
if ($this->options['orient_image']) {
$this->orient_image($file_path);
}
$file->url = $this->options['upload_url'].rawurlencode($file->name);
foreach($this->options['image_versions'] as $version => $options) {
if ($this->create_scaled_image($file->name, $options)) {
$file->{$version.'_url'} = $options['upload_url']
.
rawurlencode($file->name);
}
}
}
else if ($this->options['discard_aborted_uploads']) {
unlink($file_path);
$file->error = 'abort';
}
$file->size = $file_size;
$file->delete_url = $this->options['script_url']
.
'?file='.rawurlencode($file->name);
$file->delete_type = 'DELETE';
} else {
$file->error = $error;
}
return $file;
}

public function get() {
$file_name = isset($_REQUEST['file']) ?
basename(stripslashes($_REQUEST['file'])) : null;
if ($file_name) {
$info = $this->get_file_object($file_name);
} else {
$info = $this->get_file_objects();
}
header('Content-type: application/json');
echo json_encode($info);
}

public function post() {
if (isset($_REQUEST['_method']) && $_REQUEST['_method'] === 'DELETE') {
return $this->delete();
}
$upload = isset($_FILES[$this->options['param_name']]) ?
$_FILES[$this->options['param_name']] : null;
$info = array();
if ($upload && is_array($upload['tmp_name'])) {
foreach ($upload['tmp_name'] as $index => $value) {
$info[] = $this->handle_file_upload(
$upload['tmp_name'][$index],
isset($_SERVER['HTTP_X_FILE_NAME']) ?
$_SERVER['HTTP_X_FILE_NAME'] : $upload['name'][$index],
isset($_SERVER['HTTP_X_FILE_SIZE']) ?
$_SERVER['HTTP_X_FILE_SIZE'] : $upload['size'][$index],
isset($_SERVER['HTTP_X_FILE_TYPE']) ?
$_SERVER['HTTP_X_FILE_TYPE'] : $upload['type'][$index],
$upload['error'][$index]
);

}
}
elseif ($upload || isset($_SERVER['HTTP_X_FILE_NAME'])) {
$info[] = $this->handle_file_upload(
isset($upload['tmp_name']) ? $upload['tmp_name'] : null,
isset($_SERVER['HTTP_X_FILE_NAME']) ?
$_SERVER['HTTP_X_FILE_NAME'] : (isset($upload['name']) ?
isset($upload['name']) : null),
isset($_SERVER['HTTP_X_FILE_SIZE']) ?
$_SERVER['HTTP_X_FILE_SIZE'] : (isset($upload['size']) ?
isset($upload['size']) : null),
isset($_SERVER['HTTP_X_FILE_TYPE']) ?
$_SERVER['HTTP_X_FILE_TYPE'] : (isset($upload['type']) ?
isset($upload['type']) : null),
isset($upload['error']) ? $upload['error'] : null

);
}
header('Vary: Accept');
$json = json_encode($info);
$redirect = isset($_REQUEST['redirect']) ?
stripslashes($_REQUEST['redirect']) : null;
if ($redirect) {
header('Location: '.sprintf($redirect, rawurlencode($json)));
return;
}
if (isset($_SERVER['HTTP_ACCEPT']) &&
(
strpos($_SERVER['HTTP_ACCEPT'], 'application/json') !== false)) {
header('Content-type: application/json');
} else {
header('Content-type: text/plain');
}
echo $json;
}

public function delete() {
$file_name = isset($_REQUEST['file']) ?
basename(stripslashes($_REQUEST['file'])) : null;
$file_path = $this->options['upload_dir'].$file_name;
$success = is_file($file_path) && $file_name[0] !== '.' && unlink($file_path);
if ($success) {
foreach($this->options['image_versions'] as $version => $options) {
$file = $options['upload_dir'].$file_name;
if (is_file($file)) {
unlink($file);
}
}
}

header('Content-type: application/json');
echo json_encode($success);
}

}


$upload_handler = new UploadHandler();

header('Pragma: no-cache');
header('Cache-Control: private, no-cache');
header('Content-Disposition: inline; filename="files.json"');
header('X-Content-Type-Options: nosniff');
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: OPTIONS, HEAD, GET, POST, PUT, DELETE');
header('Access-Control-Allow-Headers: X-File-Name, X-File-Type, X-File-Size');

switch ($_SERVER['REQUEST_METHOD']) {
case 'OPTIONS':
break;
case 'HEAD':
case 'GET':
$upload_handler->get();
break;
case 'POST':
$upload_handler->post();
break;
case 'DELETE':
$upload_handler->delete();
break;
default:
header('HTTP/1.1 405 Method Not Allowed');
}
?>

а это запрос

$query="INSERT INTO gallery (pic_src,pic_show,pic_page_id) VALUES ('".$file."', 'yes', '".$_GET['rid']."')";
mysql_query("SET NAMES 'utf8'");
$result=mysql_query($query);
if(!$result)




Спустя 45 минут, 24 секунды (25.02.2012 - 00:34) m4a1fox написал(а):
Хы

Спустя 6 часов, 9 минут, 37 секунд (25.02.2012 - 06:44) Эли4ка написал(а):
leonweb
какую ошибку..на какой линии или сейчас нам весь код разбирать?

Спустя 4 часа, 6 минут, 28 секунд (25.02.2012 - 10:51) leonweb написал(а):
ошибка в том что я встовляю в любую строку код SQL
в папку изоброжение грузиться а в базу даных нет
как мне это реализовать

это код SQL

$query="INSERT INTO gallery (pic_src,pic_show,pic_page_id) VALUES ('".$file_name."', 'yes', '".$_GET['rid']."')";
mysql_query("SET NAMES 'utf8'");
$result=mysql_query($query);
if(!$result)
//return false;
//die();

die('SOMETHING IS WRONG UPDATIN THE DB');

else

header('location:room1_form.php?rid='.$_GET['rid']);

Спустя 30 минут, 41 секунда (25.02.2012 - 11:21) EvilDev написал(а):
Попробуй die(mysql_error()) может поймешь)

Спустя 39 минут, 19 секунд (25.02.2012 - 12:01) leonweb написал(а):
я это уже прописывал но проблема что ни какую ошибку не показывает
просто не добовляет в db
может надо прописать код SQL
ГДЕТО В СЕРЕДИНЕ СКРИПТА?

Спустя 24 минуты, 17 секунд (25.02.2012 - 12:25) Эли4ка написал(а):
leonweb
попробуйте сделать запрос sql таким
$sql = 'INSERT INTO `DB`.`table_name` (`title`)
VALUES("'
.mysql_real_escape_string($title).'")';
if(!mysql_query($sql))
{echo '<center><p><b>Ошибка при добавлении данных!</b></p></center>';}
else
{echo '<center><p><b>Данные добавлены!</b></p></center>';}}
?>

Спустя 14 минут, 47 секунд (25.02.2012 - 12:40) leonweb написал(а):
а в кокую строку этот кад вставить?

Спустя 4 минуты, 12 секунд (25.02.2012 - 12:44) Эли4ка написал(а):
leonweb
ну в Ваш SQL запрос конечно же..

Спустя 4 минуты, 9 секунд (25.02.2012 - 12:48) leonweb написал(а):
я прописал и вышло вот токая ошибка

SyntaxError: JSON.parse: unexpected non-whitespace character after JSON data

Спустя 1 час, 5 минут, 12 секунд (25.02.2012 - 13:53) leonweb написал(а):
этот обработчик
может загружать до 5 mb
и примерно до 20 фото одновременно и всё работает только в базу данных не загружает а только в указоную папку
как мне сделать чтобы загружалось не только в папку но и в базу даных

Спустя 15 часов, 25 минут, 17 секунд (26.02.2012 - 05:18) Эли4ка написал(а):
leonweb
Вы скрипт,который я дала под свои данные переделали или так и вставили?
Быстрый ответ:

 Графические смайлики |  Показывать подпись
Здесь расположена полная версия этой страницы.
Invision Power Board © 2001-2024 Invision Power Services, Inc.