05-25-2011 10:33 PM
I have this php code to parse SQL Database into JSON String :
<?php mysql_connect("localhost","root",""); mysql_select_db("db"); $q=mysql_query("SELECT * FROM product WHERE brandID='".$_REQUEST['brand']."' AND genderID='".$_REQUEST['gender']."' AND categoryID='".$_REQUEST['category']."'"); while($e=mysql_fetch_assoc($q)) $output=$e; print(json_encode($output)); mysql_close(); ?>
Anybody know how to parsing parameter "brand", "gender", and "category" from BB app?
And how to get the JSON string from that php result so that I can process the data?
05-26-2011 04:03 AM
And you will have to issue an HTTP query to get the php script running. Something like the httpDemo sample which should be included in your tooling, will help you create this.