problem with Form Plugin

[andrea@benedetto.com]

hello,
I'm using this simple code in form-plugin (end of form submission - onAfterProccess) and it doesn't work:

$sql = "UPDATE cars SET code='0000' WHERE id=1";
mysqli_query($conn, $sql);

'code' value never changes. Can you tell me why?
Thanks

 

[troester]

Where do you set $conn?
Use the Joomla framework
http://fabrikar.com/forums/index.php?wiki/php-common-tasks/&redirect=common-php-tasks

 

[andrea@benedetto.com]

$conn is not set by default?? I'm establishing the connection to the database with command:
$db = JFactory::getDBO();
and works if I extract data, but not for updating

 

[startpoint]

https://docs.joomla.org/Selecting_data_using_JDatabase

 

[lousyfool]

https://docs.joomla.org/Selecting_data_using_JDatabase

... and https://docs.joomla.org/Inserting,_Updating_and_Removing_data_using_JDatabase for updating.

 

[andrea@benedetto.com]

Thanks for your links but I can't find something that can help me ... I just need to change one value

 

[troester]

What's the problems with the links? Here are the "update" parts of these links.
http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#update
or
https://docs.joomla.org/Inserting,_Updating_and_Removing_data_using_JDatabase#Using_SQL_2

 

[lousyfool]

$mydb = JFactory::getDbo();
$query = $mydb->getQuery(true);
$query->update($mydb->quoteName('cars'))->set($mydb->quoteName('code').' = '0000'')->where($mydb->quoteName('id').' = 1');
$mydb->setQuery($query);
$mydb->execute();

Where do I send my invoice?

 

[andrea@benedetto.com]

$mydb = JFactory::getDbo();
$query = $mydb->getQuery(true);
$query->update($mydb->quoteName('cars'))->set($mydb->quoteName('code').' = '0000'')->where($mydb->quoteName('id').' = 1');
$mydb->setQuery($query);
$mydb->execute();

Where do I send my invoice?

I can offer you a coffee ...thank you very much! I have found the problem, I never used the "quote" keyword for print variables in query. Thanks