<?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; }