Récupérer des infos d'une table sur une autre base

<?php


$modx->db2 = new DBAPI($host,$database, $uid,$pwd);
$sql_query = 'SELECT id_lieu,societe FROM matable';
$result = $modx->db2->query($sql_query);
while($enr=mysql_fetch_array($result)) {
    $ouput .=  $enr["id_lieu"] ."-". $enr["societe"]."<br>";

}
return $ouput;
?>

<?php
/***


***/
	
	$database_type = 'mysql';
	$database_server = 'localhost';
	$database_user = 'user';
	$database_password = 'pass';
	$dbase = '`mydb`';
	$table_prefix = 'modx_';
	

if(!class_exists('makeTable')){
	
	include($modx->config['base_path'] . "manager/includes/extenders/maketable.class.php");

}

$table = new maketable();
$maxpageSize = 25;
define('MAX_DISPLAY_RECORDS_NUM',$maxpageSize);
$db = new DBAPI($database_server,$dbase, $database_user,$database_password);


$count = $db->select('count(*) as total',$table_prefix . 'site_content','','id');
$total = $db->getRow($count);
$numRecords = $total['total'];



$limit = $table->handlePaging();
$ds = $db->select('id,pagetitle',$table_prefix . 'site_content','','id',$limit);


	$datas = array();
	while($row = $db->getRow($ds)){
	
		$datas[] = $row;
	
	
	}
	




	$tableClass = "grid";
	$rowHeaderClass = "gridHeader";//
	$rowRegularClass = "gridItem";
	$rowAlternateClass = "gridAltItem";

	$table->setTableClass($tableClass);
	$table->setRowHeaderClass($rowHeaderClass);
	$table->setRowRegularClass($rowRegularClass);
	$table->setRowAlternateClass($rowAlternateClass);
	$tbWidth = array("10%","20%");           
    $table->setColumnWidths($tbWidth);
    $table->createPagingNavigation($numRecords); 
	//$table->createPagingNavigation($numRecords,'a=3&id='.$content['id']);
	
	$listTableHeader = array(	
						'id'=>'id',
						'pagetitle'=>'Page title'						
						);
	$listTableHeader = array_keys($datas);
	$listData = array();
	
	foreach($datas as $k => $v){
	
		$listData[] = array(
					'id' => $v['id'],
					'pagetitle' => $v['pagetitle']
					);
	}
	
	
	
	$output = $table->create($listData,$listTableHeader);

return $output;
?>