doufei3152 2016-05-20 16:11
浏览 12
已采纳

麻烦图像发布和mysql BLOB变量

I have a form for creating employee and I need to store images in my database (using BLOB MySQL datatype). I use this code and I get an error. Is it about this line?

$file=file_get_contents($_FILES["image"]["tmp_name"]);

what is wrong with this code???

if (isset($_POST['submit']))
{


    $name=mysqli_prep($_POST["name"]);
    $family=mysqli_prep($_POST["family"]);
    $id=$_POST["id"];
    $staff_id=$_POST["staff_id"];
    $account_number=$_POST["account_number"];
    $sex=$_POST["sex"];
    $number_of_children=$_POST["number_of_children"];
    $tel=$_POST["tel"];
    $address=$_POST["address"];
    $no=$_POST["no"];
    $working_record=$_POST["working_record"];
    $marital_state=$_POST["marital_state"];
    $employer_id=$_POST["employer_id"];
        $file=file_get_contents($_FILES["image"]["tmp_name"]); 


    $query  ="INSERT INTO Employee (";
    $query .="Name,Family,ID,Staff_ID,Account_Number,Sex,Number_of_Children,";
    $query .="Tel,Address,No,Working_Record,Marital_State,";
    $query .="Employer_ID,Image)";
    $query .=" VALUES (";
    $query .="'{$name}','{$family}',{$id},{$staff_id},{$account_number},";       
    $query .="'{$sex}',{$number_of_children},{$tel},'{$address}',{$no},";
    $query .="'{$working_record}','{$marital_state}',";
    $query .="{$employer_id},'$file')";        
    $result =mysqli_query($connection, $query);

       if(!$result){   
           $_SESSION["message"] ="There were some errors,fill each 
       section carefully";   
           redirect_to("creat_employee.php");
       }
       else{
           $_SESSION["message"]="filling has been done !";

           redirect_to("creat_employee.php");
    }
}
  • 写回答

1条回答 默认 最新

  • dopzc64662 2016-05-20 18:42
    关注

    Finally I found the answer,tried addslashes function (used for sqlinjection) and surprisingly it worked properly

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 AIC3204的示例代码有吗,想用AIC3204测量血氧,找不到相关的代码。
  • ¥20 CST怎么把天线放在座椅环境中并仿真
  • ¥15 任务A:大数据平台搭建(容器环境)怎么做呢?
  • ¥15 r语言神经网络自变量重要性分析
  • ¥15 基于双目测规则物体尺寸
  • ¥15 wegame打不开英雄联盟
  • ¥15 公司的电脑,win10系统自带远程协助,访问家里个人电脑,提示出现内部错误,各种常规的设置都已经尝试,感觉公司对此功能进行了限制(我们是集团公司)
  • ¥15 救!ENVI5.6深度学习初始化模型报错怎么办?
  • ¥30 eclipse开启服务后,网页无法打开
  • ¥30 雷达辐射源信号参考模型