|
Вернуться к записям по теме Joomla.
Joomla.Platform\JDatabaseQuery
libraries/joomla/database/databasequery.php at line 115
Class JDatabaseQueryJDatabaseQuery
public abstract class JDatabaseQuery
Field Detaillibraries/joomla/database/databasequery.php at line 199columnsprotected object The column list for an INSERT statement. $columns = null
libraries/joomla/database/databasequery.php at line 121 dbprotected resource The database connection resource. $db = null
libraries/joomla/database/databasequery.php at line 145 deleteprotected object The delete element. $delete = null
libraries/joomla/database/databasequery.php at line 133 elementprotected string The query element for a generic query (type = null). $element = null
libraries/joomla/database/databasequery.php at line 163 fromprotected object The from element. $from = null
libraries/joomla/database/databasequery.php at line 187 groupprotected object The group by element. $group = null
libraries/joomla/database/databasequery.php at line 193 havingprotected object The having element. $having = null
libraries/joomla/database/databasequery.php at line 157 insertprotected object The insert element. $insert = null
libraries/joomla/database/databasequery.php at line 169 joinprotected object The join element. $join = null
libraries/joomla/database/databasequery.php at line 211 orderprotected object The order element. $order = null
libraries/joomla/database/databasequery.php at line 139 selectprotected object The select element. $select = null
libraries/joomla/database/databasequery.php at line 175 setprotected object The set element. $set = null
libraries/joomla/database/databasequery.php at line 127 typeprotected string The query type. $type = ''
libraries/joomla/database/databasequery.php at line 151 updateprotected object The update element. $update = null
libraries/joomla/database/databasequery.php at line 205 valuesprotected object The values list for an INSERT statement. $values = null
libraries/joomla/database/databasequery.php at line 181 whereprotected object The where element. $where = null
Constructor Detaillibraries/joomla/database/databasequery.php at line 253__constructpublic JDatabaseQuery __construct(JDatabase db)
Class constructor.
Method Detaillibraries/joomla/database/databasequery.php at line 223__callpublic string __call(string method, array args)
Magic method to provide method alias support for quote() and quoteName().
libraries/joomla/database/databasequery.php at line 265 __toStringpublic string __toString()
Magic function to convert the query to a string.
libraries/joomla/database/databasequery.php at line 363 __getpublic mixed __get(String name)
Magic function to get protected variable value
libraries/joomla/database/databasequery.php at line 379 castAsCharpublic string castAsChar(string value)
Casts a value to a char. Ensure that the value is properly quoted before passing to the method.
libraries/joomla/database/databasequery.php at line 395 charLengthpublic string charLength(string value, mixed field)
Gets the number of characters in a string. Note, use 'length' to find the number of bytes in a string.
libraries/joomla/database/databasequery.php at line 409 clearpublic void clear(string clear, mixed clause)
Clear data from the query or a specific clause of the query.
libraries/joomla/database/databasequery.php at line 499 columnspublic JDatabaseQuerySQLAzure columns(mixed columns)
Adds a column, or array of column names that would be used for an INSERT INTO statement.
libraries/joomla/database/databasequery.php at line 521 concatenatepublic string concatenate(array values, string separator)
Concatenates an array of column names or values.
libraries/joomla/database/databasequery.php at line 538 currentTimestamppublic string currentTimestamp()
Gets the current date and time.
libraries/joomla/database/databasequery.php at line 550 dateFormatpublic string dateFormat()
Returns a PHP date() function compliant date format for the database driver.
libraries/joomla/database/databasequery.php at line 566 deletepublic JDatabaseQuery delete(string table)
Add a table name to the DELETE clause of the query. Note that you must not mix insert, update, delete and select method calls when building a query.
libraries/joomla/database/databasequery.php at line 589 escapepublic string escape(string text, bool extra)
Method to escape a string for usage in an SQL statement.
libraries/joomla/database/databasequery.php at line 609 frompublic JDatabaseQuery from(mixed tables)
Add a table to the FROM clause of the query. Note that while an array of tables can be provided, it is recommended you use explicit joins.
libraries/joomla/database/databasequery.php at line 630 grouppublic JDatabaseQuery group(mixed columns)
Add a grouping column to the GROUP clause of the query.
libraries/joomla/database/databasequery.php at line 652 havingpublic JDatabaseQuery having(mixed conditions, string glue)
A conditions to the HAVING clause of the query.
libraries/joomla/database/databasequery.php at line 674 innerJoinpublic JDatabaseQuery innerJoin(string conditions)
Add an INNER JOIN clause to the query.
libraries/joomla/database/databasequery.php at line 692 insertpublic JDatabaseQuery insert(mixed table)
Add a table name to the INSERT clause of the query. Note that you must not mix insert, update, delete and select method calls when building a query.
libraries/joomla/database/databasequery.php at line 710 joinpublic JDatabaseQuery join(string type, string conditions)
Add a JOIN clause to the query.
libraries/joomla/database/databasequery.php at line 729 leftJoinpublic JDatabaseQuery leftJoin(string conditions)
Add a LEFT JOIN clause to the query.
libraries/joomla/database/databasequery.php at line 747 lengthpublic int length(string value)
Get the length of a string in bytes. Note, use 'charLength' to find the number of characters in a string.
libraries/joomla/database/databasequery.php at line 761 nullDatepublic string nullDate(boolean quoted)
Get the null or zero representation of a timestamp for the database driver.
libraries/joomla/database/databasequery.php at line 785 orderpublic JDatabaseQuery order(mixed columns)
Add a ordering column to the ORDER clause of the query.
libraries/joomla/database/databasequery.php at line 806 outerJoinpublic JDatabaseQuery outerJoin(string conditions)
Add an OUTER JOIN clause to the query.
libraries/joomla/database/databasequery.php at line 824 quotepublic string quote(string text, bool escape)
Method to quote and optionally escape a string to database requirements for insertion into the database.
libraries/joomla/database/databasequery.php at line 844 quoteNamepublic string quoteName(string name)
Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection risks and reserved word conflicts.
libraries/joomla/database/databasequery.php at line 862 rightJoinpublic JDatabaseQuery rightJoin(string conditions)
Add a RIGHT JOIN clause to the query.
libraries/joomla/database/databasequery.php at line 881 selectpublic JDatabaseQuery select(mixed columns)
Add a single column, or array of columns to the SELECT clause of the query. Note that you must not mix insert, update, delete and select method calls when building a query. The select method can, however, be called multiple times in the same query.
libraries/joomla/database/databasequery.php at line 905 setpublic JDatabaseQuery set(mixed conditions, string glue)
Add a single condition string, or an array of strings to the SET clause of the query.
libraries/joomla/database/databasequery.php at line 929 updatepublic JDatabaseQuery update(mixed tables)
Add a table name to the UPDATE clause of the query. Note that you must not mix insert, update, delete and select method calls when building a query.
libraries/joomla/database/databasequery.php at line 946 valuespublic JDatabaseQuerySQLAzure values(string values)
Adds a tuple, or array of tuples that would be used as values for an INSERT INTO statement.
libraries/joomla/database/databasequery.php at line 968 wherepublic JDatabaseQuery where(mixed conditions, string glue)
Add a single condition, or an array of conditions to the WHERE clause of the query.
Вернуться к записям по теме Joomla.
|
Query Building Class.