PHP MySQL数据库 - 所有行都进入多维数组

Question

It's been a long while since I touched PHP so, I just need a refresher of sorts.

I have an HTML form that captures several lines of data (dataA, dataB, dataC & dataD) and inserts them into a database table (dataAll). I will be entering rows upon rows of data into "dataAll". What I'm looking to do is create a display.php page, where the code will take all of the data and place each cell into an array, or the row of an array, for example:

new Array = [["dataA", "dataA", "dataA", "dataA", "dataA"],
             ["dataB", "dataB", "dataB", "dataB", "dataB"],
             ["dataC", "dataC", "dataC", "dataC", "dataC"],
             ["dataD", "dataD", "dataD", "dataD", "dataD"]];

But I cannot remember the syntax on how to perform this task. Any help would be greatly appreciated.

The database is named 'compdata', the table is 'dataAll', and each row is 'dataA', 'dataB', 'dataC', 'dataD'.

Please let me know if I need to supply more information.

Answer 1

Since you asked for All rows, so the simple code for query is written below:

<?php
     //after connection to mysql db using mysql_connect()
     $sql = "Select dataA, dataB, dataC, dataD from `compdata`.`dataAll`" ;
     $result = mysql_query($sql) ;
     if(mysql_num_rows($result) > 0 ){
            while($row = mysql_fetch_array($result)){
                  $dataArray[] = $row ;
            }
    } 
   echo '<pre>';
   print_r($dataArray) ;//you got the desired 2D array with all results
?>