i wanted insert data in mysql , retrieve, modify , delete rows in it. don't have programming knowledge, little database manipulation. android studio whole new thing me , i'm having problems tutorials regarding on connecting android studio mysql. tried use ip add of computer, 10.0.2.2 , 127.0.0.1 , registering free web hosting still doesn't insert data.
another thing dialog box should display status of registration doesn't work.
one last thing know mistake in code because when looked on tutorial worked can't figure out why doesn't work on me.
i appreciate can provide.
here's php file
conn.php <?php $db_name = "dbapp"; $mysql_username="root"; $mysql_password=""; $server_name="localhost"; $con = mysqli_connect($server_name,$mysql_username,$mysql_password,$db_name); ?> register.php <?php require "conn.php"; $f_name=$_post["first_name"]; $m_name=$_post["middle_name"]; $l_name=$_post["last_name"]; $email_add=$_post["emailadd"]; $user_name=$_post["username"]; $user_pass=$_post["userpass"]; $sql_query = "insert tbluser (f_name, m_name, l_name, user_emadd, user_name, user_pass) values('$fname','$mname','$lname','email_add','$user_name','user_pass')"; ?> here's of android studio files
register.java
package com.example.*****.myapplication; // above code not asterisk, wanna hide it.. import android.app.activity; import android.os.bundle; import android.view.view; import android.widget.edittext; public class register extends activity{ edittext et_fname,et_mname,et_lname,et_email,et_username,et_pass; string txtfname, txtmname, txtlname, txtusername, txtemail, txtpass; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.register); et_fname = (edittext)findviewbyid(r.id.et_fname); et_mname = (edittext)findviewbyid(r.id.et_mname); et_lname = (edittext)findviewbyid(r.id.et_lname); et_email = (edittext)findviewbyid(r.id.et_email); et_username = (edittext)findviewbyid(r.id.et_username); et_pass = (edittext)findviewbyid(r.id.etpassword); } public void userreg(view view){ txtfname = et_fname.gettext().tostring(); txtmname = et_mname.gettext().tostring(); txtlname = et_lname.gettext().tostring(); txtemail = et_email.gettext().tostring(); txtusername = et_username.gettext().tostring(); txtpass = et_pass.gettext().tostring(); string method = "register"; backgroundworker backgroundworker = new backgroundworker(this); backgroundworker.execute(method,txtfname,txtmname, txtlname, txtemail, txtusername,txtpass); finish(); } } here's java class backgroundworker.java
package com.example.*****.myapplication; import android.app.alertdialog; import android.content.context; import android.os.asynctask; import android.widget.toast; import java.io.bufferedreader; import java.io.bufferedwriter; import java.io.ioexception; import java.io.inputstream; import java.io.inputstreamreader; import java.io.outputstream; import java.io.outputstreamwriter; import java.net.httpurlconnection; import java.net.malformedurlexception; import java.net.url; import java.net.urlencoder; public class backgroundworker extends asynctask<string,void,string> { alertdialog alertdialog; context ctx; backgroundworker(context ctx) { this.ctx = ctx; } @override protected void onpreexecute() { super.onpreexecute(); } @override protected string doinbackground(string... params) { string reg_url = "http://10.0.2.2/myapp/register.php"; string login_url = "http://10.0.2.2/myapp/login.php"; string method = params[0]; if (method.equals("register")) { string fname = params[1]; string mname = params[2]; string lname = params[3]; string emailadd = params[4]; string username = params[5]; string userpass = params[6]; try { url url = new url(reg_url); httpurlconnection httpurlconnection = (httpurlconnection) url.openconnection(); httpurlconnection.setrequestmethod("post"); httpurlconnection.setdooutput(true); outputstream os = httpurlconnection.getoutputstream(); bufferedwriter bufferedwriter = new bufferedwriter(new outputstreamwriter(os, "utf-8")); string data = urlencoder.encode("f_name", "utf-8") + "=" + urlencoder.encode(fname, "utf-8") + "&" + urlencoder.encode("m_name", "utf-8") + "=" + urlencoder.encode(mname, "utf-8") + "&" + urlencoder.encode("l_name", "utf-8") + "=" + urlencoder.encode(lname, "utf-8") + "&" + urlencoder.encode("email_add", "utf-8") + "=" + urlencoder.encode(emailadd, "utf-8") + "&" + urlencoder.encode("user_name", "utf-8") + "=" + urlencoder.encode(username, "utf-8") + "&" + urlencoder.encode("user_pass", "utf-8") + "=" + urlencoder.encode(userpass, "utf-8"); bufferedwriter.write(data); bufferedwriter.flush(); bufferedwriter.close(); os.close(); inputstream = httpurlconnection.getinputstream(); is.close(); httpurlconnection.disconnect(); return "registration success"; } catch (malformedurlexception e) { e.printstacktrace(); } catch (ioexception e) { e.printstacktrace(); } } return null; } @override protected void onprogressupdate (void...values){ super.onprogressupdate(values); } @override protected void onpostexecute(string result) { if(result.equals("registration success")) { toast.maketext(ctx, result, toast.length_long).show(); } else { alertdialog.setmessage(result); alertdialog.show(); } } } here column name in mysql, has userid primary key , autocrement.
fname mname lname email_add user_name user_pass
Comments
Post a Comment