Re: [PHP-DB] Inserting NULL values does not work
actually, try using $park = "NULL" instead go $park = NULL;
in php NULL is the same that "" which is the same that 0
> - Original Message -
> From: "Rick Emery" <[EMAIL PROTECTED]>
> To: "'Andy'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, February 01, 2002 7:51 AM
> Subject: RE: [PHP-DB] Inserting NULL values does not work
>
>
> > Your problem is that you've included the value of $park in
single-quotes.
> > Therefore, because it contains NULL, i.e., \0, this is translated to '0'
> in
> > the INSERT statement. You must make your test prior to the INSERT
> statement
> > and use the proper $park value.
> >
> > Or, you can:
> >
> > if ($park == 'false'){
> > $park = NULL;
> > }
> > else{
> > $park = "\"$park\"";
> > };
> >
> > in you INSERT statement change: '$park',to $park,
> >
> > -Original Message-
> > From: Andy [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 01, 2002 9:43 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Inserting NULL values does not work
> >
> >
> > Hi guys,
> >
> > I am trying to insert a NULL value into a DB field. The value is not
> always
> > NULL so the statement is given. Unfortunatelly it is inserting 0 instead
> of
> > NULL.
> >
> > How can I get the thing going with NULL???
> >
> > Here is the code I am using:
> >
> > if ($park == 'false'){
> > $park = NULL;
> > }
> >
> > $stmt = "INSERT INTO $T1
> > (
> > belongs_to,
> > name,
> > caption,
> > country,
> > province,
> > city,
> > glacier,
> > park,
> > lake,
> > mountain,
> > beach,
> > comment,
> > keywords,
> > date_taken,
> > date_posted
> > )
> > VALUES
> > (
> > '$user_id',
> > '$picture',
> > '$caption',
> > '$country',
> > '$province',
> > '$city',
> > '$glacier',
> > '$park',
> > '$lake',
> > '$mountain',
> > '$beach',
> > '$comment',
> > '$keyword',
> > '$date_taken',
> > '$date_posted'
> > )";
> >
> > Cheers Andy
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Inserting NULL values does not work
right ok yes I see, but surely thats
$querystr = "INSERT INTO mytable (name) VALUES(\"O'leary\") " otherwise the
query string gets truncated by PHP at the values point???
My point simply is that he IS using single quotes (see below) and would
therefore suffer from this problem (hence the reason for suggesting such
additional functionality + consideration to validation of input).
> > $stmt = "INSERT INTO $T1
> > (
> > belongs_to,
> > name,
> > caption,
> > country,
> > province,
> > city,
> > glacier,
> > park,
> > lake,
> > mountain,
> > beach,
> > comment,
> > keywords,
> > date_taken,
> > date_posted
> > )
> > VALUES
> > (
> > '$user_id',
> > '$picture',
> > '$caption',
> > '$country',
> > '$province',
> > '$city',
> > '$glacier',
> > '$park',
> > '$lake',
> > '$mountain',
> > '$beach',
> > '$comment',
> > '$keyword',
> > '$date_taken',
> > '$date_posted'
> > )";
But I don't want to piss you off and as you will undoubtable have more mysql
experience than me so please don't take this as some kind of points scoring
exercise / competition - I was just suggesting some additional features he
might want to consider at the same point.
Ollie
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> It won't fail if it is enclosed in double-quotes. That is:
>
> INSERT INTO mytable (name) VALUES("O'leary")
>
> is OK.
>
> -Original Message-
> From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 10:41 AM
> To: Rick Emery; [EMAIL PROTECTED]; Php-Db ML
> Subject: RE: [PHP-DB] Inserting NULL values does not work
>
>
> I know its not failing on YOUR example but if there is a single quote in
the
> data eg someones name is O'leary then the SQL will fail surely?
>
> Ollie
>
> -Original Message-
> From: Rick Emery [mailto:[EMAIL PROTECTED]]
> Sent: 01 February 2002 16:13
> To: '[EMAIL PROTECTED]'; Php-Db ML
> Subject: RE: [PHP-DB] Inserting NULL values does not work
>
>
> It's not failing on the single-quotes. MYSQL can use single-quotes.
>
> -Original Message-
> From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 10:01 AM
> To: Php-Db ML; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Inserting NULL values does not work
>
>
> Why not make it a function which also checks and replaces for characters
SQL
> fails on eg if ' replace with '' in strings etc, and does any sanity /
> validation checks at the same time?
>
> Ollie
>
> "Rick Emery" <[EMAIL PROTECTED]> wrote in message
> news:<[EMAIL PROTECTED]>...
> > Your problem is that you've included the value of $park in
single-quotes.
> > Therefore, because it contains NULL, i.e., \0, this is translated to '0'
> in
> > the INSERT statement. You must make your test prior to the INSERT
> statement
> > and use the proper $park value.
> >
> > Or, you can:
> >
> > if ($park == 'false'){
> > $park = NULL;
> > }
> > else{
> > $park = "\"$park\"";
> > };
> >
> > in you INSERT statement change: '$park',to $park,
> >
> > -Original Message-
> > From: Andy [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 01, 2002 9:43 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Inserting NULL values does not work
> >
> >
> > Hi guys,
> >
> > I am trying to insert a NULL value into a DB field. The value is not
> always
> > NULL so the statement is given. Unfortunatelly it is inserting 0 instead
> of
> > NULL.
> >
> > How can I get the thing going with NULL???
> >
> > Here is the code I am using:
> >
> > if ($park == 'false'){
> > $park = NULL;
> > }
> >
> > $stmt = "INSERT INTO $T1
> > (
> > belongs_to,
> > name,
> > caption,
> > country,
> > province,
> > city,
> > glacier,
> > park,
> > lake,
> > mountain,
> > beach,
> > comment,
> > keywords,
> > date_taken,
> > date_posted
> > )
> > VALUES
> > (
> > '$user_id',
> > '$picture',
> > '$caption',
> > '$country',
> > '$province',
> > '$city',
> > '$glacier',
> > '$park',
> > '$lake',
> > '$mountain',
> > '$beach',
> > '$comment',
> > '$keyword',
> > '$date_taken',
> > '$date_posted'
> > )";
> >
> > Cheers Andy
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Inserting NULL values does not work
It won't fail if it is enclosed in double-quotes. That is:
INSERT INTO mytable (name) VALUES("O'leary")
is OK.
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 10:41 AM
To: Rick Emery; [EMAIL PROTECTED]; Php-Db ML
Subject: RE: [PHP-DB] Inserting NULL values does not work
I know its not failing on YOUR example but if there is a single quote in the
data eg someones name is O'leary then the SQL will fail surely?
Ollie
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2002 16:13
To: '[EMAIL PROTECTED]'; Php-Db ML
Subject: RE: [PHP-DB] Inserting NULL values does not work
It's not failing on the single-quotes. MYSQL can use single-quotes.
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 10:01 AM
To: Php-Db ML; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Inserting NULL values does not work
Why not make it a function which also checks and replaces for characters SQL
fails on eg if ' replace with '' in strings etc, and does any sanity /
validation checks at the same time?
Ollie
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Your problem is that you've included the value of $park in single-quotes.
> Therefore, because it contains NULL, i.e., \0, this is translated to '0'
in
> the INSERT statement. You must make your test prior to the INSERT
statement
> and use the proper $park value.
>
> Or, you can:
>
> if ($park == 'false'){
> $park = NULL;
> }
> else{
> $park = "\"$park\"";
> };
>
> in you INSERT statement change: '$park',to $park,
>
> -Original Message-
> From: Andy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 9:43 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Inserting NULL values does not work
>
>
> Hi guys,
>
> I am trying to insert a NULL value into a DB field. The value is not
always
> NULL so the statement is given. Unfortunatelly it is inserting 0 instead
of
> NULL.
>
> How can I get the thing going with NULL???
>
> Here is the code I am using:
>
> if ($park == 'false'){
> $park = NULL;
> }
>
> $stmt = "INSERT INTO $T1
> (
> belongs_to,
> name,
> caption,
> country,
> province,
> city,
> glacier,
> park,
> lake,
> mountain,
> beach,
> comment,
> keywords,
> date_taken,
> date_posted
> )
> VALUES
> (
> '$user_id',
> '$picture',
> '$caption',
> '$country',
> '$province',
> '$city',
> '$glacier',
> '$park',
> '$lake',
> '$mountain',
> '$beach',
> '$comment',
> '$keyword',
> '$date_taken',
> '$date_posted'
> )";
>
> Cheers Andy
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Inserting NULL values does not work
I know its not failing on YOUR example but if there is a single quote in the
data eg someones name is O'leary then the SQL will fail surely?
Ollie
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2002 16:13
To: '[EMAIL PROTECTED]'; Php-Db ML
Subject: RE: [PHP-DB] Inserting NULL values does not work
It's not failing on the single-quotes. MYSQL can use single-quotes.
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 10:01 AM
To: Php-Db ML; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Inserting NULL values does not work
Why not make it a function which also checks and replaces for characters SQL
fails on eg if ' replace with '' in strings etc, and does any sanity /
validation checks at the same time?
Ollie
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Your problem is that you've included the value of $park in single-quotes.
> Therefore, because it contains NULL, i.e., \0, this is translated to '0'
in
> the INSERT statement. You must make your test prior to the INSERT
statement
> and use the proper $park value.
>
> Or, you can:
>
> if ($park == 'false'){
> $park = NULL;
> }
> else{
> $park = "\"$park\"";
> };
>
> in you INSERT statement change: '$park',to $park,
>
> -Original Message-
> From: Andy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 9:43 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Inserting NULL values does not work
>
>
> Hi guys,
>
> I am trying to insert a NULL value into a DB field. The value is not
always
> NULL so the statement is given. Unfortunatelly it is inserting 0 instead
of
> NULL.
>
> How can I get the thing going with NULL???
>
> Here is the code I am using:
>
> if ($park == 'false'){
> $park = NULL;
> }
>
> $stmt = "INSERT INTO $T1
> (
> belongs_to,
> name,
> caption,
> country,
> province,
> city,
> glacier,
> park,
> lake,
> mountain,
> beach,
> comment,
> keywords,
> date_taken,
> date_posted
> )
> VALUES
> (
> '$user_id',
> '$picture',
> '$caption',
> '$country',
> '$province',
> '$city',
> '$glacier',
> '$park',
> '$lake',
> '$mountain',
> '$beach',
> '$comment',
> '$keyword',
> '$date_taken',
> '$date_posted'
> )";
>
> Cheers Andy
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Inserting NULL values does not work
Like this for example:
http://www.phpbuilder.com/snippet/download.php?type=snippet&id=378
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2002 16:01
To: Php-Db ML; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Inserting NULL values does not work
Why not make it a function which also checks and replaces for characters SQL
fails on eg if ' replace with '' in strings etc, and does any sanity /
validation checks at the same time?
Ollie
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Your problem is that you've included the value of $park in single-quotes.
> Therefore, because it contains NULL, i.e., \0, this is translated to '0'
in
> the INSERT statement. You must make your test prior to the INSERT
statement
> and use the proper $park value.
>
> Or, you can:
>
> if ($park == 'false'){
> $park = NULL;
> }
> else{
> $park = "\"$park\"";
> };
>
> in you INSERT statement change: '$park',to $park,
>
> -Original Message-
> From: Andy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 9:43 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Inserting NULL values does not work
>
>
> Hi guys,
>
> I am trying to insert a NULL value into a DB field. The value is not
always
> NULL so the statement is given. Unfortunatelly it is inserting 0 instead
of
> NULL.
>
> How can I get the thing going with NULL???
>
> Here is the code I am using:
>
> if ($park == 'false'){
> $park = NULL;
> }
>
> $stmt = "INSERT INTO $T1
> (
> belongs_to,
> name,
> caption,
> country,
> province,
> city,
> glacier,
> park,
> lake,
> mountain,
> beach,
> comment,
> keywords,
> date_taken,
> date_posted
> )
> VALUES
> (
> '$user_id',
> '$picture',
> '$caption',
> '$country',
> '$province',
> '$city',
> '$glacier',
> '$park',
> '$lake',
> '$mountain',
> '$beach',
> '$comment',
> '$keyword',
> '$date_taken',
> '$date_posted'
> )";
>
> Cheers Andy
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Inserting NULL values does not work
It's not failing on the single-quotes. MYSQL can use single-quotes.
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 10:01 AM
To: Php-Db ML; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Inserting NULL values does not work
Why not make it a function which also checks and replaces for characters SQL
fails on eg if ' replace with '' in strings etc, and does any sanity /
validation checks at the same time?
Ollie
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Your problem is that you've included the value of $park in single-quotes.
> Therefore, because it contains NULL, i.e., \0, this is translated to '0'
in
> the INSERT statement. You must make your test prior to the INSERT
statement
> and use the proper $park value.
>
> Or, you can:
>
> if ($park == 'false'){
> $park = NULL;
> }
> else{
> $park = "\"$park\"";
> };
>
> in you INSERT statement change: '$park',to $park,
>
> -Original Message-
> From: Andy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 9:43 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Inserting NULL values does not work
>
>
> Hi guys,
>
> I am trying to insert a NULL value into a DB field. The value is not
always
> NULL so the statement is given. Unfortunatelly it is inserting 0 instead
of
> NULL.
>
> How can I get the thing going with NULL???
>
> Here is the code I am using:
>
> if ($park == 'false'){
> $park = NULL;
> }
>
> $stmt = "INSERT INTO $T1
> (
> belongs_to,
> name,
> caption,
> country,
> province,
> city,
> glacier,
> park,
> lake,
> mountain,
> beach,
> comment,
> keywords,
> date_taken,
> date_posted
> )
> VALUES
> (
> '$user_id',
> '$picture',
> '$caption',
> '$country',
> '$province',
> '$city',
> '$glacier',
> '$park',
> '$lake',
> '$mountain',
> '$beach',
> '$comment',
> '$keyword',
> '$date_taken',
> '$date_posted'
> )";
>
> Cheers Andy
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Inserting NULL values does not work
Why not make it a function which also checks and replaces for characters SQL
fails on eg if ' replace with '' in strings etc, and does any sanity /
validation checks at the same time?
Ollie
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Your problem is that you've included the value of $park in single-quotes.
> Therefore, because it contains NULL, i.e., \0, this is translated to '0'
in
> the INSERT statement. You must make your test prior to the INSERT
statement
> and use the proper $park value.
>
> Or, you can:
>
> if ($park == 'false'){
> $park = NULL;
> }
> else{
> $park = "\"$park\"";
> };
>
> in you INSERT statement change: '$park',to $park,
>
> -Original Message-
> From: Andy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 9:43 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Inserting NULL values does not work
>
>
> Hi guys,
>
> I am trying to insert a NULL value into a DB field. The value is not
always
> NULL so the statement is given. Unfortunatelly it is inserting 0 instead
of
> NULL.
>
> How can I get the thing going with NULL???
>
> Here is the code I am using:
>
> if ($park == 'false'){
> $park = NULL;
> }
>
> $stmt = "INSERT INTO $T1
> (
> belongs_to,
> name,
> caption,
> country,
> province,
> city,
> glacier,
> park,
> lake,
> mountain,
> beach,
> comment,
> keywords,
> date_taken,
> date_posted
> )
> VALUES
> (
> '$user_id',
> '$picture',
> '$caption',
> '$country',
> '$province',
> '$city',
> '$glacier',
> '$park',
> '$lake',
> '$mountain',
> '$beach',
> '$comment',
> '$keyword',
> '$date_taken',
> '$date_posted'
> )";
>
> Cheers Andy
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Inserting NULL values does not work
Your problem is that you've included the value of $park in single-quotes.
Therefore, because it contains NULL, i.e., \0, this is translated to '0' in
the INSERT statement. You must make your test prior to the INSERT statement
and use the proper $park value.
Or, you can:
if ($park == 'false'){
$park = NULL;
}
else{
$park = "\"$park\"";
};
in you INSERT statement change: '$park',to $park,
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 9:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Inserting NULL values does not work
Hi guys,
I am trying to insert a NULL value into a DB field. The value is not always
NULL so the statement is given. Unfortunatelly it is inserting 0 instead of
NULL.
How can I get the thing going with NULL???
Here is the code I am using:
if ($park == 'false'){
$park = NULL;
}
$stmt = "INSERT INTO $T1
(
belongs_to,
name,
caption,
country,
province,
city,
glacier,
park,
lake,
mountain,
beach,
comment,
keywords,
date_taken,
date_posted
)
VALUES
(
'$user_id',
'$picture',
'$caption',
'$country',
'$province',
'$city',
'$glacier',
'$park',
'$lake',
'$mountain',
'$beach',
'$comment',
'$keyword',
'$date_taken',
'$date_posted'
)";
Cheers Andy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
