PHP Classes

File: test/index.php

Recommend this page to a friend!
  Classes of Duong Huynh Nghia   Simple PHP ORM   test/index.php   Download  
File: test/index.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Simple PHP ORM
Manage objects stored in a database using a ORM
Author: By
Last change: Update Demo
Date: 6 years ago
Size: 1,687 bytes
 

Contents

Class file image Download
<?php
//use DbTest\Client\Model as ClientModel;
use SimpleORM\Helper\Connector;
use
SimpleORM\Db\Model;
require_once
'DbTest/autoload.php';
require_once
'../SimpleORM/autoload.php';
@
error_reporting(E_ALL);
@
ini_set('display_errors', -1);
$configs = array( 'host' => 'localhost',
   
'name' => 'd2_test2',
   
'user' => 'root',
   
'pwd' => '123456',
   
'port' => 3306,
   
'prefix' => 'tbl_',
   
'adapter' => 'mysqli',
   
'charset' => 'utf8',
   
'type' => 'mysql'
);
$db = new Connector($configs);
// custom table
$oModel = new \DbTest\Client\Model();
$oClientRow = $oModel->getOne(array('client_id',1,'>'));
d($oClientRow);
//force set custom relation'
$oClientRow->getRelation()->hasOne('info',array(
       
'source' => 'client_id',
       
'target' => 'client_id',
       
'table' => 'client_info'
));
$oClientRow->getRelation()->hasMany('apps',array(
       
'source' => 'client_id',
       
'target' => 'client_id',
       
'table' => 'client_app'
));
$oClientRow->getRelation()->belongsTo('client_type',array(
       
'source' => 'level',
       
'target' => 'id',
       
'table' => 'client_type',
));
$oClientRow->getRelation()->hasManyToMany('groups',array(
       
'source' => 'client_id',
       
'target' => 'id',
       
'table' => 'group',
       
'option' => array(
               
'bridge' => array(
                       
'table' => 'client_group',
                       
'source' => array(
                               
'client_id' => 'client_id'
                       
),
                       
'target' => array(
                               
'id' => 'group_id',
                        )
                )
        )
));
d($oClientRow->groups);


function
d($mInfo, $bVarDump = false)
{
   
$bCliOrAjax = (PHP_SAPI == 'cli');
    (!
$bCliOrAjax ? print '<pre style="text-align:left; padding-left:15px;">' : false);
    (
$bVarDump ? var_dump($mInfo) : print_r($mInfo));
    (!
$bCliOrAjax ? print '</pre>' : false);
}