时间:2021-07-01 10:21:17 帮助过:20人阅读
1、遍历数组,每次插入一个元素
2、连接成串后插入
怎么做是根据你的需要来的,并无一定之规
你是程序的主人,而不是程序的奴隶
foreach($arr as $v){ mysql_query("insert into tbname (image_url) values ('".$v."')");}
0 对应 第一个 1 对应第二个 要看你是怎么设计的....
foreach($arr as $v){ mysql_query("insert into tbname (image_url) values ('".$v."')");}
error(99); if($path) $this->upload_path = $path; if($_FILES && $this->timetree) { $this->upload_path .= date('/Y/m/d'); if(! file_exists($this->upload_path)) mkdir($this->upload_path, 0666, true); } foreach($_FILES as $info) { if(! is_array($info['name'])) { $this->upload_callback($info); continue; } for($i=0;$iupload_callback(array( 'name' => $info['name'][$i], 'type' => $info['type'][$i], 'tmp_name' => $info['tmp_name'][$i], 'error' => $info['error'][$i], 'size' => $info['size'][$i], )); } } } /** * 上传处理回调方法 * 功能 保存上传文件 **/ function upload_callback($info) { if($info['error']) return $this->error($info['error']); if(!($ext = $this->extension($info['name']))) return; $t= date('YmdHis'); $n = 0; do { $filename = sprintf('%s/%s%03d.%s', $this->upload_path, $t, $n++, $ext); }while(file_exists($filename)); copy($info['tmp_name'], $filename); $this->upload_file[] = $filename; } function extension($filename) { $t = strtolower(pathinfo($filename, PATHINFO_EXTENSION)); if(in_array($t, $this->allow)) return $t; $this->error("$t 非法的类型"); return ''; } /** * 错误处理 **/ function error($errno) { $msg = ''; switch($errno) { case UPLOAD_ERR_INI_SIZE: $msg = '上传的文件超过了 '.ini_get('upload_max_filesize'); break; case UPLOAD_ERR_FORM_SIZE: $msg = '上传文件的大小超过了 HTML 表单中 MAX_FILE_SIZE 选项指定的值'; break; case UPLOAD_ERR_PARTIAL: $msg = '文件只有部分被上传'; break; case UPLOAD_ERR_NO_FILE: $msg = '没有文件被上传'; break; case UPLOAD_ERR_NO_TMP_DIR: $msg = '找不到临时文件夹'; break; case UPLOAD_ERR_CANT_WRITE: $msg = '文件写入失败'; break; default: $msg = '错误:'.$errno; break; } echo ""; }}$p = new upload;print_r($p->upload_file);?>
下面这句是返回接收的显示就是这个内容:Array ( [0] => upload/2015/09/06/20150906164734000.jpg [1] => upload/2015/09/06/20150906164734001.jpg
$sql = "insert into 表 (IMG1,IMG 2) values('$p->upload_file[0]', '$p->upload_file[1]')";
$sql = "insert into 表 (IMG1,IMG 2) values('$p->upload_file[0]', '$p->upload_file[1]')";
$sql = "insert into 表 (IMG1,IMG 2) values('$p->upload_file[0]', '$p->upload_file[1]')";
先序列化为字符串,然后存进去,取出来之后再序列化,最方便的操作,还保留原结构。