SSQL 20200130 otawa ssh jxxxxxxx131 113 100 213

埋め込み型SSQL 2020/01/30 otawa

実験サーバ • ssh jxxxxxxx@131. 113. 100. 213 • pg_dump jxxxxxxx > エイリアス名. dump • exit

aqua • ssh エイリアス名@aqua. db. ics. keio. ac. jp • scp jxxxxxxx@131. 113. 100. 213: ~/エイリアス名. dump. • scp -rp jxxxxxxx@131. 113. 100. 213: ~/public_html /srv/http/htdocs/ssql/ehtml/エイリアス 名

データベース作成 • psql -U postgres • CREATE ROLE jxxxxxxx with LOGIN SUPERUSER; • CREATE DATABASE jxxxxxxx with owner = jxxxxxxx; • q • cat エイリアス名. dump | psql jxxxxxxx

必要なものをコピー(Cyberduck) • 自分のWebアプリ(php)があるディレクトリに /srv/http/htdocs/ssql/ehtml/otawa から以下をコピー • • config. ssql jscss Ssql Generated. XML

config. ssqlを編集 • cd Webアプリがあるディレクトリ • vi config. ssql • 以下のように書く driver=postgresql db=jxxxxxxx user=jxxxxxxx host=localhost

例 <? php require_once(‘. /Ssql/ssql. php’); ssql_set. Config(“. /config. ssql”); ssql_exec(“GENERATE Responsive. HTML [t. sport_name, t. game_date, m. login_name]! FROM tickets t, member m WHERE t. member_id = m. id; “); ? > print "<table border=1 align="center"> <tr><th>競技名</th><th>日付</th><th>出品者</th></tr>"; $conn = pg_connect("host=localhost dbname=j 150348 s user=j 150348 s"); $query 1 = "SELECT t. id, t. sport_name, t. game_date, m. login_name FROM tickets t, member m WHERE t. member_id = m. id"; $result 1 = pg_prepare($conn, "q 1", $query 1); $result 1 = pg_execute($conn, "q 1", array()); $num = pg_num_rows($result 1); for ($i = 0; $i < $num; $i++) { $row = pg_fetch_assoc($result 1, $i); print "<tr><td><a href=". /ticket_detail. php? id=". $row['id']. "">". $row['sport_ name']. "</a></td><td>". $row['game_date']. "</td><td>". $ro w['login_name']. "</td>"; } print "</table>";

リンクの例 GENERATE Responsive. HTML [glink(t. sport_name, 'ticket_detail. php', t. id), t. game_date, m. login_name]! FROM tickets t, member m WHERE t. member_id = m. id; parameter t. id GENERATE Responsive. HTML [t. sport_name! m. login_name! t. game_date! t. venue! t. price]! FROM tickets t, member m WHERE t. member_id = m. id;