Lambda-lib-DB-PDO
[ class tree: Lambda-lib-DB-PDO ] [ index: Lambda-lib-DB-PDO ] [ all elements ]

Class: PDO_MySQL_Manipulator

Source Location: /libs/DB/PDO_MySQL_Manipulator.php

Class Overview




Variables

Constants

Methods



Class Details

[line 179]


[ Top ]


Class Variables

static $pdo =

[line 181]



Tags:

access:  protected

Type:   mixed


[ Top ]

$alias =

[line 184]



Tags:

access:  protected

Type:   mixed


[ Top ]

$columns =

[line 185]



Tags:

access:  protected

Type:   mixed


[ Top ]

$duplicate_key_update =

[line 198]



Tags:

access:  protected

Type:   mixed


[ Top ]

$for_update =

[line 199]



Tags:

access:  protected

Type:   mixed


[ Top ]

$groupby =

[line 190]



Tags:

access:  protected

Type:   mixed


[ Top ]

$having =

[line 191]



Tags:

access:  protected

Type:   mixed


[ Top ]

$join =

[line 186]



Tags:

access:  protected

Type:   mixed


[ Top ]

$limit =

[line 193]



Tags:

access:  protected

Type:   mixed


[ Top ]

$orderby =

[line 192]



Tags:

access:  protected

Type:   mixed


[ Top ]

$params =

[line 196]



Tags:

access:  protected

Type:   mixed


[ Top ]

$query =

[line 197]



Tags:

access:  protected

Type:   mixed


[ Top ]

$set =

[line 195]



Tags:

access:  protected

Type:   mixed


[ Top ]

$table =

[line 183]



Tags:

access:  protected

Type:   mixed


[ Top ]

$using =

[line 187]



Tags:

access:  protected

Type:   mixed


[ Top ]

$values =

[line 194]



Tags:

access:  protected

Type:   mixed


[ Top ]

$where =

[line 188]



Tags:

access:  protected

Type:   mixed


[ Top ]



Class Methods


static method mkNamedKey [line 696]

static void mkNamedKey( )



Tags:

access:  protected


[ Top ]

method begin [line 585]

void begin( )

begin



Tags:

access:  public


[ Top ]

method columns [line 260]

void columns( )

カラム (for insert)



Tags:

access:  public


[ Top ]

method commit [line 593]

void commit( )

commit



Tags:

access:  public


[ Top ]

method delete [line 671]

void delete( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method deleteWithAffectedRows [line 680]

void deleteWithAffectedRows( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method dump [line 745]

void dump( )

for debug.



Tags:

access:  protected


[ Top ]

method fetch [line 626]

void fetch( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method fetchAll [line 617]

void fetchAll( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method fetchColumn [line 635]

void fetchColumn( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method forUpdate [line 513]

void forUpdate( )

FOR UPDATE 句



Tags:

access:  public


[ Top ]

method foundRows [line 569]

void foundRows( )

foundRows() if fetchAll.



Tags:

access:  public


[ Top ]

method getParams [line 612]

void getParams( )



Tags:

access:  public


[ Top ]

method getQuery [line 608]

void getQuery( )



Tags:

access:  public


[ Top ]

method getWhere [line 707]

void getWhere( )



Tags:

access:  protected


[ Top ]

method groupBy [line 417]

void groupBy( )

group by 句



Tags:

access:  public


[ Top ]

method hasWhere [line 689]

void hasWhere( )



Tags:

access:  public


[ Top ]

method having [line 426]

void having( )

having 句



Tags:

access:  public


[ Top ]

method ifDefineWhere [line 393]

void ifDefineWhere( str $operator)

すでに where 句 が定義されていた場合のみ、演算子を適用する



Tags:

access:  public


Parameters:

str   $operator   演算子

[ Top ]

method initParams [line 212]

void initParams( )



Tags:

access:  protected


[ Top ]

constructor __construct [line 206]

PDO_MySQL_Manipulator __construct( $host, $db, $user, $pass, [ $encoding = ''])



Tags:

access:  public


Parameters:

   $host  
   $db  
   $user  
   $pass  
   $encoding  

[ Top ]

method insert [line 644]

void insert( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method join [line 269]

void join( $type, $sql)

join 句



Tags:

access:  public


Parameters:

   $type  
   $sql  

[ Top ]

method lastInsertId [line 577]

void lastInsertId( [ $name = NULL])

lastInsertId



Tags:

access:  public


Parameters:

   $name  

[ Top ]

method limit [line 450]

void limit( $offset, $limit)

limit 句



Tags:

access:  public


Parameters:

   $offset  
   $limit  

[ Top ]

method lock [line 521]

void lock( $mode)

LOCK TABLES 句



Tags:

access:  public


Parameters:

   $mode  

[ Top ]

method onDuplicateKeyUpdate [line 494]

void onDuplicateKeyUpdate( [ $params = array()])

ON DUPLICATE KEY UPDATE 句 (for insert)



Tags:

access:  public


Parameters:

array   $params  

[ Top ]

method orderBy [line 434]

void orderBy( $arr)

order by 句



Tags:

access:  public


Parameters:

   $arr  

[ Top ]

method rawQuery [line 542]

mixed rawQuery( str $type, str $sql)

PDO::prepare メソッドを介さずに 生のクエリ を発行する。



Tags:

access:  public


Parameters:

str   $type   クエリタイプ (fetchColum|fetch|fechAll|execute)
str   $sql   クエリ

[ Top ]

method rollback [line 601]

void rollback( )

rollback



Tags:

access:  public


[ Top ]

method select [line 252]

void select( )

select 句

columns() のエイリアス




Tags:

access:  public


[ Top ]

method set [line 471]

void set( $arr)

set 句 (for update)



Tags:

access:  public


Parameters:

   $arr  

[ Top ]

method setAlias [line 243]

void setAlias( $alias)

エイリアス名 (for join)



Tags:

access:  public


Parameters:

   $alias  

[ Top ]

method setParams [line 702]

void setParams( $named_key, $val)



Tags:

access:  protected


Parameters:

   $named_key  
   $val  

[ Top ]

method setQuery [line 713]

void setQuery( $type)



Tags:

access:  protected


Parameters:

   $type  

[ Top ]

method setTable [line 235]

void setTable( $table)

対象テーブル



Tags:

access:  public


Parameters:

   $table  

[ Top ]

method unlock [line 529]

void unlock( )

UNLOCK TABLES 句



Tags:

access:  public


[ Top ]

method update [line 653]

void update( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method updateWithAffectedRows [line 662]

void updateWithAffectedRows( [ $execute = true])



Tags:

access:  public


Parameters:

   $execute  

[ Top ]

method using [line 296]

void using( $column)

using 句



Tags:

access:  public


Parameters:

   $column  

[ Top ]

method values [line 458]

void values( $arr)

values 句 (for insert)



Tags:

access:  public


Parameters:

   $arr  

[ Top ]

method where [line 304]

void where( $arr)

where 句



Tags:

access:  public


Parameters:

   $arr  

[ Top ]


Class Constants

DELETE =  4

[line 204]


[ Top ]

INSERT =  2

[line 202]


[ Top ]

SELECT =  1

[line 201]


[ Top ]

UPDATE =  3

[line 203]


[ Top ]



Documentation generated on Sat, 21 May 2011 18:34:09 +0900 by phpDocumentor 1.4.1