PHP插入資料表<?php
include "config.php";
$command=$_POST["command"];
if ($command==null) {
echo("
<html>
<title>MySql 新增查詢合併範例</title>
<center>
<form method='post' action=$PHP_SELF>
<table border=0>
<tr>
<td>學號：</td>
<td>
<input type='text' name='student_no' size='9'>
</td>
</tr>
</table>
<input type='submit' name='command' value='新增'>
<input type='submit' name='command' value='查詢'>
<input type='reset' name='command' value='清除 '>
</form>
</center>
</html>
");
}
if ($command=="新增") {
$student_no=$_POST["student_no"];
if ($student_no==null) {
echo "<center>學號欄不能空白,請回前頁重新輸入</center><p>";
exit();
} $sql="insert into stmd values('$depart_class','$student_no','$student_name','$address')";
$result=mysql_query($sql,$conn);
$no_of_rows=mysql_affected_rows($conn);
if ($no_of_rows==1)
echo("<html><center>新增成功</center></html>");
else
echo mysql_error();
}
?> | 
