android - How to fire query from the result of another query in php -

android - How to fire query from the result of another query in php -

so basically, have piece of furniture type, piece of furniture color, piece of furniture size, piece of furniture cost , piece of furniture material. have combo box showing various possible values choose. in combo boxex, have entered value named "all" incase user dont want filter in particular way. want search piece of furniture on basis of input user.

but due value named "all", facing lots of problems. need fire query result of previous query, can maintain conditions in php file , if value other "all" query should execute.

please help me..

search_furniture.java file

public class search_furniture extends activity { spinner type,color,cost,size,material; string atype, acolor, acost, asize, amaterial; button search; list<string> l2; jsonparser jsonparser = new jsonparser(); progressdialog pdialog; private static final string loginurl = "http://realroom.byethost24.com/realroom/search.php"; private static final string success = "success"; private static final string message = "message"; arrayadapter<string> adp2; int pos; sessionmanager session; @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.search_furniture); session = new sessionmanager(getapplicationcontext()); type = (spinner) findviewbyid(r.id.fur_type); cost = (spinner) findviewbyid(r.id.price); color = (spinner) findviewbyid(r.id.fur_color); size = (spinner) findviewbyid(r.id.fur_size); search = (button) findviewbyid(r.id.search); material = (spinner) findviewbyid(r.id.fur_mat); type.setonitemselectedlistener(new onitemselectedlistener() { @override public void onitemselected(adapterview<?> arg0, view arg1,int arg2, long arg3) { // todo auto-generated method stub pos=arg2; add(); } private void add() { // todo auto-generated method stub switch(pos) { case 0: l2= new arraylist<string>(); l2.add("all"); adp2=new arrayadapter<string>(search_furniture.this,r.layout.spinner_item ,l2); adp2.setdropdownviewresource(android.r.layout.simple_dropdown_item_1line); size.setadapter(adp2); break; case 1: l2= new arraylist<string>(); l2.add("all"); l2.add("2-sit"); l2.add("3-sit"); l2.add("l-shape"); l2.add("sofa+chair"); adp2=new arrayadapter<string>(search_furniture.this,r.layout.spinner_item ,l2); adp2.setdropdownviewresource(android.r.layout.simple_dropdown_item_1line); size.setadapter(adp2); // select(); break; case 2: l2= new arraylist<string>(); l2.add("all"); l2.add("2*2"); l2.add("3*3"); l2.add("4*4"); adp2=new arrayadapter<string>(search_furniture.this,r.layout.spinner_item,l2); adp2.setdropdownviewresource(android.r.layout.simple_dropdown_item_1line); size.setadapter(adp2); // select(); break; case 3: l2= new arraylist<string>(); l2.add("all"); adp2=new arrayadapter<string>(search_furniture.this,r.layout.spinner_item,l2); adp2.setdropdownviewresource(android.r.layout.simple_dropdown_item_1line); size.setadapter(adp2); // select(); break; case 4: l2= new arraylist<string>(); l2.add("all"); l2.add("jumbo"); l2.add("king size"); l2.add("double bed"); l2.add("single bed"); adp2=new arrayadapter<string>(search_furniture.this,r.layout.spinner_item,l2); adp2.setdropdownviewresource(android.r.layout.simple_dropdown_item_1line); size.setadapter(adp2); // select(); break; case 5: l2= new arraylist<string>(); l2.add("all"); l2.add("single"); l2.add("double"); adp2=new arrayadapter<string>(search_furniture.this,r.layout.spinner_item,l2); adp2.setdropdownviewresource(android.r.layout.simple_dropdown_item_1line); size.setadapter(adp2); // select(); break; case 6: l2= new arraylist<string>(); l2.add("all"); l2.add("4-sitter"); l2.add("6-sitter"); l2.add("8-sitter"); l2.add("10-sitter"); adp2=new arrayadapter<string>(search_furniture.this,r.layout.spinner_item,l2); adp2.setdropdownviewresource(android.r.layout.simple_dropdown_item_1line); size.setadapter(adp2); // select(); break; } } @override public void onnothingselected(adapterview<?> arg0) { // todo auto-generated method stub } }); search.setonclicklistener(new button.onclicklistener() { @override public void onclick(view v) { // todo auto-generated method stub new search().execute(); // intent = new intent(search_furniture.this,items.class); // startactivity(i); } }); } /* (non-javadoc) * @see android.app.activity#oncreateoptionsmenu(android.view.menu) */ @override public boolean oncreateoptionsmenu(menu menu) { // todo auto-generated method stub super.oncreateoptionsmenu(menu); menuinflater blowup = getmenuinflater(); blowup.inflate(r.menu.menu, menu); homecoming true; } /* (non-javadoc) * @see android.app.activity#onoptionsitemselected(android.view.menuitem) */ @override public boolean onoptionsitemselected(menuitem item) { // todo auto-generated method stub intent i; switch(item.getitemid()) { case r.id.checkout: = new intent(search_furniture.this, mycart.class); startactivity(i); break; case r.id.aboutus: = new intent(search_furniture.this,aboutus.class); startactivity(i); break; case r.id.profile: = new intent(search_furniture.this,profile.class); startactivity(i); break; case r.id.help: = new intent(search_furniture.this,help.class); startactivity(i); break; case r.id.logout: session.logoutuser(); break; } homecoming false; } class search extends asynctask<string, string, string> { @override protected void onpreexecute() { super.onpreexecute(); pdialog=new progressdialog(search_furniture.this); pdialog.setmessage("customizing furniture"); pdialog.setindeterminate(false); pdialog.setcancelable(true); pdialog.show(); } @override protected string doinbackground(string... params) { string atype = type.getselecteditem().tostring(); string acost = cost.getselecteditem().tostring(); string acolor = color.getselecteditem().tostring(); string asize = size.getselecteditem().tostring(); string amaterial = material.getselecteditem().tostring(); seek { list<namevaluepair> para = new arraylist<namevaluepair>(); para.add(new basicnamevaluepair("f_type", atype)); para.add(new basicnamevaluepair("f_cost", acost)); para.add(new basicnamevaluepair("f_color", acolor)); para.add(new basicnamevaluepair("f_size", asize)); para.add(new basicnamevaluepair("f_material", amaterial)); system.out.println(atype); system.out.println(acost); system.out.println(acolor); system.out.println(asize); system.out.println(amaterial); log.d("request!", "starting"); jsonobject json = jsonparser.makehttprequest(loginurl, "post", para); log.d("create response", json.tostring()); int res = json.getint(success); if (res == 1) { intent =new intent(search_furniture.this, furniture.class); startactivity(i); // log.d("user created!", json.tostring()); finish(); homecoming json.getstring(message); } } grab (jsonexception e) { e.printstacktrace(); } homecoming null; } @override protected void onpostexecute(string file_url) { pdialog.dismiss(); } } }

how write php query in mysql above facility..??

or there other way can provide facility in app..??

php android mysql