Using Sourcerer plugin to insert into table

[ilanocf]

Hello everybody!

I created a table for the user to evaluate the company's services for whom I am developing the website and I need to place a form in Joomla to make insertions in this table. For this I need to use Soucerer but I need help. Download the code below. Just one detail, I'm using the free version.

{source}

<div class="row">
<div class="col-sm-4">&nbsp;</div>
<div class="col-sm-8">
<div class="h3">Avalie-nos</div>
<div>&nbsp;</div>
<form action="/index.php" method="post">
<div><input name="option" type="hidden" value="com_content" /></div>
<div><input name="task" type="hidden" value="saveAvaliacao" /></div>
<div><input name="article_id" type="hidden" value="{ARTICLE_ID}" /></div>
<div><label for="email">E-mail:</label></div>
<div><input name="email" required="" type="email" id="email" /></div>
<div><label for="estrela">Estrela:</label></div>
<div><span class="star-rating star-5"> <input name="rating" required="" type="radio" value="1" /><i></i> <input name="rating" type="radio" value="2" /><i></i> <input name="rating" type="radio" value="3" /><i></i> <input name="rating" type="radio" value="4" /><i></i> <input name="rating" type="radio" value="5" /><i></i> </span></div>
<div><label for="observacao">Comentário:</label></div>
<div><textarea cols="50" name="comentario" rows="4" id="comentario" class="form-control"></textarea><br /> <input type="submit" value="Enviar" class="btn btn-primary btn-sm" /></div>
</form></div>
</div>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['email']) && isset($_POST['rating']) && isset($_POST['comentario'])) {
$db = JFactory::getDbo();

$query = $db->getQuery(true)
->insert($db->quoteName('josoy_pilotis_avaliacao'))
->columns(array('avaliadata', 'email', 'rating', 'comentario'))
->values($db->quote(date('Y-m-d H:i:s')) . ', ' . $db->quote($_POST['email']) . ', ' . $db->quote($_POST['rating']) . ', ' . $db->quote($_POST['comentario']));

$db->setQuery($query);
$result = $db->execute();

if ($result) {
echo 'Avaliação inserida com sucesso!';
} else {
echo 'Ocorreu um erro ao inserir a avaliação.';
}
}
?>{/source}

When executed, the message is returned:
View class not found [name, type, prefix]: page, html, site

Thanks

[ilanocf]

Enabling Joomla 4's Debug mode returns the following:

Function: ()
Location: JROOT/libraries/src/MVC/Controller/BaseController.php:837

Function: Joomla\CMS\MVC\Controller\BaseController->getView()
Location: JROOT/libraries/src/MVC/Controller/BaseController.php:615

Function: Joomla\CMS\MVC\Controller\BaseController->display()
Location: JROOT/components/com_content/src/Controller/DisplayController.php:121

Function: Joomla\Component\Content\Site\Controller\DisplayController->display()
Location: JROOT/libraries/src/MVC/Controller/BaseController.php:693

Function: Joomla\CMS\MVC\Controller\BaseController->execute()
Location: JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:143

Function: Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()
Location: JROOT/components/com_content/src/Dispatcher/Dispatcher.php:56

Function: Joomla\Component\Content\Site\Dispatcher\Dispatcher->dispatch()
Location: JROOT/libraries/src/Component/ComponentHelper.php:361

Function: Joomla\CMS\Component\ComponentHelper::renderComponent()
Location: JROOT/libraries/src/Application/SiteApplication.php:208

Function: Joomla\CMS\Application\SiteApplication->dispatch()
Location: JROOT/libraries/src/Application/SiteApplication.php:249

Function: Joomla\CMS\Application\SiteApplication->doExecute()
Location: JROOT/libraries/src/Application/CMSApplication.php:293

Function: Joomla\CMS\Application\CMSApplication->execute()
Location: JROOT/includes/app.php:61

Function: require_once()
Location: JROOT/index.php:32

[SharkyKZ]

You should reconsider this. Using Sourcerer is fundamentally wrong. It's also volatile, unmaintainable and insecure. Read some documentation how to write a proper Joomla extension.

[ilanocf]

What would you recommend me? Can I do something like this using the Custom HTML module?
I need to integrate new features into Joomla 4 so that it is more than a content manager.

[gws]

Most of the form builders will do what you need in your first post.