How to create Multidimensional Arrays?

[apssiva]

hi

i got all data in single array. How i can store the data in multidimensional array?

below my 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']."<br>";
          $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("course" => "'".$rows['COURSE_TITLE_LONG']."'" , "Grade" => "'".$rows['CRSE_GRADE_OFF']. "'" , "Unit" => "'".$rows['UNT_EARNED']."'");
              }
              $ser = serialize($data);
              print $ser;
              echo "<br>";
          }
        }
 
 

i got this output, kindly help to make multidimensional array

a:3:{s:6:"course";s:24:"'Personal Effectiveness'";s:5:"Grade";s:3:"'S'";s:4:"Unit";s:3:"'3'";}
a:3:{s:6:"course";s:16:"'Basic Numeracy'";s:5:"Grade";s:3:"'U'";s:4:"Unit";s:3:"'2'";}
a:3:{s:6:"course";s:23:"'Piping & Valve System'";s:5:"Grade";s:3:"'D'";s:4:"Unit";s:3:"'6'";}
a:3:{s:6:"course";s:24:"'Mechanical Fabrication'";s:5:"Grade";s:3:"'F'";s:4:"Unit";s:3:"'6'";}
 

[dgreenhouse]

You normally serialize the data to insert into a database but you can use the serialized data to transmit over a network.

What do want the multidimensional array structure to look like?

PHP's multidimensional arrays are easy...

$array[0][0]
...
$array[10][10]

$array[0]['name']
$array[0]['address']
$array[0]['phone']
...
$array[10]['name']
$array[10]['address']
$array[10]['phone']

$ser_index = 0;
 
while($row = mysql_fetch_array($result))
        {
         // echo $row['nric']."<br>";
          $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("course" => "'".$rows['COURSE_TITLE_LONG']."'" , "Grade" => "'".$rows['CRSE_GRADE_OFF']. "'" , "Unit" => "'".$rows['UNT_EARNED']."'");
              }
              $ser[$ser_index++] = serialize($data);
          }
        }
print_r($ser);
 

[apssiva]

Hi,

I retrieve data in the DB. I create a array and make it serialize. Below code was retrieve data each line in one array. but i want all lines in one array or array of array.

for ex:
array(array(course,grade,unit),array(course,grade, unit),.......)

if get in array use count()-> retrieve the data easy.

while($rows = mysql_fetch_array($res))
          {
              for($i=0;$i<$norows;$i++){
              $data = array("course" => "'".$rows['COURSE_TITLE_LONG']."'" , "Grade" => "'".$rows['CRSE_GRADE_OFF']. "'" , "Unit" => "'".$rows['UNT_EARNED']."'");
              }
              $ser = serialize($data);
              print $ser;
              echo "<br>";
          }
 

If i store the data line by line array(course,grade,unit) in the database, can't retrieve all the data at a time. kindly help.... i am trying to solve this problem more than three days..... still can't please help... (because i am new for php)

retrieve code

    require_once('../../includes/common.php');
    $m = array();
 
    $r = '';
        $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_r (count($data));
                   $val = unserialize($data);
                 foreach($val as $key => $va){
                 print $va;
                 }
 
      }
 
 

output:

English,A,3