Untitled

<html>
<head>
</head>
<body>

  <?php

require_once 'xpdo-2.4-3.0-pl/xpdo.class.php';

// Criteria for foreign Database
$host = 'expharm.miniserver.cz';
$username = 'jlochman';
$password = '******';
$dbname = 'modx_obchmodel';
$table_prefix = 'expharm_';
$port = 3306;
$charset = 'utf8';

$dsn = "mysql:host=$host;dbname=$dbname;port=$port;charset=$charset";
$xpdo = new xPDO($dsn, $username, $password, $table_prefix);

// Test your connection
echo $o = ($xpdo->connect()) ? 'Connected' : 'Not Connected';
echo "\n";

/*
$manager= $xpdo->getManager();
$generator= $manager->getGenerator();

$schema = './schema/expharm.mysql.schema.xml';
$target = './model/';
$generator->parseSchema($schema,$target);
 */

if ( ! $xpdo->addPackage('expharm', './model/', 'expharm_') ) {
  die('error loading package');
}

$users = $xpdo->getCollection( 'Users', array('last_name:LIKE' => '%') );
foreach($users as $user) {
  echo $user->get("first_name");
}


    ?>

</body>
</html>