一、数据库添加信息,这里主要展示html页面表单数据将信息提交过来到php文件部分,代码截图如下:
代码如下:要注意写对config.php的引用路劲,这是dedecms系统封装好的写法,和php原生语法不一样,当然这里也可以直接书写php原生语法格式。
require_once(dirname(__FILE__)."/config.php");
$userid = $_POST["userid"];
$usertype = $_POST["usertype"];
$contract_no = $_POST["contract_no"];
$contrack_time = $_POST["contrack_time"];
$cause = $_POST["cause"];
$nature = $_POST["nature"];
$type = $_POST["type"];
$point = $_POST["point"];
$stage = $_POST["stage"];
$lawyer = $_POST["lawyer"];
$lawyerone = $_POST["lawyerone"];
$price = $_POST["price"];
$netprice = $_POST["netprice"];
$owe = $_POST["owe"];
$textpiont = $_POST["textpiont"];
$efftime = $_POST["efftime"];
$time = date('Y-m-d H:i:s');
if($userid && $usertype){
$sql="INSERT INTO dede_letters(id,userid,usertype,contract_no,contrack_time,cause,nature,type,point,stage,lawyer,lawyerone,price,netprice,owe,textpiont,efftime,time) VALUES ('$id','$userid','$usertype','$contract_no','$contrack_time','$cause','$nature','$type','$point','$stage','$lawyer','$lawyerone','$price','$netprice','$owe','$textpiont','$efftime','$time')";
$dsql->ExecuteNoneQuery($sql);