[Snippet] db2form 0.1 - Produce a SELECT or INSERT html form from a MySQL table

jibbist,

You may want to look at Anders ppp function to see how he handled the edit functions.

What a great idea for a snippet! It’s something many people have wished for for a long time.

Thanks for contributing.

Thanks every one for the nice comments!

I can confirm that I am developing this again after a short break (damn Uni work). I’ve been getting into Ruby on Rails, so you’ll see some Rails inspired thinking in this snippet hopefully!

If anyone has ideas, improvements or anything -- just say.

Glad to see modx still alive and active,
Jibbist

Glad to see modx still alive and active

Not only is modx still alive, it is getting bigger and better.

Good to hear that this cool snippet will get even better. Welcome back

Just as a quick update to all of this...

This project is now available here:

http://github.com/jibbist/db2form

This is a git repository where i’ll be doing the development, and where I encourage anyone else who wants to, to start modifying it and making their own branches.

Thanks, Andy.

I see the version is 0.2. Is there a changelog from version 0.1?

Yep, just added that now from a previous post I did in this thread.

I shall hopefully work on this when I can find the time!

This works very well so far. I’m looking forward to the next version.

Hi everyone, as promised I haven’t forgotten you, don’t worry!

These are some future features that I’m working on...

- Storing regular expressions in the MySQL field comment to validate INSERT queries
- Adding an edit button to SELECT forms
- Adding a delete button to SELECT forms
- Add templating in chunks for success and failure messages
- Adding header labels by parameter, or by MYSQL comment parsing
- Aligning form cells by parameter

Any more?!

Hi Jibbist,

Thanks for all your good work! Can you explain / show an example of how to do a where clause with the help of a tv as mentioned in the 0.2 documentation.

Many Thanks in advance,

Noah