FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » Imported messages » comp.lang.php » problem saving date fields
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: problem saving date fields [message #174167 is a reply to message #174162] Mon, 23 May 2011 22:00 Go to previous messageGo to previous message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
Senior Member
On 5/23/2011 3:17 PM, Co wrote:
> On 23 mei, 20:16, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>> On 5/23/2011 1:27 PM, Co wrote:
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>> On 23 mei, 13:13, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>>>> On 5/23/2011 12:51 AM, Co wrote:
>>
>>>> >> ==================
>>
>>>> > Wow you guys really love each other.
>>
>>>> > Marco
>>
>>>> Yea, unfortunately, you have to put up with some trolls on usenet.
>>
>>> So when one of the three dates is not changed it returns the month
>>> written.
>>> Than this code:
>>> $arrival_month = preg_replace('#[^0-9]#i', '',
>>> $_POST['arrival_month']);
>>> ruins the date and it gets set back to 00-00-0000.
>>> Is there a way to detect changes? because than I could set an if
>>> statement before
>>> running the UPDATE query and we leave out the dates that were not
>>> changed.
>>
>>> Marco
>>
>> OK, the question is, where is it getting the month name instead of the
>> number? It has to be coming from your html code. Look at the page
>> source and see where you're putting 'April' in there instead of 4.
>>
>> As for detecting when the data changed - the only way is to do something
>> like save the current data in your $_SESSION and compare when it is
>> retrieved. However, that isn't necessary if you get your problem with
>> the month name being retrieved. It doesn't hurt to update a value in
>> the database with the same value.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================
>
> It is getting the name of the month when the pulldown menu is filled.
>
> <select name="arrival_month" class="formFields" id="arrival_month">
> <option value="<?php print "$arrival_month"; ?>"><?php print
> "$arrival_month"; ?></option>
> <option value="01">January</option>
> <option value="02">February</option>
> <option value="03">March</option>
> <option value="04">April</option>
> <option value="05">May</option>
> <option value="06">June</option>
> <option value="07">July</option>
> <option value="08">August</option>
> <option value="09">September</option>
> <option value="10">October</option>
> <option value="11">November</option>
> <option value="12">December</option>
> </select>
>
> The problem is that during the Post it returns the name instead of the
> number.
>
> I tried this code but when I don't change the month it doesn't pass
> the code:
> if(!is_numeric($arrival_month)) {
>
> for($i=1;$i<=12;$i++){
> if(strtolower(date("M", mktime(0, 0, 0, $i, 1, 0))) ==
> strtolower($arrival_month)){
> $arrival_month = $i;
> }
> }
> print $arrival_month;
> }
>
> Marco

Of course it will. You have:

<option value="<?php print "$arrival_month"; ?>"><?php print
"$arrival_month"; ?></option>

Which has the month name as its option value. If the arrival month were
April, you would have two Aprils - the first one in the SELECT element
with a value of 'April', then one later with a value of '4'.

You need to straighten out your HTML. You only need one APRIL. Look
up the SELECT/OPTION element and learn how to display the previously
selected value instead of the first value (hint: look for the SELECTED
keyword).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: is dis da place?
Next Topic: foreach in reverse
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 12:03:38 GMT 2024

Total time taken to generate the page: 0.04331 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software