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
| <?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include '********/admin/db_connection.php';
$ip = $_SERVER['REMOTE_ADDR'];
$gps = $_POST['gps'];
$conn = OpenCon();
$stmt->bindValue(':gps', $gps);
$stmt->bindValue(':userappip', $ip);
$sql = "INSERT INTO temporary.usercodb (userappip, gps) VALUES (:userappip, :gps)";
$stmt= $pdo->prepare($sql);
try{
$pdo->beginTransaction();
$stmt->execute();
$stmt->commit();
}catch(\PDOException $e){
$pdo->rollback();
echo $e->getMessage();
}
CloseCon($conn);
?> |
Partager