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.)

 

Related content

MySQL connectivity in Zope/Plone
Basics how to connect MySQL from Zope and Plone.

See also

Posted by amine at Dec 05, 2006 02:10 AM
A tutorial in video (swf) format showing how to integrate Mysql and Zope using Dreamweaver.
http://www.afpy.org/Members/amine/mysql_zope.zip/

problems

Posted by unset at Sep 24, 2007 08:05 PM
In can´t acces to this addres, how i can download this file

simply...

Posted by amine at Sep 29, 2007 05:34 PM
You have to register at afpy.org (french python association), then, simply copy/paste http://www.afpy.org/Members/amine/mysql_zope.zip/ in your browser.
best,

Paging in Results from MySQL + Python in Plone

Posted by Sonu at Jun 02, 2009 11:20 PM
Please let me know if there is any way to achieve the paging in the results received from Z Method from MySQL in Plone.

Thanks!