When i'm sending a session value into sql query it send a NULL value. When i manually change the value to $userMail="abc@gmail.com" instead of $userMail=$_SESSION['em'] everything works fine. Thank U for helping me :)
<?php
require_once("../php/db.php");
if(!isset($_SESSION['em'])) {
$userMail = $_SESSION['em'];
}
$taskName = $_POST['taskName'];
$taskDate = $_POST['taskDate'];
$writerName = $_POST['writerName'];
$isDone = $_POST['isDone'];
$sql ="INSERT INTO `tasksToDo`( `taskName`, `taskDate`, `writerName` , `isDone`, `userMail`)
VALUES ('$taskName','$taskDate','$writerName','$isDone','$userMail')";
if ($conn->query($sql)===TRUE) {
$last_id = $conn->insert_id;
echo json_encode(array('success' => 1,"id"=>$last_id));
}else {
echo json_encode(array('success' => 0));
}
$conn->close();
?>
Aucun commentaire:
Enregistrer un commentaire