如何获取登录id

Question

我从mysql数据库中获取数据，然后用javascript将它们写在表上，但我只想写我登录的帐户的数据

这是我的php文件

<?php 
require("sistem/baglan.php");
if($_POST){
$sahaid = $_POST["id"]
$list = $db-> query("SELECT *
FROM saat 
INNER JOIN takim ON saat.takim_id = takim.id WHERE saat_durum='dolu' AND saha_id='$sahaid'")- 
>fetchAll(PDO::FETCH_ASSOC);
echo json_encode($list);
}

?>

这是我的javascript文件

import { girisKontrolSaha } from './saha-giris.js';
window.onload = function () {
girisKontrolSaha();
var oReq = new XMLHttpRequest();
oReq.onreadystatechange = function () {
if (oReq.readyState == XMLHttpRequest.DONE) {
var response = oReq.response;
response = JSON.parse(response);
console.log(response);

response.forEach(randevubilgi => {
console.log(randevubilgi)
var postNode = document.createElement('tr');
postNode.className = "randevutablosu"
var card =
'<td class="saathucre">'+
randevubilgi.saat +
'</td>'+
'<td class="takimadihucre">'+
randevubilgi.takimadi +
'</td>'+
'<td class="kontenjanhucre">'+
randevubilgi.takimkontejyan +
'</td>'+
'<td class="kurucuhucre">'+
randevubilgi.kurucu +
'</td>'+
'<td class="iptal">' + '<i class="las la-trash-alt" id="iptal-button" data-saatid="' + 
randevubilgi.saat_id + '">'+'</i>'+ '</td>'
;
postNode.innerHTML = card;
var postList = document.getElementById("randevutablosu");
postList.appendChild(postNode);
});

}
}
oReq.open("GET", "../../backend/randevular.php");
oReq.send();
}

这也是将我登录的帐户的id和电子邮件写入控制台的功能

export function girisKontrolSaha() {
var user;
if (localStorage.getItem("auth-saha") != null) {
user = localStorage.getItem("auth-saha");
console.log("Giriş yapan kullanıcı : " + user);
console.log("Giriş yapan kullanıcı id : " + localStorage.getItem("auth-sahaid"));
var girislinkleri = document.getElementsByClassName("giris-linkleri");
for (var i = 0; i < girislinkleri.length; i++) {
girislinkleri[i].style.display = 'none';
}
var kullanicilinkleri = document.getElementsByClassName("kullanici-linkleri");
for (var i = 0; i < kullanicilinkleri.length; i++) {
kullanicilinkleri[i].style.display = 'display: block !important;';
}
} else {
var kullanicilinkleri = document.getElementsByClassName("kullanici-linkleri");
for (var i = 0; i < kullanicilinkleri.length; i++) {
kullanicilinkleri[i].style.cssText = 'display:none !important;';
}
window.location.replace("../../index.html");
}
} 

当我运行这样的代码时，我得到了Uncaught SyntaxError

但是如果我像这样运行我的php文件，它可以工作，但它从数据库中获取所有行

<?php 
require("sistem/baglan.php");
$list = $db-> query("SELECT *
FROM saat 
INNER JOIN takim ON saat.takim_id = takim.id WHERE saat_durum='dolu'")->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($list);
?> 

ım得到这个错误

Uncaught SyntaxError: Unexpected token < in JSON at position 0
at JSON.parse (<anonymous>)
at XMLHttpRequest.oReq.onreadystatechange (saha-randevular.js:11)
oReq.onreadystatechange @ saha-randevular.js:11
XMLHttpRequest.send (async)
window.onload @ saha-randevular.js:45
load (async)
(anonymous) @ saha-randevular.js:3

Answer 1

使用会话var来存储用户的id。这是你应该做的最低限度。