php - Unable to retrieve serialized data from database -

php - Unable to retrieve serialized data from database -

i'm able update using serialize info database not able retrieve properly. echoing array when seek unserialize , retrieve database.

here how update using serialize:

$query ="update dashboard_widget_users set dashboard_widget_users.configuration='".serialize($tmp)."' dashboard_widget_users.dsnr_yw_user =12 , dashboard_widget_users.dsnr_dashboard_widget=1";

result:

a:4:{i:0;s:30:""anzahl_fahrzeuge_ohne_bilder"";i:1;s:22:""fahrzeuge_ohne_preis"";i:2;s:23:""fahrzeuge_mit_fehlern"";i:3;s:19:""herausforderungen"";}

this how tried unserialize() , retrieve database not getting output properly:

$config= unserialize($row['configuration']); echo $config['configuration'];

here code:

if($param['aktion'] == 'save-widget-vehicle') { $page['register-fahrzeuge'] = array( 1 => array( 'fahrzeug','aktiv',$page['script'],''), 0 => array( 'edit-fahrzeug','enabled',$page['script'],'',''), ); $opts = !empty($param['filteropts']) ? $param['filteropts'] : array(); $tmp = array(); foreach ($opts $opt) { $tmp[] = '"'.$opt.'"'; } $data = array(); $query ="update dashboard_widget_users w set w.configuration=\"".mysql_real_escape_string(serialize($tmp))."\" w.dsnr_yw_user =12 , w.dsnr_dashboard_widget=1"; $result = mysql_query($query, $myconnection); $html = '<table width="538" cellspacing="0" cellpadding="0" border="0"> <tr> <td> <div>'.createregister($page['register-news']).'</div> '.createmessage().' <div class="cont-liste-verlauf register"> <table id="fahrzeuge"> <tr> <td> </td> </tr> </table> </div> </td> </tr> </table>'; $return = array( 'status' => 1, 'html' => $html ); echo json_encode($return); die(); $param['aktion'] = 'get-widget-vehicle'; } if($param['aktion'] == 'get-widget-vehicle') { $page['register-fahrzeuge'] = array( 1 => array( 'fahrzeug','aktiv',$page['script'],''), 0 => array( 'edit-fahrzeug','enabled',$page['script'],'',''), ); $data = array(); $opts = !empty($param['filteropts']) ? $param['filteropts'] : array(); $tmp = array(); foreach ($opts $opt) { $tmp[] = '"'.$opt.'"'; } $query ='select dashboard_widget_users.configuration dashboard_widget_users inner bring together yw_user on dashboard_widget_users.dsnr_yw_user = yw_user.intern inner bring together dashboard_widget on dashboard_widget_users.dsnr_dashboard_widget = dashboard_widget.id dashboard_widget_users.dsnr_yw_user =12 , dashboard_widget.id =1'; $result = mysql_query($query, $myconnection); /*while ($row = mysql_fetch_assoc($result)) { if($row['name'] == 'anzahl_fahrzeuge_mit_und_ohne_bilder') { $sql = 'select * amo_bilder_live l left bring together afzdaten on l.dsnr_afzdaten = a.dsnr l.dsnr_afzdaten null'; $sql_result=mysql_query($sql); //get result... // $row['number'] = $result } $data[] = $row; }*/ $html = '<table width="538" cellspacing="0" cellpadding="0" border="0" > <tr> <td> <div>'.createregister($page['register-fahrzeuge']).'</div> '.createmessage().' <div class="cont-liste-verlauf register"> '; while ($row = mysql_fetch_assoc($result)) { $config= unserialize($row['configuration']); //$config= $row['configuration']; $html .= '<table id="fahrzeuge"> <a href="amo_fahrzeuge.php"> '. $config .'</a> </table>'; } $html .= '</div> </td> </tr> </table>'; $return = array( 'status' => 1, 'html' => $html ); echo json_encode($return); die(); }

you escape string depending on going utilize mysqli_real_escape_string() on value before putting into database - not when retrieving database:

$row=mysqli_fetch_assoc($result); $config=unserialize($row['config']);

you've tagged jsonserializer - using php serialization here.

php mysql serialization