admin管理员组

文章数量:1395329

I have a custom database table, location( id, country, city, latitude, longtitude )

2 page : country.php(display all countries) and country detail.php (display cities for each country in the dropdown) that my code in the pic work perfectly

But I want to display latitude and longtitude for city selected option in the field text

<select name="state" id="address" class="form-control">
Global $wpdb;
$code = get_query_var('country');
$result = $wpdb->get_results ( "SELECT city, latitude FROM location 
WHERE country = '$code'");

foreach($result as $row) {
$city=$row->city;
?>
 <option value="<?php echo $city; ?>"><?php echo $city; ?</option>
<?php
}
?>
</select>

本文标签： theme developmentFetch data from database with dropdown selected option

版权声明：本文标题：theme development - Fetch data from database with dropdown selected option 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744575087a2613573.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。