douxian5076 2016-04-23 20:13
浏览 141

使用AJAX插入数据库而不刷新页面

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??!

  • 写回答

1条回答 默认 最新

  • duanlongnao0028 2016-04-23 20:20
    关注

    value for pure javascript. if you want to get values in jquery, you have to use .val()

    var des= $("#des").val();
    var time= $("#time").val();
    var date= $("#date").val();
    
    评论

报告相同问题?

悬赏问题

  • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
  • ¥15 个人网站被恶意大量访问,怎么办
  • ¥15 Vue3 大型图片数据拖动排序
  • ¥15 Centos / PETGEM
  • ¥15 划分vlan后不通了
  • ¥20 用雷电模拟器安装百达屋apk一直闪退
  • ¥15 算能科技20240506咨询(拒绝大模型回答)
  • ¥15 自适应 AR 模型 参数估计Matlab程序
  • ¥100 角动量包络面如何用MATLAB绘制
  • ¥15 merge函数占用内存过大