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 #174192 is a reply to message #174191] Thu, 26 May 2011 09:43 Go to previous messageGo to previous message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
Senior Member
On 5/26/2011 5:10 AM, Co wrote:
> On 24 mei, 12:45, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>> On 5/24/2011 1:30 AM, Co wrote:
>>
>>
>>
>>> On 24 mei, 00:00, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>>>> 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).
>>
>>> Are you saying that all this coding was necessary if I had
>>> straightened out
>>> my select code?
>>
>>> Marco
>>
>> No, all that coding is UNNECESSARY if you straighten out your select code.
>>
>> You do still want to validate the input, but it's much less complex -
>> i.e. in your case all you need to do is ensure the value is an integer
>> (check out intval()). And if it is not, just reject the input. No need
>> to try to correct it.
>>
>
> Jerry,
>
> that doesn't solve my problem.
> It just tells me that there is a dead end street.
>
> Marco

Marco, I gave you hints on how to code your html. Learn how to do it
properly. And if you need html help, try an html newsgroup.

--
==================
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: Fri Nov 22 20:22:45 GMT 2024

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

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