Allowing users to select large items to export from a paginated list

On a website I’m designing, users have access to a search function that lists items with potentially much content inside (they’re meant to be grammar exercises, and so multiple grammar problems can be listed in each item). The current view uses pagination (6 items per page) and looks like this:

enter image description here

Users should be able to enter a special mode in which they select the items to export to a file. While there could potentially be hundreds of items and multiple results pages, I want the design to be usable at no more than 40-50 items, suggesting to narrow down the search query if the result set is larger.

This leaves me with a problem: allowing users to select items for exporting from a list that doesn’t fit on a single page, because the items are so large. While there are many questions (1, 2, 3) and solutions about selecting items from a long list, those items are typically just small, simple text labels one-two words long, in which case list builders or a grid-based layout with checkboxes can be used; here, this is impractical.

The solution I thought of was to switch from using pagination to infinite scroll, and, when the user clicks the ‘export’ button, load all items from the server if the user hasn’t scrolled to the bottom yet, and then simply allow individual item selection via checkboxes (that is, a checkbox appears next to each item; if the item is to be exported, the checkbox should be checked).

  • Are there any significant downsides to this approach? One problem I can see is that beyond around 10 items, there will likely be a lot of scrolling involved, because of the height of each item. How much of an issue is this?
  • Is there another solution I could consider?
  • I believe my solution should be usable on mobile devices as well, since it doesn’t require anything more refined than checkboxes. Are there any difficulties I’m missing?

Ubuntu 19.04 – Can’t enable or select Nvidia card as default

I’ve been trying for weeks now to use my Laptop with an MX150 card to run some games in Ubuntu. But for some reason linux doesn’t want to let me use it!

Things I’ve tried:

  • I’ve installed the latest drivers (430)
  • done prime-select nvidia, query shows nvidia as selected too.
  • I’ve also disabled secure boot from the BIOS.
  • I’ve added nomodeset to the grub config, but this boots to a blinking cursos and black screen until i remove that.

WHen i can see the login screen, for some reason I’m forced to login selecting Wayland from the user select screen otherwise it bounces back to the user list.

And I still see in Settings > Details that the system is still using the intel Card. Even thought the nvidia drivers are suggested in the Software app and i have installed the 430 ones.

Also if i run tools like glxgears or glmark2 it uses the intel card instead of the Nvidia card to do the tests :/

I don’t know what else to try to use my graphics card… it seems at this point i will have to go back to Winbugs 馃檨

Any other ideas what to do?

Thanks and regards.

驴c贸mo definir el valor de un select mediante una variable php?

Tengo el siguiente select de los meses del a帽o y un input donde me muestra la opci贸n seleccionada, quiero que aparezca la opci贸n del mes actual seleccionada por default cuando inicie la pagina, para esto tengo una variable php donde defino en que mes me encuentro. he buscado y no encuentro una soluci贸n. Hay alguna forma de hacerlo?

var mostrarValor = function(x) {    document.getElementById('pseudonimo').value = x; }
<?php      $  mes = date("m"); ?>  <select class="custom-select pull-right" id="mes" name="mes" onchange="mostrarValor(this.selectedIndex);" selected="<?php echo $  mes;?>">               <option value="01">Enero</option>               <option value="02">Febrero</option>               <option value="03">Marzo</option>               <option value="04">Abril</option>               <option value="05">Mayo</option>               <option value="06">Junio</option>               <option value="07">Julio</option>               <option value="08">Agosto</option>               <option value="09">Septiembre</option>               <option value="10">Octubre</option>               <option value="11">Noviembre</option>               <option value="12">Diciembre</option>             </select>     <input type="text" name="pseudonimo" id="pseudonimo" value="" >

Select numerical value with +/- buttons or manually entering?

The design I’m working on has the user assigning a value to each item, then if the value is more than 1, a second dependent attribute appears (as shown). I want the numbers to be large and not default to an ugly and busy text box. However, the only solution I could think of is an even uglier and busier -/+ button combo which is also incredibly space expensive (and, I’ve found, nearly impossible to fit in mobile mode).

