Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #17530

Re: Where did the parens come from

Show all headers | View raw

Bill,

> has parens around all the values to be saved (and it shouldn't)

Are you sure (and why) ?

From https://www.w3schools.com/PHP/php_mysql_insert.asp

[quote]
Here are some syntax rules to follow:
...
String values inside the SQL query must be quoted
[/quote]

To me it looks as if your PHP environment just tries to be helpful (by
adding those quotes) ...

Regards,
Rudy Wieser


-- Origional message:
bill <william@TechServSys.com> schreef in berichtnieuws
ok0gfs$1pkp$1@gioia.aioe.org...
> 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 — Previous 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