Inserting Date into MYSQL database

[sonic00]

I am having some problems inserting data into the database

Can anybody help?

 

$mysqli1 = new mysqli ("localhost", "root","pogo", "bookingsystem");

$stmt = $mysqli1 -> prepare("INSERT INTO booked(bookedID,dateBookedFor,userID,slotID,roomID)

VALUES(?,?,?,?,?)");

//STORE IN VARIABLE

$stmt->bind_param('iisss', 4,FROM_UNIXTIME('$dateBookedOn'),$u, 6,'1001');

$_SESSION['Step'] = "Just before condition";

if($stmt -> execute())

{

$_SESSION['Step'] = "Data inserted succesfully";

echo "true";

}

else

{

$_SESSION['Step'] = "Data failed to be inserted";

echo "existed";

}

 

[jesushax]

what is the error?