Is there a better way to do this?

enter image description here

PDO INSERT INTO with SELECT no agrega registros a la base de datos phpmyadmin

La cadena “INSERT INTO admin_history (user_id, username, usernick, userlevel, delete_user_id) SELECT user_id, username, usernick, userlevel, delete_user_id FROM user WHERE (user_id =: user_id)” no escribir谩 datos en la base de datos.

Si en lugar de: user_id sustituye la identificaci贸n existente, el registro funciona.

No escrib铆 el c贸digo yo mismo, tom茅 http://demo.webslesson.info/multiple-checkbox-update-data/ aqu铆 e intent茅 agregar la capacidad de ver el historial de cambios en el sitio http://yamer7.beget.tech/panel-admin.

include($  _SERVER['DOCUMENT_ROOT'].'/sql_connect.php');  if(isset($  _POST['user_id'])) {     $  new_id = $  _POST['new_id'];     $  user_id = $  _POST['user_id'];     $  username = $  _POST['username'];     $  usernick = $  _POST['usernick'];     $  userlevel = $  _POST['userlevel'];     $  delete_user_id = $  _POST['delete_user_id'];     for($  count = 0; $  count < count($  user_id); $  count++)     {         $  data = array(             ':new_id'   => $  new_id[$  count],             ':user_id'   => $  user_id[$  count],             ':username'  =>  $  username[$  count],             ':usernick'  =>  $  usernick[$  count],             ':userlevel'  =>  $  userlevel[$  count],             ':delete_user_id'  =>  $  delete_user_id[$  count]     );     $  query0 = "INSERT INTO admin_history (user_id, username, usernick, userlevel, delete_user_id) SELECT user_id, username, usernick, userlevel, delete_user_id FROM user WHERE (user_id = :user_id)";     $  statement0 = $  connect->prepare($  query0);     $  statement0->execute($  data);     $  query1 = "UPDATE user SET user_id = :new_id, username = :username, usernick =:usernick, userlevel = :userlevel, delete_user_id = :delete_user_id WHERE (user_id = :user_id)";     $  statement1 = $  connect->prepare($  query1);     $  statement1->execute($  data);     $  query2 = "DELETE FROM user WHERE delete_user_id=1";     $  statement2 = $  connect->prepare($  query2);     $  statement2->execute($  data);     } } 

Escriba cu谩l es la mejor manera de hacerlo si deseo guardar muestras m煤ltiples durante INSERT INTO para que todos los registros modificados seleccionados en la casilla de verificaci贸n se escriban en la base de datos.

Strange pl/sql behavior – last character is removed in the Select statement, but actual data has different length

We have a table with a column name A with type nvarchar(23).

following query will always return 23 which means that the actual length of all records are 23.

select length(trim(req.A)), count(*)   from tableName req group by length(trim(req.A)); 
 |length(trim(req.A))|count(*)|  ------------------------------ |23                 |1006    | 

But when we select from this table with this query it behaves different and it seems that the last character is always removed in result Gridview in the pl/sql developer.

select LENGTHB(req.A) lenb, length(req.A) len, req.* from tableName req where req.A = 'NHBBBBB1398052635902235'; -- Note to the equal sign and the last charactar (5) of the where clause 

the result is:

 |lenb|len|          A           | --------------------------------- |46  |23 |NHBBBBB139805263590223| 

As you can see the last character (5) is removed in the select result.

Can you please explain whats happen!? Is this related to pl/sql configs? How to solve this?

Select de mi base de datos esta devolviendo los valores duplicados

estoy realizando una consulta a mi base de datos mediante select, segun el c贸digo abajo no aparece mensages de errores pero esta duplicando las filas de la tabla. Intente cambiar el c贸digo del insert dejandolo sim el INNER JOIN pero no funciona de la manera que necesito.

