Hi kamalMaroc, Use this code to get data from external db // Switch to extern...

Contribution Date

Mon, 05/21/2018 - 12:00

Technology

Drupal

Contribution Project

Drupal core

Contribution Details

Hi kamalMaroc,

Use this code to get data from external db

// Switch to external database
\Drupal\Core\Database\Database::setActiveConnection('external_db');

// Get a connection going
$db = \Drupal\Core\Database\Database::getConnection();

$data = $db->select('node','n')
       ->fields('n')
       ->condition('n.type', 'article_page', '=')
       ->range(0, 1)
       ->execute()
       ->fetchAll(\PDO::FETCH_ASSOC);

var_dump($data[0]['nid']);

// Switch back
\Drupal\Core\Database\Database::setActiveConnection();

Contribution Author

arvindkinja

Contribution Issue Link

How to load entities from non-default databases

Contribution Link

https://www.drupal.org/project/drupal/issues/2974000#comment-12623283

Files count

0

Patches count

0