mlogget.inc 1.1 KB
<?PHP 

// 送信Logを保存する
// 
// 戻り値 成功=True 失敗=False
function func_LogInput($angou,$logFrom,$logTo,$logType,$logDate,$intCountLog){

	$res = "True";

	$hostname="localhost";
	$database="post_kanri";
	 
	if( !$pg_con2=pg_connect("host=$hostname dbname=$database user=pgsqladmin password=pgsqladmin") ) {
		print "Error : connect to ${hostname}<br>";
		exit;
	}

	//表示名称を取得
	$strSQL = "SELECT user_id " .
	          "FROM mst_kanri " .
	          "WHERE angou = '".$angou."'";
	$objRecSet = pg_exec($pg_con2,$strSQL);
	if($objRecSet==false){
	    $res = "False";
	}
	if(pg_numrows($objRecSet)!=0){
		$objRecData = pg_fetch_object($objRecSet, 0);
		$user_id = $objRecData->user_id;
	}

	for($i=0;$i<$intCountLog;$i++){
		if($logTo[$i]!=""){
			$strSQL = "Insert into  send_history_tbl ".
					"(user_id,from_mail,to_mail,send_time,send_type) VALUES ".
					"('".$user_id."',".
					"'".$logFrom[$i]."',".
					"'".$logTo[$i]."',".
					"'".$logDate[$i]."',".
					$logType[$i]."".
					")";
			$objRecSet = pg_exec($pg_con2,$strSQL);
			if($objRecSet==false){
			    $res = "False";
			}
		}
	}
	return $res;
}
?>