display data after choosing option in selection box

[Celina]

i want to write a script which show the data from database after choosing the option in selection box.

here is part of my coding:

<form name="form1" method="post" action="untitled.php?sdate=$viewdate">
<?php
// create the selection box - date format

if ($sdate)
{
$vdate = $sdate;
}
else
{
$vdate = date("Y-m-d");
}
$count = 30;
echo "<select name=\"viewdate\">";
for ($i = 0; $i < $count; $i++)
{
$ddate = date("Y-m-d",mktime (0,0,0,date("m"), date("d")+$i, date("Y")));
echo "<option value=\"$ddate\"> $ddate</option>";

}
?>

<input type="submit" name="Submit" value="Submit">
</form>
<br>

// sql statement to retrieve the data (using variable $vdate)
// format the data in table

I can display the data correct first time i go to the page "untitled.php". However, after i choose an option in the selection box and submit. No record can be found. When i display the variable $vdate, it become "$viewdate".

Where is the problem?

😕

[floR]

It looks like you're mixing GET and POST.

The form.action is a GET method, whereas you submit the form as a POST.

Another thing is that the URL to submit to, is called untitled.php?sdate=$viewdate, thus bypassing any PHP... The next page will naturally assign the string "$viewdate" to the variable $sdate.

So you could try either to get rid of the GET-type URL in the form.action, or place <? ?> around $viewdate in that action.

But my advise is to not mix GET and POST as that may result in unpredictable behaviour. Rather put the sdate=$viewdate in a hidden input field like
<input type="hidden" name="sdate" value="<? echo($viewdate) ?>">

I think.

[zcketcher]

It looks like your missing your </select>....also...just a style and minimalist note....I would write your if/else as follows:

if (!$sdate)  {
$sDate = date("y-m-d");
}

...get rid of $vDate - its not needed..you already have your value if one exists in $sDate, and if there is no $sDate value, upon load the if above will set it to what you want.

Also I agree with the previous post...mixing GET/POST should be avoided...GET should be avoided if possible and the hidden field is a great way to get arround using GET.

[Celina]

Thanks floR and zchetcher. I can solve the problem. Will pay attention on GET/POST method.

😉