It might seem intimidating, but hooking Zope up to a MySQL database is easier than you think. And once you've got the two talking nice to each other, it becomes even simpler to create dynamic, Zope-based Web applications. Take a look.
As a recent convert to Zope from PHP, I was curious: could Zope really give me all the capabilities I was used to in PHP?
I decided to find out, by using one of my most common activities with PHP as the benchmark: connecting to and retrieving records from a MySQL database. As it turned out, Zope manages this quite well, and it's also nowhere near as complicated as you might think. And so, over the course of this article, I'm going to show you how to hook your Zope server up to a MySQL database, and write DTML code that allows you to retrieve and manipulate MySQL table records using standard SQL commands. If this sounds interesting, keep reading.
