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

CREATE TABLE [研討會資料表名] (
Name varchar (10) NOT NULL ,
Email varchar (50) NULL ,
Company varchar (50) NULL ,
Tel varchar (20) NOT NULL
)

複製代碼

$SQL="Create Table " .
$研討會資料表名 .
" (" .
"Name varchar(10) Not NULL," .
"Email varchar(50)," .
"Company varchar(50)," .
"Tel varchar(20) Not NULL" .
")";

複製代碼

int mysql_list_tables ( string database_name [, int link_identifier])

複製代碼

int mysql_ tablename ( int result_identifier, int i)

複製代碼

//檢驗資料表是否存在
$testrs=mysql_list_tables("AutoAct");
if (!($Actname==mysql_tablename($testrs,$Actname)))
{
//資料表不存在則建立
//以下略

複製代碼

<?
//判斷必填欄位資料是否為空白
//若必填欄位資料空白則返回報名頁
if (empty($_REQUEST["Name"]))
{
header("Location: index.php?msg=您剛剛姓名未填!!");
exit();
}
else if(empty($_REQUEST["Tel"]))
{
header("Location: index.php?msg=您剛剛聯絡電話未填!!");
exit();
}
else
{
//接收來自表單中的必填欄位資料
$Name = $_REQUEST["Name"];
$Tel = $_REQUEST["Tel"];
}

複製代碼

<?
//判斷必填欄位資料是否為空白
//若必填欄位資料空白則返回報名頁
if (empty($_REQUEST["Name"]))
{
header("Location: index.php?msg=您剛剛姓名未填!!");
exit();
}
else if(empty($_REQUEST["Tel"]))
{
header("Location: index.php?msg=您剛剛聯絡電話未填!!");
exit();
}
else
{
//接收來自表單中的必填欄位資料
$Name = $_REQUEST["Name"];
$Tel = $_REQUEST["Tel"];
}
//判斷非必填欄位'公司'資料是否為空白
if (empty($_REQUEST["Company"]))
{
$Company="";
}
else
{
$Company = $_REQUEST["Company"];
}
//判斷非必填欄位'E-Mail'資料是否為空白
if (empty($_REQUEST["Email"]))
{
$Email="";
}
else
{
$Email = $_REQUEST["Email"];
}
$Actname=$_REQUEST["Actname"];
//連結SQL Server
$conn = mysql_connect("localhost", "root", "12345a");
//選擇資料庫
mysql_select_db("AutoAct", $conn);
//指定提取資料的校對字元表
mysql_query("set character set big5");
//檢驗資料表是否存在
$testrs=mysql_list_tables("AutoAct");
if (!($Actname==mysql_tablename($testrs,$Actname)))
{
//資料表不存在則建立
$SQL="Create Table " .
$Actname .
" (" .
"Name varchar(10) Not NULL," .
"Email varchar(50)," .
"Company varchar(50)," .
"Tel varchar(20) Not NULL" .
")";
mysql_query($SQL);
}
//建立查詢字串用以判斷是否重複報名
$SQL="Select name From " . $Actname . " Where name='" . $Name . "'";
$RS=mysql_query($SQL);
if (!mysql_fetch_array($RS))
{
//如果尚未報名則寫入報名者資料
$sql = "Insert Into " . $Actname . " (name, Email, company, tel) Values ('";
$sql = $sql . $Name . "','";
$sql = $sql . $Email . "','";
$sql = $sql . $Company . "','";
$sql = $sql . $Tel . "')";
mysql_query($sql);
$msg="你已經順利完成<font color=#FF3300>" . $Actname . "</font>研討會報名";
}
else //重複報名
{
$msg="你已經報名過<font color=#FF3300>" . $Actname . "</font>研討會";
}
mysql_close();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>線上報名</title>
</head>
<body>
<p align="center"><img border="0" src="tit.gif" width="231" height="40"></p>
<p align="center"><?=$msg;?></p>
<hr width="80%" color="#FF9900">
<form method="POST" action="listpeople.php">
<p align="center">
<input type="hidden" value="<?=$Actname;?>" name="Actname">
<input type="submit" value="查看已參加人員"
style="background-color: #008000; color: #FFFFFF; border-style: groove">
</p></form>
</body>
</html>

複製代碼

<?
//接收查詢研討會資料
$Actname=$_REQUEST["Actname"];
//連結SQL Server
$conn = mysql_connect("localhost", "root", "12345a");
//選擇資料庫
mysql_select_db("AutoAct", $conn);
//指定提取資料的校對字元表
mysql_query("set character set big5");
//建立SQL命令字串
$SQL="Select * From " . $Actname;
//將回傳結果存放於變數中
$datalist=mysql_query($SQL);
//取得欄位數量
$fieldnum=mysql_num_fields($datalist);
?>
<HTML>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title><?=$Actname;?>研討會報名人員清單</title>
</head>
<BODY>
<p align="center">
<img border="0" src="../tit.gif">
<p Align="Center">
<font color="#FF9900"><?=$Actname;?>研討會報名人員清單</font></p>
<div align="center">
<center>
<TABLE Border=1 Cellspacing=1 bordercolor="#800000">
<?
//列出欄位抬頭
echo "<tr>";
for ($x=0 ;$x<$fieldnum;$x++)
{
echo "<td>" . mysql_field_name($datalist,$x) . "</td>";
}
echo "</tr>";
//列出欄位資料
//將資料錄轉換為欄位陣列集合
while ($fielddatas=mysql_fetch_array($datalist))
{
//輸出欄位資料
echo "<tr>";
for ($x=0;$x<$fieldnum;$x++)
{
echo "<td>" . $fielddatas[$x] . "</td>";
}
echo "</tr>";
}
?>
</TABLE>
</center>
</div>
<p align="center"><font size="2">
<a href="index.php">返回登錄頁</a></font></p>
</html>

複製代碼