API16

JDatabaseQuery/set

From Joomla! Documentation

< API16:JDatabaseQuery
Revision as of 20:30, 24 March 2017 by JoomlaWikiBot (talk | contribs) (preparing for archive only)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The "API16" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

<! removed transcluded page call, red link never existed >

Syntax[edit]

set($conditions, $glue=',')
Parameter Name Default Value Description
$conditions A string or array of conditions
$glue ','

Defined in[edit]

libraries/joomla/database/databasequery.php

Importing[edit]

jimport( 'joomla.database.databasequery' );

Source Body[edit]

public function set($conditions, $glue=',')
{
        if (is_null($this->_set)) {
                $glue = strtoupper($glue);
                $this->_set = new JDatabaseQueryElement('SET', $conditions, "\n\t$glue ");
        } else {
                $this->_set->append($conditions);
        }

        return $this;
}


<! removed transcluded page call, red link never existed >

Examples[edit]

Code Examples[edit]

No Title

Example:

$query	= $db->getQuery(true);
$query->insert('#__tableName');

$query->set('id=4');

$db->setQuery( $query );
$result	= $db->loadResult();
Unhindered 16:28, 18 August 2010 (CDT) Edit comment
$query	= $db->getQuery(true);
$query->insert('#__table_name');
'''$query->set('id=2');
$query->set('something_else=4');'''
$db->setQuery( $query );
$result	= $db->loadResult();