By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

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

P: 2
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,
Software Engineer,
Feb 8 '12 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,584
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.

Feb 8 '12 #2

P: 2
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,
Feb 9 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.