Actions

API16

Difference between revisions of "JDatabaseQuery/set"

From Joomla! Documentation

< API16:JDatabaseQuery
(New page: <span class="editsection" style="font-size:76%;"> <nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki> </span> {{Description:JDatabaseQuery/set}} ...)
 
m (removing red link to edit, no existant pages)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>[[Description:JDatabaseQuery/set|Edit Descripton]]<nowiki>]</nowiki>
+
<nowiki>[<! removed edit link to red link >]</nowiki>
 
</span>
 
</span>
  
{{Description:JDatabaseQuery/set}}
+
<! removed transcluded page call, red link never existed >
  
 
===Syntax===
 
===Syntax===
Line 45: Line 44:
  
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>[[SeeAlso:JDatabaseQuery/set|Edit See Also]]<nowiki>]</nowiki>
+
<nowiki>[<! removed edit link to red link >]</nowiki>
 
</span>
 
</span>
{{SeeAlso:JDatabaseQuery/set}}
+
<! removed transcluded page call, red link never existed >
  
 
===Examples===
 
===Examples===
Line 60: Line 59:
 
  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>
 +
[[Category:Archived pages API16]]

Latest revision as of 22:03, 12 May 2013

Replacement filing cabinet.png
This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

[<! removed edit link to red link >]

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

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;
}

[<! removed edit link to red link >] <! removed transcluded page call, red link never existed >

Examples

<CodeExamplesForm />

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();