Пример #1
0
         require DT_ROOT . '/include/db_mssql.class.php';
         $sc = new db_mssql();
         $sc->connect($db_host, $db_user, $db_pass, $db_name);
     } else {
         if ($database == 'access') {
             require DT_ROOT . '/include/db_access.class.php';
             $sc = new db_access();
             $sc->connect(DT_ROOT . '/' . $db_host, $db_user, $db_pass, $db_table);
         } else {
             msg('配置文件错误');
         }
     }
 }
 $key = strpos($db_key, '.') !== false ? trim(substr(strrchr($db_key, '.'), 1)) : $db_key;
 if (!isset($fid)) {
     $r = $sc->get_one("SELECT min({$db_key}) AS fid FROM {$db_table} WHERE {$db_key}>{$lastid} {$db_condition}");
     $fid = $r['fid'] ? $r['fid'] : 0;
 }
 if (!isset($tid)) {
     $r = $sc->get_one("SELECT max({$db_key}) AS tid FROM {$db_table} WHERE {$db_key}>{$lastid} {$db_condition}");
     $tid = $r['tid'] ? $r['tid'] : 0;
 }
 isset($total) or $total = 0;
 isset($num) or $num = 500;
 if ($fid <= $tid) {
     $result = $sc->query("SELECT * FROM {$db_table} WHERE {$db_key}>{$lastid} AND {$db_key}>={$fid} {$db_condition} ORDER BY {$db_key} LIMIT 0,{$num} ");
     if ($sc->affected_rows($result)) {
         while ($F = $sc->fetch_array($result)) {
             if ($db_charset) {
                 $F = convert($F, $db_charset, DT_CHARSET);
             }