du90093662774150 2015-07-07 22:15
浏览 30

PHP move_uploaded_file到SQL

I am having difficulty with the code. I am trying to upload the file to the server folder and insert in to SQL BLOB. Neither one of it works. Any suggestions?

<?php mysql_connect ("host","user","pass") 
    mysql_select_db("pics") 

    $image= addslashes($_FILES['file']['tmp_name']); 
    $name= addslashes($_FILES['file']['name']); 
    $image= file_get_contents($image); 
    $image= base64_encode($image); 

    if (move_uploaded_file ($_FILES["file"]["tmp_name"], "http://www.website.com/uploads/".$_FILES["file"]["name"])) { 
    $insert = mysql_query ("INSERT INTO pics (name,file) values ('$name','$image')"); 
    } 
    else "error uploading query to database"; 

    ?>
  • 写回答

1条回答 默认 最新

  • duandun2218 2017-01-25 06:53
    关注

    First of all (agree with @AMartinNo1) don't use mysql functions, use PDO.
    Also (one more time agree with @AMartinNo1) 2nd parameter to move_uploaded_file must be path to file on your server (file system path).

    $pdo = new PDO('mysql:dbname=pics;host=host', 'user', 'pass');
    
    $image = addslashes($_FILES['file']['tmp_name']); 
    $name = addslashes($_FILES['file']['name']); 
    $image = file_get_contents($image); 
    $image = base64_encode($image);
    
    if (move_uploaded_file($_FILES['file']['tmp_name'], '/tmp/myUploadedFile')) {
        $s = $dbh->prepare('INSERT INTO pics (name, file) VALUES (:name, :file)');
        $s->bindValue(':name', $name, PDO::PARAM_STR);
        $s->bindValue(':file', $image, PDO::PARAM_STR);
        if (!$s->execute()) {
            throw new Exception($s->errorInfo());
        }
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真
  • ¥15 arduino 四自由度机械臂
  • ¥15 wordpress 产品图片 GIF 没法显示
  • ¥15 求三国群英传pl国战时间的修改方法
  • ¥15 matlab代码代写,需写出详细代码,代价私
  • ¥15 ROS系统搭建请教(跨境电商用途)
  • ¥15 AIC3204的示例代码有吗,想用AIC3204测量血氧,找不到相关的代码。