Save formdata into database

[Stim]

Hi

Is it possible, if make some form on article and post data into database? Example into new table for example named to “order” Need to store data to database but dont know how, instead of send it to email

[rushclub]

as far as i know that must be possible with the current snapshot.

cheers
rush

[Stim]

Thanks for youre fast replay rushclub,

But what is "snapshot"? Can you explain little more? Didn’t understand what you mean really but is it any mod I need to install?

[pepe]

Let's say it SHORT:

Snapshot is an "inofficial stable" phpWCMS-version... And, because newer, with some sweet features in it

So, get it! And ...up to the moon!!! http://www.phpwcms.org/snapshot/

[flip-flop]

Please have a look: - [ Snapshot ]

Knut

[pepe]

Moin Knut...

Was treibst du dich noch hier rum... um die Zeit? Anständige Menschen sind schon im Bett

[Stim]

Thanks man! Never heard about "snapshot" before. First i was thinke on was "image snapshot"?! As some of the phpwcms user already knows I was gone from forum because make trip to India for 6 month so I suppose this "snapshot" is pretty new to "phpwcms forum chat".

Thanks for explaining and will cheek this out.

[Stim]

Well, i now installed that latest snapshot but couldn’t figure out how to save to database. How do I do this?

I installed clean version of snapshot to localhost, not update because just test and used content part “Form” but don’t understand how to save data to database instead send to email. There was some box like;

database: "save form results" and "save user profile data"

As I understand that box "save form results" mean it saves to some table in database. But can’t understand how it is possible when there is no table column created specific for the form to save it on. Or do i need to create one first?

Very confused and help needed to understand this better, if that’s is the way to store data from forms to database.

Danke for all help

[rushclub]

if you look into yout database you will see the table: phpwcms_formresult.
thats it. i think.

rush

[Stim]

Well, have tested this now to left, right, up and down and as I understand this wasn’t what i looked for really.

Stored data need of curse to shows on webpage later, filter and print etc. by costumers. This only allows to download so i suppose this staff’s doesn’t possible, not now anyway.

However, thanks for help.

[Stim]

Hi rushclub,

Sorry i didn’t saw your post or you where little faster to replay. Anyway i look into database, onto phpwcms_formresult but couldn’t find any "test data" i send before, 2 times so there should be 2 rows with info from form but can’t find data as, first name, last name etc

When download and open with Excel all data is there so it should be into table to. Will look more to se if i can find anything but this is great news that result store in table, like this, didn’t know that. Then it shouldn’t be hard to display data from this table and filter etc from webpage.

[Stim]

Ok i find it, its stored into phpwcms_formresult > formresult_content.

Can i get data from column formresult_content and show it on webpages somehow? Never seen result store like this, all result on only 1 column like this, so i dont know

[rushclub]

of course you will try the contentpart guestbook.
that suits your needs more - i think.

rush

[Stim]

I don’t think think that will work relay? Not for this anyway http://forum.phpwcms.org/viewtopic.php?f=1&t=16425

But depends on how you really mean maybe it work, don’t know

[rushclub]

what else does an guestbook?

- > store form data into an database
- > get them out to show on the webpage

or am i on the wrong track?

cheers
rush