Class SQLiteDBBuilder

create querys to create a insert or update query use addValue() to create a select query use addField() and addJoin()

Extended by

SQLiteDBBuilder

Located at sqlite.lib.php

Methods summary

`public SQLiteDBBuilder`	# `__construct( integer $SQLITE_EXEC_TYPE, mixed $table, string $where = "", string $additional = "", string $index = "" )` create a SQLiteDBBuilder object create a SQLiteDBBuilder object Parameters `$SQLITE_EXEC_TYPE` SQLITE_INSERT or SQLITE_UPDATE or SQLITE_UPDINS or SQLITE_SELINS `$table` as string or array(, ) sample: array($build, "s1") => used for a SELECT IN SELECT `$where` `$additional` => only for SELECT Sample: GROUP BY f1 `$index` => only for SELECT, name of index or index expression like "IGNORE INDEX (key3)" Returns `SQLiteDBBuilder`
`public`	# `__destruct( )`
`public`	# `free( )`
`public string`	# `query( )` return the sql query return the sql query Returns string
`public`	# `addValue( string $field, mixed $value, string $type = "U" )` add a value for INSERT or UPDATE add a value for INSERT or UPDATE Parameters `$field` `$value` `$type` as I for integer, N for numeric (float/double) or C and S for string or D for date or F and O for functions and operations
`public`	# `addField( mixed $name, string $table = "", boolean $quote = true )` add a field for SELECT add a field for SELECT Parameters `$name` => or <table.fieldname> or <db.table.fieldname> `$table` as string (optional) or SQLiteDBBuilder object for a subselect `$quote` (optional) => set automatically the tablename to the field, if you use as sample a function like COUNT use $quote == false
`public`	# `addJoin( string $table, string $field1, string $field2, string $type = "L" )` add a JOIN add a JOIN Parameters `$table` => table to join `$field1` => field from join table `$field2` => field from main table `$type` => "L" for LEFT JOIN, "R" for RIGHT JOIN, "I" for INNER JOIN
`public`	# `setOptions( $s )`

Methods inherited from SQLiteDB_

escapeString()

Properties summary

`private array`	`$m_values`	# `array()`
`private array`	`$m_fields`	# `array()`
`private array`	`$m_joins`	# `array()`
`public string`	`$m_type`	# `""`
`private string`	`$m_table`	# `""`
`private string`	`$m_index`	# `""`
`private string`	`$m_where`	# `""`
`private string`	`$m_additional`	# `""`
`private string`	`$m_options`	# `""`
`public boolean`	`$m_escape_strings` escape strings on method "addValue" escape strings on method "addValue"	# `true`