Ejemplo n.º 1
0
 static function select($sql_or_array, $name, $request = null, $xtra = null, $blank_option = true)
 {
     $select = "<select name='{$name}' id='{$name}' {$xtra} >";
     if ($blank_option) {
         $select .= "<option value=''>--Seleccionar--</option>";
     }
     if (is_array($sql_or_array)) {
         if ($sql_or_array[0]) {
             foreach ($sql_or_array as $valor) {
                 $select .= "<option value='{$valor}' " . ($request == $valor ? "selected" : "") . ">" . utf8_encode($valor) . "</option>";
             }
         } else {
             foreach ($sql_or_array as $key => $valor) {
                 $select .= "<option value='{$key}' " . ($request == $key ? "selected" : "") . ">" . utf8_encode($valor) . "</option>";
             }
         }
     } else {
         $cnx = new db_mssql();
         $cnx->set_type_result("num");
         $arreglo = $cnx->get_registros($sql_or_array);
         if (!empty($arreglo)) {
             foreach ($arreglo as $registro) {
                 $select .= "<option value='" . $registro[0] . "' " . ($request == $registro[0] ? "selected" : "") . ">" . utf8_encode($registro[1]) . "</option>";
             }
         }
     }
     $select .= "</select>";
     return $select;
 }
Ejemplo n.º 2
0
 case 'import':
     $data = array();
     @(include DT_ROOT . '/file/data/' . $name . '.php');
     $data = dstripslashes($data);
     extract($data);
     if ($database == 'mysql') {
         if ($db_host && $db_user && $db_name) {
             $sc = new db_mysql();
             $sc->connect($db_host, $db_user, $db_pass, $db_name, $CFG['db_expires'], $CFG['db_charset'], $CFG['pconnect']);
         } else {
             $sc =& $db;
         }
     } else {
         if ($database == 'mssql') {
             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;