Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement