Building 2 levels navigation from database using While()












0















I'm trying to build a navigation bar using pages stocked in a database. Nothing difficult for the first level but it gets trickier when pages have to be listed as children of a same parent. here's my code :



$dropdown = array(); 
while ($pages = mysqli_fetch_assoc($rq_page)) {
$url_pg = url_rewrite('page-' . $pages["id"] . '-' . $pages["intitule"] . '');

// Creating a dropdown button
if($pages["dropdown"] == "oui" && $pages["parent"] == 0) {
echo '<li class="nav-item dropdown">';
echo '<a class="nav-link dropdown-toggle" data-toggle="dropdown" id="Preview" href="#" role="button" aria-haspopup="true" aria-expanded="false">';
echo $pages["intitule"];
echo '</a>';
echo '<div class="dropdown-menu" aria-labelledby="Preview">';
foreach($dropdown as $variable) {
echo '<a class="dropdown-item" href="#">' . $variable . '</a>';
}
echo '</div>';
echo '</li>';
}
// If single page = no dropdown
else if($pages["dropdown"] == "non" && $pages["parent"] == 0) {
echo '<li class="nav-item">';
echo '<a class="nav-link" href="' . $url_pg . '">' . $pages["intitule"] . '</a>';
echo '</li>';
}
// If content is a dropdown item
else {
$dropdown = '"' . $pages["parent"] . '" => "' . $pages["intitule"] . '"';
}
}


So. First I get the databse content. Then I create an array() to list every content that has a $pages["parent"] equals the mother's ID. The while() deals with the 3 types of content : single page, dropdown page and items of the dropdown button.



i tried many PHP methods. The first level appears properly but the $dropdown array remains empty when used into the while() loop. When printed outside of the while(), it show the content I passed through the else { }



Can you see something wrong in this code and what would be the best way to create the navigation ? Let me know if I can provide more information.
Thanks for your help.










share|improve this question























  • How is the data organized? It looks like your approach should work as long as the "dropdown button" comes after the dropdown items.

    – Joni
    Nov 19 '18 at 19:21











  • Here's the request : "SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent" id = INT, intitule = VARCHAR, parent = INT, dropdown = VARCHAR What do you mean a bout placing the button after the item , I used the Bootstrap 4 structure.

    – Greg
    Nov 19 '18 at 19:27


















0















I'm trying to build a navigation bar using pages stocked in a database. Nothing difficult for the first level but it gets trickier when pages have to be listed as children of a same parent. here's my code :



$dropdown = array(); 
while ($pages = mysqli_fetch_assoc($rq_page)) {
$url_pg = url_rewrite('page-' . $pages["id"] . '-' . $pages["intitule"] . '');

// Creating a dropdown button
if($pages["dropdown"] == "oui" && $pages["parent"] == 0) {
echo '<li class="nav-item dropdown">';
echo '<a class="nav-link dropdown-toggle" data-toggle="dropdown" id="Preview" href="#" role="button" aria-haspopup="true" aria-expanded="false">';
echo $pages["intitule"];
echo '</a>';
echo '<div class="dropdown-menu" aria-labelledby="Preview">';
foreach($dropdown as $variable) {
echo '<a class="dropdown-item" href="#">' . $variable . '</a>';
}
echo '</div>';
echo '</li>';
}
// If single page = no dropdown
else if($pages["dropdown"] == "non" && $pages["parent"] == 0) {
echo '<li class="nav-item">';
echo '<a class="nav-link" href="' . $url_pg . '">' . $pages["intitule"] . '</a>';
echo '</li>';
}
// If content is a dropdown item
else {
$dropdown = '"' . $pages["parent"] . '" => "' . $pages["intitule"] . '"';
}
}


So. First I get the databse content. Then I create an array() to list every content that has a $pages["parent"] equals the mother's ID. The while() deals with the 3 types of content : single page, dropdown page and items of the dropdown button.



i tried many PHP methods. The first level appears properly but the $dropdown array remains empty when used into the while() loop. When printed outside of the while(), it show the content I passed through the else { }



