Wednesday January 18, 2012, 13:14This is possible to use the wpdb object to access any external database and query any table within your WordPress installation. You can even use all the wpdb classes and functions such as get_results.

Example:

$my_external_db = new wpdb('username','password','database','localhost');

$rows = $mydb->get_results("SELECT * from MYTABLE ");

foreach ($rows as $result) :

echo $ result ->Title;

endforeach;

Tweet

Connecting to External Database in WordPress

, created on Wednesday January 18, 2012, 13:14, article tagged with keywords: wordpress, database, coding,

Tags: wordpress, database, coding,

Connecting to External Database in WordPress

, related articles:

• Web Developer's Journal: moving vBulletin forums to another server | Blog/News | Friday April 16, 2010 12:33
  Step by step instruction to move vBulletin forums ...
• WordPress 3 is due in early May | Blog/News | Friday April 23, 2010 12:33
  WordPress (blogging platform) is about to get anot...
• Oracle cuts jobs | Blog/News | Friday June 04, 2010 21:12
  Oracle is making job cuts (mainly in Europe and As...
• Wordpress 3 released | Blog/News | Thursday June 17, 2010 18:56
  Few months ago we informed about an upcoming third...
• Javascript Change Font Size | Blog/News | Saturday June 19, 2010 15:27
  We are working on a website with a dynamic font si...

ARCHIVE


Categories:



--