Viewing file:  FrmEdit.php (11.52 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
if (session_is_registered("valid_user"))
{
$Username = $valid_user;
include("../../include/FunctionDB.php");
include("../../include/Function.php");
include("admin_menu.php");
include("../../source/myFunc.php");
ConnectDB();
$sql ="SELECT * FROM bookmant_tb Where code='$code' and Year='$Year' ";
$result = mysql_query($sql) or die("Cannot Select").mysql_error();
$rs = mysql_fetch_array($result);
?>
<script language="javascript" src="js/calendarDateInput2.js"></script>
<script language="JavaScript" type="text/JavaScript">
<!--
function browse()
{
form1.Imag1.src = form1.Img1.value;
}
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
function chk(c){
if (c.checked){
document.all.Prob1.disabled=false;
document.all.Prob2.disabled=false;
document.all.Prob3.disabled=false;
document.all.Prob4.disabled=false;
}
else{
document.all.Problem.disabled=false;
}
}
</script>
<table width="842" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><br><fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="../menu_teacher.php" >˹éÒËÅÑ¡</a> <img src="../../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="BookByYear.php?Book_code=1">¢éÍÁÙÅ˹ѧÊ×ÍÃÒª¡ÒÃÃѺ</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><img src="../../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />á¡é䢢éÍÁÙÅ˹ѧÊ×ÍÃѺ-Êè§</font></legend>
<label><div align="center">
<form id="form" name="form" method="post" action="EditMan.php" enctype="multipart/form-data">
<p align="left"><font size="2" face="Tahoma"><img src="../../picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></p>
<table width="68%" border="0" align="center" cellpadding="0" cellspacing="1" style="border:1px solid gray">
<tr bgcolor="#CCCCFF" >
<td height="25" colspan="3" bgcolor="#eeeeee"><div align="center"><font color="#000000" size="4" face="Tahoma"><strong><font color="#FF0000">á¡éä¢</font> ¢éÍÁÙÅ</strong></font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td width="26%" height="22" bgcolor="#eeeeee"><div align="center" class="style3"><font size="2" face="Tahoma">ª¹Ô´¢Í§Ë¹Ñ§Ê×Í</font></div></td>
<td width="2%" bgcolor="#eeeeee"> </td>
<td width="72%" bgcolor="#eeeeee"><font color="#006633" size="2" face="Tahoma">
<input type="radio" name ="Book_code" <?php if (!(strcmp("$rs[Book_code]","1"))){echo "checked";} ?> value="1">
˹ѧÊ×ÍÃѺ
<input type="radio" name="Book_code" <?php if (!(strcmp("$rs[Book_code]","2"))){echo "checked";} ?> value="2">
˹ѧÊ×ÍÊè§</font>
<label> </label></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">àÅ¢·Õè·ÐàºÕ¹ÃѺ</font></div></td>
<td bgcolor="#eeeeee"> </td>
<td bgcolor="#eeeeee"><input name="No" type="text" id="No" value="<? echo $rs[No]?>" size="10" /> <font color="#006633" size="2" face="Tahoma">»Õ§º»ÃÐÁÒ³ </font>
<select name="Year" id="Year">
<option value="" <?php if($rs['Year']==""){ echo "selected" ; } ?>>àÅ×Í¡</option>
<option value="2551"<?php if($rs['Year']=="2552"){ echo "selected" ; } ?>>2552</option>
<option value="2551"<?php if($rs['Year']=="2551"){ echo "selected" ; } ?>>2551</option>
<option value="2550"<?php if($rs['Year']=="2550"){ echo "selected" ; } ?>>2550</option>
<option value="2549"<?php if($rs['Year']=="2549"){ echo "selected" ; } ?>>2549</option>
</select></td>
</tr>
<tr bordercolor="#006699" bgcolor="#99CCFF">
<td bgcolor="#eeeeee"><div align="center"><font color="#000000" size="2" face="Tahoma">Çѹ/à´×͹/»Õ</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">*</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><!--<font color="#000000" size="2" face="Tahoma">
<select name="mDate" id="mDate" class="select" >
<?php/*
$Date_note = $rs[Date_note];
$yearthai = explode("-",$Date_note);
$mDate = intval($yearthai[2]);
$mMonth = intval($yearthai[1]);
$mYear = intval($yearthai[0]);
for($i=0;$i<=31;$i++)
{
if( $i == 0)
echo"\n\t<option value=\"$mDate\" selected>$mDate</option>\n ";
else
echo"\n\t<option value=\"$i\">$i</option>\n ";
}
// getDay1to31();*/
?>
</select>
<select name="mMonth" id="select3" class="select" >
<?php/*
$Date_buy = $rs[Date_buy];
$yearthai = explode("-",$Date_buy);
$mDate= intval($yearthai[2]);
$Month = intval($yearthai[1]);
$mYear = intval($yearthai[0]);
$mMonth = $Month;
$CMonth = TxtThaiMonth($Month);
for($i=-1;$i<=11;$i++)
{
$a = $i+1;
if( $a == 0)
echo"\n\t<option value=\"$mMonth\" selected>$CMonth</option>\n ";
else
echo"\n\t<option value=\"$a\">$ThaiMonth[$i]</option>\n ";
}
// getThaiMonth();*/
?>
</select>
<input name="mYear" type="text" class="input" id="mYear" value="<? //echo $mYear ?>" size="5" maxlength="4" />
</font><font size="2" face="Tahoma"> </font>-->
<script>DateInput('date', true, 'DD/MM/YYYY','<?php echo ymdT2dmyE($rs['Date_buy']);?>');</script> </td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">àÅ¢·Õè˹ѧÊ×ÍÃѺ</font></div></td>
<td bgcolor="#eeeeee"><div align="center"><font color="#FF0000" size="4" face="Tahoma"><strong>*</strong></font></div></td>
<td bgcolor="#eeeeee"><font color="#006633" size="2" face="Tahoma">
<input name="No_in" type="text" id="No_in" value="<? echo $rs[No_in]?>" size="30" />
</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">àÃ×èͧ</font></div></td>
<td bgcolor="#eeeeee"><div align="center"><font color="#FF0000" size="4" face="Tahoma"><strong>*</strong></font></div></td>
<td bgcolor="#eeeeee"><strong><font color="#003366" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma">
<textarea name="Status" cols="50" rows="4" id="Status"><? echo $rs[Status]?></textarea>
</font><font color="#003366" size="2" face="Tahoma"> </font></strong></td>
</tr>
<tr bgcolor="#EEEEEE">
<td bgcolor="#eeeeee"><div align="center" class="style3"><font size="2" face="Tahoma">˹èǧҹ /½èÒ </font> </div></td>
<td bgcolor="#eeeeee"> </td>
<td bgcolor="#eeeeee"><strong><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<select name="Faculty_code" class="input1" id="Faculty_code">
<?php
$Faculty_code= $rs[Faculty_code];
$strSQL1 = "SELECT * FROM faculty_tb Where Faculty_code='$Faculty_code' ";
$result1 = mysql_query($strSQL1);
$strSQL2 = "SELECT * FROM faculty_tb Order By Faculty_name ";
$result2 = mysql_query($strSQL2);
while( $rs1 = mysql_fetch_array($result1))
{
echo"<option value=\"$rs1[Faculty_code]\" ><b>$rs1[Faculty_name]</b></option>\n";
while( $rs2 = mysql_fetch_array($result2))
{
echo"<option value=\"$rs2[Faculty_code]\" ><b>$rs2[Faculty_name]</b></option>\n";
}
}
CloseDB();
?>
</select>
</font></strong></td>
</tr>
<tr bgcolor="#EEEEEE">
<td bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font size="2">µéͧ¡ÒÃá¨é§ºØ¤ÅÒ¡Ã·Ø¡æ ¤¹</font> </font></div></td>
<td bgcolor="#eeeeee"><font color="#FF0000" size="4" face="Tahoma"><strong>*</strong></font></td>
<td bgcolor="#eeeeee"><font size="2" face="Tahoma">
<input type="radio" name="Statistic" <?php if (!(strcmp("$rs[Statistic]","á¨é§"))){echo "checked";} ?> value="á¨é§" />
á¨é§
<input type="radio" name="Statistic" <?php if (!(strcmp("$rs[Statistic]","äÁèá¨é§"))){echo "checked";} ?> value="äÁèá¨é§" />
äÁèá¨é§<strong><font color="#003366" size="2" face="Tahoma"> </font></strong> </font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">˹èǧҹ</font></div></td>
<td bgcolor="#eeeeee"><div align="center"><font color="#FF0000" size="4" face="Tahoma"><strong>*</strong></font></div></td>
<td bgcolor="#eeeeee"><input name="Store_1" type="text" class="input" id="Store_1" value="<? echo $rs[Store_1]?>" size="50" /> </td>
</tr>
<tr bordercolor="#99CCFF">
<td bgcolor="#eeeeee"><div align="center"><font color="#003366" size="2" face="Tahoma">âËÅ´àÍ¡ÊÒà </font></div></td>
<td bgcolor="#eeeeee"> </td>
<td bgcolor="#eeeeee"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="73%"><div align="center"> <font color="#996600" size="2" face="Tahoma"></font>
<input name= "Img1" type="file" class="input" id="Img1" size="20" value=" <? echo $rs[Img1]?>"/>
</div></td>
<td width="27%"><div align="center"></div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#CCCCFF" >
<td height="25" colspan="3" bgcolor="#eeeeee"><div align="center">
<input name="code" type="hidden" id="code" value="<? echo $rs[code]?>" />
<input type="submit" name="Submit" value="á¡éä¢" class="button" />
</div></td>
</tr>
</table>
<br>
</form>
</div>
</label>
</fieldset><br>
<font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>ËÁÒÂà赯 :</b> ãªéàÁÒÊì¤ÅÔ¡<br>
</font></td>
</tr>
</table>
<?php
}
else
{
echo"<meta http-equiv=\"refresh\" content=\"3;URL=FrmLogin.php\">\n";
echo"Please Login ";
}
?>
|