📄 16-8.php3

📁 linux操作系统中 php 核心编程所有例程都是一些很不错的案例
💻 PHP3
字号:
<?
	print("<HTML>\n");
	print("<HEAD>\n");
	print("<TITLE>Leon's BBS</TITLE>\n");
	print("</HEAD>\n");
	print("<BODY BGCOLOR=\"#FFFFFF\">\n");

	print("<H1>Leon's BBS</H1>\n");

	// connect to server 
	$mysql_link = mysql_connect("localhost", "httpd", "");

	// select the 'store' database
	mysql_select_db("leon", $mysql_link);

	/*
	** recursive function that spits out all 
	** descendent messages
	*/
	function showMessages($parentID)
	{
		global $mysql_link;

		$dateToUse = Date("U");

		print("<UL>\n");

		$Query = "SELECT ID, Title, Created, Parent ";
		$Query .= "FROM bbsMessage ";
		$Query .= "WHERE Parent=$parentID ";
		$Query .= "ORDER BY Created ";

		$mysql_result = mysql_query($Query, $mysql_link);

		while($row = mysql_fetch_row($mysql_result))
		{
			$messageID = $row[0];
			$messageTitle = $row[1];
			$messageCreated = $row[2];
			$messageParent = $row[3];

			//show message title as a link to view the body
			print("<LI>($messageCreated) <A HREF=\"");
			print("16-8.php3?messageID=$messageID\">");
			print("$messageTitle</A><BR>\n");

			//show children of this message	
			showMessages($messageID);

			$RowCount++;
		}

		print("</UL>\n");
	}


	/*
	** print out a form for adding a message with 
	** parent id given
	*/
	function postForm($parentID, $useTitle)
	{
		print("<FORM ACTION=\"16-8.php3\" METHOD=\"post\">\n");

		print("<INPUT TYPE=\"hidden\" NAME=\"inputParent\" ");
		print("VALUE=\"$parentID\">\n");

		print("<INPUT TYPE=\"hidden\" NAME=\"ACTION\" ");
		print("VALUE=\"POST\">\n");

		print("<TABLE BORDER=\"1\" CELLSPACING=\"0\" ");
		print("CELLPADDING=\"5\" WIDTH=\"400\">\n");

		print("<TR>\n");

		print("<TD WIDTH=\"100\"><B>Title</B></TD>\n");

		print("<TD WIDTH=\"300\">");
		print("<INPUT TYPE=\"text\" NAME=\"inputTitle\" ");
		print("SIZE=\"35\" MAXLENGTH=\"64\" VALUE=\"$useTitle\">");
		print("</TD>\n");

		print("</TR>\n");

		print("<TR>\n");

		print("<TD WIDTH=\"100\"><B>Poster</B></TD>\n");

		print("<TD WIDTH=\"300\">");
		print("<INPUT TYPE=\"text\" NAME=\"inputPoster\" ");
		print("SIZE=\"35\" MAXLENGTH=\"64\">");
		print("</TD>\n");

		print("</TR>\n");

		print("<TR>\n");

		print("<TD COLSPAN=\"2\" WIDTH=\"400\">");
		print("<TEXTAREA NAME=\"inputBody\" ");
		print("COLS=\"45\" ROWS=\"5\"></TEXTAREA>");
		print("</TD>\n");
		
		print("</TR>\n");
		
		print("<TR>\n");

		print("<TD COLSPAN=\"2\" WIDTH=\"400\" ALIGN=\"middle\">");
		print("<INPUT TYPE=\"submit\" VALUE=\"Post\">");
		print("</TD>\n");

		print("</TR>\n");

		print("</TABLE>\n");
		print("</FORM>\n");
	}

	/*
	** perform actions
	*/
	if($ACTION != "")
	{
		if($ACTION == "POST")
		{
			$inputTitle = ereg_replace("'", "''", $inputTitle);
			$inputBody = ereg_replace("'", "''", $inputBody);

			$Query = "INSERT INTO bbsMessage ";
			$Query .= "VALUES(0, '$inputTitle', ";
			$Query .= "'$inputPoster', ";
			$Query .= "now(), $inputParent, ";
			$Query .= "'$inputBody')";
	
			mysql_query($Query, $mysql_link);
		}

	}


	/*
	** Show Message or show list of messages
	*/
	if($messageID > 0)
	{
		$Query = "SELECT * FROM bbsMessage ";
		$Query = $Query . "WHERE ID=$messageID ";

		$mysql_result = mysql_query($Query, $mysql_link);

		if($row = mysql_fetch_row($mysql_result))
		{
			$messageTitle = $row[1];
			$messagePoster = $row[2];
			$messageCreated = $row[3];
			$messageParent = $row[4];
			$messageBody = $row[5];

			print("<TABLE BORDER=\"1\" CELLSPACING=\"0\" ");
			print("CELLPADDING=\"5\" WIDTH=\"400\">\n");
			
			print("<TR>");
			print("<TD WIDTH=\"100\"><B>Title</B></TD>");
			print("<TD WIDTH=\"300\">$messageTitle</TD>");
			print("</TR>\n");
			
			print("<TR>");
			print("<TD WIDTH=\"100\"><B>Poster</B></TD>");
			print("<TD WIDTH=\"300\">$messagePoster</TD>");
			print("</TR>\n");

			print("<TR>");
			print("<TD WIDTH=\"100\"><B>Posted</B></TD>");
			print("<TD WIDTH=\"300\">$messageCreated</TD>");
			print("</TR>\n");

			print("<TR>");
			print("<TD COLSPAN=\"2\" WIDTH=\"400\">");
			print("$messageBody");
			print("</TD>");
			print("</TR>\n");
			
			print("</TABLE>\n");

			postForm($messageID, "RE: $messageTitle");

		}
		

		print("<A HREF=\"16-8.php3\">List of Messages</A><BR>\n");

	}
	else
	{
		print("<H2>List of Messages</H2>\n");

		// get entire list
		showMessages(0);

		postForm(0, "");

	}

	print("</BODY>\n");
	print("</HTML>\n");
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -