Foreach statement with MySQL select query in PHP
Here i have given a example for better understand...
<?php
class myclass{
public function fetchCat(){
$sql = "select c.cat_id,cat_name,product_name,price from categories as c left join products as p on p.cat_id=c.cat_id";
$result = $this->query($sql);
$Finarray = array();
while($rows = mysql_fetch_assoc($result)){
$Finarray[] = $rows;
}
return $Finarray;
}
}
$cat = $obj->fetchCat();
?>
<table border="1">
<tr>
<td>Category Id</td>
<td>Product Name</td>
<td>Product Price</td>
<td>Category Name</td>
</tr>
<?php foreach($cat as $_cat): ?>
<tr>
<td><?php echo $_cat['cat_id']; ?></td>
<td><?php echo $_cat['product_name']; ?></td>
<td>
<?php if(!$_cat['price']): ?>
<?php else: ?>
<?php echo $_cat['price']; ?>
<?php endif; ?>
</td>
<td><?php echo $_cat['cat_name']; ?></td>
</tr>
<?php endforeach; ?>
</table>
