i am trying to insert data from android to online database, my app does not give any error so that i can fix it, it worked fine when i connected my app to localhost and it was inserting data successfully but when i try to insert data to online database it doesn't work. can someone tell me what am doing wrong? before you have a look at my code i want you to look at my hosting information, in case you guys think am doing something wrong with this.
Main Domain securekid.base.pk
FTP hostname: ftp.base.pk
FTP username: basep_****
MySQL hostname: sql104.base.pk
MySQL username: basep_****
Hosting Volume vol14_2
my db connection file:
<?php
$host = "sql104.base.pk";
$user = "basep_****";
$password = "******";
$db = "basep_*****_android";
$con = mysqli_connect($host, $user, $password, $db);
if($con)
{
echo "successful";
}
else
{
die("error" . mysqli_connect_error());
}
?>
register.php
<?php
require "db_connect.php";
$username =$_POST["username"];
$password =$_POST["password"];
$phone_no =$_POST["phone_no"];
$mysql_qry = "insert into user(username,password,phone_no) values('$username', '$password', '$phone_no')";
if($con->query($mysql_qry) === TRUE)
{
echo "Registration Successful";
}
else{
echo "failed";
}
?>
this is background.java file
class backgroundTask extends AsyncTask<String,Void,String> {
AlertDialog alertDialog;
Context ctx;
// Globals session_id = Globals.getInstance();
// Globals session_id_child = Globals.getInstance();
backgroundTask(Context ctx) {
this.ctx = ctx;
}
String reg_url;
@Override
protected void onPreExecute() {
reg_url = "http://securekid.base.pk/app/register.php";
}
@Override
protected String doInBackground(String... args) {
String method = args[0];
if (method.equals("register")) {
String username = args[1];
String password = args[2];
String phone_no = args[3];
try {
URL url = new URL(reg_url);
HttpURLConnection httpURLConnection = (HttpURLConnection) url.openConnection();
httpURLConnection.setRequestMethod("POST");
httpURLConnection.setDoOutput(true);
httpURLConnection.setDoInput(true);
OutputStream OS = httpURLConnection.getOutputStream();
BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(OS, "UTF-8"));
String data = URLEncoder.encode("username", "UTF-8") + "=" + URLEncoder.encode(username, "UTF-8") + "&" +
URLEncoder.encode("password", "UTF-8") + "=" + URLEncoder.encode(password, "UTF-8") + "&" +
URLEncoder.encode("phone_no", "UTF-8") + "=" + URLEncoder.encode(phone_no, "UTF-8");
bufferedWriter.write(data);
bufferedWriter.flush();
bufferedWriter.close();
OS.close();
InputStream IS = httpURLConnection.getInputStream();
IS.close();
//httpURLConnection.connect();
httpURLConnection.disconnect();
return "Registration Successful";
} catch (MalformedURLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}