السلام عليكم
اخواني انا سويت سكربت شؤؤن الموظفين
ولكن ناقص لي وضع كود إضافة الغياب
فكرة إضافة الكود --
مثلاً انا عندي اسماء موظفين لقد عملت كود التعديل على البيانات ولكن كيف اضيف الغياب بحيث كل ما غاب الموظف اسجل اليوم و التاريخ
و عند الإستعراض ايضاً
هذا هو كود الإستعراض بدون الغياب طبعاً
Bro.php
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="mm"; // Database name
$tbl_name="staff"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// get value of id that sent from address bar
$id=$_GET['id'];
// Retrieve data from database
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
?>
<html dir="rtl">
<head>
<title>.....</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256" />
<style type="text/css"/>
body {
font-family : Verdana;
}
</style>
</head>
<body>
<table width="380" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<form name="form1" method="post" action="update_ac.php">
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td colspan="3"><strong>
<img border="0" src="adminarfaleh/FALEH1_35.jpg" width="327" height="87"></strong></td>
</tr>
<tr>
<td width="414" colspan="3">
<p align="center"><font style="font-size: 14pt" face="Times New Roman">.....</font></td>
</tr>
<tr>
<td width="108"> </td>
<td width="5"></td>
<td width="321"> </td>
</tr>
<td width="108"><font face="Times New Roman"><b>......</b></font></td>
<td></td>
<td width="321"><font face="Times New Roman"><input name="realname" type="text" id="realname" size="30"></font></td>
</tr>
<tr>
<td width="108"><font face="Times New Roman"><b>.....</b></font></td>
<td></td>
<td width="321"><font face="Times New Roman"><input name="name" type="text" id="name" size="30"></font></td>
</tr>
<tr>
<td><font face="Times New Roman"><b>.......</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="email" type="text" id="email" size="30"></font></td>
</tr>
<tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="numberoffic" type="text" id="numberoffic" size="30"></font></td>
</tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="mobiel" type="text" id="mobiel" size="30"></font></td>
</tr>
</tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="othermobiel" type="text" id="othermobiel" size="30"></font></td>
</tr>
<tr>
<td width="414" colspan="3"> </td>
</tr>
<tr>
<td width="414" colspan="3">
<p align="center"><font face="Times New Roman"><span style="font-size: 14pt">....</span></font></td>
</tr>
<tr>
<td width="108"> </td>
<td width="5"></td>
<td width="321"> </td>
</tr>
<td width="108"><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td width="321"><font face="Times New Roman"><input name="secstaff" type="text" id="secstaff" size="30"></font></td>
</tr>
<tr>
<td width="108"><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td width="321"><font face="Times New Roman"><input name="jobname" type="text" id="jobname" size="30"></font></td>
</tr>
<tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="greed" type="text" id="greed" size="30"></font></td>
</tr>
<tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="date" type="text" id="date" size="30"></font></td>
</tr>
<tr>
<td width="414" colspan="3"> </td>
</tr>
<tr>
<td width="414" colspan="3">
<p align="center"><font face="Times New Roman"><span style="font-size: 14pt">.... </span>
</font> </td>
</tr>
<tr>
<td width="108"> </td>
<td width="5"></td>
<td width="321"> </td>
</tr>
<td width="108"><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td width="321"><font face="Times New Roman"><input name="moahki" type="text" id="moahki" size="30"></font></td>
</tr>
<tr>
<td width="108"><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td width="321"><font face="Times New Roman"><input name="moahname" type="text" id="moahname" size="30"></font></td>
</tr>
<tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="staffstude" type="text" id="staffstude" size="30"></font></td>
</tr>
<tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="grad" type="text" id="v" size="30"></font></td>
</tr>
<tr>
<td><font face="Times New Roman"><b>....</b></font></td>
<td></td>
<td><font face="Times New Roman"><input name="othermoah" type="text" id="othermoah" size="30"></font></td>
</tr>
<tr>
<td> </td>
<td><input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>"></td>
<td align="center"><input type="submit" name="Submit" value="تعديل البيانات"></td>
<td> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>
<?
// close connection
mysql_close();
?>
أرجو المساعدة
وسيتم وضع السكربت كامل و مجاناً بعد الإنتهاء