如何使用mysql将id的所有列值回显到行中

Question

I am on the way to create a webform for education related activity. My mysql table looks like this

+----+--------+---------+-----------+---------+-----------------------------
| id |schlname| trname  | pay  |oa |gross|trname2|pay2|oa2|gross2| -----etc
+----+--------+---------+-----------+---------+-----------------------------
|  1 |Greatedn|  Bredier| 1000 | 25|1025|Pastiur |1000| 25|1025  |
   2 |Meritedn|  Paskin | 1000 | 25|1025|Blazer  |1000| 25|1025  |
+----+--------+---------+-----------+---------+----------------------------

I need to take report using php query using echo statement. My expected report should be like this

+----+--------+---------+-----------+-------
| id |schlname| trname  | pay  | oa |gross |
+----+--------+---------+-----------+-------
|  1 |Greatedn|  Bredier| 1000 | 25 |1025  |
                 Pastiur |1000 | 25 |1025  |
                 etc...
                 etc...
   2 |Meritedn|  Paskin | 1000 | 25 |1025  |
                 Blazer |1000  | 25 |1025  |
                 etc...
                 etc..

Your valuable ideas are expected to complete my study

Answer 1

This is untested, but I'd go somewhere along these lines, maybe a double for loop if you want to make it look pretty

        require "conn.php";
        $sql = $dbh->prepare("SELECT * FROM yourtablename WHERE 1");
        $sql->execute();
        $data_storage = $sql->fetch_all();
        for($i = 0; $i < $data_storage->rowCount(); $i++) {
            echo $data_storage[$i];
        }

Let me know if this answers your question. Not quite sure if this is what you're asking for.