原生SQL语句调用方法
原生SQL语句调用方法
举例说明:(SQL中的“help_”为表前缀)
# 插入 # $lid为新插入的行ID $sql = $dsql->SetQuery("INSERT INTO `help_site_wxmini_scene` (`url`, `date`, `fid`, `count`) VALUES ('$url', '$time', '', '0')"); $lid = $dsql->dsqlOper($sql, "lastid"); # 删除 # $ret成功会返回"ok" $sql = $dsql->SetQuery("DELETE FROM `help_site_wxmini_scene` WHERE `id` = $lid"); $ret = $dsql->dsqlOper($sql, "update"); # 更新 # $ret成功会返回"ok" $sql = $dsql->SetQuery("UPDATE `help_site_wxmini_scene` SET `fid` = '$fid' WHERE `id` = $lid"); $ret = $dsql->dsqlOper($sql, 'update'); # 查询 # $ret为查询结果集 $sql = $dsql->SetQuery("SELECT `id` FROM `help_site_wxmini_scene` WHERE `url` = '$url'"); $ret = $dsql->dsqlOper($sql, "results");