<HTML>
<META
HTTP-EQUIV="Content-Type" CONTENT="text/html;
charset=x-euc-jp">
<HEAD>
<TITLE>PHP
BBS</TITLE>
</HEAD>
<?
$table="test3";
$database=pg_Connect("","","","","test1");
$ip=getenv("REMOTE_ADDR");
$datetime=date("Y-n-j
H:i:s");
$name=i18n_convert($name,"EUC");
$title=i18n_convert($title,"EUC");
$contents=i18n_convert($contents,"EUC");
if($button == "書き込み") {
$strSQL="insert into $table values(nextval('hoge'),'$title','$contents','$name','$ip','$datetime')";
pg_exec($database,$strSQL);
include("write1.php");
Show_Titles();
}
else if(isset($print_number)) {
include("show_contents1.php");
}
else {
include("write1.php");
Show_Titles();
}
function Show_Titles() {
global $database,$table;
print ("<b>投稿一覧</b><br><br>");
$result=pg_exec($database,"select * from $table order by datetime DESC");
for($i=0;$row=@pg_fetch_array($result,$i);$i++) {
$number=$row["number"];
$name=$row["name"];
$title=$row["title"];
$datetime=$row["datetime"];
$ip=$row["ip"];
print ("$number:<a href=\"bbs1.php?print_number=$number\">$title: $name</a>---$datetime<br>");
}
pg_close($database);
}
?>
</html>