Android อยากทราบวิธีการเรียกใช้ฐานข้อมูล ลองมาแล้วหลายวิธีก็ยังไม่ได้ซักทีครับ

<?php
$username="admin";
$password="admin";
$database="smarthome";
$host="127.0.0.1";
$table = "control";

$con = mysql_connect($host,$username,$password);

mysql_select_db($database,$con) or die( "Unable to select database");

$query = "SELECT * FROM $table limit 0,4";
$result = mysql_query($query);

while($array = mysql_fetch_array($result))
{
	
for($x=0; $x <= 3; $x +=1){
	echo $array[$x];
		echo ",";
}
echo $array[4];
}

mysql_close($con);

?>

<?php
$username="admin";
$password="admin";
$database="smarthome";
$host="127.0.0.1";
$table = "control";

$con = mysql_connect($host,$username,$password);

mysql_select_db($database,$con) or die( "Unable to select database");

//$query = "INSERT INTO test VALUES ('Smith','John','')";
$query = "SELECT status FROM $table ";

$result = "UPDATE $table  SET       
			status = '$variable1'
			status = '$variable2'
			status = '$variable3'
			status = '$variable4'
		  WHERE ID = '$id'";

mysql_query($query) or die( "death to query" );

mysql_close($con);
	
echo "OK";	
	
?>

@Override
public void onProgressUpdate(Integer... progress) {
	imageAdapter.notifyDataSetChanged();
}