<?php
$response = array();
error_reporting(E_ALL);
$db_connect = oci_connect('system','admin','5.19.187.230');
if (!$db_connect)
{
$response['status'] = 'NOT_CONNECT';
}
else
{
$stmt = oci_parse($db_connect,'SELECT ID_CUSTOMER, PASSWORD FROM         customers'); // подготавливает запрос к выполнению
$ID_CUSTOMER = $_POST['ID_CUSTOMER'];
$PASSWORD = $_POST[' PASSWORD'];
oci_execute($stmt); // выполняет подготовленное выражение
echo $stmt;

$result = oci_execute($stmt);
if(!$result){
    $response["status"] = "FAILED";
}else{
    $response["status"] = "SUCCESS";
}
oci_free_statement($stmt);
oci_close($db_connect);
$db_connect = null;


}
echo json_encode($response);
die();
?>



@SuppressWarnings("deprecation")
public class MainActivity extends AppCompatActivity {
//
Button buttonCreateUser, buttonLogin;
EditText ID_CUSTOMER, PASSWORD;
//
final static String NOT_CONNECT = "NOT_CONNECT";
final static String SUCCESS = "SUCCESS";
final static String FAILED = "FAILED";

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    buttonCreateUser = (Button)findViewById(R.id.buttonCreateUser); // кнопка создания пользователей
    buttonLogin = (Button)findViewById(R.id.buttonLogin); // кнопка входа пользователя
    ID_CUSTOMER = (EditText)findViewById(R.id.ID_CUSTOMER);
    PASSWORD = (EditText)findViewById(R.id.PASSWORD);
}

public void setButtonLogin(View v){
    AsyncTask<String, Void, JSONObject> task = new AsyncTask<String, Void,  JSONObject>() {
            @Override
            protected JSONObject doInBackground(String... params) {
                JSONParser jsonParser = new JSONParser();
                List<NameValuePair> loginpass = new ArrayList<NameValuePair>();
                loginpass.add(new BasicNameValuePair("ID_CUSTOMER", params[0]));
                loginpass.add(new BasicNameValuePair("PASSWORD", params[1]));
                JSONObject json = jsonParser.makeHttpRequest("http://login.php", JSONParser.POST, loginpass);
                return json;
            }
            @Override
            protected void onPostExecute(JSONObject result) {
                if (result != null) {
                    super.onPostExecute(result);
                    String res = "";
                    try {
                        res = result.getString("status");
                        switch (res) {
                            case NOT_CONNECT:
                                Toast toast_not_connect = Toast.makeText(getApplicationContext(), "Сервер недоступен", Toast.LENGTH_SHORT);
                                toast_not_connect.setGravity(Gravity.CENTER, 0, 0);
                                toast_not_connect.show();
                                break;

                            case SUCCESS:
                                Toast toast_success = Toast.makeText(getApplicationContext(), "Вход выполнен", Toast.LENGTH_SHORT);
                                toast_success.setGravity(Gravity.CENTER, 0, 0);
                                toast_success.show();
                                Intent intentB = new Intent(MainActivity.this, StoryActivity.class);
                                startActivity(intentB);
                                break;

                            case FAILED:
                                Toast toast_failed =  Toast.makeText(getApplicationContext(), "Не правильно введен логинn или пароль", Toast.LENGTH_SHORT);
                                toast_failed.setGravity(Gravity.CENTER, 0, 0);
                                toast_failed.show();
                                break;
                        }
                    } catch (JSONException e) {
                        e.printStackTrace();
                    }
                }
            }
        };
        task.execute(ID_CUSTOMER.getText().toString(), PASSWORD.getText().toString());
    }
public void setButtonCreateUser_Click(View v){
    Intent intent = new Intent(MainActivity.this, CreateActivity.class);
    startActivity(intent);
}
}