// ***********************
// 詢價清單執行程序
// ***********************
if(!isset($_SESSION)){
session_start();
}
require_once('Connections/connbenico.php');
include_once('include/function.php');
//刪除處理
if(isset($_GET['pid'])AND isset($_SESSION['inq_session']) AND $_GET['act']=="del"){
$deleteSQL = sprintf("DELETE FROM tbinquiry WHERE inq_pid=%s AND inq_session=%s",
GetSQLValueString($_GET['pid'], "int"),
GetSQLValueString($_SESSION['inq_session'], "int"));
mysql_select_db($database_connbenico, $connbenico);
$Result1 = mysql_query($deleteSQL, $connbenico) or die(mysql_error());
echo "";
exit;
}
/*
else{
echo "";
exit;
}
*/
//判斷
if(!isset($_GET['pid'])AND !isset($_GET['act'])){
//header("Content-type: text/html; charset=utf-8");
echo "";
exit;
}
//設定SESSION
if(!isset($_SESSION['inq_session'])){
$_SESSION['inq_session'] = date('YmdHis');
$inq_session = $_SESSION['inq_session'];
}else{
$inq_session = $_SESSION['inq_session'];
}
//執行新增
if(isset($_SESSION['inq_session']) AND isset($_GET['pid']) AND isset($_GET['act'])){
$insertSQL = sprintf("INSERT INTO tbinquiry (inq_pid, inq_session, inq_date, inq_ip) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_GET['pid'], "text"),
GetSQLValueString($inq_session, "text"),
GetSQLValueString(date('Y-m-d H:i:s'), "date"),
GetSQLValueString($_SERVER["REMOTE_ADDR"], "text"));
mysql_select_db($database_connbenico, $connbenico);
$Result1 = mysql_query($insertSQL, $connbenico) or die(mysql_error());
//已加入詢價清單
echo "";
exit;
}
?>