php - inserting info into an external database with android -


so have class register , wanna register user information external database reason won't insert, can please point out error if there or tell me whats missing?

this php file have uploaded web-host

<?php  $con = mysqli_connect("localhost","my_username","my_password","my_databas");//my_user, my_password, my_database  $bn = $_post["badgenumber"]; $name = $_post["name"]; $en = $_post["extensionnumber"]; $pn = $_post["phonenumber"]; $email = $_post["email"];  $statement = mysqli_prepare($con, "insert register (badgenumber, name, extensionnumber, phonenumber, email)     values (?, ?, ?, ?, ?)");  mysqli_stmt_bind_param($statement, "isiis", $bn, $name, $en, $pn, $email);   mysqli_stmt_execute($statement);  mysqli_stmt_close($statement);  mysqli_close($con); ?> 

this class connection , inserting happening , wrote domain name server address

public class serverrequests {  private static final string tag ="serverrequests";  progressdialog progressdialog; public static final int connection_timeout = 1000 * 15; public static final string server_address = "http://92211app.netne.net/";  public serverrequests(context context){     progressdialog =  new progressdialog(context);     progressdialog.setcancelable(false);     progressdialog.settitle("processing");     progressdialog.setmessage("please wait..."); }  public void storeuserdatainbackground(user user, getusercallback usercallback){      progressdialog.show();     new storeuserdataasynctask(user, usercallback).execute(); }  public class storeuserdataasynctask extends asynctask<void, void, void>{      user user;     getusercallback usercallback;      public storeuserdataasynctask(user user, getusercallback usercallback){          this.user = user;         this.usercallback = usercallback;      }      @override     protected void doinbackground(void... params) {          //setting namevaluepairs         arraylist<namevaluepair> datatosend = new arraylist<>();//stores key , value          datatosend.add(new basicnamevaluepair("badgenumber",user.getbadgenumber()+""));         datatosend.add(new basicnamevaluepair("name",user.getname()));         datatosend.add(new basicnamevaluepair("extensionnumber",user.getextensionnumber()+""));         datatosend.add(new basicnamevaluepair("phonenumber",user.getphonenumber()+""));         datatosend.add(new basicnamevaluepair("email",user.getemail()));          log.i(tag,"storeuserdataasynctask method badgenumber: "+user.getbadgenumber()+" name: "+user.getname());          httpparams httprequestparams = new basichttpparams();         httpconnectionparams.setconnectiontimeout(httprequestparams, connection_timeout);//the time want wait until pulse executed (stop connection)         httpconnectionparams.setsotimeout(httprequestparams, connection_timeout);//the time want wait receive server          httpclient client = new defaulthttpclient(httprequestparams);//allows make requests server, passed httprequestparams client know connection timeout         httppost post = new httppost(server_address + "register.php");          try{             post.setentity(new urlencodedformentity(datatosend));             client.execute(post);             log.i(tag,"try , catch");         }catch(exception e){             e.printstacktrace();         }           return null;     }      @override     protected void onpostexecute(void avoid){         progressdialog.dismiss();         usercallback.done(null);         log.i(tag,"onpostexecute");         super.onpostexecute(avoid);     } } 

this interface

interface getusercallback {  public abstract void done(user returneduser); 

}

here call storeuserdatainbackground method once button clicked

 registerbutton.setonclicklistener(new view.onclicklistener() {          //inputstream = null;          @override         public void onclick(view v) {             int bn = integer.parseint(badgenumberview.gettext().tostring());             string name = nameview.gettext().tostring();             int en = integer.parseint(extensionnumberview.gettext().tostring());             int pn = integer.parseint(phonenumberview.gettext().tostring());             string email = emailview.gettext().tostring();                  user user = new user(bn, name, en, pn, email);                  registeruser(user);          }     });     private void registeruser(user user){      serverrequests serverrequests = new serverrequests(this);     serverrequests.storeuserdatainbackground(user, new getusercallback() {         @override         public void done(user returneduser) {              startactivity(new intent(mainactivity.this, requestactivity.class));          }     }); } 

1."email" seems reserved, change else.

2.try this:

     datatosend.add(new basicnamevaluepair("badgenumber",user.bn +""));     datatosend.add(new basicnamevaluepair("name",user.name));     datatosend.add(new basicnamevaluepair("extensionnumber",user.en +""));     datatosend.add(new basicnamevaluepair("phonenumber",user.pn +""));     datatosend.add(new basicnamevaluepair("email",user.e_mail));      log.i(tag,"storeuserdataasynctask method badgenumber: "+user.bn +" name: "+user.name); 

Comments