Switch between multiple database in PDO

by

I know that I am a couple of months late but you should be able to switch between databases from within your query.

examples:

$sql = "SELECT * FROM dbname.tablename";

$sql = "SELECT * FROM anotherdbname.anothertablename"

So even if your original $pdo object was used ‘blahblah’ as the dbname, you should still be okay based on the select examples I provided.

More Related Contents:

  1. Disappears \ from db value [closed]
  2. How to read a large file line by line?
  3. Reading JSON POST using PHP
  4. Query with multiple values in a column
  5. How To Run PHP From Windows Command Line in WAMPServer
  6. How to solve PHP error ‘Notice: Array to string conversion in…’
  7. Preserve Line Breaks From TextArea
  8. Convert time in HH:MM:SS format to seconds only?
  9. Reference: Comparing PHP’s print and echo
  10. Adding minutes to date time in PHP
  11. Error In PHP5 ..Unable to load dynamic library
  12. PHP cURL error code 60
  13. WAMP Cannot access on local network 403 Forbidden
  14. PHP – Copy image to my server direct from URL [duplicate]
  15. Convert invalid json into valid json
  16. Warning: mysql_query(): 3 is not a valid MySQL-Link resource
  17. How do I can post a multiple photos via Facebook API
  18. Extracting all values between curly braces regex php
  19. PHP using preg_replace : “Delimiter must not be alphanumeric or backslash” error
  20. ‘php.exe’ is not recognized as an internal or external command, operable program or batch file
  21. How to dynamically populate options on dropdown lists based on selection in another dropdown?
  22. CodeIgniter: Try Catch is not working in model class
  23. $_POST is empty after form submit
  24. str_shuffle and randomness
  25. How to enable SSL in Wamp Server?
  26. Make text between asterisks bold
  27. PHP: DomElement->getAttribute
  28. PHP read file as an array of bytes
  29. Convert number into xx.xx million format? [closed]
  30. Extract first integer in a string with PHP

Leave a Comment