PHP Database::getRegions Examples

Example #1

File: index.php Project: raphnelo/geovetph

        }
        $stmt .= join(", ", $updateArray);
        if (!is_null($conditions)) {
            $stmt .= " WHERE " . $conditions;
        }
        return $this->mysqli->query($stmt);
    }
}
$db = new Database();
$db->connect();
switch ($_POST['func']) {
    case 'get':
        switch ($_POST['type']) {
            case 0:
                // get all regions used by AddressManager
                $results = $db->getRegions();
                if ($results) {
                    echo json_encode($results);
                } else {
                    echo $results;
                }
                break;
            case 1:
                // get all provinces in provided region; used by AddressManager
                $region_id = $_POST['id'];
                $results = $db->getProvinces($region_id);
                if ($results) {
                    echo json_encode($results);
                } else {
                    echo $results;
                }