Sign up form and then show who signed up

velograph · 2009-02-07 03:19:39

I’ve been using Textpattern for about almost two years now and love it. All of my sites are built with this great CMS.

I’ve been using the zem_contact_reborn plugin for a couple of my sites and it’s been amazing. But now I’m standing on the edge of a whole new problem.

Although I can work with phpMyAdmin to create tables and set up databases I’m fairly new to php/mysql. What I don’t know, I’m usually able to figure out after a couple days searching and good old trial and error. But after three days of trying to figure this out, I’m lost.

What I’m wondering is this:

I’m building a site for an event that people are going to sign up for. When they sign up and submit the form with their info(name, age, city, etc…), I want that info to be saved to the server and then have that info displayed on the page in a table with other people who have already signed up.

I know this is possible. It seems like zem_contact should be able to do this, and maybe I’m just missing something. I’ve also been looking at mem_form and mem_simple_form, but I think I’m just not getting it.

Also, I’m not looking for someone to do the work for me, just looking for a shove in the right direction.

Any help would be greatly appreciated.

colak · 2009-02-07 07:58:51

ZCR does not save in the database but ZCR with Postmaster does. Maybe one method is to Install Postmaster and create your form using its tags. Once the information is in the database, I’m sure somebody with php/mysql knowledge will explain how you can parse it in the front end.

jakob · 2009-02-07 08:13:26

Colak, thanks for the info about Postmaster, which I’ve never tried to date. Does it save more than name and email? According to the docs, it also has a list view which might suffice for simple needs.

Velograph, you could also use mem_form / mem_moderation to save to a txp article (via moderation), then output those articles.
If you want a dedicated table in the database, you need to make this in your database manually, then you can use mem_simple_form to create a form that saves data to a custom table or to a txp_table, and use smd_query to retrieve the data and output it in tabular form, as address labels/nameplate badges or whatever.

Last edited by jakob (2009-02-07 09:36:44)

colak · 2009-02-07 08:48:06

Hi Jakob, the list view is admin side only… Thinking about it again, Postmaster does not accept duplicate emails which might be a problem for velograph’s needs especially if there are a number of events over time. Your suggestion for the mem plugins will most probably be more appropriate.

velograph · 2009-02-07 17:06:59

Colak and Jakob,

Thanks for the ideas. Using mem_form to store the info makes sense, as does using smd_query to pull it and post it on the page.

I’m going to work on these and I’ll get back on how it worked.

Thanks again

jakob · 2009-02-07 17:22:54

I’m going to work on these and I’ll get back on how it worked.

Velograph, please do! I’d been meaning to do this myself for a conference site, so I’d be interested in your results. I also needed a way of allowing people to pay with paypal and logging paid status, so if you happen to tackle that too, that would be even better :-)

In the end, the client chose another convoluted email-based method that I didn’t implement. I had suggested they use wufoo.com for registration and payment, which does all the above including providing a back-end for editing entries and tabular listing incl. excel-export but at a fee.

velograph · 2009-02-07 17:27:45

Actually, that’s exactly what I’m tackling. We’re going to allow people to sign up and pay immediately, through paypal, and also sign up and pay when they arrive. I’m thinking that I can have two submit buttons that each go their own way, but submit their info to the database which can be listed out.

Does this sound possible?

velograph · 2009-02-10 13:34:41

So it would seem, according to Manfre the plugins author, that mem_simple_form doesn’t support two buttons going their own ways at this time. He suggested using javascript to change the form’s action query before it submits.

I’m going to tackle that now.

Aside from that, mem_simple and smd_query work great together as a sign up form with a shown list of who’s attending. Thanks for the help.

Textpattern CMS

Textpattern CMS support forum

#1 2009-02-07 03:19:39

Sign up form and then show who signed up

#2 2009-02-07 07:58:51

Re: Sign up form and then show who signed up

#3 2009-02-07 08:13:26

Re: Sign up form and then show who signed up

#4 2009-02-07 08:48:06

Re: Sign up form and then show who signed up

#5 2009-02-07 17:06:59

Re: Sign up form and then show who signed up

#6 2009-02-07 17:22:54

Re: Sign up form and then show who signed up

#7 2009-02-07 17:27:45

Re: Sign up form and then show who signed up

#8 2009-02-10 13:34:41

Re: Sign up form and then show who signed up

Board footer