$db=... $sth=$db->prepare("INSERT INTO beacon (time, addr, query, agent, referer) VALUES (FROM_UNIXTIME(?), ?, ?, ?, ?)"); $sth->execute([ $_SERVER["REQUEST_TIME"], $_SERVER["REMOTE_ADDR"], $_SERVER["QUERY_STRING"], isset($_SERVER["HTTP_USER_AGENT"])?$_SERVER["HTTP_USER_AGENT"]:NULL, isset($_SERVER["HTTP_REFERER"])?$_SERVER["HTTP_REFERER"]:NULL ]);