其中会话数据Sql


Where session data Sql

我想有一个sql查询,其中会话数据'id'等于一个变量。目前,我有这个查询从日历中获取事件:

<?php
// List of events
 $json = array();
 // Query that retrieves events
 $requete = "  SELECT * FROM `evenement` LEFT JOIN `evenementontvanger` ON `evenementontvanger`.`idEvent` = `evenement`.`id` WHERE `idEvent`=`evenement`.`id`";
 // connection to the database
 try {
 $bdd = new PDO('mysql:host=localhost;dbname=blackboks-calendar', 'root', 'root');
 } catch(Exception $e) {
  exit('Unable to connect to database.');
 }
 // Execute the query
 $resultat = $bdd->query($requete) or die(print_r($bdd->errorInfo()));
 // sending the encoded result to success page
 echo json_encode($resultat->fetchAll(PDO::FETCH_ASSOC));
?>

我认为答案应该是这样的:

$requete = "  SELECT * FROM `evenement` LEFT JOIN `evenementontvanger` ON `evenementontvanger`.`idEvent` = `evenement`.`id` WHERE `idWerknemer`=`"$this->session_data['id']"`";

应该是

$requete = " SELECT * FROM `evenement` 
    LEFT JOIN `evenementontvanger` ON `evenementontvanger`.`idEvent` = `evenement`.`id` 
    WHERE `idWerknemer`='".$this->session_data['id']."'";

字符串数据应该用单引号"括起来,如果是整数则不需要提供"