Save formdata into database

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Save formdata into database

Post by Stim » Wed 2. Jan 2008, 08:30

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
)-= 1.3.0 user =-(

rushclub
Posts: 915
Joined: Tue 17. Feb 2004, 18:52

Re: Save formdata into database

Post by rushclub » Wed 2. Jan 2008, 10:05

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

cheers
rush
3 (!) Jahre warten reichen mir. Ich bin erst mal weg.

Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Re: Save formdata into database

Post by Stim » Wed 2. Jan 2008, 23:43

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?
)-= 1.3.0 user =-(

pepe
Posts: 3954
Joined: Mon 19. Jan 2004, 13:46

Re: Save formdata into database

Post by pepe » Thu 3. Jan 2008, 00:22

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/

User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Re: Save formdata into database

Post by flip-flop » Thu 3. Jan 2008, 00:23

Please have a look: - [ Snapshot ]

Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )

pepe
Posts: 3954
Joined: Mon 19. Jan 2004, 13:46

Re: Save formdata into database

Post by pepe » Thu 3. Jan 2008, 00:25

Moin Knut... :D :D :D

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

Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Re: Save formdata into database

Post by Stim » Thu 3. Jan 2008, 00:38

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.
)-= 1.3.0 user =-(

Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Re: Save formdata into database

Post by Stim » Fri 4. Jan 2008, 00:57

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
)-= 1.3.0 user =-(

rushclub
Posts: 915
Joined: Tue 17. Feb 2004, 18:52

Re: Save formdata into database

Post by rushclub » Fri 4. Jan 2008, 08:13

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

rush
3 (!) Jahre warten reichen mir. Ich bin erst mal weg.

Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Re: Save formdata into database

Post by Stim » Fri 4. Jan 2008, 08:21

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.
Last edited by Stim on Fri 4. Jan 2008, 08:44, edited 1 time in total.
)-= 1.3.0 user =-(

Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Re: Save formdata into database

Post by Stim » Fri 4. Jan 2008, 08:44

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.
)-= 1.3.0 user =-(

Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Re: Save formdata into database

Post by Stim » Fri 4. Jan 2008, 09:18

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
)-= 1.3.0 user =-(

rushclub
Posts: 915
Joined: Tue 17. Feb 2004, 18:52

Re: Save formdata into database

Post by rushclub » Tue 15. Jan 2008, 07:25

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

rush
3 (!) Jahre warten reichen mir. Ich bin erst mal weg.

Stim
Posts: 587
Joined: Mon 6. Jun 2005, 13:13

Re: Save formdata into database

Post by Stim » Wed 16. Jan 2008, 00:17

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
)-= 1.3.0 user =-(

rushclub
Posts: 915
Joined: Tue 17. Feb 2004, 18:52

Re: Save formdata into database

Post by rushclub » Fri 18. Jan 2008, 07:02

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
3 (!) Jahre warten reichen mir. Ich bin erst mal weg.

Post Reply