Código PHP:
$sqlRec = 'SELECT * FROM sessions';
Código PHP:
$sqlRec = 'SELECT * FROM sessions limit :starting, :nrecord';
Este es mi codigo de PDO y HTML:
Código PHP:
<?php
if (!$_GET) {
header('Location:ordinaryConsultant.php?page=1');
}
$record_by_page = 10;
$total_records = $sentence->rowCount();
$page = $total_records/10;
$page = ceil($page);
$starting = ($_GET['page']-1)*$record_by_page;
$sqlRec = 'SELECT * FROM sessions limit :starting, :nrecord';
$sentenceRec = $pdo->prepare($sqlRec);
$sentenceRec->bindParam(':starting', $starting, PDO::PARAM_INT);
$sentenceRec->bindParam(':nrecord', $record_by_page, PDO::PARAM_INT);
$sentenceRec->execute();
$resultRec = $sentenceRec->fetchAll();
?>
<div class="registros" id='agrega-registros' style="background-color: #35889936;">
<?php foreach ($resultRec as $fila): ?>
<div class='registros' style='background-color: #35889936; color: #FFF;'>
<?php echo $fila['0']; ?>
</div>
<?php endforeach ?>
</div>