php获取时间插入到数据库,将datetime插入数据库PHP

将date(type：datetime)插入数据库时​​遇到一些困难.

无论我放在那里,它都会引发关于日期格式的语法错误等.有人可以帮助我吗？

DB::insert('INSERT INTO hidden_authors (e_user = ? AND h_user = ? AND h_change_time = ?)', array($userBanId, $id, date(Y-m-d H:i:s) ));

我已经尝试过使用sql getdate()但它也给了我一个错误.

解决方法:

Error Because of missing " inside date() function.

将此更改为

date(Y-m-d H:i:s)

这个

date("Y-m-d H:i:s")

所以最终的Well Form代码应该是

DB::insert('INSERT INTO hidden_authors (e_user = ? AND h_user = ? AND h_change_time = ?)',array($userBanId, $id, date("Y-m-d H:i:s")));

Tip For Your Code:

Without add exact function in query, assign that to variable and call it to your query

示例：

$date = date("Y-m-d H:i:s");

所以里面的查询

DB::insert('INSERT INTO hidden_authors (e_user = ? AND h_user = ? AND h_change_time = ?)',array($userBanId, $id, $date));

So when you read that insert function you can get clear idea about

what you did?

what you need to do?

where is the error??

Its simply point all of these questions

标签：php,mysql,date,insert,laravel

来源： https://codeday.me/bug/20190717/1488827.html