<?
include("config.php");
session_start();
if(!session_is_registered(user_name)) {
echo"<script>alert('กรุณาเข้าสู่ระบบ'); window.location='?p=login';</script>";
} else{
if($_SESSION[status] != "u2"){
echo"<script>alert('สถานะของคุณไม่มีสิทธิ์ใช้งานในหน้านี้'); window.location='index.php';</script>";
}
}
if($_POST[ok])
{
$Emp_no=$_POST[Emp_no];
$salary=$_POST[salary];
$sql="update emp set salary='$salary'
where Emp_no='$Emp_no' ";
mysql_db_query($dbname,$sql);
//echo $sql;
echo"<script>alert('[บันทึกข้อมูลแล้ว]'); window.location='?p=viewemp02';</script>";
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<style type="text/css">
<!--
.style4 {font-size: 9pt; font-weight: bold; }
-->
</style>
<div align="center">บันทึกเงินเดือน<br />
<br>
<?
$sql= "select * from emp ORDER by Emp_no asc ";
//$sql= "select emp_no,emp_name,salary,job,dept_name from emp inner join dept on emp.dept_no = dept.dept_no";
?>
<table width="793" border="0" cellspacing="0" cellpadding="3">
<?
$result = mysql_query($sql) ;
$Num_Rows = mysql_num_rows($result);
$Per_Page = 5;
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$sql .="LIMIT $Page_Start , $Per_Page";
$result = mysql_query($sql);
//จบ
while($row=mysql_fetch_array($result) )
{
$sql2 ="select * from dept where dept_no='".$row[dept_no]."'";
$result2=mysql_query($sql2);
$row2=mysql_fetch_array($result2);
$deptname=$row2[dept_no]." - ".$row2[dept_name];
?>
<tr>
<td width="144" height="32" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">รหัสพนักงาน</span></div></td>
<td width="187" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">ชื่อ-สกุล</span></div></td>
<td width="144" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">ตำแหน่ง</span></div></td>
<td width="156" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">แผนก</span></div></td>
<td width="132" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">เงินเดือน</span></div></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="Emp_no" id="Emp_no" value="<?=$row[Emp_no] ?>" disabled="disabled" /></td>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="Emp_name" id="Emp_name" value="<?=$row[Emp_name] ?>" disabled="disabled" /></td>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="job" id="job" value="<?=$row[job] ?>" disabled="disabled" /></td>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="dept_name" id="dept_name" value="<?=$row2[dept_name] ?>" disabled="disabled"/></td>
<td align="left" valign="top" bgcolor="#99FFFF">
<div align="center">
<input type="text" name="salary" id="salary" value="<?=$row[salary] ?>" size="15" />
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="5" align="left" valign="top" bgcolor="#333333"><div align="center">
<label></label>
<label>
<input type="submit" name="ok" id="ok" value="บันทึก">
</label>
</div></td>
</tr>
</table>
<p>จำนวนข้อมูล
<?= $Num_Rows;?>
ระเบียน :
<?=$Num_Pages;?>
หน้า :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?p=incentive04&Page=$Prev_Page'><< Back</a> ";
}
for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?p=incentive04&Page=$i'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?p=incentive04&Page=$Next_Page'>Next>></a> ";
}
?>
<br>
</p>
</div>
คลิกบันทึกแล้วไม่ไปครับ
include("config.php");
session_start();
if(!session_is_registered(user_name)) {
echo"<script>alert('กรุณาเข้าสู่ระบบ'); window.location='?p=login';</script>";
} else{
if($_SESSION[status] != "u2"){
echo"<script>alert('สถานะของคุณไม่มีสิทธิ์ใช้งานในหน้านี้'); window.location='index.php';</script>";
}
}
if($_POST[ok])
{
$Emp_no=$_POST[Emp_no];
$salary=$_POST[salary];
$sql="update emp set salary='$salary'
where Emp_no='$Emp_no' ";
mysql_db_query($dbname,$sql);
//echo $sql;
echo"<script>alert('[บันทึกข้อมูลแล้ว]'); window.location='?p=viewemp02';</script>";
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<style type="text/css">
<!--
.style4 {font-size: 9pt; font-weight: bold; }
-->
</style>
<div align="center">บันทึกเงินเดือน<br />
<br>
<?
$sql= "select * from emp ORDER by Emp_no asc ";
//$sql= "select emp_no,emp_name,salary,job,dept_name from emp inner join dept on emp.dept_no = dept.dept_no";
?>
<table width="793" border="0" cellspacing="0" cellpadding="3">
<?
$result = mysql_query($sql) ;
$Num_Rows = mysql_num_rows($result);
$Per_Page = 5;
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$sql .="LIMIT $Page_Start , $Per_Page";
$result = mysql_query($sql);
//จบ
while($row=mysql_fetch_array($result) )
{
$sql2 ="select * from dept where dept_no='".$row[dept_no]."'";
$result2=mysql_query($sql2);
$row2=mysql_fetch_array($result2);
$deptname=$row2[dept_no]." - ".$row2[dept_name];
?>
<tr>
<td width="144" height="32" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">รหัสพนักงาน</span></div></td>
<td width="187" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">ชื่อ-สกุล</span></div></td>
<td width="144" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">ตำแหน่ง</span></div></td>
<td width="156" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">แผนก</span></div></td>
<td width="132" align="left" valign="top" bgcolor="#99FFFF"><div align="center"><span class="style4">เงินเดือน</span></div></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="Emp_no" id="Emp_no" value="<?=$row[Emp_no] ?>" disabled="disabled" /></td>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="Emp_name" id="Emp_name" value="<?=$row[Emp_name] ?>" disabled="disabled" /></td>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="job" id="job" value="<?=$row[job] ?>" disabled="disabled" /></td>
<td align="left" valign="top" bgcolor="#99FFFF"><input type="text" name="dept_name" id="dept_name" value="<?=$row2[dept_name] ?>" disabled="disabled"/></td>
<td align="left" valign="top" bgcolor="#99FFFF">
<div align="center">
<input type="text" name="salary" id="salary" value="<?=$row[salary] ?>" size="15" />
</div></td>
</tr>
<?
}
?>
<tr>
<td colspan="5" align="left" valign="top" bgcolor="#333333"><div align="center">
<label></label>
<label>
<input type="submit" name="ok" id="ok" value="บันทึก">
</label>
</div></td>
</tr>
</table>
<p>จำนวนข้อมูล
<?= $Num_Rows;?>
ระเบียน :
<?=$Num_Pages;?>
หน้า :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?p=incentive04&Page=$Prev_Page'><< Back</a> ";
}
for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?p=incentive04&Page=$i'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?p=incentive04&Page=$Next_Page'>Next>></a> ";
}
?>
<br>
</p>
</div>