Overview

Namespaces

  • PHPixie
    • Auth
      • Context
        • Container
      • Domains
      • Providers
        • Builder
        • Provider
      • Repositories
        • Registry
        • Repository
    • AuthHTTP
      • Providers
    • AuthLogin
      • Providers
      • Repository
    • AuthORM
      • Repositories
        • Repository
        • Type
          • Login
    • AuthProcessors
      • Processor
    • BundleFramework
      • Configuration
        • FilesystemLocator
        • ORM
    • Bundles
      • Bundle
        • Provides
      • FilesystemLocators
      • Processors
    • Config
      • Formats
        • Format
      • Storages
        • Storage
          • Editable
        • Type
    • Database
      • Conditions
        • Builder
          • Container
          • Operators
        • Condition
          • Collection
          • Field
        • Logic
      • Connection
      • Driver
        • Mongo
          • Conditions
            • Builder
          • Parser
            • Conditions
          • Query
            • Type
        • PDO
          • Adapter
            • Mysql
              • Parser
            • Pgsql
              • Parser
            • Sqlite
              • Parser
          • Conditions
            • Builder
          • Query
            • Type
      • Exception
      • Parser
      • Query
        • Implementation
        • Type
          • Update
      • Type
        • Document
          • Conditions
            • Builder
            • Condition
              • Collection
                • Embedded
                  • Group
                  • Placeholder
          • Query
            • Implementation
        • SQL
          • Conditions
            • Builder
          • Parser
          • Query
            • Implementation
            • Type
      • Values
    • Debug
      • Logger
      • Tracer
        • Trace
    • DefaultBundle
      • Processor
        • HTTP
    • Filesystem
      • Locators
        • Locator
    • Framework
      • Extensions
        • Template
          • Extension
      • Processors
        • HTTP
          • Response
    • HTTP
      • Context
        • Container
        • Cookies
        • Session
      • Data
        • Headers
      • Messages
        • Message
          • Request
            • ServerRequest
        • Stream
        • UploadedFile
        • URI
      • Responses
    • HTTPProcessors
      • Parsers
        • Parser
      • Processor
        • Actions
        • Dispatcher
          • Builder
          • Registry
    • ORM
      • Conditions
        • Builder
        • Condition
          • Collection
            • RelatedTo
          • Field
          • In
      • Configs
      • Data
        • Diff
        • Type
        • Types
          • Document
            • Node
              • ArrayNode
      • Drivers
        • Driver
          • Mongo
          • PDO
          • SQL
      • Exception
      • Loaders
        • Loader
          • Embedded
          • Proxy
          • Repository
      • Mappers
        • Cascade
          • Mapper
        • Conditions
        • Preload
      • Maps
        • Map
          • Cascade
          • Property
      • Models
        • Model
          • Implementation
        • Type
          • Database
            • Implementation
          • Embedded
            • Implementation
      • Planners
        • Planner
          • In
            • Strategy
          • Pivot
            • Strategy
          • Query
            • Strategy
      • Plans
        • Plan
          • Query
      • Relationships
        • Relationship
          • Handler
            • Cascading
            • Mapping
          • Implementation
            • Preloader
              • Result
                • Multiple
            • Property
            • Side
          • Property
            • Entity
          • Side
            • Cascade
            • Property
          • Type
        • Type
          • Embeds
            • Preload
            • Property
            • Side
            • Type
              • Many
                • Preload
                • Property
                  • Entity
                • Side
              • One
                • Preload
                • Property
                  • Entity
                • Side
          • ManyToMany
            • Property
            • Side
          • OneTo
            • Preloader
            • Property
              • Entity
              • Query
            • Side
            • Type
              • Many
                • Preloader
                  • Property
                • Property
                  • Entity
                  • Query
                • Side
                • Value
                  • Preload
              • One
                • Preloader
                • Property
                • Side
      • Steps
        • Result
        • Step
          • Pivot
          • Query
            • Insert
              • Batch
                • Data
            • Result
          • Update
      • Values
        • Preload
          • Property
        • Update
      • Wrappers
        • Model
        • Type
          • Database
          • Embedded
    • Paginate
      • Loader
    • PaginateORM
      • Loader
    • Processors
      • Processor
        • Dispatcher
    • Route
      • Exception
      • Matcher
      • Resolvers
        • Resolver
          • Pattern
      • Translator
    • Security
      • Tokens
        • Storage
          • Database
    • Slice
      • Data
        • Slice
      • Type
        • ArrayData
        • Slice
    • Template
      • Extensions
        • Extension
      • Formats
      • Renderer
    • Test
  • Project
    • App
      • HTTPProcessors
    • Framework
  • Psr
    • Http
      • Message

Classes

  • Count
  • Delete
  • Insert
  • Select
  • Update
  • Overview
  • Namespace
  • Class
  • Tree
  • Return

Class Select

PHPixie\Database\Query\Implementation implements PHPixie\Database\Query
Extended by PHPixie\Database\Type\SQL\Query\Implementation implements PHPixie\Database\Type\SQL\Query
Extended by PHPixie\Database\Driver\PDO\Query
Extended by PHPixie\Database\Driver\PDO\Query\Items implements PHPixie\Database\Type\SQL\Query\Items, PHPixie\Database\Driver\PDO\Conditions\Builder
Extended by PHPixie\Database\Driver\PDO\Query\Type\Select implements PHPixie\Database\Type\SQL\Query\Type\Select
Namespace: PHPixie\Database\Driver\PDO\Query\Type
Located at vendor/phpixie/database/src/PHPixie/Database/Driver/PDO/Query/Type/Select.php
Methods summary
public
# type( )

