PHP MySql Update

[Akhenaten]

Coding apparently leads to blindness! I have an unclosed quote in here
and I'm not sure where......

$query="UPDATE table_name set ".
"First_Name = \"".$formVar s["First_Name "]."\",".
"Date_Committed = \"".$formVar s["Date_Committed "]."\",".
"Signed_By= \"".$formVar s["Signed_By"]."\",".
"Rep= \"".$formVar s["Sales_Rep"]."\",".
"Aut= \"".$formVar s["Atty"]."\",".
"Car= \"".$formVar s["Car"]."\",".
"Dbl= \"".$formVar s["Dbl"]."\",".
"Sts= \"".$formVar s["Sts"]."\",".
"Notes= \"".$formVar s["Notes"]."\",".
" \"WHERE Client_ID = \"".$formVar s["Client_ID"]."\"";

mysql_query($qu ery);

Your eyesite is appreciated!

[Geoff Berrow]

Re: PHP MySql Update

Message-ID: <1164073657.807 358.34740@h54g2 000cwb.googlegr oups.comfrom
Akhenaten contained the following:

>$query="UPDA TE table_name set ".

shouldn't that be
$query="UPDATE table_name set

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Chris Hope]

Re: PHP MySql Update

Akhenaten wrote:

Coding apparently leads to blindness! I have an unclosed quote in here
and I'm not sure where......
>
$query="UPDATE table_name set ".
"First_Name = \"".$formVar s["First_Name "]."\",".
"Date_Committed = \"".$formVar s["Date_Committed "]."\",".
"Signed_By= \"".$formVar s["Signed_By"]."\",".
"Rep= \"".$formVar s["Sales_Rep"]."\",".
"Aut= \"".$formVar s["Atty"]."\",".
"Car= \"".$formVar s["Car"]."\",".
"Dbl= \"".$formVar s["Dbl"]."\",".
"Sts= \"".$formVar s["Sts"]."\",".
"Notes= \"".$formVar s["Notes"]."\",".
" \"WHERE Client_ID = \"".$formVar s["Client_ID"]."\"";
>
mysql_query($qu ery);
>
Your eyesite is appreciated!

Wow, that's really hard to read... is there are reason you keep opening
and closing the string? It would be much easier to write it like this:

$query="UPDATE table_name set
First_Name = \"$formVars[First_Name]\",
Date_Committed = \"$formVars[Date_Committed]\",
Signed_By = \"$formVars[Signed_By]\",
....
";

or even using heredoc syntax like this:

$query = <<<END_OF_QUE RY
UPDATE table_name set
First_Name = "$formVars[First_Name]",
Date_Committed = "$formVars[Date_Committed]",
Signed_By = "$formVars[Signed_By]",
...
END_OF_QUERY;

Secondly, I hope you are escaping the variables in $formVars before
putting them into that string. If not, someone could inject sql into
the form variables and your sql will have unexpected consequences. Try
Googling "sql injection attack" some time to find out more.

If you use the PEAR DB library, ADODB or ADODB_Lite (and other database
libraries that are out there) instead of the straight php mysql_*
functions, you'll be able to use variable binding which helps to
eliminate the sql injection issues, and also can make your code a lot
easier to read. They also add portability between databases and error
checking.

Example of variable binding:

$db->query("
UPDATE table_name
SET First_Name = ?,
Date_Committed = ?,
Signed_By = ?
...",
array(
$formVars['First_Name'],
$formVars['Date_Committed '],
$formVars['Signed_By']
...
)
);

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Michael Fesser]

Re: PHP MySql Update

..oO(Chris Hope)

>Wow, that's really hard to read... is there are reason you keep opening
>and closing the string? It would be much easier to write it like this:
>
>$query="UPDA TE table_name set
First_Name = \"$formVars[First_Name]\",
Date_Committed = \"$formVars[Date_Committed]\",
Signed_By = \"$formVars[Signed_By]\",
>...
>";

Even simpler and more SQL-compliant with single quotes:

$query="UPDATE table_name set
First_Name = '$formVars[First_Name]',
Date_Committed = '$formVars[Date_Committed]',
Signed_By = '$formVars[Signed_By]',
....
";

>If you use the PEAR DB library, ADODB or ADODB_Lite (and other database
>libraries that are out there) instead of the straight php mysql_*
>functions, you'll be able to use variable binding which helps to
>eliminate the sql injection issues, and also can make your code a lot
>easier to read.

