Attention

This document was written for an old version of Plone, Plone 2.5.x, and was last updated 1205 days ago.

To learn how to upgrade to the current version of Plone, read the upgrade manual.

Plone and MySQL

How to integrate and manage MySQL data within Plone using TAL, MySQL, Python and Zope Page Templates (TMPZ)

  1. Introduction Requirements to make this happen.
  2. Z MySQL Database Connection The Z MySQL database connection is used to connect Zope to the actual MySQL database.
  3. Z SQL Method Z SQL Methods are queries made to a MySQL database when you need to perform an action such as select, insert, delete, etc.
  4. Creating Your First Page In this example, we will be displaying data within a page template from our MySQL database.
  5. Passing Arguments Passing arguments with MySQL and Python to create insert, update and delete statements.
  6. Conclusion Let's wrap this up.

All content on one page (useful for printing, presentation mode etc.)

 

Contribute

Something wrong or out of date? Anybody can edit or create a new article in the knowledge base. Simply create an account on this site, log in, and click the Edit button to contribute.