Can you see something wrong in this code and what would be the best way to create the navigation ? Let me know if I can provide more information.
Thanks for your help.










share|improve this question























  • How is the data organized? It looks like your approach should work as long as the "dropdown button" comes after the dropdown items.

    – Joni
    Nov 19 '18 at 19:21











  • Here's the request : "SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent" id = INT, intitule = VARCHAR, parent = INT, dropdown = VARCHAR What do you mean a bout placing the button after the item , I used the Bootstrap 4 structure.

    – Greg
    Nov 19 '18 at 19:27
















0












0








0








I'm trying to build a navigation bar using pages stocked in a database. Nothing difficult for the first level but it gets trickier when pages have to be listed as children of a same parent. here's my code :



$dropdown = array(); 
while ($pages = mysqli_fetch_assoc($rq_page)) {
$url_pg = url_rewrite('page-' . $pages["id"] . '-' . $pages["intitule"] . '');

// Creating a dropdown button
if($pages["dropdown"] == "oui" && $pages["parent"] == 0) {
echo '<li class="nav-item dropdown">';
echo '<a class="nav-link dropdown-toggle" data-toggle="dropdown" id="Preview" href="#" role="button" aria-haspopup="true" aria-expanded="false">';
echo $pages["intitule"];
echo '</a>';
echo '<div class="dropdown-menu" aria-labelledby="Preview">';
foreach($dropdown as $variable) {
echo '<a class="dropdown-item" href="#">' . $variable . '</a>';
}
echo '</div>';
echo '</li>';
}
// If single page = no dropdown
else if($pages["dropdown"] == "non" && $pages["parent"] == 0) {
echo '<li class="nav-item">';
echo '<a class="nav-link" href="' . $url_pg . '">' . $pages["intitule"] . '</a>';
echo '</li>';
}
// If content is a dropdown item
else {
$dropdown = '"' . $pages["parent"] . '" => "' . $pages["intitule"] . '"';
}
}


So. First I get the databse content. Then I create an array() to list every content that has a $pages["parent"] equals the mother's ID. The while() deals with the 3 types of content : single page, dropdown page and items of the dropdown button.



i tried many PHP methods. The first level appears properly but the $dropdown array remains empty when used into the while() loop. When printed outside of the while(), it show the content I passed through the else { }



Can you see something wrong in this code and what would be the best way to create the navigation ? Let me know if I can provide more information.
Thanks for your help.










share|improve this question














I'm trying to build a navigation bar using pages stocked in a database. Nothing difficult for the first level but it gets trickier when pages have to be listed as children of a same parent. here's my code :



$dropdown = array(); 
while ($pages = mysqli_fetch_assoc($rq_page)) {
$url_pg = url_rewrite('page-' . $pages["id"] . '-' . $pages["intitule"] . '');

// Creating a dropdown button
if($pages["dropdown"] == "oui" && $pages["parent"] == 0) {
echo '<li class="nav-item dropdown">';
echo '<a class="nav-link dropdown-toggle" data-toggle="dropdown" id="Preview" href="#" role="button" aria-haspopup="true" aria-expanded="false">';
echo $pages["intitule"];
echo '</a>';
echo '<div class="dropdown-menu" aria-labelledby="Preview">';
foreach($dropdown as $variable) {
echo '<a class="dropdown-item" href="#">' . $variable . '</a>';
}
echo '</div>';
echo '</li>';
}
// If single page = no dropdown
else if($pages["dropdown"] == "non" && $pages["parent"] == 0) {
echo '<li class="nav-item">';
echo '<a class="nav-link" href="' . $url_pg . '">' . $pages["intitule"] . '</a>';
echo '</li>';
}
// If content is a dropdown item
else {
$dropdown = '"' . $pages["parent"] . '" => "' . $pages["intitule"] . '"';
}
}


So. First I get the databse content. Then I create an array() to list every content that has a $pages["parent"] equals the mother's ID. The while() deals with the 3 types of content : single page, dropdown page and items of the dropdown button.



