How to get the database prefix value ?

[alainroger]

Hi,

how can i get the database prefix (e.g. jos_ for 1.5 or anything else if user changed it) during component installation ?
thx

[imanickam]

I doubt whether you need to do that as the place holder could be used for the prefix.

Review of the document http://docs.joomla.org/How_to_use_the_d ... our_script could be of help.

[radiant_tech]

Code: Select all

$app = JFactory::getApplication();
$prefix = $app->getCfg('dbprefix');

[tkuschel]

With Joomla 3.x and database environment, this is more convenience in that context:

Code: Select all

$db = JFactory::getDbo();
$prefix = $db->getPrefix();

Thomas
PS: In a standard query the place holder #__ is recommended, but sometimes with special mysql processing the prefix is needed.