如何将提交时间写入数据库?
除了将name/email/phone写入"feedback"表外,我还想把提交时间(当前时间)写入表的"date"字段中.
不知如何实现,请帮忙!谢谢!
以下是现有执行代码:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("database.mdb")
name=request.form("name")
email=request.form("email")
phone=request.form("phone")
exec="insert into feedback(name,email,phone)values('"+name+"','"+email+"','"+phone+"')"
conn.execute exec
conn.close
set conn=nothing
'response.write "success!"
%>