Connecting Android To MySql Using PHP and JSON Part-III

PHP files

Config file
<?php
define('DB_USER', "root");
define('DB_PASSWORD', "");
define('DB_DATABASE', "elec_bill");
define('DB_SERVER', "localhost");
?>


Connection class file


<?php
class DB_CONNECT {
    function __construct() {
        $this->connect();
    }
    function __destruct() {
        $this->close();
    }
    function connect() {
        require_once __DIR__ . '/db_config.php';
        $con = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die(mysql_error());
        $db = mysql_select_db(DB_DATABASE) or die(mysql_error()) or die(mysql_error());
        return $con;
    }
    function close() {
        mysql_close();
    }
}
?>


bridging file


<?php
$response = array();

if(isset($_POST['user_id'])&&($_POST['connect']=="connectionallowed")){
require_once __DIR__ . '/db_connect.php';
$assignto=$_POST['user_id'];
$db = new DB_CONNECT();
$result = mysql_query("SELECT * FROM ebill_details WHERE eb_mtr_sl_no='$assignto'") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
    $response["consumers"] = array();
    while ($row = mysql_fetch_array($result)) {
        $customerlist = array();
        $customerlist["cons_ac_no"] = $row["eb_cons_ac_no"];
$customerlist["cust_id"]=$row["eb_cust_id"];
$customerlist["oa_no"]=$row["eb_oa_no"];
$customerlist["inst_no"]=$row["eb_inst_no"];
$customerlist["mtr_sl_no"]=$row["eb_mtr_sl_no"];
$customerlist["mtr_owner"]=$row["eb_mtr_owner"];
$customerlist["cons_name"]=$row["eb_cons_name"];
$customerlist["cons_addrs"]=$row["eb_cons_addrs"];
$customerlist["bill_unit_1"]=$row["eb_bill_unit_1"];
$customerlist["prev_unit"]=$row["eb_prev_unit"];
$customerlist["prev_amt"]=$row["eb_prev_amt"];
$customerlist["pre_mtr_rdng"]=$row["eb_pre_mtr_rdng"];
$customerlist["tax"]=$row["eb_tax"];
$customerlist["bill_unit_2"]=$row["eb_bill_unit_2"];
$customerlist["bill_unit_3"]=$row["eb_bill_unit_3"];
$customerlist["bill_basis"]=$row["eb_bill_basis"];
$customerlist["energy_charge"]=$row["eb_energy_charge"];
$customerlist["ed_charge"]=$row["eb_ed_charge"];
$customerlist["mtr_rent"]=$row["eb_mtr_rent"];
$customerlist["misc_charge"]=$row["eb_misc_charge"];
$customerlist["prev_bill_dt"]=$row["eb_prev_bill_dt"];

        array_push($response["consumers"], $customerlist);
    }
    $response["success"] = 1;
    echo json_encode($response);
} else {
    $response["success"] = 0;
    $response["message"] = "No user found";
    echo json_encode($response);
}
}else {
    $response["success"] = 0;
    $response["message"] = "Required field missing";
    echo json_encode($response);
}

?>