Exemplo use database in datatables with sorting

<?php
include "includes/config.php";
include "includes/sltpac.php";

?>

<!--Table head-->
<thead>
<tr>
<th>
<input type="checkbox" id="checkbox">
<label for="checkbox" class="mr-2 label-table"></label>
</th>
<th class="th-lg"><a>Prontuário <i class="fa fa-sort ml-1"></i></a></th>
<th class="th-lg"><a href="">Nome<i class="fa fa-sort ml-1"></i></a></th>
<th class="th-lg"><a href="">Tipo paciente<i class="fa fa-sort ml-1"></i></a></th>
<th class="th-lg"><a href="">E-mail<i class="fa fa-sort ml-1"></i></a></th>
<th class="th-lg"><a href="">Telefone<i class="fa fa-sort ml-1"></i></a></th>
</tr>
</thead>
<!--Table head-->

<!--Table body-->
<tbody>
<?php foreach($dados as $cliente):?>
<tr>
<th scope="row">
<input type="checkbox" id="checkbox1" value=<?=$cliente->id?>>
<label for="checkbox1" class="label-table"></label>
</th>
<td><?=$cliente->id?></td>
<td><?=$cliente->nome?> </td>
<td><?=$cliente->tipopaciente?> </td>
<td><?=$cliente->email?> </td>
<td><?=$cliente->telefone?> </td>
</tr>
<?php endforeach; ?>
</tbody>
<!--Table body-->
</table>
<!--Table-->
</div>

not work, not made pagination,

Witold Tkaczyk commented 7 years ago

Hi Meireles, Can you extend your question for $dados variable?

---

Meireles pro commented 7 years ago

Hi, dados is cursor(foreach), include select in database include "includes/sltpac.php";

---

Meireles pro commented 7 years ago

I want an example of "Table with pagination" with mysql connection.

---