i tried many PHP methods. The first level appears properly but the $dropdown array remains empty when used into the while() loop. When printed outside of the while(), it show the content I passed through the else { }



Can you see something wrong in this code and what would be the best way to create the navigation ? Let me know if I can provide more information.
Thanks for your help.







php bootstrap-4






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 19 '18 at 19:12









GregGreg

217




217













  • How is the data organized? It looks like your approach should work as long as the "dropdown button" comes after the dropdown items.

    – Joni
    Nov 19 '18 at 19:21











  • Here's the request : "SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent" id = INT, intitule = VARCHAR, parent = INT, dropdown = VARCHAR What do you mean a bout placing the button after the item , I used the Bootstrap 4 structure.

    – Greg
    Nov 19 '18 at 19:27





















  • How is the data organized? It looks like your approach should work as long as the "dropdown button" comes after the dropdown items.

    – Joni
    Nov 19 '18 at 19:21











  • Here's the request : "SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent" id = INT, intitule = VARCHAR, parent = INT, dropdown = VARCHAR What do you mean a bout placing the button after the item , I used the Bootstrap 4 structure.

    – Greg
    Nov 19 '18 at 19:27



















How is the data organized? It looks like your approach should work as long as the "dropdown button" comes after the dropdown items.

– Joni
Nov 19 '18 at 19:21





How is the data organized? It looks like your approach should work as long as the "dropdown button" comes after the dropdown items.

– Joni
Nov 19 '18 at 19:21













Here's the request : "SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent" id = INT, intitule = VARCHAR, parent = INT, dropdown = VARCHAR What do you mean a bout placing the button after the item , I used the Bootstrap 4 structure.

– Greg
Nov 19 '18 at 19:27







Here's the request : "SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent" id = INT, intitule = VARCHAR, parent = INT, dropdown = VARCHAR What do you mean a bout placing the button after the item , I used the Bootstrap 4 structure.

– Greg
Nov 19 '18 at 19:27














1 Answer
1






active

oldest

votes


















0














Your code doesn't work because when it finds a page that has $pages["dropdown"] == "oui", the $dropdown array is always empty.



The reason why it's always empty is because your query returns dropdown "item" pages last, after all of the dropdown "button" pages. If you add var_dump($dropdown) into a few strategic places in the loop you'll see it for yourself.



A quick hacky fix is changing the ordering of your query, so that the dropdown "items" (with parent>0) are returned first:



SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent DESC


This will make every dropdown "button" include every dropdown "item," including the ones that are not related. The sort order will need further modifications to make your current approach work the way you expect.






share|improve this answer
























  • I figured it could be a problem of request order but no matter how I turn it upside down, the result is the same : $dropdown is empty everytime is in the loop. Unfortunately I need its result in the loop.

    – Greg
    Nov 19 '18 at 20:57











  • It seems to be working now. It wasn't just a matter of order, I also made a mistake when using the array(). It needed the keys to be declared $var[3]

    – Greg
    Nov 19 '18 at 21:32











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
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381156%2fbuilding-2-levels-navigation-from-database-using-while%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














Your code doesn't work because when it finds a page that has $pages["dropdown"] == "oui", the $dropdown array is always empty.



The reason why it's always empty is because your query returns dropdown "item" pages last, after all of the dropdown "button" pages. If you add var_dump($dropdown) into a few strategic places in the loop you'll see it for yourself.



A quick hacky fix is changing the ordering of your query, so that the dropdown "items" (with parent>0) are returned first:



SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent DESC


This will make every dropdown "button" include every dropdown "item," including the ones that are not related. The sort order will need further modifications to make your current approach work the way you expect.






share|improve this answer
























  • I figured it could be a problem of request order but no matter how I turn it upside down, the result is the same : $dropdown is empty everytime is in the loop. Unfortunately I need its result in the loop.

    – Greg
    Nov 19 '18 at 20:57











  • It seems to be working now. It wasn't just a matter of order, I also made a mistake when using the array(). It needed the keys to be declared $var[3]

    – Greg
    Nov 19 '18 at 21:32
















0














