php - inserting android data in mysql -

php - inserting android data in mysql -

php code: when insert info sql database itc come this. can tell me why info not inserting in database. in database insert 0000-00-00 (for date) , 00:00:00.0000 (for time). can please help me out

<?php session_start(); $btnselectdate=$_post['btnselectdate']; $btnselecttime=$_post['btnselecttime']; $db = 'event'; $conn=mysql_connect("localhost", "root", "") or die("not connected"); mysql_select_db($db, $conn) or die("could not find database"); $query = "insert date_time(btnselecttime, btnselectdate) values('$btnselecttime', '$btnselectdate')"; $result = mysql_query($query) or die("unable verify user because : " . mysql_error()); if(mysql_num_rows($result)) echo 1; // right login response else echo 0; // wrong login response ?>

here android code:

public class mainactivity extends activity { button btnselectdate,btnselecttime,done; static final int date_dialog_id = 0; static final int time_dialog_id=1; // variables save user selected date , time public int year,month,day,hour,minute; // declare variables show/set date , time when time , date picker dialog first appears private int myear, mmonth, mday,mhour,mminute; // constructor public mainactivity() { // assign current date , time values variables final calendar c = calendar.getinstance(); myear = c.get(calendar.year); mmonth = c.get(calendar.month); mday = c.get(calendar.day_of_month); mhour = c.get(calendar.hour_of_day); mminute = c.get(calendar.minute); } @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); // references of buttons btnselectdate=(button)findviewbyid(r.id.buttonselectdate); btnselecttime=(button)findviewbyid(r.id.buttonselecttime); done = (button)findviewbyid(r.id.button1); // set clicklistener on btnselectdate btnselectdate.setonclicklistener(new view.onclicklistener() { public void onclick(view v) { // show datepickerdialog showdialog(date_dialog_id); } }); // set clicklistener on btnselecttime btnselecttime.setonclicklistener(new view.onclicklistener() { public void onclick(view v) { // show timepickerdialog showdialog(time_dialog_id); }}); done.setonclicklistener(new view.onclicklistener() { @override public void onclick(view v) { // todo auto-generated method stub new postdataasynctask().execute(); }});} public class postdataasynctask extends asynctask<string, string, string> { @override protected string doinbackground(string... params) { // todo auto-generated method stub string resresult=null; seek { resresult = posttext(); } grab (nullpointerexception e) { e.printstacktrace(); } grab (exception e) { e.printstacktrace(); } homecoming resresult; } @override protected void onpostexecute(string result) { // todo auto-generated method stub toast.maketext(getapplicationcontext(), result, toast.length_long).show(); } } private string posttext(){ string responsestr=null; try{ string postreceiverurl = "http://10.0.2.2:8080/a/insert4.php"; httpclient client = new defaulthttpclient(); httppost post = new httppost(postreceiverurl); multipartentitybuilder entitybuilder = multipartentitybuilder.create(); entitybuilder.setmode(httpmultipartmode.browser_compatible); entitybuilder.addtextbody("btnselectdate", btnselectdate.gettext().tostring()); entitybuilder.addtextbody("btnselecttime", btnselecttime.gettext().tostring()); httpentity entity = entitybuilder.build(); post.setentity(entity); httpresponse response = client.execute(post); httpentity resentity = response.getentity(); if (resentity != null) { responsestr = entityutils.tostring(resentity).trim(); //log.v(tag, "response: " + responsestr); } } grab (clientprotocolexception e) { e.printstacktrace(); } grab (ioexception e) { e.printstacktrace(); } homecoming responsestr; } // register datepickerdialog listener private datepickerdialog.ondatesetlistener mdatesetlistener = new datepickerdialog.ondatesetlistener() { // callback received when user "sets" date in datepickerdialog public void ondateset(datepicker view, int yearselected, int monthofyear, int dayofmonth) { year = yearselected; month = monthofyear; day = dayofmonth; // set selected date in select date button btnselectdate.settext("date selected : "+day+"-"+month+"-"+year); }}; // register timepickerdialog listener private timepickerdialog.ontimesetlistener mtimesetlistener = new timepickerdialog.ontimesetlistener() { // callback received when user "sets" timepickerdialog in dialog public void ontimeset(timepicker view, int hourofday, int min) { hr = hourofday; min = min; // set selected date in select date button btnselecttime.settext("time selected :"+hour+"-"+minute); }}; // method automatically gets called when phone call showdialog() method @override protected dialog oncreatedialog(int id) { switch (id) { case date_dialog_id: // create new datepickerdialog values want show homecoming new datepickerdialog(this,mdatesetlistener,myear, mmonth, mday); // create new timepickerdialog values want show case time_dialog_id: homecoming new timepickerdialog(this, mtimesetlistener, mhour, mminute, false);}return null;}}

php android mysql