query different database other than drupal one
Hello folks, Need to search/read some data(basically a search form which will result records) from a database other than drupal one.And display it inside drupal. Will following be enough ? http://drupal.org/node/18429 (db_set_active) -- Cheers, Gaurav Khambhala i-hack-at-DeepRoot Linux Getting GNU/Linux to work for you. Faster. Better. Today. Every way. http://www.deeproot.in, +91 80 4089 0000
On Thu, Apr 30, 2009 at 12:45 AM, Gaurav Khambhala <gaurav@deeproot.co.in> wrote:
Hello folks,
Need to search/read some data(basically a search form which will result records) from a database other than drupal one.And display it inside drupal.
Will following be enough ?
http://drupal.org/node/18429 (db_set_active)
I'm not sure how well that works, hopefully someone more knowledgeable will chime in. But the Table Wizard (drupal.org/project/tw) module might help you out depending on your exact situation. The module exposes any tables in your database to views, which might make implementing your solution a lot easier.
Hi Justin, Justin Gruenberg wrote:
Need to search/read some data(basically a search form which will result records) from a database other than drupal one.And display it inside drupal.
Will following be enough ?
http://drupal.org/node/18429 (db_set_active)
I'm not sure how well that works, hopefully someone more knowledgeable will chime in. But the Table Wizard (drupal.org/project/tw) module might help you out depending on your exact situation.
Thanks for quick input. Quote from tw project page: "It allows surfacing any table in the Drupal default database through Views 2." Wherein our requirement is to interact with totally different mysql database than drupal's default one. -- Cheers, Gaurav Khambhala i-hack-at-DeepRoot Linux Getting GNU/Linux to work for you. Faster. Better. Today. Every way. http://www.deeproot.in, +91 80 4089 0000
Quoting Gaurav Khambhala <gaurav@deeproot.co.in>:
Wherein our requirement is to interact with totally different mysql database than drupal's default one.
Review the comments in settings.php and see http://api.drupal.org/api/function/db_set_active for a function to change between DB. -- Earnie -- http://r-feed.com/ -- http://for-my-kids.com/ -- http://www.4offer.biz/ -- http://give-me-an-offer.com/
Quoting Gaurav Khambhala <gaurav@deeproot.co.in>:
Hello folks,
Need to search/read some data(basically a search form which will result records) from a database other than drupal one.And display it inside drupal.
Will following be enough ?
http://drupal.org/node/18429 (db_set_active)
Also http://www.palantir.net/blog/remote-data-drupal-museums-and-web-2009 -- Earnie -- http://r-feed.com/ -- http://for-my-kids.com/ -- http://www.4offer.biz/ -- http://give-me-an-offer.com/
participants (3)
-
Earnie Boyd -
Gaurav Khambhala -
Justin Gruenberg