Mixing
PHP MySQLi - Display Product Based On Product Category
I have around 5 meal category, for example 'M01' ('M' stands for Meal), 'B01' ('B' stands for Baverages) and so on. In every category page on front end, instead of showing everything in 1 page, I want to sort the product based on its category, for example in Baverages page, there will be a list of baverages under 'B01' category code. How can I achieve that with PHP and MySQLi? Sorry for the simple code, I'm still new to this. Thanks in advance!
Here's my code:
<table class="table-list">
<tbody id="mealTable">
<?php
$result=mysqli_query($conn,"SELECT * FROM meal");
$row_count = mysqli_num_rows($result);
if ($row_count == 0) { ?>
<tr>
<td colspan = "6">
<?php echo "No data found"; ?>
</td>
</tr>
<?php } else {
while($row = mysqli_fetch_array($result)) { ?>
<tr>
<td><?php echo $row['meal_name']?></td>
<td>RM <?php echo $row['meal_price']?></td>
<td ><a href="addtocart.php?mid=<?php echo $row['meal_id']; ?>" style="background-color: green; color: white; padding: 10px 10px; text-align: center; text-decoration: none; display: inline-block;font-size: 14px; width: 70px; height: 13px; ">Add To Cart</a>
</td>
</tr>
<?php } }
?>
</div>
This is the List of Meal page on Admin side
This is the database table for Meal Category
This is the database table for Meal
php mysqli
asked Nov 21 '18 at 19:38
znf96znf96
3618
add a comment |
I have around 5 meal category, for example 'M01' ('M' stands for Meal), 'B01' ('B' stands for Baverages) and so on. In every category page on front end, instead of showing everything in 1 page, I want to sort the product based on its category, for example in Baverages page, there will be a list of baverages under 'B01' category code. How can I achieve that with PHP and MySQLi? Sorry for the simple code, I'm still new to this. Thanks in advance!
Here's my code:
<table class="table-list">
<tbody id="mealTable">
<?php
$result=mysqli_query($conn,"SELECT * FROM meal");
$row_count = mysqli_num_rows($result);
if ($row_count == 0) { ?>
<tr>
<td colspan = "6">
<?php echo "No data found"; ?>
</td>
</tr>
<?php } else {
while($row = mysqli_fetch_array($result)) { ?>
<tr>
<td><?php echo $row['meal_name']?></td>
<td>RM <?php echo $row['meal_price']?></td>
<td ><a href="addtocart.php?mid=<?php echo $row['meal_id']; ?>" style="background-color: green; color: white; padding: 10px 10px; text-align: center; text-decoration: none; display: inline-block;font-size: 14px; width: 70px; height: 13px; ">Add To Cart</a>
</td>
</tr>
<?php } }
?>
</div>
This is the List of Meal page on Admin side
This is the database table for Meal Category
This is the database table for Meal
php mysqli
asked Nov 21 '18 at 19:38
znf96znf96
3618
What have you tried so far? Where are you stuck?
– Nico Haase
Nov 21 '18 at 19:54
The code above is displaying all types of meal in 1 page. I have no idea how to separate them in different pages by using category.
– znf96
Nov 21 '18 at 19:56
Have you tried adding aWHEREto your query and use URL parameters?
– Nico Haase
Nov 21 '18 at 19:57
add a comment |
I have around 5 meal category, for example 'M01' ('M' stands for Meal), 'B01' ('B' stands for Baverages) and so on. In every category page on front end, instead of showing everything in 1 page, I want to sort the product based on its category, for example in Baverages page, there will be a list of baverages under 'B01' category code. How can I achieve that with PHP and MySQLi? Sorry for the simple code, I'm still new to this. Thanks in advance!
Here's my code:
<table class="table-list">
<tbody id="mealTable">
<?php
$result=mysqli_query($conn,"SELECT * FROM meal");
$row_count = mysqli_num_rows($result);
if ($row_count == 0) { ?>
<tr>
<td colspan = "6">
<?php echo "No data found"; ?>
</td>
</tr>
<?php } else {
while($row = mysqli_fetch_array($result)) { ?>
<tr>
<td><?php echo $row['meal_name']?></td>
<td>RM <?php echo $row['meal_price']?></td>
<td ><a href="addtocart.php?mid=<?php echo $row['meal_id']; ?>" style="background-color: green; color: white; padding: 10px 10px; text-align: center; text-decoration: none; display: inline-block;font-size: 14px; width: 70px; height: 13px; ">Add To Cart</a>
</td>
</tr>
<?php } }
?>
</div>
This is the List of Meal page on Admin side
This is the database table for Meal Category
This is the database table for Meal
php mysqli
asked Nov 21 '18 at 19:38
znf96znf96
3618
I have around 5 meal category, for example 'M01' ('M' stands for Meal), 'B01' ('B' stands for Baverages) and so on. In every category page on front end, instead of showing everything in 1 page, I want to sort the product based on its category, for example in Baverages page, there will be a list of baverages under 'B01' category code. How can I achieve that with PHP and MySQLi? Sorry for the simple code, I'm still new to this. Thanks in advance!
Here's my code:
<table class="table-list">
<tbody id="mealTable">
<?php
$result=mysqli_query($conn,"SELECT * FROM meal");
$row_count = mysqli_num_rows($result);
if ($row_count == 0) { ?>
<tr>
<td colspan = "6">
<?php echo "No data found"; ?>
</td>
</tr>
<?php } else {
while($row = mysqli_fetch_array($result)) { ?>
<tr>
<td><?php echo $row['meal_name']?></td>
<td>RM <?php echo $row['meal_price']?></td>
<td ><a href="addtocart.php?mid=<?php echo $row['meal_id']; ?>" style="background-color: green; color: white; padding: 10px 10px; text-align: center; text-decoration: none; display: inline-block;font-size: 14px; width: 70px; height: 13px; ">Add To Cart</a>
</td>
</tr>
<?php } }
?>
</div>
This is the List of Meal page on Admin side
This is the database table for Meal Category
This is the database table for Meal
php mysqli
php mysqli
asked Nov 21 '18 at 19:38
znf96znf96
3618
asked Nov 21 '18 at 19:38
znf96znf96
3618
asked Nov 21 '18 at 19:38
znf96znf96
3618
asked Nov 21 '18 at 19:38
znf96znf96
3618
asked Nov 21 '18 at 19:38
znf96znf96
3618
3618
What have you tried so far? Where are you stuck?
– Nico Haase
Nov 21 '18 at 19:54
The code above is displaying all types of meal in 1 page. I have no idea how to separate them in different pages by using category.
– znf96
Nov 21 '18 at 19:56
Have you tried adding aWHEREto your query and use URL parameters?
– Nico Haase
Nov 21 '18 at 19:57
add a comment |
What have you tried so far? Where are you stuck?
– Nico Haase
Nov 21 '18 at 19:54
The code above is displaying all types of meal in 1 page. I have no idea how to separate them in different pages by using category.
– znf96
Nov 21 '18 at 19:56
Have you tried adding aWHEREto your query and use URL parameters?
– Nico Haase
Nov 21 '18 at 19:57
What have you tried so far? Where are you stuck?
– Nico Haase
Nov 21 '18 at 19:54
What have you tried so far? Where are you stuck?
– Nico Haase
Nov 21 '18 at 19:54
The code above is displaying all types of meal in 1 page. I have no idea how to separate them in different pages by using category.
– znf96
Nov 21 '18 at 19:56
The code above is displaying all types of meal in 1 page. I have no idea how to separate them in different pages by using category.
– znf96
Nov 21 '18 at 19:56
Have you tried adding a
WHERE to your query and use URL parameters?– Nico Haase
Nov 21 '18 at 19:57
Have you tried adding a
WHERE to your query and use URL parameters?– Nico Haase
Nov 21 '18 at 19:57
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53419407%2fphp-mysqli-display-product-based-on-product-category%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53419407%2fphp-mysqli-display-product-based-on-product-category%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What have you tried so far? Where are you stuck?
– Nico Haase
Nov 21 '18 at 19:54
The code above is displaying all types of meal in 1 page. I have no idea how to separate them in different pages by using category.
– znf96
Nov 21 '18 at 19:56
Have you tried adding a
WHEREto your query and use URL parameters?– Nico Haase
Nov 21 '18 at 19:57