dongou1970 2017-06-06 03:40
浏览 53
已采纳

mysql BLOB在php中操作

In mysql, I have a db column with BLOB data type.

The blob data looks something like this:

{\"Name\":\"Mike Smith\",\"Number\":\"1\"}

or

[{\"Name\":\"Mike Smith\"},{\"Name\":\"Jon Doe\",\"Spaces\":\"1\"},{\"Name\":\"My Space(s)\"},{\"Name\":\"Rear\"}]

I am trying to detect the content in php and saving the string as a variable as such:

{\"Name\":\"Mike Smith\",\"Number\":\"1\"} 
BECOMES -> Mike Smith(1)

And...

[{\"Name\":\"Mike Smith\"},{\"Name\":\"Jon Doe\",\"Number\":\"1\"},{\"Name\":\"My Space(s)\"},{\"Name\":\"Rear\"}]   
BECOMES --> Mike Smith, Jon Doe(1), My Space(s), Rear

I am not familiar with BLOB data type and wanted to get some help from the community. How would I manipulate the BLOB data to above?

Any suggestions will be much appreciated.

  • 写回答

1条回答 默认 最新

  • douzaipou3327 2017-06-06 04:55
    关注
    <?php
    
    $data = '[{\"Name\":\"Mike Smith\"},{\"Name\":\"Jon Doe\",\"Number\":\"1\"},
    {\"Name\":\"My Space(s)\"},{\"Name\":\"Rear\"}]';
    
    $data =  json_decode(stripslashes($data))  ;
    
     $string = '';
     for ($i=0; $i <sizeof($data) ; $i++) { 
    
     $d = $data[$i];
    
     if(isset($d->Number)){
        $number = '('.$d->Number.')';
     }
     else{
        $number = '';
     }
    
     $string .= ($d->Name).$number.',  ';
    
    }
    
    
    echo $string;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?