//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);
?>
���E�����������Z��
| |
���� |
���� |
|
1 |
|
�h�C�c�A�J�b�Z���s |
|
2 |
|
�h�C�c�A�~�����w���s |
|
3 |
|
�I�����_�A�A���X�e���_�� |
|
4 |
|
�t�����X�A�x�g���N�[�� |
|
5 |
|
�h�C�c�A�n���u���N�s |
|
6 |
|
�h�C�c�A�t���C�u���O |
|
7 |
|
�h�C�c�A�N���C�c�x���O |
|
8 |
|
�h�C�c�A�p���R�E�n�� |
|
|