how to serialize() and unserialize()?

[apssiva]

Hi,

Kindly help, where i did the mistake?

serialize() code:

    require_once('../../includes/common.php');
 
        $m = array();
    $result = mysql_query("SELECT * from sgc where year = '2008'") or die(mysql_error());
 
    while($row = mysql_fetch_array($result))
        {
          //echo $row['nric'];
          $res =mysql_query("select COURSE_TITLE_LONG, CRSE_GRADE_OFF, UNT_EARNED, nric from ite where nric = '".$row['nric']."' AND STRM = '2008'")or die(mysql_error()); 
          $norows=mysql_num_rows($res);
          echo $norows."<br>";
 
          while($rows = mysql_fetch_array($res))
          {
              for($i=0;$i<$norows;$i++){
              $data = array("'".$rows['COURSE_TITLE_LONG']."','".$rows['CRSE_GRADE_OFF']."','".$rows['UNT_EARNED']."'");
              $serial = serialize($data);
              }
             print $serial;
 
          }
        }
 
 
 

output for serialize:

a:1:{i:0;s:30:"'Communication Skills','U','2'";}a:1:{i:0;s:32:"'Information Technology','U','1'";}a:1:{i:0;s:31:"'Piping & Valve System','F','6'";}a:1:{i:0;s:32:"'Mechanical Fabrication','F','6'";}a:1:{i:0;s:32:"'Personal Effectiveness','U','3'";}a:1:{i:0;s:29:"'Sports & Wellness I','U','1'";}a:1:{i:0;s:24:"'Basic Numeracy','U','2'";}a:1:{i:0;s:29:"'Machinery Servicing','F','5'";}a:1:{i:0;s:33:"'Hydraulics & Pneumatics','F','7'";}
 

unserialize() code:

    require_once('../../includes/common.php');
    $data = array();
    $r=1;
        $result = mysql_query("SELECT meta_ite from sgc where nric = 'S9405127D'") or die(mysql_error());
        $count = mysql_numrows($result);
 
    while($row = mysql_fetch_array($result))
       {
          $data = str_replace('""','"',$row['meta_ite']);
        //  print $data;
         $unser = unserialize($data);
          print_r ($unser);
 
}
 

[code green]

Please define the problem and re-phrase the question

[apssiva]

Hi,

I am tiring to unserialize() the data, but i got below output only one line

"Communication Skills","S","2"
 

in this unserialize() --- still have some data, its not display. pls check my previous post "serialize()" output.

kindly help me. below my code

    require_once('../../includes/common.php');
    $data = array();
    $r=1;
        $result = mysql_query("SELECT meta_ite from sgc where nric = 'S9405127D'") or die(mysql_error());
        $count = mysql_numrows($result);
 
    while($row = mysql_fetch_array($result))
       {
          $data = $row['meta_ite'];
        //  print $data;
         $unser = unserialize($data);
          print_r ($unser);
 
 
      }
 

[code green]

It is difficult to say where the problem is because you have no testing or error trapping.
A few if statements and echos will help pinpoint the problem

[apssiva]

sorry i don't know. can you give some idea? pls....