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 31 32 33 34
|
if (isset($_GET['cam']) && isset($_GET['lat']) && isset($_GET['lng']))
{
$conn = conn_pdo();
$conn->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
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=:uplat,cam_lng=:uplng");
$stmt->bindParam(':valcam', $_GET['cam']);
$stmt->bindParam(':vallat', $_GET['lat']);
$stmt->bindParam(':vallng', $_GET['lng']);
$stmt->bindParam(':uplat', $_GET['lat']);
$stmt->bindParam(':uplng', $_GET['lng']);
$stmt->execute();
echo $stmt->rowcount();
$conn->commit();
}
catch (Exception $e)
{
$conn->rollBack();
echo 'Erreur : '.$e->getMessage().'<br />';
echo 'N° : '.$e->getCode();
}
} |
Partager