Overview

Namespaces

  • Simpletools
    • Autoload
    • Config
    • Db
      • Mysql
    • Event
    • Http
    • Mvc
    • Page
    • Store

Classes

  • Client
  • Iterator
  • Model
  • QueryBuilder
  • Result
  • Sql
  • Overview
  • Namespace
  • Class

Class QueryBuilder

Simpletools\Db\Mysql\QueryBuilder implements Iterator
Namespace: Simpletools\Db\Mysql
Located at Simpletools/Db/Mysql/QueryBuilder.php
Methods summary
public
# __construct( $table, $mysql, $columns = array() )
public &
# columns( )
public &
# db( $db )
public &
# group( )
public &
# sort( )
public &
# insertIgnore( $data )
public &
# insertDelayed( $data )
public &
# delete( )
public &
# insert( $data )
public &
# onDuplicate( $data )
public &
# update( $data )
public
# run( )
public
# get( $id, $column = 'id' )
public
# _escape( $value )
public
# replace_first( $needle, $replace, $haystack )
public
# getQuery( )
public &
# whereSql( $statement, $vars = null )
public &
# select( $columns )
public &
# offset( $offset )
public &
# limit( $limit )
public &
# find( )
public &
# where( )
public &
# alternatively( )
public &
# also( )
public &
# setTable( $table )
public
# __get( $name )
public
# getAffectedRows( )
public
# getInsertedId( )
public
# isEmpty( )
public
# fetch( )
public
# fetchAll( )
public
# length( )
public
# rewind( )

Implementation of

Iterator::rewind()
public
# current( )

Implementation of

Iterator::current()
public
# key( )

Implementation of

Iterator::key()
public
# next( )

Implementation of

Iterator::next()
public
# valid( )

Implementation of

Iterator::valid()
Properties summary
protected string $_query
# ''
protected string $_mysql
# ''
protected $_result
# null
API documentation generated by ApiGen