Sylvain1969
Member
Hello
I have got this code in the form plugin and it's being execute after the onAfterProcess.
However no data is entered in the database ?
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Insert columns.
$columns = array('status','agent_name');
// Insert values.
$values = array('1001','sylvain');
// Prepare the insert query.
$query
->insert($db->quoteName('#__track_handling'))
->columns($db->quoteName($columns))
->values(implode(',', $values));
// Set the query using our newly populated query object and execute it.
$db->setQuery($query);
$db->query();
I have got this code in the form plugin and it's being execute after the onAfterProcess.
However no data is entered in the database ?
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Insert columns.
$columns = array('status','agent_name');
// Insert values.
$values = array('1001','sylvain');
// Prepare the insert query.
$query
->insert($db->quoteName('#__track_handling'))
->columns($db->quoteName($columns))
->values(implode(',', $values));
// Set the query using our newly populated query object and execute it.
$db->setQuery($query);
$db->query();