1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
if (isset($_GET['cam']) && isset($_GET['lat']) && isset($_GET['lng']))
{
$conn = conn_pdo();
try
{
$conn->beginTransaction();
echo "INSERT INTO cam (cam_id,cam_lat,cam_lng)
VALUES ('{$_GET['cam']}','{$_GET['lat']}','{$_GET['lng']}')
ON DUPLICATE KEY UPDATE cam_lat='{$_GET['lat']}',cam_lng='{$_GET['lng']}'";
$stmt = $conn->prepare("INSERT INTO cam (cam_id,cam_lat,cam_lng)
VALUES (:valcam,:vallat,:vallng)
ON DUPLICATE KEY UPDATE cam_lat=:vallat,cam_lng=:vallng");
$stmt->bindParam(':valcam', $_GET['cam']);
$stmt->bindParam(':vallat', $_GET['lat']);
$stmt->bindParam(':vallng', $_GET['lng']);
$stmt->execute();
echo $stmt->rowcount();
}
catch (Exception $e)
{
$conn->rollBack();
echo 'Erreur : '.$e->getMessage().'<br />';
echo 'N° : '.$e->getCode();
}
} |
Partager