Page 1 of 2

Save formdata into database

Posted: Wed 2. Jan 2008, 08:30
by 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

Re: Save formdata into database

Posted: Wed 2. Jan 2008, 10:05
by rushclub
as far as i know that must be possible with the current snapshot.

cheers
rush

Re: Save formdata into database

Posted: Wed 2. Jan 2008, 23:43
by 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?

Re: Save formdata into database

Posted: Thu 3. Jan 2008, 00:22
by pepe
Let's say it SHORT:

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

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

Re: Save formdata into database

Posted: Thu 3. Jan 2008, 00:23
by flip-flop
Please have a look: - [ Snapshot ]

Knut

Re: Save formdata into database

Posted: Thu 3. Jan 2008, 00:25
by pepe
Moin Knut... :D :D :D

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

Re: Save formdata into database

Posted: Thu 3. Jan 2008, 00:38
by 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.

Re: Save formdata into database

Posted: Fri 4. Jan 2008, 00:57
by 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

Re: Save formdata into database

Posted: Fri 4. Jan 2008, 08:13
by rushclub
if you look into yout database you will see the table: phpwcms_formresult.
thats it. i think.

rush

Re: Save formdata into database

Posted: Fri 4. Jan 2008, 08:21
by 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.

Re: Save formdata into database

Posted: Fri 4. Jan 2008, 08:44
by 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.

Re: Save formdata into database

Posted: Fri 4. Jan 2008, 09:18
by 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

Re: Save formdata into database

Posted: Tue 15. Jan 2008, 07:25
by rushclub
of course you will try the contentpart guestbook.
that suits your needs more - i think.

rush

Re: Save formdata into database

Posted: Wed 16. Jan 2008, 00:17
by 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

Re: Save formdata into database

Posted: Fri 18. Jan 2008, 07:02
by 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