我不能在php中发布session和post变量

Question

Hi guys I have below code for creating a simple php private message I have below send form

<form enctype="multipart/form-data" method="POST" action="send.php">
<label>To</label>
<select name="To" class="form-control">
<option value="user">user</option>
<option value="user1">user1</option>
</select>
<input type="hidden" name="From" value="<?php $_SESSION['user'];?>">
<label>Subject</label>
<input type="text" name="Subject" placeholder="Subject">
<label>Message</label>
<textarea class="form-control" cols="40" name="Message" placeholder="Message" rows="10"></textarea>
<input type="hidden" name="Date" value="<?php date("F j, Y, g:i a"); ?>">
<button type="submit" name="Send" class="btn btn-success">Send</button></form>

and my php code is as below:

<?php 
session_start();
include 'db.php';
if(isset($_POST['Send'])){
    $To = $_POST['To'];
    $From = $_POST['From'];
    $Sub = $_POST['Subject'];
    $Mess = $_POST['Message'];
    $Date = $_POST['Date'];

$sql = "INSERT INTO pm from, to, sub, mess, date VALUES '$From', '$To', '$Sub', '$Mess', '$Date'";
$result = mysqli_query($con, $sql);

if($result == true){
$sent = "Message sent Successfully";
header("Location: Home.php?message=$sent");
}
else{
$ntsent = "Message not sent Successfully";
header("Location: Home.php?message=$ntsent");
}
mysqli_close($con); 
}
?>

It always says message not sent successfully message can you please guess what is wrong?

Answer 1

I think your INSERT query is incomplete. Try this out

$sql = "INSERT INTO TABLE_NAME (pm, from, to, sub, mess, date) VALUES ('$From', '$To', '$Sub', '$Mess', '$Date'");