Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #17540
| From | bill <william@TechServSys.com> |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: Where did the parens come from |
| Date | 2017-07-12 08:03 -0400 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <ok5366$5k9$1@gioia.aioe.org> (permalink) |
| References | (1 earlier) <ok108o$pgf$1@jstuckle.eternal-september.org> <ok2d24$h9s$3@gioia.aioe.org> <ok2ik8$tjc$1@jstuckle.eternal-september.org> <ok2n6c$1207$1@gioia.aioe.org> <ok36qf$658$1@jstuckle.eternal-september.org> |
On 7/11/2017 2:57 PM, Jerry Stuckle wrote:
> On 7/11/2017 10:26 AM, bill wrote:
>> function mSavePersonData($postData) { // mSavePersonData
>> global $connection;
>> // $postData contains the $_POST data from rescueDog1.php
>>
>> $sql = "INSERT INTO `dogs`
>> (`hName`,
>> `street`,
>> `city`,
>> `state`,
>> `zip`,
>> `hPhone`,
>> `wPhone`,
>> `cPhone`,
>> `email`
>> )
>> VALUES (
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})',
>> '$connection->real_escape_string({$postData['hName']})'
>> )
>> ";
>> echo basename(__FILE__) . ": " . __LINE__ . ": sql=>$sql<br />";
>> $result =mysqli_query($connection, $sql);
>> if (!$result) die("MySql ERROR in dogs-basic: ".__FUNCTION__." on
>> line " . __LINE__ . " " . $connection->error);
>
> OK, I was able to duplicate it here. Very interesting. I haven't run
> into this before because I really don't like trying to evaluate values
> within a string. I changed it to the following, which is more my style.
> It's a bit more of a hassle, but it works all the time.
>
> function mSavePersonData($postData) { // mSavePersonData
> global $connection;
> // $postData contains the $_POST data from rescueDog1.php
>
> $sql = "INSERT INTO `dogs`
> (`hName`,
> `street`,
> `city`,
> `state`,
> `zip`,
> `hPhone`,
> `wPhone`,
> `cPhone`,
> `email`
> )
> VALUES (
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "',
> '" . $connection->real_escape_string($postData['hName']) . "'
> )
> ";
> echo basename(__FILE__) . ": " . __LINE__ . ": sql=>$sql<br />";
> $result =mysqli_query($connection, $sql);
> if (!$result) die("MySql ERROR in dogs-basic: ".__FUNCTION__." on
> line " . __LINE__ . " " . $connection->error);
> } //mSavePersonData
>
> Notice I've taken the function calls out of the quotes and just
> concatenated them.
That's nice
-bill
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Where did the parens come from bill <william@TechServSys.com> - 2017-07-10 14:19 -0400
Re: Where did the parens come from "J.O. Aho" <user@example.net> - 2017-07-10 21:17 +0200
Re: Where did the parens come from bill <william@TechServSys.com> - 2017-07-11 07:31 -0400
Re: Where did the parens come from "J.O. Aho" <user@example.net> - 2017-07-11 18:05 +0200
Re: Where did the parens come from Jerry Stuckle <jstucklex@attglobal.net> - 2017-07-10 18:53 -0400
Re: Where did the parens come from bill <william@TechServSys.com> - 2017-07-11 07:29 -0400
Re: Where did the parens come from bill <william@TechServSys.com> - 2017-07-11 07:33 -0400
Re: Where did the parens come from Jerry Stuckle <jstucklex@attglobal.net> - 2017-07-11 09:12 -0400
Re: Where did the parens come from bill <william@TechServSys.com> - 2017-07-11 10:26 -0400
Re: Where did the parens come from "Peter H. Coffin" <hellsop@ninehells.com> - 2017-07-11 12:55 -0500
Re: Where did the parens come from "Peter H. Coffin" <hellsop@ninehells.com> - 2017-07-11 13:52 -0500
Re: Where did the parens come from Jerry Stuckle <jstucklex@attglobal.net> - 2017-07-11 14:57 -0400
Re: Where did the parens come from bill <william@TechServSys.com> - 2017-07-12 08:03 -0400
Re: Where did the parens come from "Peter H. Coffin" <hellsop@ninehells.com> - 2017-07-12 13:51 -0500
Re: Where did the parens come from bill <william@TechServSys.com> - 2017-07-13 07:37 -0400
Re: Where did the parens come from "R.Wieser" <address@not.available> - 2017-07-11 08:40 +0200
csiph-web