PHP Classes
elePHPant
Icontem

File: Xyndravandria/Dyverath/Query/Select.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mauro Di Girolamo  >  Xyndravandria Dyverath  >  Xyndravandria/Dyverath/Query/Select.php  >  Download  
File: Xyndravandria/Dyverath/Query/Select.php
Role: Class source
Content type: text/plain
Description: Class source
Class: Xyndravandria Dyverath
Compose and execute MySQL database queries
Author: By
Last change: Alpha 0.0.0
Date: 2 years ago
Size: 5,656 bytes
 

Contents

Class file image Download
<?php
/*
=============================================================================================================================================
| This file is part of a project released under the terms of the Xyndravandria PHP License (XyndravandriaPHPLicense.txt). |
| |
| You should be given a copy of the Xyndravandria PHP License (XyndravandriaPHPLicense.txt) within the same directory as the README.md; |
| if not, you can get a copy at http://Xyndravandria.ohost.de/XyndravandriaPHPLicense.txt . |
| |
| The copyright (c) of this project is owned by Mauro Di Girolamo <maurodigirolamo@.web.de>. |
============================================================================================================================================|



Xyndravandria Dyverath
----------------------
Alpha 0.0.0

Xyndravandria is the name of a collection of projects designed and developed by Mauro Di Girolamo (maurodigirolamo@web.de); he is therefore the copyright (c) owner of Xyndravandria itself and all of its projects.

Xyndravandria Dyverath is released under the terms of the Xyndravandria PHP License (XyndravandriaPHPLicense.txt). You should be given a copy of the Xyndravandria PHP License (XyndravandriaPHPLicense.txt) within the same directory as the README.md; if not, you can get a copy at http://Xyndravandria.ohost.de/XyndravandriaPHPLicense.txt . There might be a release under a freer license for a later, more stable version.

The documentation is either included in ./admin_media/Documentation/ or can be read at http://Xyndravandria.ohost.de/Dyverath/Documentation/.

All projects:

   Xyndravandria Averazain
   http://github.com/MauroDiGirolamo/Xyndravandria_Averazain
   PHP
   Averazain is an Ajax framework supporting also JavaScript disabled clients perfectly - including search engines like Google.
  
   Xyndravandria Dyverath
   http://github.com/MauroDiGirolamo/Xyndravandria_Dyverath
   PHP
   Dyverath is a database access wrapper.
  
   Xyndravandria Erozaver
   http://github.com/MauroDiGirolamo/Xyndravandria_Erozaver
   PHP
   Erozaver is a class extending the type hinting given by the PHP engine (additional support for basic type hinting and size constraints).
  
   Xyndravandria Mondraviel
   http://github.com/MauroDiGirolamo/Xyndravandria_Mondraviel
   PHP
   Mondraviel is a class used to separate HTML from PHP code by firstly register models - files containing place holders embedded in HTML code - and then later fill them dynamically with content by passing values for the place holders.
*/

namespace Xyndravandria\Dyverath\Query;

use
Xyndravandria\Dyverath\Table;
use
Xyndravandria\Dyverath\Query\Component\Statement\StatementListing\Where;
use
Xyndravandria\Dyverath\Query\Component\Type\Column;
use
Xyndravandria\Dyverath\Query\Component\Type\Limit;
use
Xyndravandria\Erozaver\XyndravandriaDyverathException;

/// A class representing a SELECT statement.
class Select extends Query {
  
  
/// The @ref Column "Column(s)" to be selected.
   /// <dl class = "type"><dt><b>%Type:</b></dt>
   /// <dd>Column</dd></dl>
   /// @private
  
private $Column;
  
  
/// The Where used to select the Data.
   /// <dl class = "type"><dt><b>%Type:</b></dt>
   /// <dd>Database</dd></dl>
   /// @private
  
private $Where;
  
  
/// The Limit of the selection.
   /// <dl class = "type"><dt><b>%Type:</b></dt>
   /// <dd>Limit</dd></dl>
   /// @private
  
private $Limit;
  
  
/// The ORDER BY clause.
   /// <dl class = "type"><dt><b>%Type:</b></dt>
   /// <dd>Column</dd></dl>
   /// @private
  
private $OrderBy;
  
  
/// Creates a new Select.
   /// @public
   /// @param Column $Column: The @ref Column "Column(s)"
   /// to be selected.
   /// @param Table $Table: The Table this Query is
   /// executed in.
   /// @param Where $Where: The Where used to select the
   /// Data.
   /// @param Column $OrderBy: The order of the selection.
   /// @param Limit $Limit: The Limit of the selection.
   /// @note $Where, $OrderBy and $Limit are optional
   /// parameters. @n
   /// You can also pass only one of them and leave the
   /// other out; passing null is not needed.
  
public function __construct( Column $Column, Table $Table, Where $Where = null, Column $OrderBy = null, Limit $Limit = null ) {
     
$this->Column = $Column;
     
$this->Table = $Table;
     
$this->Where = $Where;
      if(
$OrderBy instanceof Limit ) {
        
$Limit = $OrderBy;
        
$OrderBy = null;
      }
     
$this->Limit = $Limit;
     
$this->OrderBy = $OrderBy;
     
     
$this->Optimise( );
      return;
   }
  
  
/// Optimises a Select.
   /// @public
  
public function Optimise( ) {
     
$this->Column->Optimise( $this->Table );
      \
is_null( $this->OrderBy ) || $this->OrderBy->Optimise( $this->Table );
      \
is_null( $this->Where ) || $this->Where->Optimise( $this->Table );
      return;
   }
  
  
/// Returns the complete statement.
   /// @public
   /// @returns string
  
public function __ToString( ) {
      return
'SELECT ' . $this->Column . ' FROM ' . $this->Table . ( \is_null( $this->Where ) ? '' : ' WHERE ' . $this->Where ) . ( \is_null( $this->OrderBy ) ? '' : ' ORDER BY ' . $this->OrderBy ) . ( \is_null( $this->Limit ) ? '' : ' LIMIT ' . $this->Limit );
   }
  
}
?>