duancenxiao0482
2013-11-04 21:29 阅读 44
已采纳

将图像(NSData)插入BLOB字段

From iOS app to php script, I want to store a bench of images as BLOB types:

 $profile_images = $_REQUEST['profile_images_array'];//get the array of images

        //loop the images and store them one by one
        foreach($profile_images as $image){ 
        $sqlinsertimages = "insert into profile_images (id_client,image) Values ('".$id."',mysql_real_escape_string('".$image."'))";
        $result = mysql_query($sqlinsertimages);

        }   

The insert would work fine if I eliminate the image field (which is BLOB type), so the issue is obviously with the saving BLOB types in the table.

How to store properly the images in PHP as BLOB?

PS: not willing to adopt the file system storage.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    doukunsan5553 doukunsan5553 2013-11-04 23:42

    Ok, I guess that work finally, didn't knew that I had to save the image to the server before saving it to MySQL:

                foreach($profile_images as $image){ 
                    //Get the file as a string before inserting it to table
                    $content = file_get_contents($image);
                    $content = mysql_real_escape_string($content);
                    $sqlinsertimages = "insert into profile_images (id_client,image) Values ('".$id."','".$content."')";
    
                    $result = mysql_query($sqlinsertimages);
                }   
    
    点赞 评论 复制链接分享

相关推荐