php - Android MYSQL Select * to Consctruct Java Object -


i trying retrieve data mysql database in android using following code:

... httpresponse response = httpclient.execute(httppost);                 bufferedreader in = new bufferedreader(                         new inputstreamreader(response.getentity()                                 .getcontent()));                 stringbuffer sb = new stringbuffer("");                 string line = "";                 while ((line = in.readline()) != null) {                     sb.append(line);                     break;                 }                 in.close();                 responsestring = sb.tostring();                 responsestring = responsestring.substring(0,                         responsestring.length() - 1);                 showmessage(responsestring);                 system.out.println(responsestring);                 // handle response                 user.orderlist.clear();                 string[] tmp1 = responsestring.split("\\|");                 (string s : tmp1) {                     string[] tmp2 = s.split(",");                     order tmp3 = new order();                     tmp3.orderid = tmp2[0];                     tmp3.placername = tmp2[1];                     tmp3.itemname = tmp2[2];                     tmp3.payment = tmp2[3];                     tmp3.locationstring = tmp2[4];                     user.orderlist.add(tmp3);                     system.out.println(tmp3.tostring());                 } ...

this gets response php file string , splits response based on , , | here php code returns data java code:

$sql = mysql_query("select * orders (location_lat between '".$_post['latmin']."' , '".$_post['latmax']."') , (location_long between '".$_post['longmin']."' , '".$_post['longmax']."')");         if($sql){             while($row = mysql_fetch_assoc($sql)) {  echo ($row['order_id'] . "," . $row['placer_name'] . "," . $row['item_name'] . "," . $row['payment_amount'] . "," . $row['location_string'] . "|");             }         } else{             echo 'failed. sql error occured.';         }

the issue reason getting 4 of values: placername, itemname, payment, locationstring. orderid not return anything.

database: enter image description here


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria...
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w...
Read more