Forums

Stored procedures in concrete5

Permalink
can anybody tell me like we execute sql statements in concrete 5 can we call stored procedures in concrete 5
amita
 
T30 replied on at Permalink Reply
In my site (with mysql db) I use the normal Execute call:

$query = "CALL `db_name`.`proc_name`()";
$db = Loader::db();
$db->Execute($query);

MySqlWorkbench can write the query for you, right clicking the procedure name and selecting 'Copy to clipboard/Procedure call'.