Saving Data to a database

Hi again & thanks for any help.

I really don’t know why I’m not getting this, but I’m slowly starting to understand modx better & better. My issue is now saving data to a database using formit.

What I do is I have a Resource which calls a chunk. The chunk has the following info at the top:
************************************************
[[!FormIt?
&hooks=`redirect`
&redirectTo=`53`
&store=`1`
]]

[[!FormItRetriever]]

<form action="[[~[[*id]]]]" method="POST" id="cityCouncilUpdate">
....
</form>

************************************************

When I submit this form it goes to another resource, which then calls the snippet which will need to save the data into the database. This is where I’m having an issue.

Is it possible to easily pass all fields that were submitted via POST to the new snippet so I can use it and save it to the database all in one step? I know if I put the [[+fi.field_name]] in a parameter of the snippet call that it will pass and I can save it, however I would rather use an array and pass everything. Some of these forms that I’m going to be submitting might have well over 100 fields on them and I don’t want to type all fields out on all pages.

I tried using the $_POST variable, but as expected that didn’t work.

Hopefully my question makes sense and someone can help me out.

Thanks again!

I was fighting with checkboxes and getting information into an email the other day... where is this going you ask ...the point being that $_POST worked fine - it is after all it is just a form that ’posts’ data

try putting ’ print_r($ POST); in a snippet and put the snippet on the form processing page (id=53 in your example)

You should get a print out of the $_POST array

Then its just a matter of a little php...

Edit: FormIt does not save data to the database - it is on the roadmap for version 2.0 http://rtfm.modx.com/display/ADDON/FormIt.Roadmap

Thanks for the response Whislemaker,

So, now I’m going to have to try that again. I had tried using the $_POST variable, but it kept coming up empty for whatever reason. When I get back to that project, I will give it a shot. If the $_POST variable actually does work, then things will go so much smoother for me.

It’s funny, usually I catch on to these things really quickly...but for some reason the way modx handles some of these things is just taking me a little longer than normal. If I was doing this from scratch, no problems...lol.

But I’m going to keep using modx, as I really like the potential of it, and it will eventually make all of my sites much easier to edit and update.

Thanks again,
Dustin

don’t want to lead you astray -
I went back to work on the page to see if the new version of formit solved the problem I had (I had worked around it, and decided since everything was working to just leave it and not waste any more time).
Any way I noticed that if I used the formit &redirect=`whatever` $_POST did not work - if I just returned the results to same page as the form it did work, I think that if I used the standard <form action="foo.bar" it also worked (makes sense that it would.

Hope that helps.