log.php

开源的 库存管理系统 www.minierp.cn php+ mysql

<?php
require("../inc/minifun.php");
function operlogin($uid,$conn){
$m_tablename="log";

$ip=getip();
$FIELDSTR  =" LOGID = 'IN',";
$FIELDSTR .=" LOG01 ='$uid',";
$FIELDSTR .=" LOG02 ='$ip',";
$FIELDSTR .=" DT999 = now()  ";


 	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
	
	$uSql  = "INSERT INTO $m_tablename set  ";
	$uSql .=$FIELDSTR;

$rs   = phpmkr_query($uSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $uSql);
}

function operlogout($uid,$conn){
$m_tablename="log";
$ip=getip();
$FIELDSTR  =" LOGID = 'OUT',";
$FIELDSTR .=" LOG01 ='$uid',";
$FIELDSTR .=" LOG02 ='$ip' ,";
$FIELDSTR .=" DT999 = now()  ";


 	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
	
	$uSql  = "INSERT INTO $m_tablename set  ";
	$uSql .=$FIELDSTR;
//echo $uSql;
$rs   = phpmkr_query($uSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $uSql);
}
?>