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: 4 years ago
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!!!!!'

?>