Hi all
I'm using this demo
https://www.jeasyui.com/demo/main/index.php CRUD DataGrid with this code
$sort = isset($_POST['sort']) ? strval($_POST['sort']) : 'sigla';
$order = isset($_POST['order']) ? strval($_POST['order']) : 'asc';
$where = "sigla like '%$_REQUEST[sigla]%'";
$db_con = new PDO("mysql:host={$db_host};dbname={$db_name}",$db_user,$db_pass);
$db_con -> exec('SET CHARACTER SET utf8');
$db_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
$q = "select * from items where " . $where . " order by $sort $order";
$sql = $db_con->prepare($q);
$sql->execute();
$rows = $sql->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($rows);
}
catch(PDOException $e)
{
echo $e->getMessage();
}
but table show all 25 rows founded in db although pagination at bottom work correctly
Page 1 of 3 Displaying 1 to 10 of 25 itemsOf course in table grid I have set
pagination="true"The version is the last one 1.5.4.2
Any help please?