留空时jquery datepicker输入值本身（codeigniter）

Question

excuse me, i am still a nubie in programming and want to make an edit page with datepicker in it. the problem is, when i leave the datepicker input null and proceed to submit the edited data, datepicker automatically input data to database with its oldest date.

my question is, how to make a validation when the datepicker is not filled, system will not input anything to database?

this is the datepicker script in view

 <script>
  $(function() {
    $( "#datepicker" ).datepicker();
    $("#datepicker").datepicker('setDate', null);
  });
  $(function() {
    $( "#selesai" ).datepicker();
    $( "#selesai").datepicker('setDate', null);
  });
  </script>

and here is the doEdit function in controller

public function doEdit(){
    $id_req = $this->input->post('idrequest');
    //$fnama = $this->input->post('first');
    //$lnama = $this->input->post('lnama');
    //$email = $this->input->post('email');
    //$subto = $this->input->post('submitted');
    $reqtype = $this->input->post('reqtype');
    $status = $this->input->post('jenisstatus');
    $date_mulai = $this->input->post('datepicker'));
    $date_selesai = $this->input->post('selesai'));


    //$date_selesai = $this->input->post('selesai');
    //$message = $this->input->post('message');


    $type = $this->db->query("SELECT reqType,nomorUrut FROM tbl_request WHERE id_request = '$id_req'");
    $cek_nomor = $this->db->query("SELECT nomorTiket FROM tbl_request WHERE id_request='$id_req' ");
    $res_tipe = $type->row();
    $tipe_request = $res_tipe->reqType;
    $nomor_urut = $res_tipe->nomorUrut;
    $res = $cek_nomor->row();
    if($tipe_request == $reqtype){
        $nomors = $res->nomorTiket;
    }else{
        $cek_tgl = $this->db->query("SELECT dateSubmit, firstName, lastName FROM tbl_request WHERE id_request = '$id_req' ");
        $cek_urutan = $this->db->query("SELECT max(nomorUrut) as terakhir FROM tbl_request WHERE reqType = '$reqtype' ");
        $res_tgl = $cek_tgl->row();
        $res_urut = $cek_urutan->row();

        $tglSubmit = date("dmY", strtotime($res_tgl->dateSubmit));
        $fnama = $res_tgl->firstName;
        $lnama = $res_tgl->lastName;

        $urutTerakhir = $res_urut->terakhir;
        $nomor_urut = $urutTerakhir +1;

        if($reqtype==1){
            $tipe = "B";
        }else{
            $tipe = "J";
        }
        $nomors = strtoupper($tipe.$nomor_urut."-".$fnama[0].$lnama[0]."-".$tglSubmit);
    }
    $data = array(
        "nomorTiket"=>$nomors,
        "reqType"=>$reqtype,
        "status"=>$status,
        "nomorUrut"=>$nomor_urut,
        "startDate"=>date("Y-m-d", strtotime($date_mulai)),
        "endDate"=>date("Y-m-d", strtotime($date_selesai))
    );
    $id = array(
        "id_request"=>$id_req
    );
    $this->m_ticketing->update_data($data, $id);
    //echo $nomors."<br>idreq".$id_req."<br>req".$reqtype."<br>submit".$tglSubmit."<br>c".$c."<br>".$jmlChara."<br>idreq".$id_request."<br>".$fnama;
    redirect("index/data_admin");
}

that's my question, thank you

Answer 1

i think empty of your column followed by script please removed and check

$("#datepicker").datepicker('setDate', null);