Difference between revisions of "JDatabaseMySQL/insertObject"
From Joomla! Documentation
< API16:JDatabaseMySQL
(New page: ===Description===
Inserts a row into a table based on an objects properties
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>[[Description:JDatabaseMySQL/insertObje...) |
m (preparing for archive only) |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
Inserts a row into a table based on an objects properties | Inserts a row into a table based on an objects properties | ||
− | |||
− | |||
− | |||
− | + | ||
+ | <! removed transcluded page call, red link never existed > | ||
===Syntax=== | ===Syntax=== | ||
Line 21: | Line 19: | ||
| The name of the table | | The name of the table | ||
|- | |- | ||
− | | | + | | &$object |
| | | | ||
| An object whose properties match table fields | | An object whose properties match table fields | ||
Line 64: | Line 62: | ||
</source> | </source> | ||
− | + | ||
− | + | <! removed transcluded page call, red link never existed > | |
− | < | ||
− | |||
===Examples=== | ===Examples=== | ||
− | + | === Code Examples === | |
<dpl> | <dpl> | ||
noresultsheader=\n | noresultsheader=\n | ||
category=insertObject | category=insertObject | ||
category=JDatabaseMySQL | category=JDatabaseMySQL | ||
− | + | namespace=CodeExample | |
category=MethodExample | category=MethodExample | ||
include=* | include=* | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
+ | [[Category:Archived pages API16]] |
Latest revision as of 20:27, 24 March 2017
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.
Description[edit]
Inserts a row into a table based on an objects properties
<! removed transcluded page call, red link never existed >
Syntax[edit]
insertObject($table, &$object, $keyName=NULL)
Parameter Name | Default Value | Description |
---|---|---|
$table | The name of the table | |
&$object | An object whose properties match table fields | |
$keyName | NULL | The name of the primary key. If provided the object property is updated. |
Defined in[edit]
libraries/joomla/database/database/mysql.php
Importing[edit]
jimport( 'joomla.database.database.mysql' );
Source Body[edit]
public function insertObject($table, &$object, $keyName = NULL)
{
$fmtsql = 'INSERT INTO '.$this->nameQuote($table).' (%s) VALUES (%s) ';
$fields = array();
foreach (get_object_vars($object) as $k => $v) {
if (is_array($v) or is_object($v) or $v === NULL) {
continue;
}
if ($k[0] == '_') { // internal field
continue;
}
$fields[] = $this->nameQuote($k);
$values[] = $this->isQuoted($k) ? $this->Quote($v) : (int) $v;
}
$this->setQuery(sprintf($fmtsql, implode(",", $fields) , implode(",", $values)));
if (!$this->query()) {
return false;
}
$id = $this->insertid();
if ($keyName && $id) {
$object->$keyName = $id;
}
return true;
}
<! removed transcluded page call, red link never existed >
Examples[edit]
Code Examples[edit]