Ejemplos de get_counties_name en PHP

Ejemplo n.º 1

Archivo: get_counties_names.php Proyecto: beiercm/PopDoxa

<?php

include 'get_connection.php';
if (PHP_SAPI === 'cli') {
    $state_id = $argv[1];
} else {
    $state_id = $_GET['state_id'];
}
get_counties_name($conn, $state_id);
$conn = null;
function get_counties_name($conn, $state_id)
{
    $stmt = "SELECT name,id FROM counties where state_id = :state_id";
    $stmt = $conn->prepare($stmt);
    $stmt->bindparam(':state_id', $state_id);
    $stmt->execute();
    $result = $stmt->fetchAll();
    echo json_encode($result);
}

Ejemplo n.º 2

Archivo: get_cities_names.php Proyecto: beiercm/PopDoxa

<?php

include 'get_connection.php';
if (PHP_SAPI === 'cli') {
    $county_id = $argv[1];
} else {
    $county_id = $_GET['county_id'];
}
get_counties_name($conn, $county_id);
$conn = null;
function get_counties_name($conn, $county_id)
{
    $stmt = "SELECT name,id FROM cities where county_id = :county_id";
    $stmt = $conn->prepare($stmt);
    $stmt->bindparam(':county_id', $county_id);
    $stmt->execute();
    $result = $stmt->fetchAll();
    echo json_encode($result);
}