I recently inherited a website project that my employer had summer interns create. Being non-technical types, they opted for Joomla CMS to create the content. They also opted to make all of the current content static, and to manage updates manually, article by article (these were high school interns with little/no technical background).
As part of my takeover, one of my first goals is to get all of the volatile data (company information, event information, etc) into MySQL, and then load the content into the articles dynamically. Joomla already has a MySQL database; I've added a table to it, storing the frontend content I want to load dynamically, and now I want to make one of my articles pull from that table, row by row, and spit out some HTML to format it. To my knowledge, the easiest way to do this is to use PHP to embed SQL queries (if I'm wrong about that, feel free to suggest alternate dynamic content models in Joomla!), and so the logical first step is to get some PHP embedded in an article.
I have tried using the Sourcerer and DirectPHP extensions, but in both cases (and with manually inserted PHP code), I find that the PHP is getting ignored. For example, I made an article with nothing but this:
<?php echo "This is a PHP string"; ?>
And when I load the article, it is empty. I've scanned the settings and configuration pages of the Joomla install and done a number of Google searches, and thus far haven't been able to find anything. I bet I'm missing something pretty simple, but I don't know what. Any suggestions?