« on: August 19, 2017, 03:35:47 PM »
Connecting Via Get MethodThere are two ways to connect to MYSQL via PHP page. The first one is called Get method. We will use HttpGet and HttpClient class to connect.URL url =new URL(link);HttpClient client =newDefaultHttpClient();HttpGet request =newHttpGet();
request.setURI(new URI(link));
[/SIZE]
...call execute method of HttpClient class and receive it in a HttpResponse object.HttpResponse response = client.execute(request);
BufferedReader in = new BufferedReader
(new InputStreamReader(response.getEntity().getContent()));
[/SIZE]
Connecting Via Post MethodURL url = new URL(link);
String data = URLEncoder.encode("username", "UTF-8")
+ "=" + URLEncoder.encode(username, "UTF-8");
data += "&" + URLEncoder.encode("password", "UTF-8")
+ "=" + URLEncoder.encode(password, "UTF-8");
URLConnection conn = url.openConnection();
[/SIZE]
OutputStreamWriter wr = new OutputStreamWriter(conn.getOutputStream());
wr.write( data );
BufferedReader reader = new BufferedReader(new
InputStreamReader(conn.getInputStream()));
The php page has been given below which takes parameters by post method.[/SIZE]
$con=mysqli_connect("mysql10.000webhost.com","username","password","db_name");
if (mysqli_connect_errno($con)) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$username = $_POST['username'];
$password = $_POST['password'];
$result = mysqli_query($con,"SELECT Role FROM table1 where
Username='$username' and Password='$password'");
$row = mysqli_fetch_array($result);
$data = $row[0];
if($data){
echo $data;
}
mysqli_close($con);
?>
[/SIZE]
More info and complete Android - PHP/MYSQL tutorial
--
Ref: www.tutorialspoint.com/android/android_php_mysql.htm