| [ Index ] |
|
Code source de b2evolution 2.1.0-beta |
[Code source] [Imprimer] [Statistiques]
This file implements the SQL class. This file is part of the evoCore framework - {@link http://evocore.net/} See also {@link http://sourceforge.net/projects/evocms/}.
| Author: | fplanque: Francois PLANQUE. |
| Copyright: | (c)2003-2007 by Francois PLANQUE - {@link http://fplanque.net/} |
| Version: | $Id: _sql.class.php,v 1.1 2007/06/25 10:58:59 fplanque Exp $ |
| Poids: | 419 lignes (9 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 0 fois |
| Nécessite: | 0 fichiers |
SQL:: (23 méthodes):
SQL()
get()
display()
get_select()
get_from()
get_where()
get_group_by()
get_order_by()
get_limit()
SELECT()
SELECT_add()
FROM()
FROM_add()
WHERE()
WHERE_and()
WHERE_or()
GROUP_BY()
ORDER_BY()
ORDER_BY_prepend()
LIMIT()
add_search_field()
WHERE_keyword()
WHERE_regexp()
| SQL() X-Ref |
| Constructor. |
| get() X-Ref |
| Get whole query |
| display() X-Ref |
| Get whole query |
| get_select( $prefix = ' SELECT ' ) X-Ref |
| Get SELECT clause if there is something inside |
| get_from( $prefix = ' FROM ' ) X-Ref |
| Get FROM clause if there is something inside |
| get_where( $prefix = ' WHERE ' ) X-Ref |
| Get WHERE clause if there is something inside |
| get_group_by( $prefix = ' GROUP BY ' ) X-Ref |
| Get GROUP BY clause if there is something inside |
| get_order_by( $prefix = ' ORDER BY ' ) X-Ref |
| Get ORDER BY clause if there is something inside |
| get_limit( $prefix = ' LIMIT ' ) X-Ref |
| Get LIMIT clause if there is something inside |
| SELECT( $select ) X-Ref |
| Set SELECT clause |
| SELECT_add( $select_add ) X-Ref |
| Extends the SELECT clause. param: srting should typically start with a comma ',' |
| FROM( $from ) X-Ref |
| Pas de description |
| FROM_add( $from_add ) X-Ref |
| Extends the FROM clause. param: string should typically start with INNER JOIN or LEFT JOIN |
| WHERE( $where ) X-Ref |
| Pas de description |
| WHERE_and( $where_and ) X-Ref |
| Extends the WHERE clause with AND param: string |
| WHERE_or( $where_or ) X-Ref |
| Extends the WHERE clause with OR NOTE: there is almost NEVER a good reason to use this! Think again! param: string |
| GROUP_BY( $group_by ) X-Ref |
| Pas de description |
| ORDER_BY( $order_by ) X-Ref |
| Pas de description |
| ORDER_BY_prepend( $order_by_prepend ) X-Ref |
| Pas de description |
| LIMIT( $limit ) X-Ref |
| Pas de description |
| add_search_field( $field, $reg_exp = '' ) X-Ref |
| create array of search fields param: string field to search on param: string regular expression we want to use on the search for the field param |
| WHERE_keyword( $search, $search_kw_combine ) X-Ref |
| create the filter whith the search field array param: string search param: string operator( AND , OR , PHRASE ) for the filter |
| WHERE_regexp( $search, $search_kw_combine ) X-Ref |
| create the filter whith the search field regexp array param: string search param: string operator( AND , OR , PHRASE ) for the filter |
| Généré le : Thu Nov 29 23:58:50 2007 | par Balluche grâce à PHPXref 0.7 |
|
|