Ich probiere grade aus, meine eigenen „Google Analystics“ zu machen, da das Originale zu teuer ist. Egal, kommen wir zurück zum Thema. Wie füge ich Daten zu einer MySQL-Datenbank hinzu, genau dann, wenn der User die Seite verlässt. Ich habe es bereits mit diesem JavaScript versucht:
How do i run PHP-Functions before the page unloads bwz. close? I tried `beforunload` but it never really worked. I want to insert a record for analystics into php database. Here is the JavaScript:
```
const beforeUnloadListener = (event) => {
document.write(' <?php
$sql2 = "DELETE FROM `SwiftSpion` WHERE ip = `$ip`";
$result2 = $conn->query($sql2);
?> ');
}
window.addEventListener("beforeunload", beforeUnloadListener);
const pageHideListener = (event) => {
document.write(' <?php
$sql2 = "DELETE FROM `SwiftSpion` WHERE ip = `$ip`";
$result2 = $conn->query($sql2);
?> ');
}
document.onvisibilitychange = function() {
if (document.visibilityState === 'hidden') {
document.write(' <?php
$sql2 = "DELETE FROM `SwiftSpion` WHERE ip = `$ip`";
$result2 = $conn->query($sql2);
?> ');
}
};
window.addEventListener("pagehide", pageHideListener);
```
I expect, that the MySQL-Command works when the user leaves the site.