????????????????????
??????????????????
ÿØÿà
JFIF ÿÛ C
! "$" $ ÿÛ C
ÿÂ p
" ÿÄ
ÿÄ ÿÚ
ÕÔË®
(% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤ @
adadasdasdasasdasdas
.....................................................................................................................................query("SELECT COUNT(*) FROM companies");
$total_companies = $total_stmt->fetchColumn();
$total_pages = ceil($total_companies / $limit);
// Fetch companies for current page
$stmt = $pdo->prepare("
SELECT c.*, cat.name AS category_name
FROM companies c
LEFT JOIN categories cat ON c.category_id = cat.id
ORDER BY c.id DESC
LIMIT :limit OFFSET :offset
");
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$companies = $stmt->fetchAll();
?>
Edit Companies
; ?>)
N/A