php mysql query to fetch field names and its data into a table in one run

Question

I have tried to prepare a data table where any list query is passed its results would be sown in a table.

I have used 2 if conditions and foreach loop. Now i have doubt that this is would slow down if bulk records are fetched.. Can anyone suggest me much better way to do this..

Query as follows

 echo "<table width='100%' align='center' border=1 style='text-align:center; vertical-align:center; border-collapse:collapse; font-size:80%' class='main'>";
    $i=0;
    while($row=mysqli_fetch_array($result)){
      echo "<tr>";
        foreach($row as $rowvalues => $cellvalues){
            if (!is_numeric($rowvalues)){
               if($i==0){ 
                    echo "<th>".$rowvalues."</th>"; // For Table header
               }else{
                    echo "<td>".$cellvalues."</td>"; // For field values
               }
            }
        }
      echo "</tr>"; 
      $i++;
    }
    echo "</table>";

Michael D. · Accepted Answer · 2013-11-09 18:31:29Z

1

maybe this is a bit faster? (reduce the amount of echos)

$output = "<table width='100%' align='center' border=1 style='text-align:center; vertical-align:center; border-collapse:collapse; font-size:80%' class='main'>";
    $i=0;
    while($row=mysqli_fetch_array($result)){
      $output .= "<tr>";
        foreach($row as $rowvalues => $cellvalues){

            if (!is_numeric($rowvalues)){       
                $output .= ($i == 0) ? "<th>".$rowvalues."</th>" : "<td>".$cellvalues."</td>";              
            }
        }
      $output .= "</tr>"; 
      $i++;
    }
    echo $output."</table>";

answered Nov 9, 2013 at 18:31

Michael D.

1,8372 gold badges19 silver badges26 bronze badges

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

3 Comments

Jimson Jose Over a year ago

Thanks Michale, I welcome your attempt. and i have tried it but i didn't see major difference. still i feel code can be tweaked.

Michael D. Over a year ago

I don't see any more potential. If speed really matters you should use Perl instead of PHP.

Michael D. Over a year ago

you can decouple html generation from db fetching, MVC frameworks are getting db data from the model. the view is rendering the data to html ...

Nick John Bueno · Accepted Answer · 2013-11-09 18:14:18Z

0

Create a php pagination to avoid slowing down of fetching records in your database.

answered Nov 9, 2013 at 18:14

Nick John Bueno

1111 gold badge2 silver badges9 bronze badges

1 Comment

Jimson Jose Over a year ago

Yes that i have already done; but still i feel that some my code can be adjusted in a better way.

Collectives™ on Stack Overflow

php mysql query to fetch field names and its data into a table in one run

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related