Menu
Community /Pin to ProfileBookmark
@NogDogApr 02.2019 — #Assuming I'm understanding what you want to do, I might do a query that gets everything, then loop through the results to populate an array structured to give you the various categories.
You could then extract the sub-arrays you want from that
run another query on mysqli_fetch_assoc array ONLY on first array
Hi I’m working menu page for a restaurant and in the process of fetching data from MySQL database to display on page.
The problem I’m having is that there is 3 Main Categories, being Traditional Favourites, Starters, and Mains
ONLY Within Traditional Favourites and are 3 SubCategories, being Dosa, Steamed Rice Cakes & Breads
Traditional Favourites as Heading
Dosa, Steamed Rice Cakes & Breads as Sub Headings
under each Sub Heading should be dish titles and price
Below is what I’ve created so far:
[code]
$connect = mysqli_connect($hostname, $username, $password);
mysqli_select_db($connect, $database_name);
if ($connect) {
$queryCatTitle = “SELECT lookupTblMenuItem_Category.lookupTblMenuItem_Category_CategoryTitle FROM lookupTblMenuItem_Category WHERE lookupTblMenuItem_Category.lookupTblMenuItem_Category_CategoryTitle = ‘Traditional Favourites'”;
$runSql = mysqli_query($connect, $queryCatTitle);
if($runSql) {
if (mysqli_num_rows($runSql) > 0) {
while ($resultCatTitle = mysqli_fetch_assoc($runSql)) {
print_r($resultCatTitle);
}
}
}
} else {
die(“Connection could not be established: ” . mysqli_connect_error());
}
?>
being a newbie to PHP MySQL I’m not even sure is this is correct but having tested it it displays Array ( [lookupTblMenuItem_Category_CategoryTitle] => Traditional Favourites ) on the page so I know I’m half way there.
Could someone please possible provide me with a pointer, ideas, or even a solution?
Many thanks
__(Added `[code]…[/code]
Sign in
to post a comment18 Comments(s) ↴
0
@NogDogApr 02.2019 — #Assuming I'm understanding what you want to do, I might do a query that gets everything, then loop through the results to populate an array structured to give you the various categories.<i>
</i>$sql = "
SELECT
each,
field,
you,
want,
including,
lookupTblMenuItem_Category_CategoryTitle
FROM lookupTblMenuItem_Category
";
$result = mysqli_query($connect, $sql);
$menu = array();
while($row = mysqli_fetch_assoc($result)) {
switch($row['lookupTblMenuItem_Category_CategoryTitle']) {
case 'Dosa':
case 'Steamed Rice Cakes':
case 'Breads':
$menu['Traditional Favorites'][$row['lookupTblMenuItem_Category_CategoryTitle']] = $row;
break;
default:
$menu[$row['lookupTblMenuItem_Category_CategoryTitle']] = $row;
}
}
// See what the array looks like now:
echo "<pre>menu:n".print_r($menu,1)."</pre>";
You could then extract the sub-arrays you want from that
$menu