//CONNECT to SERVER
$connect_string = "host=localhost dbname=ecohouse port=5432";
@$con = pg_connect($connect_string);
if ($con == false) {
print("データベースに接続できませんでした。");
exit;
}
//GET HOUSE DATA
$sql = "SELECT id,name,place1,areatype FROM house ORDER BY areatype;";
$result = pg_exec($sql);
if ($result == false) {
printf("SQL:\"$sql\"の実行に失敗しました。");
exit;
}
$rows = pg_numrows($result);
$columns = pg_numfields($result);
$data = array();
for ($r = 0; $r < $rows; $r++){
for ($i = 0; $i < $columns; $i++) {
$str = pg_fieldname($result,$i);
@$data[$r][$str] = pg_result($result,$r,$i);
if ($data[$r][$str] == "") {
$data[$r][$str] = "データなし";
}
}
}
pg_freeresult($result);
pg_close($con);
?>
EZ
|
|
|
|
1 |
|
hCcAJbZs |
|
2 |
|
hCcA~ws |
|
3 |
|
I_AAXe_ |
|
4 |
|
tXAxgN[ |
|
5 |
|
hCcAnuNs |
|
6 |
|
hCcAtCuO |
|
7 |
|
hCcANCcxO |
|
8 |
|
hCcApREn |
|
|