"; $tags .= "\t\t\t\t" . $i . ""; $tags .= "\t\t\t\t" . htmlspecialchars($row['id']) . ""; $tags .= "\t\t\t\t" . htmlspecialchars($row['name']) . ""; $tags .= "\t\t\t\t" . htmlspecialchars($row['zip']) . ""; $tags .= "\t\t\t\t" . htmlspecialchars($row['address']) . ""; $tags .= "\t\t\t\t表示"; $tags .= "\t\t\t\n"; $i++; } // DBとの接続をクローズ $db = null; /** * ハウス一覧取得SQL */ function getHouseListSql() { $sql = "SELECT\n"; $sql .= " h.id\n"; $sql .= " ,h.name\n"; $sql .= " ,h.zip\n"; $sql .= " ,h.address\n"; $sql .= "FROM\n"; $sql .= " house h\n"; $sql .= ";\n"; return $sql; } ?>