Log in with LINE
นี่ code ครับ
Code: Select all
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
</head>
<body>
<?php
DEFINE ('DB_USER', 'root');
DEFINE ('DB_PASSWORD', 'Admin');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'test');
$conn = mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($conn, 'utf8');
if(isset($_POST['add'])){
$sql = "insert into employee (SSN, FNAME, MINIT, LNAME, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNO) values
('{$_POST['ssn']}','{$_POST['firstName']}','{$_POST['minName']}','{$_POST['surName']}','{$_POST['birthDate']}','{$_POST['Address']}','{$_POST['Sex']}','{$_POST['Salary']}', '{$_POST['Superssn']}', '{$_POST['Dno']}')";
echo $sql;
mysqli_query($conn,$sql);
}
$sql = 'select * from employee';
$result = mysqli_query($conn, $sql);
$html = '<table border=1>';
while($array=mysqli_fetch_array($result)){
$html = $html .'<tr><td>'. $array['SSN'].'</td>'.'<td>'. $array['FNAME'].'</td>'.'<td>'. $array['MINIT'].'</td>'.'<td>'. $array['LNAME'].'</td>'.'<td>'. $array['BDATE'].'</td>'.'<td>'. $array['ADDRESS'].'</td>'.'<td>'. $array['SEX'].'</td>'.'<td>'. $array['SALARY'].'</td>'.'<td>'. $array['SUPERSSN'].'</td>'.'<td>'. $array['DNO'].'</td></tr>';
}
$html = $html . '</table>';
if(mysqli_num_rows($result)>0)
echo $html;
mysqli_close($conn);
?>
<form action="from.php" method="POST">
<table>
<tr><td>รหัสพนักงาน *</td><td><input type="text" name="ssn" maxlenth="9"/> </td></tr>
<tr><td>ชื่อ *</td><td><input type="text" name="firstName" maxlenth="15"/> </td></tr>
<tr><td>ชื่อกลาง </td><td><input type="text" name="minName" maxlenth="1"/> </td></tr>
<tr><td>นามสกุล *</td><td><input type="text" name="surName" maxlenth="15"/> </td></tr>
<tr><td>วันเกิด </td><td><input type="text" name="birthDate" maxlenth="15"/> </td></tr>
<tr><td>ที่อยู่</td><td> <textarea name="Address"></textarea></td><tr>
<td>เพศ</td><td> <input type="radio" name="Sex" value="M"/> ชาย <input type="radio" name="Sex" value="F"/> หญิง </td>
<tr><td>เงินเดือน</td><td> <INPUT TYPE='TEXT' NAME = "Salary" size="15" ></td></tr>
<tr><td>หัวหน้างาน </td><td><input type="text" name="Superssn" maxlenth="9"/> </td></tr>
<tr><td>แผนก *</td><td><input type="text" name="Dno" maxlenth="1"/></td></tr>
<tr><td colspan="2"><input type="submit" name="add" value="เพิ่ม"/></td></tr>
</table>
</form>
</body>
</html> 
