Where did the parens come from

From	bill <william@TechServSys.com>
Newsgroups	comp.lang.php
Subject	Where did the parens come from
Date	2017-07-10 14:19 -0400
Organization	Aioe.org NNTP Server
Message-ID	<ok0gfs$1pkp$1@gioia.aioe.org> (permalink)

Show all headers | View raw

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

Back to comp.lang.php | Previous | Next — Next in thread | Find similar | Unroll thread

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