- 新增db.class.php調用 使用全部方法,需要以對象方式調用 http://www.hmoore.net/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)."')");//多選刪除 ~~~