javascript - Selecting all the 'id' and 'app_img_path' from the mysql database -


i working on app want select id , image path database limit result mysql_fetch_assoc($running) array( [id] => 1 [app_img_path] => images/1_subway_surfers.jpg) want select id(1 - 10) , image path not 1 please how do that. code html

<div id="andriod_menu">             <div id="categories">                 <ul id='cat_con'>                     <li id="arc" data-app="arc_app" data-db-table="arcade_apps_andriod"><div id="arc_txt">arcade                     <img src="images/ajax-loader (5).gif" id="loader_ard" value="ard">                     </div></li>                     <li id="spo" data-app="spo_app" data-db-table="sports_apps_andriod"><div id="spo_txt">sports                     <img src="images/ajax-loader (5).gif" id="loader_ard" value="spo">                     </div></li>                     <li id="act" data-app="act_app" data-db-table="action_apps_andriod"><div id="act_txt">action                     <img src="images/ajax-loader (5).gif" id="loader_ard" value="act">                     </div></li>                     <li id="adv" data-app="adv_app" data-db-table="adventure_apps_andriod"><div id="adv_txt">adventure                     <img src="images/ajax-loader (5).gif" id="loader_ard" value="adv">                     </div></li>                     <li id="sim" data-app="sim_app" data-db-table="simulation_apps_andriod"><div id="sim_txt">simulation                     <img src="images/ajax-loader (5).gif" id="loader_ard" value="sim">                     </div></li>                     <!--<li id="spo"><div id="spo_txt">sports</div></li>-->                     <li id="rac" data-app="rac_app" data-db-table="racing_apps_andriod"><div id="rac_txt">racing                     <img src="images/ajax-loader (5).gif" id="loader_ard" value="rac">                     </div></li>                 </ul>             </div>

javascript

function li_categories()         {             //list of              $('div>#loader_ard').hide();             var cat_arr=             [             'arc',             'spo',             'act',             'adv',             'sim',             'rac'             ];               jquery.each(cat_arr, function() {                 //$('button[value="' + + "]')               $('#' + ).click(function()                 {                     $(this).find('#loader_ard').show();                     cat_clicked=$(this).data('app');// returns data object...                     db_selected=$(this).data('db-table');                       //if cat_click data matches data on db list of data                     // db..                      $.ajax(                     {                         url:"pages/func.php",                         type: "post",                         datatype: "json",                         cache: false,                         data: {clicked:cat_clicked,db_selected:db_selected}                      });                   });             });             }          li_categories();

php

function cat_clicked() {  if (isset($_post['clicked']) && isset($_post['db_selected'])) {     $clicked=$_post['clicked'];     $db_selected=$_post['db_selected'];      include('db_con.php');     // go data base based on db categories , fecth app data..     $sqlbaba="select `id`,`app_img_path` `$db_selected`";      $run=mysql_query($sqlbaba) or die(mysql_error());      if ($running=mysql_query($sqlbaba)) {          $ss=mysql_fetch_assoc($running);         print_r($ss);      }    }    } cat_clicked();

your function mysql_fetch_assoc fetches one row.

to iterate rows use this:

while ($ss=mysql_fetch_assoc($running)) {     print_r($ss); }

attention: current php code has serious security problems. should use mysqli-interface or pdo.

this because of 

$db_selected=$_post['db_selected']; $sqlbaba="select `id`,`app_img_path` `$db_selected`";

so if modify $_post['db_selected']; evil mysql_information; drop table $db_selected can destroy application.


Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more