0

I want to use calander to pick a date as DD.MM.YYYY and post to database. Please help............

Entry.php

<?php
require 'config.php';

if (isset($_GET['logout']))
{
    unset($_SESSION['isLogged']);
    unset($_SESSION['isLogged']);
    session_destroy();
    header('location: index.php');
    exit;
}

if (!isset($_SESSION['userLogin']) && !isset($_SESSION['isLogged']))
{
    header('location: index.php');
    exit;
}

?>
<!doctype html>
<html>
<head>



<meta itemprop="image" content="mainlogo_title.png">
    <title>SEA TURTLE NEST MONITORING RECORD</title>
 <link rel="shortcut icon" href="mainlogo_title.png" type="image/x-icon"/>
    <link rel="stylesheet" href="css/link.css" />
    <script src="js/jquery.js"></script>
    <script src="js/custom.js"></script>
<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
  <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
  <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script>

  <script>
  $(document).ready(function() {
    $("#datepicker").datepicker();
  });
  </script>


    <style type="text/css">
<!--
-->
<style>
#Layer1 {
    position:absolute;
    left:100px;
    top:309px;
    width:744px;
    height:681px;
    z-index:1;
}
body {
    background-color: #FFFFFF;
}


    #Layer1 {
    position:absolute;
    left:600px;
    top:1145px;
    width:54px;
    height:26px;
    z-index:1;
}
    #Layer2 {
    position:absolute;
    width:822px;
    height:1044px;
    z-index:2;
    left: 241px;
    top: 1245px;
}
    #Layer3 {
    position:absolute;
    width:823px;
    height:185px;
    z-index:1;
}
    #Layer4 {
    position:absolute;
    width:722px;
    height:576px;
    z-index:2;
    left: 52px;
    top: 279px;
}
    #Layer5 {
    position:absolute;
    width:183px;
    height:26px;
    z-index:1;
    left: 174px;
    top: 1px;
}
    #Layer6 {
    position:absolute;
    width:169px;
    height:25px;
    z-index:2;
    top: 1px;
}
    #Layer7 {
    position:absolute;
    width:155px;
    height:32px;
    z-index:3;
    left: 361px;
    top: 1px;
}
    #Layer8 {
    position:absolute;
    width:200px;
    height:28px;
    z-index:4;
    left: 523px;
    top: 1px;
}
    #Layer9 {
    position:absolute;
    width:208px;
    height:23px;
    z-index:5;
    top: 36px;
    left: 1px;
}
    #Layer10 {
    position:absolute;
    width:350px;
    height:26px;
    z-index:6;
    left: 367px;
    top: 71px;
}
    #Layer11 {
    position:absolute;
    width:239px;
    height:24px;
    z-index:7;
    left: 215px;
    top: 36px;
}
    #Layer12 {
    position:absolute;
    width:360px;
    height:27px;
    z-index:8;
    left: 1px;
    top: 71px;
}
    #Layer13 {
    position:absolute;
    width:230px;
    height:29px;
    z-index:9;
    left: 495px;
    top: 36px;
}
    #Layer14 {
    position:absolute;
    width:200px;
    height:27px;
    z-index:10;
    left: 115px;
    top: 204px;
}
    #Layer15 {
    position:absolute;
    width:200px;
    height:29px;
    z-index:11;
    left: 459px;
    top: 181px;
}
    #Layer16 {
    position:absolute;
    width:200px;
    height:30px;
    z-index:12;
    left: 70px;
    top: 263px;
}
    #Layer17 {
    position:absolute;
    width:156px;
    height:29px;
    z-index:13;
    left: 3px;
    top: 125px;
}
    #Layer18 {
    position:absolute;
    width:200px;
    height:24px;
    z-index:14;
    left: 377px;
    top: 244px;
}
    #Layer19 {
    position:absolute;
    width:262px;
    height:25px;
    z-index:15;
    left: 70px;
    top: 327px;
}
    #Layer20 {
    position:absolute;
    width:200px;
    height:28px;
    z-index:16;
    left: 298px;
    top: 141px;
}
    #Layer21 {
    position:absolute;
    width:200px;
    height:24px;
    z-index:17;
    left: 362px;
    top: 303px;
}
    #Layer22 {
    position:absolute;
    width:200px;
    height:29px;
    z-index:18;
    left: 344px;
    top: 372px;
}
    #Layer23 {
    position:absolute;
    width:930px;
    height:815px;
    z-index:3;
    left: 175px;
    top: 0px;
    background-color: #FFFFCC;
}
    #Layer24 {
    position:absolute;
    width:885px;
    height:433px;
    z-index:1;
    left: 23px;
    top: 320px;
}
.style6 {font-size: 12px}
.style9 {color: #FFFFFF}
.style12 {color: #CCCCCC}
    .style14 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: #333333; }
.style15 {color: #333333}
    #Layer25 {
    position:absolute;
    width:930px;
    height:21px;
    z-index:4;
    left: 175px;
    top: 816px;
    background-color: #CCCCCC;
}
    .style1 {   font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 12px;
    color: #000066;
}
    #Layer26 {
    position:absolute;
    width:930px;
    height:187px;
    z-index:2;
}
    #Layer27 {
    position:absolute;
    width:76px;
    height:22px;
    z-index:3;
    left: 837px;
    top: 194px;
}
    .style16 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 13px;
}
    #Layer28 {
    position:absolute;
    width:107px;
    height:23px;
    z-index:4;
    left: 706px;
    top: 194px;
}
    .style17 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; }
    #Layer29 {
    position:absolute;
    width:85px;
    height:20px;
    z-index:5;
    left: 390px;
    top: 194px;
}
    #Layer30 {
    position:absolute;
    width:125px;
    height:20px;
    z-index:6;
    left: 22px;
    top: 195px;
    background-color: #FFFFCC;
}
    #Layer31 {
    position:absolute;
    width:192px;
    height:20px;
    z-index:7;
    left: 170px;
    top: 194px;
}
    .style4 {font-family: Verdana, Arial, Helvetica, sans-serif}
    #Layer32 {
    position:absolute;
    width:892px;
    height:24px;
    z-index:8;
    left: 23px;
    top: 267px;
}
    .style18 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 18px; }
    .style19 {color: #003366}
    a:link {
    color: #000000;
    text-decoration: none;
}
a:visited {
    color: #000000;
    text-decoration: none;
}
a:hover {
    color: #000000;
    text-decoration: underline;
}
a:active {
    color: #000000;
    text-decoration: none;
}
    .style20 {color: #FF0000}
    #Layer33 {
    position:absolute;
    width:870px;
    height:25px;
    z-index:5;
    top: 202px;
    left: 2px;
}
    .style22 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16.5px; color: #003366; }
    </style>

</head>

<body>
<!-- start:Wrap --><!-- end:Header -->

<!-- start:Content --><!-- end:Content -->

<!-- start:Footer -->
<p>
  <!-- end:Footer -->

  </div>
  <!-- end:Wrap -->
</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer23">
  <div id="Layer24"><form name="form" method="post" action="insert_ac.php">
    <table width="874" border="0">
      <tr>
        <td width="106" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Day : </span></td>
        <td width="101" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style6" style="font-family: Verdana, Arial, Helvetica, sans-serif">



         <input id="datepicker" />



            </select>
        </span></td>
        <td width="68" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Species : </span></td>
        <td width="132" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style6" style="font-family: Verdana, Arial, Helvetica, sans-serif">
          <select name="species" id="species" style="border:1px solid #999999">
            <option value="">Select Species</option>
            <option>Olive Ridley</option>
            <option>Green Turtle</option>
            <option>Hawksbill</option>
            <option>Loggerhead</option>
            <option>Leatherback</option>
            </select>
        </span></td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Nest Time : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="nesttime" type="text" id="nesttime" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Longitude : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="longitude" type="text" id="longtitude2" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CCL : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="ccl" type="text" id="longtitude4" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Area : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="area" type="text" id="area" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Latitude : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="latitude" type="text" id="longtitude3" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CCW : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="ccw" type="text" id="longtitude5" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Spot : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="spot" type="text" id="spot" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">BHT/AHT : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="bhtaht" type="text" id="longtitude54" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">WT : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="wt" type="text" id="longtitude57" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CS (EGG) : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="csegg" type="text" id="longtitude56" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">High Tide : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="hightide" type="text" id="longtitude55" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CR : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="cr" type="text" id="longtitude52" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Conservation : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="conservation" type="text" id="longtitude53" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Tag : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="tag" type="text" id="longtitude58" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><div class="style22" id="Layer33">
          <div align="center">ENVIRONMENTAL INFORMATION </div>
        </div>          
          <span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Lunerdate : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="lunerdate" type="text" id="longtitude59" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Moonlight/Dark : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="moondark" type="text" id="longtitude510" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Cloud : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="cloud" type="text" id="longtitude511" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Wind : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="wind" type="text" id="longtitude512" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Rain : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="rain" type="text" id="longtitude513" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Remark : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="remark" type="text" id="longtitude514" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style9"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style9"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style9"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style4">
          <input name="submit" type="submit" value="           Submit          " />
        </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"> </td>
      </tr>
    </table>
    </form>
  </div>
  <div id="Layer26"><img src="bannar.png" alt="bannar_image" width="928" height="187"></div>
  <div class="style16" id="Layer27">
    <div align="right" class="style20">Logout</div>
  </div>
  <div class="style17" id="Layer28"><a href="main.php">Back to home </a></div>

  <div class="style18" id="Layer32">
    <div align="center" class="style19">
      <div align="center">aaaa </div>
    </div>
  </div>
</div>

Edited by FOYSAL_1

3
Contributors
15
Replies
39
Views
3 Years
Discussion Span
Last Post by pritaeas
0

What exactly do you need help with? See the manual for datepicker to see how to set "DD.MM.YYYY" as the format. However, since you want to insert into a database, then the most likely format you need is "yyyy-mm-dd".

0

ok please help how to entry with yyyy-mm-dd formet in the database

0
<?php

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="seaturtle"; // Database name
$tbl_name="entry"; // Table name

// Connect to server and select database.
mysql_connect("localhost", "root", "")or die("cannot connect");
mysql_select_db("seaturtle")or die("cannot select DB");

// Get values from form
$date=$_POST['date'];
$species=$_POST['species'];
$nesttime=$_POST['nesttime'];
$area=$_POST['area'];
$spot=$_POST['spot'];
$longitude=$_POST['longitude'];
$latitude=$_POST['latitude'];
$ccl=$_POST['ccl'];
$ccw=$_POST['ccw'];
$cr=$_POST['cr'];
$wt=$_POST['wt'];
$csecg=$_POST['csecg'];
$hightide=$_POST['hightide'];
$bhtaht=$_POST['bhtaht'];
$lunerdate=$_POST['lunerdate'];
$conservation=$_POST['conservation'];
$tag=$_POST['tag'];
$year=$_POST['year'];
$month=$_POST['month'];
$rain=$_POST['rain'];
$cloud=$_POST['cloud'];

// Insert data into mysql
$sql="INSERT INTO $tbl_name(date,species,nesttime,area,spot,longitude,latitude,ccl,ccw,cr,wt,csecg,hightide,bhtaht,lunerdate,conservation,tag,year,month,moondark,rain,cloud,wind,remark)
VALUES('$date','$species','$nesttime','$area','$spot','$longitude','$latitude','$ccl','$ccw','$cr','$wt','$csecg','$hightide','$bhtaht','$lunerdate','$conservation','$tag','$year','$month','$rain','$cloud','$moondark','wind','remark')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message "Successful".
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='main.php'>Back to Main page</a>";
echo "</BR>";
echo "<BR>";
echo "<a href='entry.php'>Back to Entry page</a>";


}

else {
echo "Error!!!!!!!!";
}

// close connection
mysql_close();
?>
0

And please give a date picker on entry form that I submit before..........

0

Sorry Foysal, but I'm a bit lost. There's about 500 lines of markup and styling. This is your datepicker:

<td width="101" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style6" style="font-family: Verdana, Arial, Helvetica, sans-serif">
     <input id="datepicker" />
        </select>
    </span></td>

It doesn't make sense. Do you want to use HTML5 datepicker or something like jQuery? Here's the HTML5 version:

<input type="date" name="mydate">

The format shown in your browser will probably be in your local format - depending on your browser. HOWEVER, the data is sent in "wire" format: yyyy-mm-dd - so if the input shows: 25/12/2013

$_POST['mydate'] would give 2013-12-25

The jQueryUI stuff is available from their website.

Edited by diafol

0

sorry my date picker is,

This is the script

<link rel="stylesheet" type="text/css" media="all" href="jsDatePick_ltr.min.css" />
  <script type="text/javascript" src="jquery.1.4.2.js"></script>
<script type="text/javascript" src="jsDatePick.jquery.min.1.3.js"></script>


  <script type="text/javascript">
    window.onload = function(){
        new JsDatePick({
            useMode:2,
            target:"mydate",
            dateFormat:"%d-%M-%Y"
            /*selectedDate:{                This is an example of what the full configuration offers.
                day:5,                      For full documentation about these settings please see the full version of the code.
                month:9,
                year:2006
            },
            yearsRange:[1978,2020],
            limitToToday:false,
            cellColorScheme:"beige",
            dateFormat:"%m-%d-%Y",
            imgPath:"img/",
            weekStartDay:1*/
        });
    };
