コード例 #1
0
ファイル: city.php プロジェクト: manishkhanchandani/mkgxy
            parent::__construct();
            $this->_connMain->Execute("SET NAMES utf8");
        }
        public function getList()
        {
            $query = 'SELECT * 
FROM  `geo_cities` 
WHERE  `extraDetails` IS NULL
ORDER BY RAND()
LIMIT 0 , 30';
            $result = $this->fetchAll($query, array(), 0);
            return $result;
        }
    }
    $cities = new Cities();
    $list = $cities->getList();
} catch (Exception $e) {
}
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>

<body>

<h1>Cities</h1>
<?php 
foreach ($list as $city) {