mysql字段类型为int默认null,插入却显示0的解决办法,参考php代码

最新推荐文章于 2024-05-10 23:52:43 发布

hai7425

最新推荐文章于 2024-05-10 23:52:43 发布

阅读量8k

点赞数 1

分类专栏： mysql 通达OA php学习研究文章标签： php mysql null 0 int

本文链接：https://blog.csdn.net/hai7425/article/details/51791666

版权

通达OA 同时被 3 个专栏收录

108 篇文章 14 订阅

订阅专栏

php学习研究

107 篇文章 2 订阅

订阅专栏

mysql

19 篇文章 0 订阅

订阅专栏

<?
include_once("inc/auth.inc.php");
include_once("inc/utility.php");
include_once("inc/utility_file.php");

include_once("inc/utility_sms1.php");
include_once("inc/utility_sms2.php");

include_once("inc/utility_org.php");



$HTML_PAGE_TITLE = _("新建");
include_once("inc/header.inc.php");
?>




<body class="bodycolor" style="font-family:微软雅黑,宋体">

<?
$field1=$_POST["field1"];
$field2=$_POST["field2"]; if($field2!="") { $field2=strtotime($field2); }  else { $field2="NULL";}
$field3=$_POST["field3"];
$field4=$_POST["field4"];
$field5=$_POST["field5"];
$field6=$_POST["field6"]; if($field6!="") { $field6=strtotime($field6);  }  else { $field6="NULL";}

$field7=$_POST["field7"];
$field8=$_POST["field8"];
$field9=$_SESSION["LOGIN_USER_ID"];
$field9_text=$_SESSION["LOGIN_USER_NAME"];
$field10=time();
$field11=$_POST["field11"];
$field12=$_POST["field12"];
$TO_ID_SMS_MAOJIN=$_POST["TO_ID_SMS_MAOJIN"];
$TO_ID_SMS_CAIWU=$_POST["TO_ID_SMS_CAIWU"];

$sql2="select u.USER_ID,u.USER_NAME,u.DEPT_ID,d.DEPT_NAME from user u join department d on u.DEPT_ID=d.DEPT_ID where u.USER_ID='".$field9."'";
	$cursor2 = exequery(TD::conn(),$sql2);
  	$ROW_USER=mysql_fetch_array($cursor2);
	$shenqingrenid=$ROW_USER["USER_ID"];//用户账号
	$shenqingrenxm=$ROW_USER["USER_NAME"];//用户姓名
	$DEPT_ID=$ROW_USER["DEPT_ID"];//部门ID
	$DEPT_NAME=$ROW_USER["DEPT_NAME"];//部门名称
	$c_time=strtotime(date("Y-m-d H:i:s"));//当前时间


//------------------- 新建文件 -----------------------
//$query="INSERT INTO `TD_OA`.`crm_module_8` ( `field1`, `create_man`, `create_man_text`, `create_time`, `update_man`, `update_man_text`, `update_time`, `owner`, `owner_dept`, `create_dept`, `create_dept_text`, `deleted`, `share_man`, `share_op`, `field2`, `field3`, `field4`, `field5`, `field6`, `field7`, `field8`, `field9`, `field10`, `field11`, `field12`,  `field9_text`,) VALUES ('$field1',  '$field9', '$shenqingrenxm', '$c_time', '$field9', '$shenqingrenxm', '$c_time', '$field9', '$DEPT_ID', '$DEPT_ID', '$DEPT_NAME', '0', NULL, NULL,'$field2', '$field3', '$field4', '$field5', '$field6', '$field7', '$field8', '$field9', '$field10', '$field11', '$field12', '$field9_text')";
$query="INSERT INTO `TD_OA`.`crm_module_8` ( `field1`, `create_man`, `create_man_text`, `create_time`, `update_man`, `update_man_text`, `update_time`, `owner`, `owner_dept`, `create_dept`, `create_dept_text`, `deleted`, `share_man`, `share_op`, `field2`, `field3`,`field4`, `field5`,`field6`,`field7`,`field8`,`field9`,`field9_text`,`field10`,`field11`,`field12`) VALUES ('$field1',  '$field9', '$shenqingrenxm', '$c_time', '$field9', '$shenqingrenxm', '$c_time', '$field9', '$DEPT_ID', '$DEPT_ID', '$DEPT_NAME', '0', NULL, NULL,".$field2.",'$field3','$field4','$field5',".$field6.",'$field7','$field8','$field9','$field9_text','$field10','$field11','$field12')";
//echo $query."<br>";
//exit;
exequery(TD::conn(),$query);

$id=mysql_insert_id();

    $from_id=$_SESSION["LOGIN_USER_ID"];
	$content_sms="新建业务进度日志提醒：";
if($field1!=""){
	 $content_sms.="合同号：".$field1."；"; }
if($field3!=""){
	 $content_sms.="船名：".$field3."；"; }		 
	// $REMIND_URL1="yewurizhi/manage/modify1.php?id=".$id;
	 $REMIND_URL2="yewurizhi/manage/modify2.php?id=".$id;
	 $REMIND_URL3="yewurizhi/manage/modify3.php?id=".$id;
	 $SEND_TIME=date("Y-m-d H:i:s");
	 send_sms($SEND_TIME,$from_id,$TO_ID_SMS_MAOJIN,0,$content_sms,$REMIND_URL2);//0是系统提醒
	 send_sms($SEND_TIME,$from_id,$TO_ID_SMS_CAIWU,0,$content_sms,$REMIND_URL3);

   	Message("提示：",_("业务进度日志新建成功！"));
   

?>
<center>
		<input type="button" class="BigButton" value="<?=_("返回")?>" onClick="window.location.href='new.php'"/>
</center>
</body>
</html>

hai7425

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
打赏
0
评论
mysql字段类型为int默认null,插入却显示0的解决办法,参考php代码

<?include_once("inc/auth.inc.php");include_once("inc/utility.php");include_once("inc/utility_file.php");include_once("inc/utility_sms1.php");include_once("inc/utility_sms2.php");include_once("
复制链接

扫一扫