Skip to content

Instantly share code, notes, and snippets.

@remoharsono
Created November 22, 2019 09:10
Show Gist options
  • Save remoharsono/aabbba1ef9828e8678bd7d9652d25467 to your computer and use it in GitHub Desktop.
Save remoharsono/aabbba1ef9828e8678bd7d9652d25467 to your computer and use it in GitHub Desktop.
PHP ADOdb Active Record | TableHasMany
<?php
require 'adodb/adodb.inc.php';
require 'adodb/adodb-active-record.inc.php';
define("DB_DRIVER", "mysqli");
define("DB_HOST", "localhost");
define("DB_USERNAME", "root");
define("DB_PASSWORD", "");
define("DB_NAME", "test");
define("DB_CHARSET", "UTF-8");
$db = newAdoConnection(DB_DRIVER);
// $db->debug = true;
$db->setConnectionParameter('CharacterSet', DB_CHARSET);
// persistent connection
if (!$db->pConnect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME)) {
echo 'Unable to connect to database server';
exit;
}
ADOdb_Active_Record::SetDatabaseAdapter($db);
class Meeting extends ADOdb_Active_Record {}
class MeetingAttachment extends ADOdb_Active_Record {}
ADODB_Active_Record::TableHasMany('meetings', 'meeting_attachments', 'meeting_id');
$meetingObj = new Meeting('meetings');
$meeting = $meetingObj->find("id=?", array(167));
echo $meeting[0]->title;
foreach ($meeting[0]->meeting_attachments as $attachment) {
echo $attachment->filename . '<br>';
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment