麻辣家族討論版版 - Powered by Discuz! Board

<input type="radio" name="pic" value="1" checked >
<img src="1.gif">
<input type="radio" name="pic" value="2"><img src="2.gif">
<input type="radio" name="pic" value="3"><img src="3.gif">
<input type="radio" name="pic" value="4"><img src="4.gif">
<input type="radio" name="pic" value="5"><img src="5.gif">
<input type="radio" name="pic" value="6"><img src="6.gif">
<input type="radio" name="pic" value="7"><img src="7.gif">
<input type="radio" name="pic" value="8"><img src="8.gif">
<input type="radio" name="pic" value="9"><img src="9.gif">
<input type="radio" name="pic" value="10"><img src="10.gif">

複製代碼

<select name="personal" size="1">
<option value="0" selected>大家來討論</option>
<option value="1">只給板主看</option>
</select>

複製代碼

<textarea name="memo" cols="50" rows="4" ></textarea>

複製代碼

<form name="addmsg" method="POST" action="add.php">

複製代碼

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>麻辣家族留言板</title>
</head>
<body>
<div align="center">
<p align="center">
<font size="2">
<img src="title.gif">
</font>
<br>
<font size="2"><a href="guest.php">
<img border="0" src="team2.gif" align="absmiddle">
看看網友們的意見<img border="0" src="team2.gif" align="absmiddle">
</a></font> </div>
<form name="addmsg" method="POST" action="add.php">
<div align="center">
<table border="1" cellspacing="0" style="border-collapse: collapse"
bordercolor="#FFFFFF" cellpadding="0">
<tr><td bgcolor="#339933" align="center" valign="middle" width="147">
<font color="#FFFFFF" size="2">留言主題</font></td>
<td height="25" bgcolor="#E8FFE8"><font size="2">
<input type="text" name="subject" size="50" value maxlength="20">
</font></td></tr> <tr>
<td bgcolor="#339933" align="center" valign="middle" width="147">
<font color="#FFFFFF" size="2">您的大名</font></td>
<td height="25" bgcolor="#E8FFE8"><font size="2">
<input type="text" name="name" size="20" maxlength="20"></font></td>
</tr>
<tr>
<td bgcolor="#339933" align="center" valign="middle" width="147">
<font color="#FFFFFF" size="2">E-Mail</font></td>
<td height="25" bgcolor="#E8FFE8"><font size="2">
<input type="text" name="email" size="35" maxlength="40"></font></td>
</tr>
<tr>
<td bgcolor="#339933" align="center" height="27" valign="middle" width="147">
<font size="2" color="#FFFFFF">代表圖形</font></td>
<td height="27" bgcolor="#E8FFE8">
<font size="2">
<input type="radio" name="pic" value="1" checked ><img src="1.gif">
<input type="radio" name="pic" value="2"><img src="2.gif">
<input type="radio" name="pic" value="3"><img src="3.gif">
<input type="radio" name="pic" value="4"><img src="4.gif">
<input type="radio" name="pic" value="5"><img src="5.gif">
<input type="radio" name="pic" value="6"><img src="6.gif">
<input type="radio" name="pic" value="7"><img src="7.gif">
<input type="radio" name="pic" value="8"><img src="8.gif">
<input type="radio" name="pic" value="9"><img src="9.gif">
<input type="radio" name="pic" value="10"><img src="10.gif">
</font>
</td>
</tr>
<tr>
<td bgcolor="#339933" align="center" width="147">
<font color="#FFFFFF" size="2">留言性質</font></td>
<td bgcolor="#E8FFE8">
<font size="2">
<select name="personal" size="1">
<option value="0" selected>大家來討論</option>
<option value="1">只給板主看</option>
</select>
</font>
</td>
</tr>
<tr>
<td bgcolor="#339933" align="Center" height="98" valign="middle" width="147">
<font color="#FFFFFF" size="2">留言內容：</font>
</td>
<td height="98" valign="middle" bgcolor="#E8FFE8">
<font size="2">
<textarea name="memo" cols="50" rows="4" ></textarea>
</font>
</td></tr><tr><td align="Center" colspan="2">
<font size="2"><input type="submit"value="送出意見">
<input type="reset" value="重填資料"></font></td>
</tr></table></div>
</form></center>
</body></html>

複製代碼

//接收addmsg.php傳來的資訊
$subject=$_REQUEST["subject"];
$name = $_REQUEST["name"];
$email = $_REQUEST["email"];
$pic=$_REQUEST["pic"];
$memo=nl2br($_REQUEST["memo"]);
$personal = $_REQUEST["personal"];

複製代碼

//將單引號置換為雙引號
Function chgStr($data)
{
$chgStr = "'" . str_replace("'", "''", $data) . "'";
return $chgStr;
}

複製代碼

//連結SQL Server
$conn = mysql_connect("127.0.0.1", "sa", "12345");
//選擇資料庫
mysql_select_db("Message", $conn);
//指定提取資料的校對字元表
mysql_query("set character set big5");

複製代碼

Insert Into 資料表名 (欄位名) values (欄位值)

複製代碼

//將資料寫入資料庫
$sql = "Insert Into allmessage (網友姓名, 留言主題, 聯絡信箱, 留言內容, 私人公開, 圖形, 留言時間) Values (";
$sql = $sql . chgStr($name) . ",";
$sql = $sql . chgStr($subject) . ",";
$sql = $sql . chgStr($email) . ",";
$sql = $sql . chgStr($memo) . ",";
$sql = $sql . chgStr($personal) . ",";
$sql = $sql . $pic . ",'";
$sql = $sql . date("Y-m-j H:i:s") . "')";
mysql_query($sql);

複製代碼

//將網頁轉向至顯示留言意見的網頁guest.php
header("Location: guest.php");

複製代碼

<?
//接收addmsg.php傳來的資訊
$subject=$_REQUEST["subject"];
$name = $_REQUEST["name"];
$email = $_REQUEST["email"];
$pic=$_REQUEST["pic"];
$memo=nl2br($_REQUEST["memo"]);
$personal = $_REQUEST["personal"];
//連結MySQL Server
$conn = mysql_connect("localhost", "root", "12345a");
//選擇資料庫
mysql_select_db("Message", $conn);
//指定提取資料的校對字元表
mysql_query("set character set big5");
//將單引號置換為雙引號
Function chgStr($data)
{
$chgStr = "'" . str_replace("'", "''", $data) . "'";
return $chgStr;
}
//將資料寫入資料庫
$sql = "Insert Into allmessage (網友姓名, 留言主題, 聯絡信箱, 留言內容, 私人公開, 圖形, 留言時間) Values (";
$sql = $sql . chgStr($name) . ",";
$sql = $sql . chgStr($subject) . ",";
$sql = $sql . chgStr($email) . ",";
$sql = $sql . chgStr($memo) . ",";
$sql = $sql . chgStr($personal) . ",";
$sql = $sql . $pic . ",'";
$sql = $sql . date("Y-m-j H:i:s") . "')";
mysql_query($sql);
//將網頁轉向至顯示留言意見的網頁guest.php
header("Location: guest.php");
?>

複製代碼

編號	欄位	欄位名稱	表單元件
１	留言主題	subject	單行文字方塊
２	您的大名	parent	單行文字方塊
３	E-Mail	email	單行文字方塊
４	代表圖形	pic	選擇鈕
５	留言性質	personal	下拉式功能表
６	留言內容	memo	多行文字方塊
７	送出意見	Submit	按鈕
８	清除重寫	／	按鈕