Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #1747
| From | Jerry Stuckle <jstucklex@attglobal.net> |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: problem saving date fields |
| Date | 2011-05-21 10:32 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <ir8idn$ojm$1@dont-email.me> (permalink) |
| References | <2407eb47-b406-432c-9aed-b76abc94aae9@z37g2000vbl.googlegroups.com> <hdqdt6t7376p18vh6jr8kdfrfgl9fn1iv2@4ax.com> <ir78cp$53s$1@dont-email.me> <ms9et65fukkeqtr9l5ki4bq4mt11tuj4ce@4ax.com> |
On 5/20/2011 11:13 PM, Jeff North wrote:
<Several pieces of unrelated items snipped>
> On Fri, 20 May 2011 22:35:03 -0400, in comp.lang.php Jerry Stuckle
> <jstucklex@attglobal.net>
> <ir78cp$53s$1@dont-email.me> wrote:
>
>> |>
>> |> How are you setting the $arrival_* and $depature_* values?
>> |
>> | From the input - after is is sent from his form.
>
> Therefore the variables aren't initialised and would cause php errors
> - right?
>
Not if he's programmed correctly and is not using them. There is no
need to initialize variables which are not being used.
>> |> If this is a new entry then all of the $arrival_* and $depature_* will
>> |> be null or zero - therefore the select options will not be
>> |> automatically selected (View Source of the page to see if there are
>> |> any error messages within these lists).
>> |
>> | No, because he isn't setting them until after the form has been
>> | displayed and the user has made his selection.
>
> Methinks you are making too many assumptions - have you seen the full
> source code of the page?
>
No, but I've seen enough to understand what he's doing.
>
> Who said anything about "add a row every time the page is displayed".
> According to your criteria there would never be any edit pages - only
> add pages.
>
> If editing an existing item wouldn't you want to read the already
> stored data from the database?
>
That's what it looked like you were trying to say.
> i.e.
> // initialise variables to meaningful values
> // if editing an existing entry
> // read record
> // overwrite initialised variables
> // display the page
>
Completely unnecessary to initialize values which are not used.
>> |
>> | He needs to do other validation on the data also, but first he needs to
>> | get this part working.
>
> ...and how do you know this, hmmmm?
>
Because I see the code he's using.
>> |>> | $sqlUpdate = mysql_query("UPDATE myMembers SET
>> |>> | firstname='$firstname', lastname='$lastname', gender='$gender',
>> |>> | partner='$partner', country='$country', rank='$rank',
>> |>> | service='$service', position='$position',
>> |>> | arrival_date='$arrival_date',departure_date='$departure_date' WHERE
>> |>> | id='$id' LIMIT 1");
>> |>> |
>> |>> | Is there a reason why this happens? I do create the right format to
>> |>> | put the data back in the table.
>> |>
>> |> But are the values your setting the ones you expect?
>> |
>> | That's why the suggestion to print the SQL statement he generated.
>
> The SQL statement should be ok - it's the "When I change of them the
> other one gets set back to default: 00-00-0000" I'm considering.
>
The SQL statement is NOT ok. As he would find if he printed it out as
was suggested.
>> | BTW - your sig separator is broken. It needs to be exactly
>> | hyphen-hyphen-space-newline.
>
> Oh Jerry is now the sig line cop :-P
> Complain to the writers of Thunderbird as I couldn't care less about
> whether or not my sig appears 'correctly' in your news reader.
> -- -------------------------------------------------
> The supplied code is for guideline purposes only.
It has nothing to do with Thunderbird. It has EVERYTHING to do with
following usenet standards, in this case RFC 3736.
But I see you're as clueless about rfcs as you are programming.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-20 11:38 -0700
Re: problem saving date fields Luuk <Luuk@invalid.lan> - 2011-05-20 20:50 +0200
Re: problem saving date fields Jeff North <jnorthau@yahoo.com.au> - 2011-05-21 08:58 +1000
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-20 22:35 -0400
Re: problem saving date fields Jeff North <jnorthau@yahoo.com.au> - 2011-05-21 13:13 +1000
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-20 23:47 -0700
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-21 00:18 -0700
Re: problem saving date fields Luuk <Luuk@invalid.lan> - 2011-05-21 09:54 +0200
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-21 10:37 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-21 08:07 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-21 19:55 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-22 14:20 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-22 17:28 -0400
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-21 10:32 -0400
Re: problem saving date fields Jeff North <jnorthau@yahoo.com.au> - 2011-05-22 02:08 +1000
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-21 20:01 -0400
Re: problem saving date fields "Twayne" <nobody@devnull.spamcop.net> - 2011-05-21 20:30 -0400
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-21 23:13 -0400
Re: problem saving date fields Jeff North <jnorthau@yahoo.com.au> - 2011-05-22 14:28 +1000
Re: problem saving date fields Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-05-22 12:45 +0200
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-22 08:26 -0400
Re: problem saving date fields "Twayne" <nobody@devnull.spamcop.net> - 2011-05-22 09:20 -0400
Re: problem saving date fields Jeff North <jnorthau@yahoo.com.au> - 2011-05-23 00:08 +1000
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-22 13:47 -0400
Re: problem saving date fields Bill B <me@privacy.net> - 2011-05-22 14:17 -0400
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-22 14:26 -0400
Re: problem saving date fields Bill B <me@privacy.net> - 2011-05-22 16:27 -0400
Re: problem saving date fields Jeff North <jnorthau@yahoo.com.au> - 2011-05-23 09:01 +1000
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-22 20:21 -0400
Re: problem saving date fields Bill B <me@privacy.net> - 2011-05-22 21:36 -0400
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-22 21:46 -0400
Re: problem saving date fields Jeff North <jnorthau@yahoo.com.au> - 2011-05-23 12:20 +1000
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-22 22:30 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-22 21:51 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-23 07:13 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-23 10:18 -0700
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-23 10:27 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-23 14:16 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-23 12:17 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-23 18:00 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-23 22:30 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-24 05:45 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-26 02:10 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-26 05:43 -0400
Re: problem saving date fields Co <vonclausowitz@gmail.com> - 2011-05-23 14:26 -0700
Re: problem saving date fields Jerry Stuckle <jstucklex@attglobal.net> - 2011-05-23 18:01 -0400
Re: problem saving date fields Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-05-23 23:59 +0200
Re: problem saving date fields "Twayne" <nobody@devnull.spamcop.net> - 2011-05-22 09:11 -0400
csiph-web