How does {} affect a MySQL Query in PHP? [duplicate]

by

ON the SQL side, there is absolutely no difference : the two queries are exactly the same.

(you can check that by echo-ing them)

{$variable} is a more complete syntax of $variable, that allows one to use :

  • "this is some {$variable}s"
  • "{$object->data}"
  • "{$array['data']}"
  • "{$array['data']->obj->plop['test']}"

For more informations, you should read the Variable parsing / Complex (curly) syntax section of the manual (quoting a few bits) :

This isn’t called complex because the
syntax is complex, but because it
allows for the use of complex
expressions.

Any scalar variable, array element or
object property with a string
representation can be included via
this syntax.
Simply write the
expression the same way as it would
appear outside the string, and then
wrap it in { and }.

More Related Contents:

  1. php+mysql Fatal error: Call to undefined function mysql_connect()
  2. Using PHP data in MySQL [closed]
  3. drop down menu using php and mysql [closed]
  4. php code for multiple search box after connecting to mysql [closed]
  5. Checking the availability of rooms
  6. How to sort user data by id
  7. Select those record only from table 1 where city exist against state id in table 2 in PHP
  8. PHP PDO prepared statements
  9. Example of how to use bind_result vs get_result
  10. mysqli::query(): Couldn’t fetch mysqli
  11. select count(*) from table of mysql in php
  12. Incorrect Integer (2147483647) is inserted into MySQL?
  13. I need my PHP page to show my BLOB image from mysql database
  14. jQuery UI Sortable, then write order into a database
  15. Delete multiple rows by selecting checkboxes using PHP
  16. Object of class DateTime could not be converted to string
  17. PHP MYSQL UPDATE if Exist or INSERT if not?
  18. mysql_real_escape_string VS addslashes
  19. How to add a delete button to a PHP form that will delete a row from a MySQL table
  20. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  21. Is there any way to check the performance of mysql Indexing
  22. Understanding pdo mysql transactions
  23. Date in a URL dd/mm/yyyy
  24. Codeigniter Transactions
  25. PDO::rowCount VS COUNT(*)
  26. How can I select rows in MySQL starting at a given row number?
  27. how to fetch all the row of the result in php mysql?
  28. Coverting Hex to Image in PHP?
  29. PHP: mysql v mysqli v pdo [closed]
  30. Aggregated query without GROUP BY

Leave a Comment