PHP db_mssql::set_type_result Beispiele

Beispiel #1

Datei: class.html.php Projekt: etlapa/uiest

 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;
 }