Menu
Community /Pin to ProfileBookmark
@NogDogMay 21.2019 — #You need to put quotes around
I would agree that, if feasible, I'd look into doing it with one query, leveraging table joins and/or sub-queries, and possibly some aggregate functions with a
If this is for that menu application I think I recall, then it's probably not a big deal, as we're talking about a pretty small data set. That being said, I _might_ consider implementing something that runs in the background to populate some data store (a JSON file, perhaps?) with the menu data structured the way you want to process it, since in theory it should only change occasionally. That way you could, perhaps, have the admin side of the application that allows you to add/update/delete menu items and categories to regenerate that file upon any successful change. Then when you want to display the menu, just
using foreach variable in sql query
aim: display the dish category title and then the dishes under/ foreach category title
this is what I’ve done so far well at least a snippet:
[code]
–> foreach ($assocarrsubcattitle_descript as $title => $descript) {
if ($descript != NULL) {
?>
<div class=”row”>
<div class=”col-xs-12″>
<p class=”titleSubCatg_title”>
<?php echo $title; ?>
</p>
<div>
<div class=”row”>
<div class=”col-xs-12″>
<p class=”titleSubCatg_title”>
<?php echo $descript; ?>
</p>
</div>
</div>
</div>
<?php
–> $querySubCatgDishTitle_DishPrice = “SELECT DishTitle, DishPrice FROM MainTblMenuItem INNER JOIN SubCategory ON FK_MenuItemSubCategoryId = PK_MenuItemSubCategoryId WHERE SubCategoryTitle = $title”;
$runSql2_qry1 = mysqli_query($connect, $querySubCatgDishTitle_DishPrice);
if ($runSql2_qry1) {
if (mysqli_num_rows($runSql2_qry1) > 0) {
while ($assocarrSubCatgDishTitles_MainDishPrices = mysqli_fetch_assoc($runSql2_qry1)) {
?>
I’ve used –> to indicate the loop variable and the –> to indicate it the query
How would one use the loop variable $title in the where clause of another query?
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogMay 21.2019 — #You need to put quotes around '$title'I would agree that, if feasible, I'd look into doing it with one query, leveraging table joins and/or sub-queries, and possibly some aggregate functions with a
group by0
@NogDogMay 22.2019 — #>@nsath#1603905 I know its not good practice and all
If this is for that menu application I think I recall, then it's probably not a big deal, as we're talking about a pretty small data set. That being said, I _might_ consider implementing something that runs in the background to populate some data store (a JSON file, perhaps?) with the menu data structured the way you want to process it, since in theory it should only change occasionally. That way you could, perhaps, have the admin side of the application that allows you to add/update/delete menu items and categories to regenerate that file upon any successful change. Then when you want to display the menu, just
file_get_contents()json_decode()