业余爱好者试图修复SQL中的下拉菜单

Question

我正试图帮助一位朋友建立一个网站。我通常不使用PHP，jquery。

下拉列表有4个级别。第一级得4分。这4个点有自己的子级别，每个级别都不同。

我正试图找到它们，然后直接从数据库中将它们显示在下拉列表中。

我被困在第二层，这个错误

注意：正在尝试获取…中非对象的属性"subcategore"。。。。。

到目前为止我所做的：

<?php   $categorii = $wpdb->get_results("SELECT DISTINCT categorie FROM catalog_rural");

?>

<?php

$subcategorie = $wpdb->get_results("SELECT DISTINCT subcategorie FROM catalog_rural WHERE categorie = 'Afaceri'");

?>


<div class="container">    

<?php          
foreach($categorii as $categorie) {

?>


<ul>
<li>

<a <?php if(isset($_GET['categorie']) && $categorie->categorie==$_GET['categorie']){ echo "btn-success";}else{ echo "btn-info";};?> href="<?php site_url(); ?>catalog-rural/?categorie=<?php echo urlencode($categorie->categorie); ?>"> <i class="fa fa-caret-down"></i>
<?php echo $categorie->categorie  ; ?> </a>

<ul class="">
<li>                  <a href="<?php echo site_url(); ?>/catalog-rural/?categorie=<?php echo urlencode($_GET['categorie']); ?>&subcategorie=<?php echo $subcategorie->subcategorie; ?>"  class="list-group-item <?php if($subcategorie->subcategorie==$_GET['subcategorie']){ echo "active";};?> "><?php echo $subcategorie->subcategorie; ?> </a>

</li>

</ul>

</li>


</ul>     

</a>

Answer 1

Hi您需要像对$categorii那样对$subcategorie执行foreach循环。因为您得到的是数组，而不是像$categorii那样的对象。在这里，我将其设置为li，因为它似乎是最好的。

<?php
$categorii = $wpdb->get_results("SELECT DISTINCT categorie FROM catalog_rural");
?>
<?php
$subcategories = $wpdb->get_results("SELECT DISTINCT subcategorie FROM catalog_rural WHERE categorie = 'Afaceri'");
?>

<div class="container">
<?php          
foreach( $categorii as $categorie ) {
?>
<ul>
<li>
<a
<?php
#### What are these? Are they classnames? ####
if( isset( $_GET['categorie'] ) && $categorie->categorie==$_GET['categorie'] ){
echo "btn-success";
}else{ 
echo "btn-info";
};
?> href="<?php site_url(); ?>catalog-rural/?categorie=<?php echo urlencode( $categorie->categorie ); ?>">
<i class="fa fa-caret-down"></i>
<?php echo $categorie->categorie; ?>
</a>

<ul class="">
<?php foreach( $subcategories as $subcategorie ) { ?>
<li>

<a href="<?php echo site_url(); ?>/catalog-rural/?categorie=<?php echo urlencode( $_GET['categorie'] ); ?>&subcategorie=<?php echo $subcategorie->subcategorie; ?>"  class="list-group-item <?php if($subcategorie->subcategorie==$_GET['subcategorie']){ echo "active";};?> ">
<?php echo $subcategorie->subcategorie; ?>
</a>
</li>
<?php } ?>
</ul>
</li>
</ul>

Answer 2

不是用来解决错误" Trying to get property 'subcategorie' of non-object"~的，只是为了说明无效标记。如果你使用正确的代码缩进，你可能已经能够发现这一点！

<?php
$categorii = $wpdb->get_results("SELECT DISTINCT categorie FROM catalog_rural");
?>
<?php
$subcategorie = $wpdb->get_results("SELECT DISTINCT subcategorie FROM catalog_rural WHERE categorie = 'Afaceri'");
?>

<div class="container">
<?php          
foreach( $categorii as $categorie ) {
?>
<ul>
<li>
<a
<?php
#### What are these? Are they classnames? ####
if( isset( $_GET['categorie'] ) && $categorie->categorie==$_GET['categorie'] ){
echo "btn-success";
}else{ 
echo "btn-info";
};
?> href="<?php site_url(); ?>catalog-rural/?categorie=<?php echo urlencode( $categorie->categorie ); ?>">
<i class="fa fa-caret-down"></i>
<?php echo $categorie->categorie; ?>
</a>

<ul class="">

<!-- ### Where is the opening LI? ### -->

<a href="<?php echo site_url(); ?>/catalog-rural/?categorie=<?php echo urlencode( $_GET['categorie'] ); ?>&subcategorie=<?php echo $subcategorie->subcategorie; ?>"  class="list-group-item <?php if($subcategorie->subcategorie==$_GET['subcategorie']){ echo "active";};?> ">
<?php echo $subcategorie->subcategorie; ?>
</a>
</li>
</ul>
</li>
</ul>
</a><!-- ### what is this closing? ### -->