Insert date from datepicker into msql database using jQuery Mobile framework and php

Question

I would like to insert the date from datepicker into my msql database but the error function is called in ajax query instead of success and the date is not inserted.

HTML:

<form id="dForm">
         <input type="date" name="date" id="date">
         <input type="submit" name="submit" id="submit" value="Submit">
    </form>

JAVASCRIPT:

$(function(){
  $("#my-page").submit(function(e){
    e.preventDefault();

    var formData = $("#dForm :input")
      .datepicker("getDate").serialize();

    console.log(formData);

    $.ajax({
       url: "php/file.php",
       type: "POST",
       data: formData,
       dataType: "json",
       async: "false",
       encode: true,
       success: function(response)
       {
           if(response.status == 'success')
           {
             console.log(response);
             $.mobile.changePage("#next-page");
           }
       },

       error: function(response)
       {
         alert("error.");
         console.log(response);
       }
   });
 });
});

PHP:

include_once("db.php");

if(!empty($_POST["date"])){

$date = strtotime($_POST["date"]);
$date = date("Y-m-d",$date);

    $q = "INSERT INTO table (date) VALUES ('$date')";
    $res = ($q);
    $array = array();

    if (mysqli_query($conn, $res)) {
      $array["status"] = "success";
      $array["message"] = "successful";
      $array["date"] = $form_date;
    }else{
      $array["status"] = "error";
      $array["message"] = "failed";
      header('HTTP/1.1 401 Unauthorized', true);
    }
    echo json_encode($array);
  }

The date picker works correctly and shows the date selected in the textfield but I cannot insert the date selected. I believe it may be an error regarding the php. Help would very much be appreciated.

Michael · Accepted Answer · 2017-03-06 12:56:25Z

1

Just a typo mistake: Instead of $("#da") you have to write $("#dat")

See https://jsfiddle.net/kkybs254/

edited Mar 6, 2017 at 12:56

answered Mar 6, 2017 at 12:30

Michael

1891 silver badge17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert date from datepicker into msql database using jQuery Mobile framework and php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related