http://www.php.net/pdo

Micha

[Chris Hope]

Re: PHP MySql Update

Michael Fesser wrote:

.oO(Chris Hope)
>

>>Wow, that's really hard to read... is there are reason you keep
>>opening and closing the string? It would be much easier to write it
>>like this:
>>
>>$query="UPDAT E table_name set
> First_Name = \"$formVars[First_Name]\",
> Date_Committed = \"$formVars[Date_Committed]\",
> Signed_By = \"$formVars[Signed_By]\",
>>...
>>";

>
Even simpler and more SQL-compliant with single quotes:
>
$query="UPDATE table_name set
First_Name = '$formVars[First_Name]',
Date_Committed = '$formVars[Date_Committed]',
Signed_By = '$formVars[Signed_By]',
...
";

Very true. Now why didn't I think of that ;)

>>If you use the PEAR DB library, ADODB or ADODB_Lite (and other
>>database libraries that are out there) instead of the straight php
>>mysql_* functions, you'll be able to use variable binding which helps
>>to eliminate the sql injection issues, and also can make your code a
>>lot easier to read.

>
http://www.php.net/pdo

I haven't yet used PDO so I always forget it exists :)

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Jerry Stuckle]

Re: PHP MySql Update

Akhenaten wrote:

Coding apparently leads to blindness! I have an unclosed quote in here
and I'm not sure where......
>
$query="UPDATE table_name set ".
"First_Name = \"".$formVar s["First_Name "]."\",".
"Date_Committed = \"".$formVar s["Date_Committed "]."\",".
"Signed_By= \"".$formVar s["Signed_By"]."\",".
"Rep= \"".$formVar s["Sales_Rep"]."\",".
"Aut= \"".$formVar s["Atty"]."\",".
"Car= \"".$formVar s["Car"]."\",".
"Dbl= \"".$formVar s["Dbl"]."\",".
"Sts= \"".$formVar s["Sts"]."\",".
"Notes= \"".$formVar s["Notes"]."\",".
" \"WHERE Client_ID = \"".$formVar s["Client_ID"]."\"";
>
mysql_query($qu ery);
>
Your eyesite is appreciated!
>

I don't see any problems with the PHP quotes. However, SQL uses single
quotes (') to indicate a string, not double quotes ("). And you
shouldn't have a \" before the WHERE clause.

Your query should be:

$query="UPDATE table_name set ".
"First_Name = '".$formVars["First_Name "]."', ".
"Date_Committed = '".$formVars["Date_Committed "]."', ".
"Signed_By= '".$formVars["Signed_By"]."', ".
"Rep= '".$formVars["Sales_Rep"]."', ".
"Aut= '".$formVars["Atty"]."', ".
"Car= '".$formVars["Car"]."', ".
"Dbl= '".$formVars["Dbl"]."', ".
"Sts= '".$formVars["Sts"]."', ".
"Notes= '".$formVars["Notes"]."', ".
"WHERE Client_ID = '".$formVars["Client_ID"]."'";

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Marcin Dobrucki]

Re: PHP MySql Update

Akhenaten wrote:

Coding apparently leads to blindness! I have an unclosed quote in here
and I'm not sure where......
>
$query="UPDATE table_name set ".
"First_Name = \"".$formVar s["First_Name "]."\",".
"Date_Committed = \"".$formVar s["Date_Committed "]."\",".
"Signed_By= \"".$formVar s["Signed_By"]."\",".
"Rep= \"".$formVar s["Sales_Rep"]."\",".
"Aut= \"".$formVar s["Atty"]."\",".
"Car= \"".$formVar s["Car"]."\",".
"Dbl= \"".$formVar s["Dbl"]."\",".
"Sts= \"".$formVar s["Sts"]."\",".
"Notes= \"".$formVar s["Notes"]."\",".
" \"WHERE Client_ID = \"".$formVar s["Client_ID"]."\"";
>
mysql_query($qu ery);
>
Your eyesite is appreciated!

Instead of doing this, I would suggest taking some wrapper which
builds the querries from you based on an array of values. This is a
sure way of creating code that's very difficult to maintain. Eg. you
want to add something to your tables in the next update, and you have to
insert just the right code in the right place into this mess. Perhaps
PEAR::MDB2 to the rescue?