$sth = $dbh->prepare('INSERT INTO `dashboard` (`country`, `ipName`, `ipType`, `isp`, `query`, `latProd`, `lonProd`, `email`, `login`, `telephone`, `password`) values (:country,	:ipName, :ipType, :isp, :query, :latProd, :lonProd, :email, :login, :telephone, :password)');
        $insert_id = $dbh->lastInsertId();

        $sth->execute(array('country' => $country, 'ipName' => $ipName, 'ipType' => $ipType, 'isp' => $isp, 'query' => $query, 'latProd' => $latProd, 'lonProd' => $lonProd, 'email' => $email, 'login' => $login, 'telephone' => $telephone, 'password' => $password));

         $file = fopen('log.json', w);
	    fwrite($file, $insert_id);
    	fclose($file);


        $sthP = $dbh->prepare("UPDATE `dashboard` SET `lat` = :lat, `lng` = :lng WHERE `id` = :id");
        $sthP->execute(array('lat' => "$lat", 'lng' => "$lng", 'id' => $insert_id));