<?php
include 'JLDatabase.php';
$host = 'localhost';
$dbname = 'dbutils';
$username = '******';
$password = '******';
$db = JLDatabase::getInstance();
$db->setDriver('mysql');
$db->setDatabaseName($dbname);
$db->setHostName($host);
$db->setUserName($username);
$db->setPassword($password);
$db->connect();
$dbh = $db->getConnection();
// Departamentos
$sql = '
SELECT `id_ubigeo` , `nombre_ubigeo` , `codigo_ubigeo` , `etiqueta_ubigeo` , `buscador_ubigeo` , `numero_hijos_ubigeo` , `nivel_ubigeo` , `id_padre_ubigeo`
FROM `ubigeo`
WHERE `id_padre_ubigeo` = 2533
ORDER BY `ubigeo`.`nombre_ubigeo` ASC
';
$sth = $dbh->prepare($sql);
$sth->execute();
$departaments = $sth->fetchAll(PDO::FETCH_ASSOC);
$provinces = array();
$provinces2 = array();
$districts = array();
// Provincias
foreach ($departaments as $departament) {
$sql = '
/**
* JLDatabase::getInstance()
* Get a unique Instance to the JLDatabase class
* @return JLDatabase
*/
public static function getInstance()
{
if (self::$_instance == null) {
self::$_instance = new self();
}
return self::$_instance;
}
