Changeset 2905 for trunk/system/libraries/Database.php
- Timestamp:
- 06/25/2008 01:50:32 PM (5 months ago)
- Files:
-
- 1 modified
-
trunk/system/libraries/Database.php (modified) (32 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/system/libraries/Database.php
r2899 r2905 51 51 * 52 52 * @param mixed configuration array or DSN 53 * @return object53 * @return Database_Core 54 54 */ 55 55 public static function instance($config = array()) … … 214 214 * 215 215 * @param string SQL query to execute 216 * @return objectDatabase_Result216 * @return Database_Result 217 217 */ 218 218 public function query($sql = '') … … 257 257 * 258 258 * @param string string or array of column names to select 259 * @return objectThis Database object.259 * @return Database_Core This Database object. 260 260 */ 261 261 public function select($sql = '*') … … 303 303 * 304 304 * @param string string or array of tables to select 305 * @return objectThis Database object.305 * @return Database_Core This Database object. 306 306 */ 307 307 public function from($sql) … … 337 337 * @param string where value 338 338 * @param string type of join 339 * @return objectThis Database object.339 * @return Database_Core This Database object. 340 340 */ 341 341 public function join($table, $key, $value = NULL, $type = '') … … 386 386 * @param string value to match with key 387 387 * @param boolean disable quoting of WHERE clause 388 * @return objectThis Database object.388 * @return Database_Core This Database object. 389 389 */ 390 390 public function where($key, $value = NULL, $quote = TRUE) … … 408 408 * @param string value to match with key 409 409 * @param boolean disable quoting of WHERE clause 410 * @return objectThis Database object.410 * @return Database_Core This Database object. 411 411 */ 412 412 public function orwhere($key, $value = NULL, $quote = TRUE) … … 430 430 * @param string like value to match with field 431 431 * @param boolean automatically add starting and ending wildcards 432 * @return objectThis Database object.432 * @return Database_Core This Database object. 433 433 */ 434 434 public function like($field, $match = '', $auto = TRUE) … … 451 451 * @param string like value to match with field 452 452 * @param boolean automatically add starting and ending wildcards 453 * @return objectThis Database object.453 * @return Database_Core This Database object. 454 454 */ 455 455 public function orlike($field, $match = '', $auto = TRUE) … … 472 472 * @param string like value to match with field 473 473 * @param boolean automatically add starting and ending wildcards 474 * @return objectThis Database object.474 * @return Database_Core This Database object. 475 475 */ 476 476 public function notlike($field, $match = '', $auto = TRUE) … … 492 492 * @param string|array field name or array of field => match pairs 493 493 * @param string like value to match with field 494 * @return objectThis Database object.494 * @return Database_Core This Database object. 495 495 */ 496 496 public function ornotlike($field, $match = '', $auto = TRUE) … … 512 512 * @param string|array field name or array of field => match pairs 513 513 * @param string like value to match with field 514 * @return objectThis Database object.514 * @return Database_Core This Database object. 515 515 */ 516 516 public function regex($field, $match = '') … … 532 532 * @param string|array field name or array of field => match pairs 533 533 * @param string like value to match with field 534 * @return objectThis Database object.534 * @return Database_Core This Database object. 535 535 */ 536 536 public function orregex($field, $match = '') … … 552 552 * @param string|array field name or array of field => match pairs 553 553 * @param string regex value to match with field 554 * @return objectThis Database object.554 * @return Database_Core This Database object. 555 555 */ 556 556 public function notregex($field, $match = '') … … 572 572 * @param string|array field name or array of field => match pairs 573 573 * @param string regex value to match with field 574 * @return objectThis Database object.574 * @return Database_Core This Database object. 575 575 */ 576 576 public function ornotregex($field, $match = '') … … 591 591 * 592 592 * @param string column name to group by 593 * @return objectThis Database object.593 * @return Database_Core This Database object. 594 594 */ 595 595 public function groupby($by) … … 619 619 * @param string value to match with key 620 620 * @param boolean disable quoting of WHERE clause 621 * @return objectThis Database object.621 * @return Database_Core This Database object. 622 622 */ 623 623 public function having($key, $value = '', $quote = TRUE) … … 633 633 * @param string value to match with key 634 634 * @param boolean disable quoting of WHERE clause 635 * @return objectThis Database object.635 * @return Database_Core This Database object. 636 636 */ 637 637 public function orhaving($key, $value = '', $quote = TRUE) … … 646 646 * @param string|array column(s) to order on, can be an array, single column, or comma seperated list of columns 647 647 * @param string direction of the order 648 * @return objectThis Database object.648 * @return Database_Core This Database object. 649 649 */ 650 650 public function orderby($orderby, $direction = '') … … 687 687 * @param integer number of rows to limit result to 688 688 * @param integer offset in result to start returning rows from 689 * @return objectThis Database object.689 * @return Database_Core This Database object. 690 690 */ 691 691 public function limit($limit, $offset = FALSE) … … 701 701 * 702 702 * @param integer offset value 703 * @return objectThis Database object.703 * @return Database_Core This Database object. 704 704 */ 705 705 public function offset($value) … … 715 715 * @param string|array key name or array of key => value pairs 716 716 * @param string value to match with key 717 * @return objectThis Database object.717 * @return Database_Core This Database object. 718 718 */ 719 719 public function set($key, $value = '') … … 738 738 * @param string limit clause 739 739 * @param string offset clause 740 * @return objectDatabase_Result740 * @return Database_Result 741 741 */ 742 742 public function get($table = '', $limit = NULL, $offset = NULL) … … 769 769 * @param string limit clause 770 770 * @param string offset clause 771 * @return objectThis Database object.771 * @return Database_Core This Database object. 772 772 */ 773 773 public function getwhere($table = '', $where = NULL, $limit = NULL, $offset = NULL) … … 827 827 * @param string table name 828 828 * @param array array of key/value pairs to insert 829 * @return object This Database object.829 * @return Database_Result Query result 830 830 */ 831 831 public function insert($table = '', $set = NULL) … … 862 862 * @param mixed An array or string to match against 863 863 * @param bool Generate a NOT IN clause instead 864 * @return objectThis Database object.864 * @return Database_Core This Database object. 865 865 */ 866 866 public function in($field, $values, $not = FALSE) … … 892 892 * @param string Name of the column being examined 893 893 * @param mixed An array or string to match against 894 * @return objectThis Database object.894 * @return Database_Core This Database object. 895 895 */ 896 896 public function notin($field, $values) … … 904 904 * @param string table name 905 905 * @param array array of key/value pairs to merge 906 * @return object This Database object.906 * @return Database_Result Query result 907 907 */ 908 908 public function merge($table = '', $set = NULL) … … 936 936 * @param array associative array of update values 937 937 * @param array where clause 938 * @return object This Database object.938 * @return Database_Result Query result 939 939 */ 940 940 public function update($table = '', $set = NULL, $where = NULL) … … 972 972 * @param string table name 973 973 * @param array where clause 974 * @return object This Database object.974 * @return Database_Result Query result 975 975 */ 976 976 public function delete($table = '', $where = NULL) … … 1001 1001 * Returns the last query run. 1002 1002 * 1003 * @return string 1003 * @return string SQL 1004 1004 */ 1005 1005 public function last_query() … … 1204 1204 * 1205 1205 * @param string|TRUE clear cache by SQL statement or TRUE for last query 1206 * @return objectThis Database object.1206 * @return Database_Core This Database object. 1207 1207 */ 1208 1208 public function clear_cache($sql = NULL)
