Viewing file: InsertOilSave.php (2.94 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if (! session_is_registered("valid_user") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../includes/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//### รับค่าจาก Form
/** Receive values */
$Mile_start = trim( $_POST['Mile_start'] );
$Mile_finish = trim( $_POST['Mile_finish'] );
$Lish_start = trim( $_POST['Lish_start'] );
$Lish_finish = trim( $_POST['Lish_finish'] );
$Price_start = trim ( $_POST['Price_start'] );
$Price_finis = trim( $_POST['Price_finish'] );
$Num_start = trim( $_POST['Num_start'] );
$Num_finish = trim( $_POST['Num_finish'] );
$Teacher_code = trim( $_POST['Teacher_code'] );
/** Table --> */
$Num_Mile = $Mile_finish - $Mile_start ;
$Num_Lish = $Lish_finish - $Lish_start ;
//### user_tb
$checkid = 0;
$sql11 = " Select * From autocar_tb ";
$result11 = mysql_query($sql11);
while ($rs11 = mysql_fetch_array($result11)){
if ($rs11["carId"] == $carId){
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<script>alert('รหัสข้อมูลพื้นฐานมีการใช้งานอยู่แล้ว');</script>";
echo "<script>window.opener.document.all.myForm; window.opener.location.reload(); window.close();</script>";
exit();
}else{
$checkid = 1;
}
}
if ($check == 0){
}
InsertOil( $carId , $CarmoId, $Mile_start , $Mile_finish , $Num_Mile, $Num_Lish , $Lish_start , $Price_start , $Num_start ,$Lish_finish , $Price_finish , $Num_finish , $Teacher_code );
// } # else
$dbObj->disconn();
unset($dbObj);
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<script>alert('บันทึกข้อมูลเรียบร้อยแล้ว');</script>";
echo "<script>window.opener.document.all.myForm; window.opener.location.reload(); window.close();</script>";
exit();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>Edit Password</title>
<link href="../css/default.css" rel="stylesheet" type="text/css" />
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
</body>
</html>
|