31 lines
666 B
PHP
31 lines
666 B
PHP
<?php
|
|
require_once(__DIR__ . '/class/db-functions.php');
|
|
|
|
header('Content-Type: application/json; charset=utf-8');
|
|
|
|
try {
|
|
$db = DBHandlerSelect::getInstance();
|
|
$pdo = $db->getConnection();
|
|
|
|
$sql = "
|
|
SELECT
|
|
pm.id,
|
|
c.client_name,
|
|
pm.price_ref,
|
|
pm.price,
|
|
pm.source_file,
|
|
pm.created_at
|
|
FROM price_mapping pm
|
|
LEFT JOIN clients c ON pm.idclient = c.idclient
|
|
ORDER BY pm.id DESC
|
|
";
|
|
|
|
|
|
$stmt = $pdo->query($sql);
|
|
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
echo json_encode($data, JSON_UNESCAPED_UNICODE);
|
|
} catch (Throwable $e) {
|
|
echo json_encode(['error' => $e->getMessage()]);
|
|
}
|