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
Post a Comment