Search query to select multiple database (Different Tables in different database)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sanjay Dey
    New Member
    • Feb 2012
    • 2

    Search query to select multiple database (Different Tables in different database)

    Hi !!!
    I want to write search query for multiple database. I have 3 different database and each database contains nearly 60 tables. Now i want to create search function for user which will allow user to search anything from any database using PHP (Codigniter).I am using Codeigniter.

    Can anyone help me to do this ??


    With Thanks & Regards,
    Sanjay
    Software Engineer,
    India
  • dlite922
    Recognized Expert Top Contributor
    • Dec 2007
    • 1586

    #2
    You write you query as you normally would except you would prepend the name of the database to the table. i.e. db1.table1, db2.table2 etc.

    If you're looking to do this using CodeIgniter API, you need to refer to the CodeIgniter manual to see how to do this.

    Dan

    Comment

    • Sanjay Dey
      New Member
      • Feb 2012
      • 2

      #3
      I have checked in codeIgniter manual for multiple database search at a single time with keyword. But it didnt worked out. If u have anyother process to do then please send me.

      Thanks & Regards,
      Sanjay

      Comment

      Working...