Home / Questions / 107445
Accepted
MNibor
Asked: 2020-10-06 04:51:11 +0800 CST 2020-10-06 04:51:11 +0800 CST

Datatables jquery showing me hidden fields

  • 772

I have a table on a page in which I use the datatables.jquery plugin, which for me is very practical and functional.
It turns out that in the table I use two hidden fields, the id and the nrologins (I use the latter to order the data that the sql query brings)

<table id="tabla" class="ui celled stackable table">
        <thead>
            <tr>
                <th hidden>nrologins</th>
                <th hidden>Id</th>
                <th>Nombre</th>
                <th>Apellido</th>
            </tr>
        </thead>

     <tbody>
            <?php
                if ($arrDatos) {
                    foreach ($arrDatos as $row) { ?>
                <tr>
                    <td hidden> <?php echo $row['nrologins']; ?> </td>
                    <td hidden> <?php echo $row['id']; ?> </td>
                    <td> <?php echo $row['nombre']; ?> </td>
                    <td> <?php echo $row['apellido']; ?> </td>
                </tr>
            <?php }} ?>
        </tbody>
      </table>

Now, at full screen, it works fine but when I reduce the screen (or for example I see it from the mobile) the "hidden" fields are shown !!!... How can I prevent this from happening?

php

1 Answers

  1. Best Answer

    Try to hide the fields in your JS code, add the following in your datatable configuration:

    $('#example').DataTable( {
    "columnDefs": [
        {
            "targets": [ 0 ],
            "visible": false,
            "searchable": false
        },
        {
            "targets": [ 1 ],
            "visible": false
        }
    ]
} );

    Targets specifies the position of the column you want to hide.

    • 2