Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #17533
| From | bill <william@TechServSys.com> |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: Where did the parens come from |
| Date | 2017-07-11 07:33 -0400 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <ok2d24$h9s$3@gioia.aioe.org> (permalink) |
| References | <ok0gfs$1pkp$1@gioia.aioe.org> <ok108o$pgf$1@jstuckle.eternal-september.org> |
On 7/10/2017 6:53 PM, Jerry Stuckle wrote:
> On 7/10/2017 2:19 PM, bill wrote:
>> this works, but...
>> ---------------------------------------------
>> echo basename(__FILE__).": " . __LINE__ . "-> " . __FUNCTION__ ." |<pre>";
>> print_r($postData);
>> echo "</pre>";
>>
>> $sql = "INSERT INTO `dogs`
>> (`hName`,
>> `street`,
>> `city`,
>> `state`,
>> `zip`,
>> `hPhone`,
>> `wPhone`,
>> `mPhone`,
>> `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 />";
>>
>> ------------------------------------
>>
>> the test data:
>> ogs-basic.php: 251-> mSavePersonData |
>>
>> Array
>> (
>> [org] => IWROM
>> [hName] => my name
>> [street] => 123 willoughby
>> [city] => MASON
>> [state] => MI
>> [zip] => 44444
>> [hphone] => home
>> [wphone] => work
>> [cphone] => (517* 881-6007
>> [email] => yad@yada
>> )
>>
>> dogs-basic.php: 277: sql=>INSERT INTO `dogs`
>> (`hName`, `street`, `city`, `state`, `zip`, `hPhone`, `wPhone`,
>> `mPhone`, `email` )
>> VALUES (
>> '(my name)', '(my name)', '(my name)', '(my name)', '(my name)', '(my
>> name)', '(my name)', '(my name)', '(my name)' )
>>
>> The sql produced has parens around all the values to be saved (and it
>> shouldn't) and I can't figure out where they come form.
>>
>> yes, I know that I am saving the same value into each cell, it is just
>> test data
>>
>> bill
>
> Are you sure this is the code you're using? If so, look at the source
> code for your page.
>
> The code you showed does not match the output you displayed.
>
Jerry, here is the full source code of the function
//---------------------------------------------------------page 1
of a dog needs help -------------------
function mSavePersonData($postData) { // mSavePersonData
global $connection;
// $postData contains the $_POST data from rescueDog1.php
echo basename(__FILE__).": " . __LINE__ . "-> " . __FUNCTION__ ."
|<pre>";
print_r($postData);
echo "</pre>";
$sql = "INSERT INTO `dogs`
(`status`,
`hName`,
`street`,
`city`,
`state`,
`zip`,
`hPhone`,
`wPhone`,
`mPhone`,
`email`
)
VALUES (
'new',
'$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
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