Personal tools
You are here: Home → Documentation → Tutorials → Plone and MySQL
Support

Get Help

Join our chat rooms or support forums if you have more specific questions.

Plone Training
Learn how to design, build, and deploy a website in Plone through one of the numerous Plone training sessions around the world.
Find Plone training…
 
Document Actions

Plone and MySQL

This Tutorial applies to: Plone 2.5.x, Plone 2.1.x, Plone 2.0.x
This Tutorial is intended for: Integrators, Customizers, Developers

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

mtakahashi

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

  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.
 

see also:

MySQL connectivity in Zope/Plone
Basics how to connect MySQL from Zope and Plone.
by Mike Takahashi — last modified October 31, 2006 - 20:52 All content is copyright Plone Foundation and the individual contributors.

See also

Posted by amine at December 5, 2006 - 02:10
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 September 24, 2007 - 20:05
In can´t acces to this addres, how i can download this file

simply...

Posted by amine at September 29, 2007 - 17:34
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,

For any issues with the web site functionality, please file a ticket.

Please consult the policy on plone.org content if you want your content published on this site.

Servers and hosting by