Implementation of

PHPixie\Database\Query::type()
public
# fields( $fields )

Implementation of

PHPixie\Database\Query\Type\Select::fields()
public
# clearFields( )

Implementation of

PHPixie\Database\Query\Type\Select::clearFields()
public
# getFields( )

Implementation of

PHPixie\Database\Query\Type\Select::getFields()
public
# groupBy( $fields )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::groupBy()
public
# clearGroupBy( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::clearGroupBy()
public
# getGroupBy( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::getGroupBy()
public
# union( $query, $all = false )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::union()
public
# clearUnions( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::clearUnions()
public
# getUnions( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::getUnions()
public
# execute( )

Overrides

PHPixie\Database\Type\SQL\Query\Implementation::execute()

Implementation of

PHPixie\Database\Query::execute()
public
# buildHavingCondition( $logic, $negate, $params )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::buildHavingCondition()
public
# addHavingCondition( $logic, $negate, $condition )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::addHavingCondition()
public
# getHavingContainer( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::getHavingContainer()
public
# getHavingConditions( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::getHavingConditions()
public
# addHavingOperatorCondition( $logic, $negate, $field, $operator, $values )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::addHavingOperatorCondition()
public
# addHavingInOperatorCondition( $field, $values, $logic = 'and', $negate = false )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::addHavingInOperatorCondition()
public
# startHavingConditionGroup( $logic = 'and', $negate = false )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startHavingConditionGroup()
public
# addHavingPlaceholder( $logic = 'and', $negate = false, $allowEmpty = true )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::addHavingPlaceholder()
public
# having( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::having()
public
# andHaving( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::andHaving()
public
# orHaving( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::orHaving()
public
# xorHaving( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::xorHaving()
public
# havingNot( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::havingNot()
public
# andHavingNot( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::andHavingNot()
public
# orHavingNot( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::orHavingNot()
public
# xorHavingNot( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::xorHavingNot()
public
# startHavingGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startHavingGroup()
public
# startAndHavingGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startAndHavingGroup()
public
# startOrHavingGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startOrHavingGroup()
public
# startXorHavingGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startXorHavingGroup()
public
# startHavingNotGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startHavingNotGroup()
public
# startAndHavingNotGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startAndHavingNotGroup()
public
# startOrHavingNotGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startOrHavingNotGroup()
public
# startXorHavingNotGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::startXorHavingNotGroup()
public
# endHavingGroup( )

Implementation of

PHPixie\Database\Type\SQL\Query\Type\Select::endHavingGroup()
Methods inherited from PHPixie\Database\Driver\PDO\Query\Items
__construct(), _and(), _not(), _or(), _xor(), addCondition(), addContainerCondition(), addContainerInOperatorCondition(), addContainerOperatorCondition(), addContainerPlaceholder(), addInOperatorCondition(), addOnCondition(), addOnInOperatorCondition(), addOnOperatorCondition(), addOnPlaceholder(), addOperatorCondition(), addPlaceholder(), addWhereCondition(), addWhereInOperatorCondition(), addWhereOperatorCondition(), addWherePlaceholder(), andNot(), andOn(), andOnNot(), andWhere(), andWhereNot(), buildCondition(), buildContainerCondition(), buildOnCondition(), buildWhereCondition(), clearJoins(), clearLimit(), clearOffset(), clearOrderBy(), endContainerConditionGroup(), endGroup(), endOnConditionGroup(), endOnGroup(), endWhereGroup(), getJoins(), getLimit(), getOffset(), getOrderBy(), getWhereConditions(), getWhereContainer(), join(), limit(), offset(), on(), onNot(), orNot(), orOn(), orOnNot(), orWhere(), orWhereNot(), orderAscendingBy(), orderDescendingBy(), startAndGroup(), startAndNotGroup(), startAndOnGroup(), startAndOnNotGroup(), startAndWhereGroup(), startAndWhereNotGroup(), startConditionGroup(), startContainerConditionGroup(), startGroup(), startNotGroup(), startOnConditionGroup(), startOnGroup(), startOnNotGroup(), startOrGroup(), startOrNotGroup(), startOrOnGroup(), startOrOnNotGroup(), startOrWhereGroup(), startOrWhereNotGroup(), startWhereConditionGroup(), startWhereGroup(), startWhereNotGroup(), startXorGroup(), startXorNotGroup(), startXorOnGroup(), startXorOnNotGroup(), startXorWhereGroup(), startXorWhereNotGroup(), where(), whereNot(), xorNot(), xorOn(), xorOnNot(), xorWhere(), xorWhereNot()
Methods inherited from PHPixie\Database\Type\SQL\Query\Implementation
clearTable(), getTable(), parse(), table()
Methods inherited from PHPixie\Database\Query\Implementation
__call(), connection()
Properties inherited from PHPixie\Database\Type\SQL\Query\Implementation
$builder
Properties inherited from PHPixie\Database\Query\Implementation
$aliases, $conditions, $config, $connection, $database, $parser
PHPixie 3 API API documentation generated by ApiGen