I am trying to write PHP code (req_form.php) which is supposed to insert into an SQL Database "Requests" without refreshing the page, by sending inserted data to (insert.php) and its just not working :(
Here is my "Request" table: Request
req_form.php:
<form action="req_form.php" method="post">
<textarea id="des" name="des" placeholder="Problem description" type="text" required></textarea>
<input id="date" name="date" placeholder="Date (YEAR-MONTH-DAY)" type="date"/>
<input id="time" name="time" placeholder="Time (Hour:Minute)" type="time"/>
<button type="submit" name="send" id="send" onclick="Send_req()"> Send</button>
</form>
<script type="text/javascript">
function Send_req() {
var des= $("#des").value;
var time= $("#time").value;
var date= $("#date").value;
$.ajax({
type: "POST",
url: 'insert.php',
data: {des:des, time:time, date:date;},
success: function(html)
{
if (html=='1')
{
alert ("Congratulations, Request Sent Successfuly! ");
}
else
{
alert ("Sorry, Error in sending request!");
}
}
});
}
</script>
insert.php:
<?php
$connect= mysql_connect("localhost","root","") or die("Can't connect to database!");
$db = mysql_select_db("hwp",$connect) or die ("Can't select database!");
if($_POST["des"] !="" && $_POST["date"] != "" && $_POST["time"] !="" )
{
$des= mysql_real_escape_string($_POST["des"]);
$date= mysql_real_escape_string($_POST["date"]);
$time= mysql_real_escape_string($_POST["time"]);
$sender= '1';
$receiver= '2';
$sql = mysql_query("INSERT INTO request (Req_sender_id, Req_receiver_id, Req_date, Req_time, Req_msg) VALUES ( '$sender','$receiver','$date','$time','$des');") or die(mysql_error());
if ($sql)
{
echo '1';
}
else
{
echo '0';
}
}
?>
What is the problem??!