|
|
Posted by "Ben Litton" on 10/18/05 22:35
You're using two =='s for your assignment.
On Tue, 18 Oct 2005 15:15:59 -0400, "Shaun" <shaunthornburgh@hotmail.com>
wrote:
> Hi all,
>
> Thanks for your replies, rather than check each vaule by name I am
> trying to
> produce a more dynamic solution:
>
> foreach ($_POST as $key => $value) {
> if ($value == '') {
> $_POST[$key] == 'NULL';
> }
> }
>
> I was expecting $_POST[$key] to be the same as $key, however this isnt
> the
> case:
>
> $key = city
> $_POST[$key] = London
> $value = London
>
> Any ideas?
>
> ""Richard Lynch"" <ceo@l-i-e.com> wrote in message
> news:6246.67.108.68.36.1129661387.squirrel@www.l-i-e.com...
>> On Tue, October 18, 2005 12:42 pm, tg-php@gryffyndevelopment.com wrote:
>>> That should work. You can set it so you can't have NULL, but dont
>>> know of anything that tells the database not to accept '' as a value
>>
>> Any database, other than MySQL, is *NOT* going to accept '' as an
>> integer value.
>>
>> Because '' is not an integer by any stretch of the imagination.
>>
>> If you don't care about ever porting your application to something
>> other than MySQL, then you can IGNORE the advice to not use '' on
>> integers.
>>
>> If there's ANY possibility that some day somebody might maybe wanna
>> use a different database with your application, then don't confuse
>> strings with integers.
>>
>> Actually, it might be better for your own
>> education/sanity/comprehension/documentation/code to not confuse
>> strings and integers with '' around integers in the SQL, but if
>> everything ELSE is good in your code, and it's "always going to be
>> MySQL" then it's fine.
>>
>> Note that:
>>
>> $value2 = 'NULL'; //PHP $value2 is a string
>>
>> $query = "insert into (integer_field) values ($value2)";
>> //PHP $query is a string, but...
>>
>> The place-holder in $value2 will be just: NULL
>>
>> No quotes.
>>
>> No apostrophes.
>>
>> Not a string.
>>
>> NULL
>>
>> SQL NULL value representing "no value"
>>
>> --
>> Like Music?
>> http://l-i-e.com/artists.htm
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Navigation:
[Reply to this message]
|