kglife developer's blog | our web,our life

TAG | php

九/09

23

上传文件到MYSQL数据库中

假如我们现在从一个页面中提交一个文件到PHP文件中处理,代码如下(省略了html提交页面) PHP |  copy |? 01< ?php02 $filename = $_FILES[’userfile’][’tmp_name’];03 if($_FILES[’userfile’][’size’]&lt;100) exit("请选择文件");04 $fp = fopen($filename, "rb");05 $picture = fread($fp,filesize($filename));06 $picture = base64_encode($picture);07 fclose($fp);08 $data[’p_pic’] = $picture;09 $data[’type’] = $_FILES[’userfile’][’type’];10 $data[’file_name’] = $_FILES[’userfile’][’name’];11 $data[’file_size’] = $_FILES[’userfile’][’size’];12 $data[’content’] = $_POST[’content’];13 $connect =MYSQL_CONNECT("localhost","root","") or die("Unable to connect to MySQL server"); 14 mysql_select_db( "test") or die("Unable to select database");15 $result=MYSQL_QUERY( "INSERT INTO (p_pic,type,file_name,file_size,filetype,content) VALUES16 [...]

· · ·