PHP Classes

File: test/join/natural_join.php

Recommend this page to a friend!
  Classes of Peter   Storage Class   test/join/natural_join.php   Download  
File: test/join/natural_join.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Storage Class
Manipulate data in arrays and store it in files
Author: By
Last change: Merge branch 'master' of github.com:teed7334-restore/storage

Conflicts:
README.md
Date: 8 years ago
Size: 1,530 bytes
 

Contents

Class file image Download
<?php
include_once('../../config/config_setting.php');
$config = config_setting::get_config();
$base_path = $config['base_path'];
include_once("{$base_path}/join.php");
$join = new join();
$customer = array(
    array('id' => 1, 'name' => 'Peter', 'address' => 'AAAA', 'mobile' => '0900123456'),
    array('id' => 2, 'name' => 'Bill', 'address' => 'BBBB', 'mobile' => '0910123456'),
    array('id' => 3, 'name' => 'Ryan', 'address' => 'CCCC', 'mobile' => '0920123456'),
    array('id' => 4, 'name' => 'Chris', 'address' => 'DDDD', 'mobile' => '0930123456'),
    array('id' => 5, 'name' => 'John', 'address' => 'EEEE', 'mobile' => '0940123456'),
);
$order = array(
    array('id' => 1, 'customer_id' => 1, 'order_no' => 'A123456789'),
    array('id' => 2, 'customer_id' => 2, 'order_no' => 'B123456789'),
    array('id' => 3, 'customer_id' => 3, 'order_no' => 'C123456789'),
    array('id' => 4, 'customer_id' => 5, 'order_no' => 'D123456789'),
    array('id' => 5, 'customer_id' => 1, 'order_no' => 'E123456789'),
    array('id' => 6, 'customer_id' => 5, 'order_no' => 'F123456789'),
    array('id' => 7, 'customer_id' => 3, 'order_no' => 'G123456789'),
    array('id' => 8, 'customer_id' => 2, 'order_no' => 'H123456789'),
    array('id' => 9, 'customer_id' => 8, 'order_no' => 'I123456789'),
    array('id' => 10, 'customer_id' => 9, 'order_no' => 'J123456789'),
);
$table_name = array('customer' => 'order');
$type = 'inner';
$join->set_table_name($table_name);
print_r($join->natural_join($customer, $order, $type));