<?php
$host = '127.0.0.1';
$db   = 'app';
$user = 'root';
$pass = '******';
$charset = 'utf8';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'
];
$pdo = new PDO($dsn, $user, $pass, $opt);
$pdo->exec("SET CHARACTER SET utf8");

$stmt = $pdo->prepare('INSERT INTO Locations (place, lat, lon, address) VALUES (?,?,?,?)');
$stmt->execute([$_GET['place'],$_GET['lat'],$_GET['lon'],$_GET['address']]);
echo "OK";
?>