如何使用索引为多个数据库创建搜索引擎[重复]

Question

Possible Duplicate:
How do you connect to multiple MySQL databases on a single webpage?

I am building a search engine for my website, I have 6 databases with many tables.

For multiple database I know I have to build a index file containing information from all database and tables.

I know how to build a search engine for database in PHP and MySQL,

Connect to multiple database

mysql_connect(“hostname”, “username”, “password”);
mysql_select_db(“database1”);

mysql_connect(“hostname”, “username”, “password”);
mysql_select_db(“database2”);

and query like this

"(SELECT * from database1.search_table WHERE MATCH (title, link) AGAINST(‘keyword’))
  Union All 
 (SELECT * from database2.search_table WHERE MATCH (title, link) AGAINST(‘keyword’)"

I want to do it by making an index file.

Please suggest any good tutorial or method for this, I google many times but no good results.

Answer 1

I think of three ways to do this: 1-st You can user multiple database connection. That's the heaviest way to do this, because it'll increase the connections to the server. 2-nd You can just switch the chosen database. 3-rd You can make your queries database independent by selecting the database in the query. Here's an example :

SELECT * FROM `database`.`table` WHERE `database`.`table`.`column`='something'

I personally think that the third way is the best.