Login   Register  
PHP Classes
elePHPant
Icontem

File: test.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Arthur Borisow  >  Chain Query Builder  >  test.php  >  Download  
File: test.php
Role: Example script
Content type: text/plain
Description: Example
Class: Chain Query Builder
Compose MySQL queries chaining functions
Author: By
Last change: added JOIN, LEFT JOIN, RIGHT JOIN, USING, ON
added IN to the where method as a valid operand
Date: 2010-12-03 03:53
Size: 2,019 bytes
 

Contents

Class file image Download
<?php

    require 'chainquerybuilder.class.php';

    $a = new ChainQueryBuilder;
    $q = $a
            ->update('table')
            ->set(array('name' => 'Arthur', 'sirname' => 'Borisow'))
            ->where('userId', '=', 1)
            ->orWhere('name', '=', 'Arthur')
            ->build();

    $b = new ChainQueryBuilder;
    $q2 = $b
            ->select(array('name', 'sirname'))
            ->addField('username')
            ->from('users')
            ->where('userId', '=', 1)
            ->build();
            
    $c = new ChainQueryBuilder;
    $q3 = $c
            ->select('name', 'sirname', 'username')
            ->from('users')
            ->where('userId', 'in', array(1, 3, 4, 5))
            ->andWhere('username', 'in', array('Arthur', 'Vova'))
            ->groupBy('name')
            ->orderBy('userId', 'sirName')
            ->order('ASC')
            ->offset(10)
            ->limit(5)
            ->build();
            
    $d = new ChainQueryBuilder;
    $q4 = $d
            ->select('t1.name', 't2.sirname')
            ->from('names as t1')
            ->leftJoin('sirnames as t2')
            ->using('userId')
            ->build();
    
    $e = new ChainQueryBuilder;
    $q5 = $e
            ->select('names.name', 'sirnames.sirname')
            ->from('names')
            ->leftJoin('sirnames')
            ->on('names.userId', '=', 'sirnames.userName')
            ->andOn('names.userName', '<>', 'sirnames.userSirname')
            ->where('names.userName', '=', 'Arthur')
            ->build();
    
    $f = new ChainQueryBuilder;
    $q6 = $f
            ->select('names.name', 'sirnames.sirname')
            ->from('names')
            ->leftJoin('sirnames')
            ->using('userId')
            ->where('names.userName', '=', 'Arthur')
            ->build();
//AND so on with SELECT, DELETE, UPDATE and INSERT (see the class code)
// Don't forget to change the method _sanitizeValue!!!!!'

?>