Help On Creating a Script

alexrho · December 14th, 2005, 12:13 PM

Hello

I am new in php and i want to ask you something

I want to create a script that the admin will choose a date e.x 12 December 2005

and click sumbit and show him the result only for 12 december 2005

I have created the arrays for day month and year and i want now someone to help me how i can add the things that i told you before

This is the code that i have written :

<html>

<head>
  <title></title>
</head>

<body>

<?php
/* Program name: report.php
* Description: Program displays a selection list that
* customers can use to select a date.
*/
$link = mysql_connect("mysql_host", "mysql_login", "mysql_password")
  or die ("Could not connect to MySQL");

mysql_select_db ("my_database")
  or die ("Could not select database");
echo "<html>
<head><title>Select a date</title></head>
<body>";
/* create an array of months*/
$monthName = array(1=> "January", "February", "March",
"April", "May", "June", "July",
"August", "September", "October",
"November", "December");
$today = time(); //stores today's date
$f_today = date("M-d-Y",$today); //formats today's date
echo "<div align='center'>\n";
/* display today's date */
echo "<p> <h3>Today is $f_today</h3>\n";
/* create form containing date selection list */
echo "<form action='processform.php' method='POST'>\n";
/* build selection list for the month */
$todayMO = date("m",$today); //get the month from $today
echo "<select name='dateMO'>\n";
for ($n=1;$n<=12;$n++)
{
echo "<option value=$n\n";
if ($todayMO == $n)
{
echo " selected";
}
echo "> $monthName[$n]\n";
}
echo "</select>";
/* build selection list for the day */
$todayDay= date("d",$today); //get the day from $today
echo "<select name='dateDay'>\n";
for ($n=1;$n<=31;$n++)
{
echo " <option value=$n";
if ($todayDay == $n )
{
echo " selected";
}
echo "> $n\n";
}
echo "</select>\n";
/* build selection list for the year */
$startYr = date("Y", $today); //get the year from $today
echo "<select name='dateYr'>\n";
for ($n=$startYr;$n<=$startYr+1;$n++)
{
echo " <option value=$n";
if ($startYr == $n )
{
echo " selected";
}
echo "> $n\n";
}
echo "</select>\n";
echo "</form>\n";

?>
</body>

</html>

jmaronilla · December 15th, 2005, 02:16 AM

First you need to add a submit input type on your form:
<input type="submit" name="submit" value="submit">
Then you need php file name processform.php. and
have a script that will check if submit button was clicked:
if (!(array_key_exists('submit', $_POST)))
{
  // This will redirect back to the form
  echo "This will redirect back to the form";
  header (Location: URL where the above form is located);
  exit();
}
else
{
  // validate each form input if there are values submitted.
  // for example:
  $dateMo = $_POST['dateMo'];
  if (!isset($dateMo))
  {
    $mm = false;
  }
  else
  {
    $mm = true;
  }

  $dateDay = $_POST['dateDay'];
  if (!isset($dateDay))
  {
    $dd = false;
  }
  else
  {
    $dd = true;
  }

  $dateYr = $_POST['dateYr'];
  if (!isset($dateYr))
  {
    $yy = false;
  }
  else
  {
    $yy = true;
  }

  // All should be true
  if ( $mm && $dd && $yy )
  {
    // Process script to retreive data from the database.
  }

}

Hope this helps.
jmaronilla