Member Avatar for ElegantElephant

I have a table called projects, and I'm currently coding the "create a project" functionality that allows the administrator to create a new project and save it in the projects mysql table.

I have a slight problem though, I have two fields/inputs named start date and deadline date, what should I use to allow selection of these dates in the form?

  • 3 Contributors
  • 3 Replies
  • 84 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by saiprem
Member Avatar for harry_watson

Have you got some tables and fields set up
in mysql? With date fields?

$from_date= date(Y,M,D)//or whatever php date function u decide.
$to_date = date(Y,M,D)//or whatever php date, could be today for example. 
$from_date = $_REQUEST['day_one'];
$to_date = $_REQUEST['today'];

then you SELECT day one < = $from_date and > = $to_date WHERE this AND so on...

See the date function
on php.net http://nz.php.net/manual/en/function.date.php

Edited by harry_watson because: spelling error
Member Avatar for saiprem

Use javascript date picker, there are may opensource scripts are available for it, gooogle it and get any one them and implement it in your scripts, I suggest Jquery is one of the best date picker.

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.