Codigo PHP y HTML

 <table class="table table-striped">                  <tr>                   <th>ID quarto</th>                   <th>Hotel</th>                   <th>Tipo de quarto</th>                   <th>Numero do quarto</th>                   <th>Valor diaria R$  </th>                  </tr>                 <?php                  $  sql= "SELECT  id_tipo_quarto,  num_quarto, valor_diaria,                               nome_hotel, tipo_quarto2                               FROM tipo_quarto                                INNER JOIN hoteis_pousadas                                 INNER JOIN tipo2 ON cod_tipo2 =  tipo_quarto ";                 $  resultado=$  mysqli->query($  sql);               while($  row = $  resultado->fetch_array(MYSQLI_ASSOC))                 {                   echo '                   <tr>                   <td>'.$  row['id_tipo_quarto'].'</td>                   <td>'.$  row['nome_hotel'].'</td>                   <td>'.$  row['tipo_quarto2'].'</td>                   <td>'.$  row['num_quarto'].'</td>                   <td>'.$  row['valor_diaria'].'</td>                    </tr>                     ';                  }                    ?>               </table> 

introducir la descripci贸n de la imagen aqu铆

varios select con un boton

bueno pues resulta que tengo una tabla de calificaciones

require_once "../crud/crud.php";  $  obj= new Crud();  $  datos=$  obj->mostrarDatos();  $  tabla='<table class="table table-dark">                                     <thead>                                         <tr class="font-weight-bold">                                             <td>Matricula</td>                                             <td>Nombre</td>                                             <td>Unidad I</td>                                             <td>Examen</td>                                             <td>Unidad II</td>                                             <td>Examen</td>                                             <td>Unidad III</td>                                             <td>Examen</td>                                             <td>Unidad IV</td>                                             <td>Examen</td>                                             <td>Unidad V</td>                                             <td>Examen</td>                                             <td>Calificar</td>                                             <td>Editar</td>                                             <td>Eliminar</td>                                         </tr>                                     </thead>                                     <tbody>'; $  datosTabla="";  foreach ($  datos as $  key => $  value){     $  datosTabla=$  datosTabla.'<tr>                                             <td>'.$  value['matricula_alumno'] .'</td>                                             <td>'.$  value['nombre_alumno'] .'</td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td></td>                                             <td>                                                    <span class="btn btn-primary btn-sm" onclick="calificarDatos " data-toggle="modal" data-target="#calificarModal">                                                      <i class="fas fa-pen-square"> </i></td>                                             <td>                                                 <span class="btn btn-warning btn-sm" onclick="obtenerDatos('.$  value['id'] .')" data-toggle="modal" data-target="#actualizarModal">                                                     <i class="fas fa-edit"></i>                                                 </span>                                              </td>                                             <td>                                                 <span class="btn btn-danger btn-sm" onclick="eliminarDatos('.$  value['id'] .')">                                                     <li class="fas fa-trash-alt"></li>                                                 </span>                                             </td>                                         </tr>'; }  echo $  tabla.$  datosTabla.'</tbody></table>';  ?> 

