php – 在blueimp / jquery-file-upload上添加更多自定义变量给mysql insert
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了php – 在blueimp / jquery-file-upload上添加更多自定义变量给mysql insert,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2975字,纯文字阅读大概需要5分钟。
内容图文
![php – 在blueimp / jquery-file-upload上添加更多自定义变量给mysql insert](/upload/InfoBanner/zyjiaocheng/888/1ccec52f5969444794c8e7c7fd08840a.jpg)
我目前正在通过mysql在blueimp / jquery-file-upload脚本中插入标题和描述.我使用this教程让我在那里,但是,我需要添加另一个变量.该变量是当前登录用户的ID $_SESSION [“userid”]的会话,我想将其插入到我添加的名为uid的列中.通常很容易将另一列插入到插入中,但是这个脚本非常敏感,任何时候我都搞乱它,即使是最轻微的一点,我得到“SyntaxError:Unexpected token<”.任何帮助将不胜感激. /server/php/index.php
$options = array(
'delete_type' => 'POST',
'db_host' => 'localhost',
'db_user' => 'fpform_fanuser',
'db_pass' => '*****',
'db_name' => 'fpform_fandata',
'db_table' => 'files'
);
error_reporting(E_ALL | E_STRICT);
require('UploadHandler.php');
class CustomUploadHandler extends UploadHandler {
protected function initialize() {
$this->db = new mysqli(
$this->options['db_host'],
$this->options['db_user'],
$this->options['db_pass'],
$this->options['db_name']
);
parent::initialize();
$this->db->close();
}
protected function handle_form_data($file, $index) {
$file->title = @$_REQUEST['title'][$index];
$file->description = @$_REQUEST['description'][$index];
}
protected function handle_file_upload($uploaded_file, $name, $size, $type, $error,
$index = null, $content_range = null) {
$file = parent::handle_file_upload(
$uploaded_file, $name, $size, $type, $error, $index, $content_range
);
if (empty($file->error)) {
$sql = 'INSERT INTO `'.$this->options['db_table']
.'` (`name`, `size`, `type`, `title`, `description`)'
.' VALUES (?, ?, ?, ?, ?)';
$query = $this->db->prepare($sql);
$query->bind_param(
'sisss',
$file->name,
$file->size,
$file->type,
$file->title,
$file->description,
);
$query->execute();
$file->id = $this->db->insert_id;
}
return $file;
}
protected function set_additional_file_properties($file) {
parent::set_additional_file_properties($file);
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
$sql = 'SELECT `id`, `type`, `title`, `description` FROM `'
.$this->options['db_table'].'` WHERE `name`=?';
$query = $this->db->prepare($sql);
$query->bind_param('s', $file->name);
$query->execute();
$query->bind_result(
$id,
$type,
$title,
$description
);
while ($query->fetch()) {
$file->id = $id;
$file->type = $type;
$file->title = $title;
$file->description = $description;
}
}
}
public function delete($print_response = true) {
$response = parent::delete(false);
foreach ($response as $name => $deleted) {
if ($deleted) {
$sql = 'DELETE FROM `'
.$this->options['db_table'].'` WHERE `name`=?';
$query = $this->db->prepare($sql);
$query->bind_param('s', $name);
$query->execute();
}
}
return $this->generate_response($response, $print_response);
}
}
$upload_handler = new CustomUploadHandler($options);
解决方法:
假设您要更改INSERT查询(您发布的代码中只有一个INSERT查询),这是您需要更改的内容:
if (empty($file->error)) {
$sql = 'INSERT INTO `'.$this->options['db_table']
.'` (`name`, `size`, `type`, `title`, `description`, `uid`)'
.' VALUES (?, ?, ?, ?, ?, ?)';
$query = $this->db->prepare($sql);
$query->bind_param(
'sisss',
$file->name,
$file->size,
$file->type,
$file->title,
$file->description,
$_SESSION['userid']
);
$query->execute();
$file->id = $this->db->insert_id;
}
内容总结
以上是互联网集市为您收集整理的php – 在blueimp / jquery-file-upload上添加更多自定义变量给mysql insert全部内容,希望文章能够帮你解决php – 在blueimp / jquery-file-upload上添加更多自定义变量给mysql insert所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。