How to display MySQL table data which is stored as an array?

I would like to replace those arrays with real values. Is it possible?

I am assuming you want to access and print those two variables which is shown as “Array” in the print out (contact, question_answers_array)

Solution as follows – replace your foreach look with below (I didn’t test code but should give you an idea):

foreach($response_data as $key=> $value){
    if($key=='contact'){
        echo 'contact array:<br>';
        $value = unserialize($value); //turn serialized string into array
        print_r($value)."<br>"; //prints out the array all at once for debug
        //if you want to loop through
        foreach($value as $contactKey=>$contactValue){
                echo $contactKey."<br>";
                echo $contactValue['label']."<br>";
                echo $contactValue['value']."<br>";
                echo $contactValue['use']."<br>";
        }
    }elseif($key=='question_answers_array'){
        echo 'question_answers_array:<br>';
        $value = unserialize($value);
        print_r($value)."<br>"; 
        //if you want to loop through
        foreach($value as $qKey=>$qValue){
                echo $qKey."<br>";
                echo $qValue['0']."<br>";
                echo $qValue['1']."<br>";
                echo $qValue['2']."<br>";
                echo $qValue['3']."<br>";
                echo $qValue['correct']."<br>";
                //so on....
        }
    }else{
        echo $value."<br>";
    }
}

Give it a try; may have to fix some syntax / code issues.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)