As simple as 4 rules of code you can do create a mySQL statment for database interactions.

Here we call a stored procedure with a variable ($jn_cache_data)

use Joomla\CMS\Factory;
$setquery="call geo_v01_delete_old_records($jn_cache_data);";
$db = Factory::getDBO();
$db->setQuery($setquery);
$db->execute();
 
Happy coding!
 

Share this page