</script>

and the form below

<div id="Layer24"><form name="form" method="post" action="insert_ac.php">
    <table width="874" border="0">
      <tr>
        <td width="106" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Date : </span></td>
        <td width="101" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style6" style="font-family: Verdana, Arial, Helvetica, sans-serif">



         <input type="date" size="12" id="date" />




        </span></td>
        <td width="68" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Species : </span></td>
        <td width="132" bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style6" style="font-family: Verdana, Arial, Helvetica, sans-serif">
          <select name="species" id="species" style="border:1px solid #999999">
            <option value="">Select Species</option>
            <option>Olive Ridley</option>
            <option>Green Turtle</option>
            <option>Hawksbill</option>
            <option>Loggerhead</option>
            <option>Leatherback</option>
            </select>
        </span></td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Nest Time : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="nesttime" type="text" id="nesttime" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Longitude : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="longitude" type="text" id="longtitude2" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CCL : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="ccl" type="text" id="longtitude4" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Area : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="area" type="text" id="area" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Latitude : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="latitude" type="text" id="longtitude3" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CCW : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="ccw" type="text" id="longtitude5" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Spot : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="spot" type="text" id="spot" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">BHT/AHT : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="bhtaht" type="text" id="longtitude54" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">WT : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="wt" type="text" id="longtitude57" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CS (EGG) : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="csegg" type="text" id="longtitude56" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">High Tide : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="hightide" type="text" id="longtitude55" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">CR : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="cr" type="text" id="longtitude52" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Conservation : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="conservation" type="text" id="longtitude53" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Tag : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="tag" type="text" id="longtitude58" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><div class="style22" id="Layer33">
          <div align="center">ENVIRONMENTAL INFORMATION </div>
        </div>          
          <span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style15"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Lunerdate : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="lunerdate" type="text" id="longtitude59" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Moonlight/Dark : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="moondark" type="text" id="longtitude510" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Cloud : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="cloud" type="text" id="longtitude511" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Wind : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="wind" type="text" id="longtitude512" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Rain : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="rain" type="text" id="longtitude513" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style14">Remark : </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><input name="remark" type="text" id="longtitude514" size="15"></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style9"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style9"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
      <tr>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style9"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style12"></span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC"><span class="style4">
          <input name="submit" type="submit" value="           Submit          " />
        </span></td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
        <td bordercolor="#FFFFCC" bgcolor="#FFFFCC">&nbsp;</td>
      </tr>
    </table>
    </form>
0

Cut out all the markup - we don't need it. Just the datepicker input. I'm not familiar with this datepicker. The jQueryUI version is called like this:

  $(function() {
    $( "#mydate" ).datepicker({
        //options here
    });
  });
0

how can I post it to database, when i click submit to post it, it shows three error on my php page that is insert_ac.php...........
I already post php page to you

0

Instead of:

$result=mysql_query($sql);

do:

$result = mysql_query($sql) or die(mysql_error());

and post the error message here.

The notices above mean that your HTML form does not contain input's with those names.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.