dedecms数据库操作

首先引入common.inc.php文件，require_once (dirname(__FILE__) . “/include/common.inc.php”);

查找一个表的所有数据

$sql=”select * from dede_”;
$dsql->SetQuery($sql);//将sql查询格式化
$dsql->Execute();//执行sql操作
while($row = $dsql->GetArray()) {
$result[] = $row;

}

获取一条

$exist = “select * from dede_ where “;
$rexist=$dsql->GetOne($exist);

将查询总数输出

$row = $dsql->GetOne(‘select count(*) as dd where ‘)

echo $row[‘dd’];

插入一条数据

$sql = “INSERT INTO `dede_`(flow_code,addtime) VALUES (‘$flow_code’,’$addtime’)”;//插入记录数据库
$dsql->ExecuteNoneQuery($sql);//执行SQL操作
$gid = $dsql->GetLastID();//获取刚刚插入的id

修改一条

$upquery = ” update dede_ set data=’$data’,addtime=’$time’ where “;

$rslt = $dsql->ExecuteNoneQuery($upquery);//返回bool类型

删除一条

$sql = “Delete From dede_member_flink where aid=’$aid’ And mid='”.$cfg_ml->M_ID.”‘;”;
$dsql->SetQuery($sql);
$dsql->ExecNoneQuery();