1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| $db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Insert columns.
$columns = array('id_from', 'subject', 'message');
// echo JRequest::getVar('Itemid'). $db->Quote($this->submittername() . " (" . $this->submitteraddress() . ")"). $db->Quote(JMailHelper::cleanBody($body));
// Insert values.
$values = array(JRequest::getVar('Itemid'), $db->Quote($this->submittername() . " (" . $this->submitteraddress() . ")"), $db->Quote(JMailHelper::cleanBody($body)));
// Prepare the insert query.
$query
->insert($db->quoteName('#__contact'))
->columns($db->quoteName($columns))
->values(implode(',', $values));
// var_dump($query);
// exit();
// Set the query using our newly populated query object and execute it.
$db->setQuery($query);
$db->execute(); |
Partager