By wschaepe on

My client has a large number of HTML files in a MYSQL database that he wants to search through and display on a results page. The user needs to be able to click on one of the priortized results and pull up the HTML page. There are relative links in the HTML pages that need to link to other pages in the database table.

My Client wants also wants to run four Drupal sites with the one Drupal install. He has four different Drupal databases for this. We will need help in configuring this so that when a user goes to a specific URL, Drupal connects to that database. The four sites just have different designs (different custom Blocks)to give each a unique look. The tables that contain the HTML data will be replicated in each of the four Drupal databases.

The client wants to start this as soon as possible. This custom search module could be made public for other Drupal users.

Regards,
BIll Schaepe
wschaepe@earthlink.net
646-213-6427

⋅ Categories: Drupal 6.x

Comments

webchuck’s picture

webchuck commented

So when you say HTML in MySQL, are you talking about the entire HTML page, from to stored in the database? Have you considered importing the files into Drupal as nodes and using Drupal search (or Apache SOLR) to do your search? It seems that an import function may be easier than an advanced search module, since it would only need to be done once. Just a thought...

Chuck

----------------------------------------
Chuck Crandall
WebChuck Web Development
chuck at webchuckweb dot com
----------------------------------------

maksy-1’s picture

maksy-1 commented

Hello, are you talking about a external database containing html files to be included in a drupal site database ?

"My Client wants also wants to run four Drupal sites with the one Drupal install."
Are you talking about the multisites feature ?
Bernard