Database driven Sermon Website
Mar 9th, 2005 by Lyle Melick
I have been using a database driven (MySQL) website to host the sermons for our church. The LAMP sermon webpage is actually here since I have a lot of disk space available on my home server. The page is generated with PHP and the webserver is Apache running on OpenNA linux. I’m using a CSS style sheet instead of tables.
The website is driven by a database. When you’re ready to add a new sermon to the website, you simply add an entry to the database. The next time someone hits the site, the new entry is shown along with all the past sermons. Currently, I update the database via MySQLfront.
I’m in the process of turning this into a Sourceforge project, PHPSermon. I’ve recently been intrigued with the possibility of podcasting the sermons, especially since MP3 is already on of the formats. There are a number of links on the wikipedia page to help you get started. A podcatcher will allow you to automatically pick up the sermons after they’re posted, so their ready the next time you sync your ipod or are ready to load your MP3’s to realplayer on your Zire.
[...] k to download the file.) The trick is to develop what’s called an RSS feed. With a Database Driven Website[5] or blogging software like WordPress the generation of the RSS Feed is nearly trivial. L [...]
For Madison Park Christian Church I have developed a PHP / mySQL sermon archive web site with a complete multiple-administrative back-end. Come have a look around. I’m in the process of refining the software into a package that I will be able to distribute. http://www.MadisonParkSermons.com
[...] as a link to download the file.) The trick is to develop what’s called an RSS feed. With a Database Driven Website[5] or blogging software like WordPress[6] the generation of the RSS Feed is nearly [...]