Manage a MySQL Table#

Hello there!

I am trying to build a tiny shop. It should be just a table with fields like item number, description, price and so on.

For this i want to set up a MySQL table. I want to fill the data from the Modx Manager.
You could say I want a lite phpMyAdmin for a single table inside of the manager.

Is there an extra doing this?

If you have another idea, how to realize my project without having a mass of unsorted data in the end (like I would, if I put the whole data in one html table), please let me know.

I'm using MODX Revolution 2.1.3-pl (traditional).

Thank you for your help,
Simon!

What version of MODX are you using?

Quote from: AMDbuilder at Oct 26, 2011, 04:03 PM

What version of MODX are you using?

I'm using MODX Revolution 2.1.3-pl (traditional).

Hello
Have a look at http://rtfm.modx.com/display/revolution20/Developing+an+Extra+in+MODX+Revolution
and http://rtfm.modx.com/display/revolution20/Using+Custom+Database+Tables+in+your+3rd+Party+Components
it should be useful to achieve your goals
Cheers

This might help also: http://bobsguides.com/custom-db-tables.html. In this version, you create the table in PhpMyAdmin then run the tools to create the schema and class files. It's sometimes easier to do it that way if you just have a single table.

Hello,
Note that It's pretty easy to reverse engineer database by the Bob's way, BUT this way does NOT create the relationships between tables if you have some...You wiil have to create them manually once the xml schema and class files are created

Thank you for you'r advices.

I now decided to build a dedicated php script for this purpose, since there's not enaugh time left.

But I think your tips and ideas will help me in the future.

Thank you guys!

FYI, you can also use straight PDO to interact with your table.