{
private $conn;
function __construct()
{
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function get_province()
{
$sql = "SELECT * FROM province ORDER BY `province_name`";
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX();
$_ajax_province = filter_var($_POST['province'], FILTER_SANITIZE_STRING);
$_ajax_city = filter_var($_POST['city'], FILTER_SANITIZE_STRING);
$getProvince = $_ajax->get_province();
echo "<select class=\"form-control\" id=\"id-province\" name=\"province\" onchange=\"getCity('" . $_ajax_city . "')\">";
foreach ($getProvince as $province) {
echo '<option value="' . $province->province_name . '"';
if ($province->province_name == $_ajax_province) {
echo ' selected="selected" ';
}
echo '>' . $province->province_name . '</option>';
}
echo '</select>';
}
";
$query = $this->conn->query($sql);
$row = array();
while($result = $query->fetch_object()){
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX();
$provinces = $_ajax->get_province();
?>
<div class="box row" id="local">
<div class="desc col-xs-3">
<h3>Local Shipping</h3>
<p>Details of local shipping.</p>
</div>
<div class="content col-xs-9">
<ul class="form-set">
<?php
$row = 0;
foreach($provinces as $provinces){
$row++;
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX();
$ajax_email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
$count = $_ajax->count_user($ajax_email);
if ($count->rows > 0) {
$data = $_ajax->get_user($ajax_email);
$country = $_ajax->get_country();
$province = $_ajax->get_provinces();
if ($data->user_country == 'Indonesia') {
$city = $_ajax->get_province($data->user_province);
} else {
$city = $data->user_city;
}
?>
<li class="form-group p_t_25 m_t_30 upperlined">
<h5 class="m_b_20"><strong>BILLING ADDRESS</strong></h5>
</li>
<li class="form-group row" id="id-row-billing-fname">
<label class="control-label col-xs-3">First Name <span>*</span></label>
<div class="col-xs-9">
<input type="text" name="billing-fname" class="form-control" value="<?php
echo $data->user_first_name;
?>
">
