<HTML>
<META
HTTP-EQUIV="Content-Type" CONTENT="text/html;
charset=x-euc-jp">
<HEAD>
<TITLE>PHP
BBS</TITLE>
</HEAD>
<?
$table="test4";
$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('moge'),'$parent_number','$title','$contents','$name','$ip','$datetime')";
pg_exec($database,$strSQL);
unset($number,$title,$contents,$name,$ip,$datetime);
$parent_number=0;
include("write2.php");
Show_Titles();
}
else if(isset($print_number)) {
include("show_contents2.php");
$parent_number=$print_number;
include("write2.php");
}
else {
$parent_number=0;
include("write2.php");
Show_Titles();
}
function Show_Titles() {
print ("<b>投稿一覧</b><br><br>");
Show_Itself_And_Call_Children(0,-1);
}
function Show_Itself_And_Call_Children($number,$indent) {
global $database,$table;
if($number != 0) {
$result=pg_exec($database,"select * from $table where number='$number'");
for($i=0;$arr=@pg_fetch_array($result,$i);$i++) {
$name=$arr["name"];
$title=$arr["title"];
$datetime=$arr["datetime"];
print str_repeat("-",$indent);
print ("$number: <a href=\"bbs2.php?print_number=$number\">$title : $name</a><br>");
}
}
//子供呼出
$result=pg_exec($database,"select * from $table where parent_number='$number'");
for($i=0;$arr=@pg_fetch_array($result,$i);$i++) {
Show_Itself_And_Call_Children($arr["number"],$indent+1);
}
}
?>
</html>