MODX3 How to get the db table prefix?

fritzkola · August 17, 2022, 8:59am

Hello,

how can I get the database table prefix?
I dont find anything…

thank you in advance.

bye
Chris

dejaya · August 17, 2022, 9:04am

You should be able to find your table prefix in:

Manage / Reports / System Info:

fritzkola · August 17, 2022, 9:06am

Thank you very much.

I have to be more specific.

I need the prefix value in snippet.

dejaya · August 17, 2022, 9:31am

There may be more elegant ways to do this but I think this should work:

<?php
include 'core/config/config.inc.php';
echo $table_prefix;

Someone more knowledgeable than me might be able to comment on the security of this method.

fritzkola · August 17, 2022, 9:33am

thank you.
ok, this is a solution.

I tried some, but I remember there should be indeed a more elegant way.

halftrainedharry · August 17, 2022, 9:38am

$modx->getOption('table_prefix');

fritzkola · August 17, 2022, 9:46am

yes, thats it.

thank you so much.