API16:JDatabaseQuery/set
From Joomla! Documentation
< API16:JDatabaseQuery(Difference between revisions)
(New page:
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki>
</span>
{{Description:JDatabaseQuery/set}}
...) |
Unhindered (Talk | contribs) (→Examples) |
||
| Line 60: | Line 60: | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
| + | |||
| + | <source lang="php"> | ||
| + | $query = $db->getQuery(true); | ||
| + | $query->insert('#__table_name'); | ||
| + | '''$query->set('id=2'); | ||
| + | $query->set('something_else=4');''' | ||
| + | $db->setQuery( $query ); | ||
| + | $result = $db->loadResult(); | ||
| + | </source> | ||
Revision as of 16:30, 18 August 2010
Description:JDatabaseQuery/set
Contents |
Syntax
set($conditions, $glue=',')
| Parameter Name | Default Value | Description |
|---|---|---|
| $conditions | A string or array of conditions | |
| $glue | ',' |
Defined in
libraries/joomla/database/databasequery.php
Importing
jimport( 'joomla.database.databasequery' );
Source Body
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; }
[Edit See Also] SeeAlso:JDatabaseQuery/set
Examples
<CodeExamplesForm />
No Title
$query = $db->getQuery(true); $query->insert('#__table_name'); '''$query->set('id=2'); $query->set('something_else=4');''' $db->setQuery( $query ); $result = $db->loadResult();
Example: