Right way to fetch and display massive php variables via html

Question

When we are supposed to fetch some 200 database entries using php and display them in the page using html, what is the best way to do so. Right now i am doing like this<?php echo $variable1?;>,,,,<?php echo $variable200;?> and feel like its bit slow to load. Any alternative please?

model:

$query_str = "select *from table where sl_no='$report_id' and code='$code'";
$row=$query->row_array();
    return $row;

controller:

$reports=$this->patient_model->fetch_previous_reports($pat_lab_id);
    echo json_encode($reports);

Use Foreach -- php.net/manual/en/control-structures.foreach.php to loop through the array values, so you have $var[0] ... $var[199] as an array of organised data — Mm-Art-In
– Mm-Art-In, Commented Feb 24, 2016 at 13:04

Community · Accepted Answer · 2017-05-23 11:59:26Z

0

You can fetch all the variables and store it in a array. Refer to this question, How to store row/column of mysql data in array, on how to store MySQL values in array.

More information on array: http://www.w3schools.com/php/php_arrays.asp.

Then, echo all the values stored in the array:

foreach ($array as $item) {
    echo $item . '<br/>';
}

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Feb 24, 2016 at 13:09

Panda

6,8846 gold badges46 silver badges61 bronze badges

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

2 Comments

Maxim Colesnic Over a year ago

echo implode('<br>', $array);

Panda Over a year ago

@MaximColesnic Yup, missed out line break, thanks :)

Collectives™ on Stack Overflow

Right way to fetch and display massive php variables via html

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related