mySQLi查询将结果放入数组和不同的DIV中

Question

I want to query the content of multiple (6 in total, IDs 1 to 6) IDs from a mySQL database using mySQLi. After that I want to put the result ("introtext") in different DIVs. At the moment I use the following code (works perfect):

<?php
$q = $db->query("SELECT introtext FROM content WHERE id=1");
$r = $q->fetch_object();
?>
<div id="content1" class="toggle"><?php echo "$r->introtext";?></div>

<?php
$q = $db->query("SELECT introtext FROM content WHERE id=2");
$r = $q->fetch_object();
?>
<div id="content2" class="toggle"><?php echo "$r->introtext";?></div>

<?php
$q = $db->query("SELECT introtext FROM content WHERE id=3");
$r = $q->fetch_object();
?>
<div id="content3" class="toggle"><?php echo "$r->introtext";?></div>

And so on...

How can I optimize this code to query mySQL only once (put the results in array) and assign the different results into the different DIVs?

Cheers Shredder

Answer 1

Good question
Basically you will need 2 loops
one to get your array with data:

<?php
$data = array();
$res = $db->query("SELECT id, introtext FROM content ORDER BY id LIMIT 6");
while($row = $res->fetch_assoc()) {
    $data[$row['id']] = $row['introtext'];
}
?>

You can use whatever SQL to filter out your queries. ORDER BY id LIMIT 6 seems most convenient for the present case "get first 6 ids", as consecutiveness is never guaranteed.

And then another loop to display

<? foreach ($data as $id => $introtext): ?>
<div id="content<?=$id?>" class="toggle"><?=htmlspecialchars($introtext?)></div>
<? endforeach ?>

By the way, if use not raw Mysqli API but some helper library the PHP part will be reduced to one line:

<?php
$data = $db->getIndCol("id","SELECT id, introtext FROM content ORDER BY id LIMIT 6");
?>