Your code doesn't work because when it finds a page that has $pages["dropdown"] == "oui", the $dropdown array is always empty.



The reason why it's always empty is because your query returns dropdown "item" pages last, after all of the dropdown "button" pages. If you add var_dump($dropdown) into a few strategic places in the loop you'll see it for yourself.



A quick hacky fix is changing the ordering of your query, so that the dropdown "items" (with parent>0) are returned first:



SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent DESC


This will make every dropdown "button" include every dropdown "item," including the ones that are not related. The sort order will need further modifications to make your current approach work the way you expect.






share|improve this answer
























  • I figured it could be a problem of request order but no matter how I turn it upside down, the result is the same : $dropdown is empty everytime is in the loop. Unfortunately I need its result in the loop.

    – Greg
    Nov 19 '18 at 20:57











  • It seems to be working now. It wasn't just a matter of order, I also made a mistake when using the array(). It needed the keys to be declared $var[3]

    – Greg
    Nov 19 '18 at 21:32














0












0








0







Your code doesn't work because when it finds a page that has $pages["dropdown"] == "oui", the $dropdown array is always empty.



The reason why it's always empty is because your query returns dropdown "item" pages last, after all of the dropdown "button" pages. If you add var_dump($dropdown) into a few strategic places in the loop you'll see it for yourself.



A quick hacky fix is changing the ordering of your query, so that the dropdown "items" (with parent>0) are returned first:



SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent DESC


This will make every dropdown "button" include every dropdown "item," including the ones that are not related. The sort order will need further modifications to make your current approach work the way you expect.






share|improve this answer













Your code doesn't work because when it finds a page that has $pages["dropdown"] == "oui", the $dropdown array is always empty.



The reason why it's always empty is because your query returns dropdown "item" pages last, after all of the dropdown "button" pages. If you add var_dump($dropdown) into a few strategic places in the loop you'll see it for yourself.



A quick hacky fix is changing the ordering of your query, so that the dropdown "items" (with parent>0) are returned first:



SELECT id, intitule, parent, dropdown FROM db_page ORDER BY parent DESC


This will make every dropdown "button" include every dropdown "item," including the ones that are not related. The sort order will need further modifications to make your current approach work the way you expect.







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 19 '18 at 20:08









JoniJoni

76.8k997151




76.8k997151













  • I figured it could be a problem of request order but no matter how I turn it upside down, the result is the same : $dropdown is empty everytime is in the loop. Unfortunately I need its result in the loop.

    – Greg
    Nov 19 '18 at 20:57











  • It seems to be working now. It wasn't just a matter of order, I also made a mistake when using the array(). It needed the keys to be declared $var[3]

    – Greg
    Nov 19 '18 at 21:32



















  • I figured it could be a problem of request order but no matter how I turn it upside down, the result is the same : $dropdown is empty everytime is in the loop. Unfortunately I need its result in the loop.

    – Greg
    Nov 19 '18 at 20:57











  • It seems to be working now. It wasn't just a matter of order, I also made a mistake when using the array(). It needed the keys to be declared $var[3]

    – Greg
    Nov 19 '18 at 21:32

















I figured it could be a problem of request order but no matter how I turn it upside down, the result is the same : $dropdown is empty everytime is in the loop. Unfortunately I need its result in the loop.

– Greg
Nov 19 '18 at 20:57





I figured it could be a problem of request order but no matter how I turn it upside down, the result is the same : $dropdown is empty everytime is in the loop. Unfortunately I need its result in the loop.

– Greg
Nov 19 '18 at 20:57













It seems to be working now. It wasn't just a matter of order, I also made a mistake when using the array(). It needed the keys to be declared $var[3]

– Greg
Nov 19 '18 at 21:32





It seems to be working now. It wasn't just a matter of order, I also made a mistake when using the array(). It needed the keys to be declared $var[3]

– Greg
Nov 19 '18 at 21:32




















draft saved

draft discarded




















































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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381156%2fbuilding-2-levels-navigation-from-database-using-while%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

Guess what letter conforming each word

Port of Spain

Run scheduled task as local user group (not BUILTIN)