X-Cart forums

[dagdag]

Good day!

I really need to call my external stored procedure before the checkout page ( shop.com/?target=checkout as example) start loading.
Stored procedure located in x-cart database and does not use or return parameters.

How can this be realize most correctly? Thank you very much!

This is necessary to monitor the connection of the store with the external fiscal registrar.

[qualiteam]

Do you mean stored procedures?

If so, working with them will be tricky a bit. X-Cart 5 works with the database via Doctrine that is an abstraction over different database types. But stored procedures are not consistent across different types of databases, so is not something that can be implemented as an abstract thing.

However, you can use "Native Queries" to run raw SQL queries against the database:

PHP Code:

\XLite\Core\Database::getEM()->getConnection()->executeQuery('YOUR RAW SQL QUERY GOES THERE'); 


Does this work?

---

I've been told by our support staff that using the same "database handle" for regular queries and stored procedures may result into "Commands out of sync" error. If this happens to you too, you may try to use the MySQL PDO or MySQLi directly (not via Doctrine).

[dagdag]

However, you can use "Native Queries" to run raw SQL queries against the database:

\XLite\Core\Database::getEM()->getConnection()->executeQuery('YOUR RAW SQL QUERY GOES THERE');

Does this work?

Yes! It works fine! MySQL store procedures (and functions too!) called from x-cart and run without errors.
You are my god! Thank!