Make a multidimensional array in PHP from mysql result

Question

I have query result like this

Query result Table:

I need to display this data to html table view like

HTMLTable:

So how should i convert this result array variable in to such PHP array variable so i can loop that array variable and display the result according to attached html Table view

Please help. Thanks.

For starters: php.net/manual/en/pdostatement.fetchall.php , php.net/manual/en/mysqli-result.fetch-assoc.php — Andrew Nolan
– Andrew Nolan, Commented Jul 21, 2017 at 5:33

devman · Accepted Answer · 2017-07-21 06:26:45Z

1

One way is you can use mysql_fetch_assoc() function in a loop like this :

// The array which will store all questions
$questions = array();

while ($row = mysqli_fetch_assoc($result)) {

   // Put in the array questions an array per question using mysql fieldsnames

   // if a question with main_question_id=2 exists 
   if (!isset($questions[$row['main_question_id'])) {

      //build your question and put it in your array
      $questions[$row['main_question_id']] = array(
         'question_num' => $row['main_question_number'],
         'description' => $row['descritption'],
         'obtained_mark' => $row['obtained_mark'],
         // etc ...
      );
   }
}

// Displays description for question 2 for example :
echo $questions[2]['description'];

Then you can build your html (were also doable during first loop)

// Builds head of html table
$html = '<table><tr><th>Question Number</th><th>Desc.</th><th>Mark</th></tr>';

// Builds html content table with another loop
foreach ($questions as $question){
    $html .= '<tr>';
    $html .= '<td>'.$question["main_number_question"].'</td>';
    $html .= '<td>'.$question["description"].'</td>';
    $html .= '<td>'.$question["obtained_mark"].'</td>';
    $html .= '</tr>';
}

// build the bottom of table
$html .= '</table>;


// Displays all table
echo $html;

Dont forget to check doc and comments behind her here : http://php.net/mysqli_fetch_assoc

You can also use http://php.net/mysqli_fetch_array

Cheers,

edited Jul 21, 2017 at 6:26

answered Jul 21, 2017 at 6:19

devman

313 bronze badges

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

1 Comment

N.S Over a year ago

Thanks for the reply bro but i already have fetched result in to a PHP array variable but i need to store these rows in to multi dimensional array like **main_question > sub_question > child_question **

Collectives™ on Stack Overflow

Make a multidimensional array in PHP from mysql result

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related