addact.html dbconnect(); projects = database.cursor("SELECT * FROM project ORDER BY projectname") if(request.add) { if(request.mm2 != "" && request.dd2 != "" && request.yy2 != "") { var duedate ="'" + request.mm2 + "/" + request.dd2 + "/" + request.yy2 + "'" } else { var duedate = "null" } var opendate = request.mm1 + "/" + request.dd1 + "/" + request.yy1 database.execute("INSERT INTO actionitems (projectname, actionitem, requester, owner, duedate, opendate) VALUES ('" + request.projectname + "', '" + request.actionitem + "', '" + request.requester + "', '" + request.owner + "', " + duedate + ", '" + opendate + "')") redirect("projact.html?project=" + escape(request.projectname)); }

業務內容新增
專案名稱*
行動項目
內容
需求提出者
執行者
起始日期* / / (例如 8/7/1996)
要求完成日期 / / (例如 8/20/1996)

* 表示為必須輸入之欄位