php - Android Login app with MySQL database -
i'm trying create login app following youtube tutorial. created table using wamp username , password entry. should showing "login success" message "login status" message whenever press login button regardless of input.
i've pasted code below. hope can tell me i'm doing wrong here
background activity class code:
package com.example.klm.sql; import android.app.alertdialog; import android.content.context; import android.os.asynctask; 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.malformedurlexception; import java.net.url; import java.net.urlencoder; import javax.net.ssl.httpsurlconnection; public class background extends asynctask<string, void, string> { context context; alertdialog alertdialog; background (context ctx){ context = ctx; } @override protected string doinbackground(string... params) { string type = params[0]; string user_name = params[1]; string password = params[2]; string login_url = "https://192.168.1.2/login.php"; if(type.equals("login")){ try { url url = new url(login_url); httpsurlconnection httpsurlconnection = (httpsurlconnection)url.openconnection(); httpsurlconnection.setrequestmethod("post"); httpsurlconnection.setdooutput(true); httpsurlconnection.setdoinput(true); outputstream outputstream = httpsurlconnection.getoutputstream(); bufferedwriter bufferedwriter = new bufferedwriter(new outputstreamwriter(outputstream, "utf-8")); string post_data = urlencoder.encode("user_name", "utf-8") + "=" + urlencoder.encode(user_name, "utf-8") + "&" + urlencoder.encode("password", "utf-8") + "=" + urlencoder.encode(password, "utf-8"); bufferedwriter.write(post_data); bufferedwriter.flush(); bufferedwriter.close(); outputstream.close(); inputstream inputstream = httpsurlconnection.getinputstream(); bufferedreader bufferedreader = new bufferedreader(new inputstreamreader(inputstream, "iso-8859-1")); string result = ""; string line = ""; while ((line = bufferedreader.readline()) != null) { result += line; } bufferedreader.close(); inputstream.close(); httpsurlconnection.disconnect(); return result; } catch (malformedurlexception e) { e.printstacktrace(); } catch (ioexception e) { e.printstacktrace(); } } return null; } @override protected void onpreexecute() { alertdialog = new alertdialog.builder(context).create(); alertdialog.settitle("login status"); } @override protected void onpostexecute(string result) { alertdialog.setmessage(result); alertdialog.show(); } @override protected void onprogressupdate(void... values) { super.onprogressupdate(values); } } mainactivity class code
package com.example.klm.sql; import android.os.bundle; import android.support.v7.app.appcompatactivity; import android.view.view; import android.widget.edittext; public class mainactivity extends appcompatactivity { edittext etusername, etpassword; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); etusername = (edittext) findviewbyid(r.id.etusername); etpassword = (edittext) findviewbyid(r.id.etpassword); } public void onlogin(view view) { string username = etusername.gettext().tostring(); string password = etpassword.gettext().tostring(); string type = "login"; background background = new background(this); background.execute(type, username, password); } } login php code
<?php require "conn.php"; $user_name = addslashes($_post["user_name"]); $user_pass = addslashes($_post["password"]); $mysql_qry = "select * `login_data` `username` = '$user_name' , `password` = '$user_pass';"; $result = mysqli_query($conn, $mysql_qry); if (mysqli_num_rows($result) > 0) { echo "login succes"; } else { echo "login failed"; } ?> connection php code
<?php $db_name = "login"; $mysql_username = "root"; $mysql_password = ""; $server_name = "localhost"; $conn = mysqli_connect($server_name, $mysql_username, $mysql_password, $db_name ); ?>
Comments
Post a Comment