做dedecms的二次開發(fā)中間需要很多用sql語句來根據(jù)需要整合新的功能和頁面，先將內(nèi)容付下，搜外首發(fā)：）

列表顯示用法

$dsql->SetQuery("SELECT * FROM dede_payment WHERE enabled='1' ORDER BY rank ASC");

$dsql->Execute();

$i = 0 ;

while($row = $dsql->GetArray())

{

$row['disabled'] = ($row['id'] == 5) && ($cfg_ml->M_Money < $priceCount) ? ' disabled="disabled"' : '';

$shops_paymentarr[] = $row;

$i++;

}

此方法在無法直接用在member目錄下的htm模板內(nèi)，下面的方法比較適用所有能適用php語法的環(huán)境

$dsql->Execute('fl',"SELECT a.id,a.title,a.litpic,b.price,b.jdxj from hw_archives a left join hw_addonshop30 b on a.id=b.aid where $addsql limit $offset,$pagesize");

while($rowa = $dsql->GetArray('fl'))

{

}

DELETE刪除用法

//不能刪除id為1的創(chuàng)建人帳號，不能刪除自己

$rs = $dsql->ExecuteNoneQuery2("DELETE FROM `dede_admin` WHERE id='$id' AND id<>1 AND id<>'".$cuserLogin->getUserID()."' ");

select查詢用法

$sql = "select *

FROM `hw_shops_orders` where gys='$mid' $addsql and state='0'";

$row = $dsql->GetOne($sql);

UPDATE更新用法

$query = "UPDATE `dede_member` SET uname='$uname',email='$email'$pwdm WHERE mid='$id'";

$dsql->ExecuteNoneQuery($query);

ShowMsg("成功更改一個帳戶！", "sys_admin_user.php");

exit();

插入新紀錄的方法

$query = "

INSERT INTO dede_myad(clsid,typeid,tagname,adname,timeset,starttime,endtime,normbody,expbody)

VALUES('$clsid','$typeid','$tagname','$adname','$timeset','$starttime','$endtime','$normbody','$expbody');

";

$dsql->ExecuteNoneQuery($query);

ShowMsg("成功增加一個廣告！","ad_main.php");

exit();