Kuwasilisha Matokeo Kutoka kwa Hifadhidata katika PHP

Tayari unajua jinsi ya kupata data kutoka kwa hifadhidata. Hebu sasa tuwasilishe data hizo, tukiziweka katika vitambulisho.

Kwa mfano, rekodi za jedwali letu la majaribio users tutazwasilisha kwa mfumo ufuatao:

<p>
	<b>user1</b>
	<b>23</b>
	<b>400</b>
</p>
<p>
	<b>user2</b>
	<b>24</b>
	<b>500</b>
</p>
<p>
	<b>user3</b>
	<b>25</b>
	<b>600</b>
</p>

Kuanza, hebu tupate safu ya rekodi kutoka kwa hifadhidata yetu:

<?php
	$query = "SELECT * FROM users";
	$result = mysqli_query($link, $query) or die(mysqli_error($link));
	for ($data = []; $row = mysqli_fetch_assoc($result); $data[] = $row);
?>

Hebu sasa tuwasilishe data za safu yetu kwa muonekano ulioandaliwa:

<?php
	$result = '';
	
	foreach ($data as $elem) {
		$result .= '<p>';
		
		$result .= '<b>' . $elem['name'] . '</b>';
		$result .= '<b>' . $elem['age'] . '</b>';
		$result .= '<b>' . $elem['salary'] . '</b>';
		
		$result .= '</p>';
	}
	
	echo $result;
?>

Inaweza kuandikwa upya kwa mfumo ufuatao:

<?php foreach ($data as $elem): ?>
	<p>
		<b><?= $elem['name'] ?></b>
		<b><?= $elem['age'] ?></b>
		<b><?= $elem['salary'] ?></b>
	</p>
<?php endforeach; ?>

Wasilisha rekodi za jedwali letu kwa mfumo ufuatao:

<div>
	<h2>user1</h2>
	<p>
		23 miaka, <b>400$</b>
	</p>
</div>
<div>
	<h2>user2</h2>
	<p>
		24 miaka, <b>500$</b>
	</p>
</div>
<div>
	<h2>user3</h2>
	<p>
		25 miaka, <b>600$</b>
	</p>
</div>

Wasilisha rekodi za jedwali letu kwa mfumo ufuatao:

<table>
	<tr>
		<th>id</th>
		<th>name</th>
		<th>age</th>
		<th>salary</th>
	</tr>
	<tr>
		<td>1</td>
		<td>user1</td>
		<td>23</td>
		<td>400</td>
	</tr>
	<tr>
		<td>2</td>
		<td>user2</td>
		<td>25</td>
		<td>500</td>
	</tr>
	<tr>
		<td>3</td>
		<td>user3</td>
		<td>23</td>
		<td>500</td>
	</tr>
</table>

Wasilisha rekodi za jedwali letu kwa mfumo ufuatao:

<ul>
	<li>user1</li>
	<li>user2</li>
	<li>user3</li>
</ul>