mysql BLOB manipulate in php

Question

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.

That looks like JSON data. Why not just parse it with the various JSON functions? — tadman
– tadman, Commented Jun 6, 2017 at 3:58

Bhavin Thummar · Accepted Answer · 2017-06-06 04:55:55Z

1

<?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;

answered Jun 6, 2017 at 4:55

Bhavin Thummar

1,3011 gold badge14 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql BLOB manipulate in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related