Add calender date picker and enter date in to my database

Question

FOYSAL_1 0 Newbie Poster

10 Years Ago

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>

css javascript php

Edited 10 Years Ago by FOYSAL_1

3 Contributors
15 Replies
394 Views
17 Hours Discussion Span
Latest Post 10 Years Ago Latest Post by pritaeas

All 15 Replies

pritaeas 2,194 ¯\_(ツ)_/¯

10 Years Ago

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".

diafol

10 Years Ago

Where's your php code? What have you tried?

diafol

10 Years Ago

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 10 Years Ago by diafol

diafol

10 Years Ago

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
    });
  });

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

FOYSAL_1 0 Newbie Poster · Answer 1 · 2014-01-15T17:59:53+00:00

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

FOYSAL_1 0 Newbie Poster · Answer 2 · 2014-01-15T18:19:42+00:00

<?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();
?>

FOYSAL_1 0 Newbie Poster · Answer 3 · 2014-01-15T18:22:23+00:00

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

FOYSAL_1 0 Newbie Poster · Answer 4 · 2014-01-15T19:17:58+00:00

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>

FOYSAL_1 0 Newbie Poster · Answer 5 · 2014-01-15T19:18:52+00:00

FOYSAL_1 0 Newbie Poster

10 Years Ago

it shows three error

FOYSAL_1 0 Newbie Poster · Answer 6 · 2014-01-16T05:19:21+00:00

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

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 7 · 2014-01-16T07:38:52+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

10 Years Ago

it shows three error

What errors?

FOYSAL_1 0 Newbie Poster · Answer 8 · 2014-01-16T08:26:48+00:00

FOYSAL_1 0 Newbie Poster

10 Years Ago

Please see the error with attachment.

1bff506afbc462e091f34c2295cef552

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 9 · 2014-01-16T08:39:50+00:00

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.

FOYSAL_1 0 Newbie Poster · Answer 10 · 2014-01-16T09:04:12+00:00

FOYSAL_1 0 Newbie Poster

10 Years Ago

Now I have this error,

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 11 · 2014-01-16T09:15:40+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

10 Years Ago

Apparently moondark is not a column in your table.

Add calender date picker and enter date in to my database

Recommended Answers Collapse Answers

All 15 Replies

Recommended Answers