esa es la tabla, ahora el problema que tengo es como hacer que 3 select se guarden en la base de datos y la tabla pinte esos datos guardados

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00";    CREATE TABLE `alumnos` (   `id` int(11) NOT NULL,   `matricula_alumno` int(200) NOT NULL,   `nombre_alumno` text COLLATE utf8_spanish2_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;    CREATE TABLE `carreras` (   `id` int(11) NOT NULL,   `nombre_carrera` text COLLATE utf8_spanish2_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;   CREATE TABLE `examen` (   `id` int(11) NOT NULL,   `ordinario` int(11) NOT NULL,   `r1` int(11) NOT NULL,   `r2` int(11) NOT NULL,   `ra` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;    CREATE TABLE `grupo` (   `id` int(11) NOT NULL,   `grupo` text COLLATE utf8_spanish2_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;    CREATE TABLE `materias` (   `id` int(11) NOT NULL,   `nombre_materia` text COLLATE utf8_spanish2_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;  -- --------------------------------------------------------   CREATE TABLE `profesores` (   `id` int(11) NOT NULL,   `nombre_profesor` text COLLATE utf8_spanish2_ci NOT NULL,   `matricula_profesor` int(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;    CREATE TABLE `unidades` (   `id` int(11) NOT NULL,   `unidad_1` varchar(200) COLLATE utf8_spanish2_ci NOT NULL,   `unidad_2` varchar(200) COLLATE utf8_spanish2_ci NOT NULL,   `unidad_3` varchar(200) COLLATE utf8_spanish2_ci NOT NULL,   `unidad_4` varchar(200) COLLATE utf8_spanish2_ci NOT NULL,   `unidad_5` varchar(200) COLLATE utf8_spanish2_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;   ALTER TABLE `alumnos`   ADD PRIMARY KEY (`id`);   ALTER TABLE `carreras`   ADD PRIMARY KEY (`id`);   ALTER TABLE `examen`   ADD PRIMARY KEY (`id`);   ALTER TABLE `grupo`   ADD PRIMARY KEY (`id`);   ALTER TABLE `materias`   ADD PRIMARY KEY (`id`);   ALTER TABLE `profesores`   ADD PRIMARY KEY (`id`);   ALTER TABLE `unidades`   ADD PRIMARY KEY (`id`);   ALTER TABLE `alumnos`   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;   ALTER TABLE `carreras`   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;   ALTER TABLE `examen`   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;   ALTER TABLE `grupo`   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;   ALTER TABLE `materias`   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;   ALTER TABLE `profesores`   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;   ALTER TABLE `unidades`   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; 

esa es la base de datos, ahora aqui estan mis selects

<!-- Modal --> <div class="modal fade" id="calificarModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">   <div class="modal-dialog" role="document">     <div class="modal-content">       <div class="modal-header">         <h5 class="modal-title" id="exampleModalLabel">Calificar</h5>         <button type="button" class="close" data-dismiss="modal" aria-label="Close">           <span aria-hidden="true">&times;</span>         </button>       </div>       <div class="modal-body">      <form>             <h1>Unidad</h1>             <select id="unidad" name="unidad" >                  <option value="u1">Unidad I</option>                 <option value="u2">Unidad II</option>                 <option value="u3">Unidad III</option>                 <option value="u4">Unidad IV</option>                 <option value="u5">Unidad V</option>              </select>           </form>           <br>         <form>            <h1>Calificaci贸n</h1>             <select id="calificacion" name="calificacion" >                 <option value="ocho">8</option>                 <option value="nueve">9</option>                 <option value="diez">10</option>              </select>                      </form>                     <br>        <form>        <h1>Ex谩men</h1>         <select id="examen" name="examen" >             <option value="ordinario">Ordinario</option>             <option value="r1">R1</option>             <option value="r2">R2</option>             <option value="ra">RA</option>         </select>        </form>                    </div>       <div class="modal-footer">         <input type="submit" value="Guardar" class="btn btn-warning">         <button type="button" class="btn btn-secondary" data-dismiss="modal">Cerrar</button>        </div>     </div>   </div> </div> 

entonces necesito que esos datos del select se guarden todos con un boton guardar y que luego se pinten en sus respectivos campos en la tabla, espero se entienda mi duda y si necesitan mas informacion para ayudarme, por favor no duden en pedirla y muchas gracias por la ayuda

Material Design Select box /Dropdown Usability which is correct interaction

I like material design, when using one of the material design components (select box/dropdown), I got confused about which interaction is correct, the link below has 2 interactions filled and filled enhanced. If you click on the filled examples the dropdown box list covers the field label, on the other hand, the list item is opening below the dropbox, which help the user to read the field label easily. So which is the correct interaction for this component? Or does simply saying filled enhanced mean that the correct interaction has been updated?

https://material-components.github.io/material-components-web-catalog/#/component/select

DESHABILITAR BOT脫N SI UN UN SELECT E INPUT EST脕N VAC脥OS

Tengo un formulario con tres input[type=”text”], un select y su bot贸n de env铆o.

Estoy intentando deshabilitar el bot贸n de env铆o del formulario, SI los INPUTS y el SELECT est谩n vac铆os 煤nicamente.

Si tiene informaci贸n y se selecciono algo entonces me permita enviar los datos. Alguno idea de como se puede lograr eso?