phpjquerymysqlajaxosclass

In osclass, how display cities only with ads?


How can I display regions and their cities only with ads? And why I can't see numbers of ads? I would like use jQuery but I don't know how.

<?php
              $aRegions = Region::newInstance()->getByCountry('AT');
              if(count($aRegions) > 0 ) { ?>
                <ul>
              <?php
                foreach($aRegions as $region) {
                //print_r ($region);
                echo "<li>";
                 //$region['pk_i_id'].
                ?>
                <div class="accordionButton">
                 <a href="javascript:void()">
                  <?php echo $region['s_name']."\n"; ?>
                 </a>
                 <?php // echo "</em>(". $region['items'].")</em>";?>
                 </div>
                  <?php
                  $aCities = City::newInstance()-> getByRegion($region['pk_i_id']);
                  if(count($aCities) > 0 ) { 
                  echo "<div class=\"accordionContent\">";
                  echo "<ul>";
                      foreach($aCities as $city)  { 
                    //  print_r ($city);
                                                //$city["pk_i_id"].'
                        echo "<li>";
                        echo  "<a href='". osc_search_url( array( 'sRegion'=>$region["s_name"], 'sCity' => $city['s_name']  ) ) ."'> ";
                        echo $city["s_name"]."\n";
                        echo "</em>(". $city['items'].")</em>";
                        echo "</a>";
                        echo "</li>";
                        }
                      }
                       echo "</ul>";
                 echo "</li>";
                  } ?>
            </ul>
            <?php
              }
            ?>

Solution

  • The solution for regions > cities is:

    $locations = array();
    if(osc_count_list_cities() > 0 ) {
    
        while(osc_has_list_cities() ) { 
            $city_id = osc_list_city_id();
            $city = City::newInstance()->findByPrimaryKey($city_id);
            $region_id = $city['fk_i_region_id'];
            $locations[$region_id][$city_id] = array("cityurl"=>osc_list_city_url(), "cityname"=>osc_list_city_name(), "cityitems"=>osc_list_city_items());
        }
        echo '<ul>';
        while(osc_has_list_regions() ) {  
            $region_id = osc_list_region_id();
            echo '<li><a href="' . osc_list_region_url() . '">' . osc_list_region_name() . '<em>(' . osc_list_region_items() . ')</em></a>' ;
            echo '<ul>';
            foreach($locations[$region_id] as $acity) {
                echo '<li><a href="' . $acity['cityurl'] . '">' . $acity['cityname'] . '<em>(' . $acity['cityitems'] . ')</em></a></li>' ;
            }
            echo '</ul></li><br/>';
    
        }
        echo '</ul>';
    
    }