最近用jquery-file-upload 来改善网站上传的体验
https://github.com/blueimp/jQuery-File-Upload/wiki/PHP-MySQL-database-integration
上传时按照他的参考文档，立马就完成了，一开始也按照他的sql 架构先试试
结果上传后，也能成功插入，json传回页面一切正常！
但问题来了，他的sql 架构...有个叫url
但作者好像在PHP的SQL中没有处理
那我就改改吧，....
先新增了一些基本配置
$dir = $_COOKIE["uid"].'/'.date("Y").'/'.date("m").'/'.date("d").'/';$dirUP = "../../../att/".$dir;$dirLink = $dir;$options=array( 'upload_dir' => $dirUP, 'upload_url' => $dirLink, 'delete_type' => 'POST', 'db_host' => 'localhost', 'db_user' => 'root', 'db_pass' => '*****', 'db_name' => '*****', 'db_table' => 'files'); 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 handle_file_upload($uploaded_file, $name, $size, $type,$url, $error, $index = null, $content_range = null) { $file = parent::handle_file_upload( $uploaded_file, $name, $size, $type,$url, $error, $index, $content_range ); if (empty($file->error)) { $sql = 'INSERT INTO `'.$this->options['db_table'] .'` (`name`, `size`, `type`, `url`, `title`, `description`)' .' VALUES (?, ?, ?, ?,? , ?)'; $query = $this->db->prepare($sql); $query->bind_param( 'sisss', $file->name, $file->size, $file->type, $file->url, $file->title, $file->description ); $query->execute(); $file->id = $this->db->insert_id; } return $file; }
警告：mysqli_stmt：：bind_param()：在类型定义字符串不匹配的绑定变量的元素个数
这还不清楚吗？
$query->bind_param(
' sisss', //怎么只有 5 个类型声明？
$file->name, //1
$file->size, //2
$file->type, //3
$file->url, //4
$file->title,//5
$file->description //6 共6个
);
警告：mysqli_stmt：：bind_param()：在类型定义字符串不匹配的绑定变量的元素个数
这还不清楚吗？
$query->bind_param(
' sisss', //怎么只有 5 个类型声明？
$file->name, //1
$file->size, //2
$file->type, //3
$file->url, //4
$file->title,//5
$file->description //6 共6个
);
