数据库

• 新增db.class.php调用 使用全部方法,需要以对象方式调用
  https://www.kancloud.cn/logoove/we7/678561

require_once(DEDEINC.'/Db.class.php');
$db = new Db($GLOBALS['cfg_dbhost'],$GLOBALS['cfg_dbuser'],$GLOBALS['cfg_dbpwd'],'3306',$GLOBALS['cfg_dbname'],$GLOBALS['cfg_dbprefix']);

• 单条数据

global $dsql;
$row = $dsql->GetOne("SELECT * FROM hx_arctype WHERE id= $id");

新写法
global $db;
$row =$db->get('arctype',array('id'=>$id));

• 多条数据

$sql = "Select * from #@__arctype";
$dsql->SetQuery($sql);
$dsql->Execute();
while($row = $dsql->GetArray()){
$row1[]= ['id'=>$row['id'],'typename'=>$row['typename']];
}
$n= $dsql->GetTotalRow();  总记录数

新写法
global $db;
$db->getall('arctype');

• 插入删除修改

 $sql = "insert into hx_arctype (typename) VALUES ('测试')";
$dsql->ExecNoneQuery($sql);
$id = $dsql->GetLastID();插入id

$sql = "delete from hx_arctype where id=12";
$dsql->ExecNoneQuery($sql);

$sql = "update hx_arctype set typename='12' where id=13";
$dsql->ExecNoneQuery($sql);

新写法
global $db;
$db->insert('demo',array());
$id = $db->insertid();插入id


$db->update('demo',['num +='=>1],['id'=>1]);

$db->delete('demo',['id'=>1]);
$db->delete('demo', "id IN ('".implode("','", $deleteid)."')");//多选删除