dongliming2416 2012-02-20 20:56
浏览 62

php mysql查询不发送要插入的日期和时间类型null

I looked at similar questions but I can't solve the problem. I have 2 different columns with types date and time in MySql. I use explode to split date from time. The split code is the following ;

$task_date_time = $data['task_date_time'];

if($task_date_time != "")
    $date_time = explode(" ", $task_date_time); // split according to the delimiter
    $task_date = $date_time[0];         
    $task_time = $date_time[1];         
    $task_date = NULL;
    $task_time = NULL;          

After that, I am calling the php function that inserts this variables to MySQL database. My query inside the data function is the following ;

$query = "call insertProcedure(...some variables...,  ".$task_date.", ".$task_time.")";

However, query gives the following error ;

Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':48)' at line 1
  • The ':48)' field corresponds to minute field of time type.

Notes :

1) I also tried the query string below. it doesn't work either

$query = "call insertProcedure(...some variables...,  '".$task_date."', '".$task_time."')";

2) $task_date and $task_time are nullable in MySQL database.

Any ideas ? Solutions ?

  • 写回答

3条回答 默认 最新

  • douyong1850 2012-02-20 21:06

    When it should be NULL:

    $task_date = 'NULL';
    $task_time = 'NULL';

    You're setting the variables to NULL, which when cast to a string will produce an empty string. And mysql fails to parse it.

    If you set the variables to the string 'NULL' mysql will correctly set the columns to be NULL

    And when it should have a real value, the date and time need to be surrounded by quotes. e.g.:

    $task_date = "'".$date_time[0]."'";         
    $task_time = "'".$date_time[1]."'";     
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥60 如图:直线与椭圆X轴平行,求直线与椭圆任意一点的相切坐标计算公式
  • ¥50 如何用python使用opencv里的cv::cudacodec::VideoWriter函数对视频进行GPU硬编码
  • ¥100 c#solidworks 二次开发 工程图自动标边线法兰 等折弯尺寸怎么标
  • ¥15 halcon DrawRegion 提示错误
  • ¥15 FastAPI Uvicorn启动显示404
  • ¥15 centos7.9脚本,怎么排除特定的访问记录
  • ¥15 关于#Django#的问题:我的静态文件呢?
  • ¥15 关于CPLEX的问题,请专家解答
  • ¥15 cocos的点击事件 怎么穿透到 原生fragment上。
  • ¥20 基于相关估计的TDOA算法中的加权最小二乘拟合法matlab仿真