Hey guys its my first post ...So i have a suggestion box for countries and i need to get the countries from SQL database..It only shows the last one ...
<?php mysql_connect("127.0.0.1", "root", "---") or die(mysql_error()); mysql_select_db("xxx") or die(mysql_error()); $data = mysql_query("SELECT * FROM countries") or die(mysql_error()); while($info = mysql_fetch_array( $data, MYSQL_ASSOC)) { ?>
$(document).ready(function() { var jsonData = []; var cities = '<?php echo $info['country'].","; } ?>'.split(','); for(var i=0;i<cities.length;i++) jsonData.push({id:i,name:cities[i],status:i%2?'':'Planned for visit',coolness:Math.floor(Math.random() * 10) + 1}); var ms1 = $('#ms1').magicSuggest({ data: jsonData, sortOrder: 'name', value: [0,1,2,3,4,5,6], groupBy: 'status', maxDropHeight: 2000, name: 'ms1'
SQL,PHP AND JAVASCRIPT
in JavaScript
Posted
Hey guys its my first post ...So i have a suggestion box for countries and i need to get the countries from SQL database..It only shows the last one ...
<?php mysql_connect("127.0.0.1", "root", "---") or die(mysql_error()); mysql_select_db("xxx") or die(mysql_error()); $data = mysql_query("SELECT * FROM countries") or die(mysql_error()); while($info = mysql_fetch_array( $data, MYSQL_ASSOC)) { ?>$(document).ready(function() { var jsonData = []; var cities = '<?php echo $info['country'].","; } ?>'.split(','); for(var i=0;i<cities.length;i++) jsonData.push({id:i,name:cities[i],status:i%2?'':'Planned for visit',coolness:Math.floor(Math.random() * 10) + 1}); var ms1 = $('#ms1').magicSuggest({ data: jsonData, sortOrder: 'name', value: [0,1,2,3,4,5,6], groupBy: 'status', maxDropHeight: 2000, name: 'ms1'THank you.