How to go about doing this?

I'm not quite sure where I needed to post this, but my feeling is that I will need to use data assist for it.

So what I'm looking to do:

When a visitor decides to complete their project with me I send them a registration form (rather than just have it on my site for anyone to fill in at random) for them to fill out. This would include their details as in name, company, phone, email and of course username and password. When that is done I want a page to show up stating that everything went well and they should expect an email with further details on accessing the site.

Here is where I think it gets complicated. Once they register, I want a page created (from a template that I create) that's personalized with their information. The contents of the page will be standard for all clients but each individual client should be able to access only their personalized page securely.

- Name anywhere that it's needed.
- Access to their admin section to change password.
- Payment Gateway
- Web IM
- Link to Development Site or Layout Draft

These are some of the things I will have on the page.

I have all sections of the site almost complete. Currently working on an issue with the WA CSS Form Builder to complete my contact page.

My question is which WA products do I use and how would I go about it? Or would I have to manually enter every client in the database and create the page manually for each?

Any guidance on this would be great.

jc

DataAssist could be the extension that you want to use, but i recommend looking into using Security Assist, because you are creating a registration form. And once the user is registered you would use Universal Email to send a confirmation email.

This link contain a few documentation that could help you get started:

securityassist/

Once you have your registration working, you could then start on the profile page where you could customize the page to show information for each user.

But before you start on any thing, make sure you have your database set up already and ready to go.

Let me know if you still have any questions.

I think your last statement told me everything.

Here's the temporary work plan:

1. Create database for registration form and any other dynamic data related to each client and business.
-Name -email -login info
-any other dynamic data needed in profile page

2. Create registration form using CSS Form Builder

3. Create profile page using Data Assist getting specific data for the page.

4. Create admin section for password and profile managing.

5. Create login page.

6. Create my admin page

7. Apply Security Assist, Universal Email where needed.
-form -client admin -profile page -my admin page

That's the general idea. I'm just beginning with dynamic sites (basically giving mine the functionality to get a jumpstart- I can always fix issues without clients and deadlines looming). I'm just looking into your database starter kit and that's helping a bit.

So thanks for your response. I was sure I needed to use several extensions for this.

jc

I just want to let you know that Security Assist is able to generate the Login and Registration pages. But if you wanted to style these forms i would go with Form Builder. It should be the same process either way.

Let me know if you have any other questions.

So, other than an error I'm getting right now with the registration form which is in another thread already, I have my registration form and new project form already set up. I also have the database schema created with the relations noted in the attached image.

The purpose of the new project form is for my clients to be able to start a new project. I have it set up on registration and it will be accessed via their client page. Where I'm getting the error at this early stage is when I press next on the form. It tells me:

"Cannot add or update a child row: a foreign key constraint fails (`zonapromo/Projects`, CONSTRAINT `fk_Projects_Clients1` FOREIGN KEY (`Clients_IDclient`) REFERENCES `Clients` (`IDclient`) ON DELETE NO ACTION ON UPDATE NO ACTION)"

Which I interpret to be the unavailability of a client id which should come from the client table and passed on to the projects table as shown in the image.

I'm just not sure how I would go about this. I'm just starting to play around with database and am not sure if I need a session behavior that would keep the client id at hand and then pass it on as we move along, as well as the project id and any other information that needs to be passed along from table to table.

Any suggestions, pointers or tutorials I should read?

jc

All forms seem to be working correctly right now with the register form creating my client record. The way my tables are setup, my projects records cannot exist without having a clientid attached to it.

The way the forms work is that first the client registers and is taken to the projects page (this works like a charm). The project form seems to work fine except that it can't create the record because it doesn't have the client id for it. It gives me this error:

"Cannot add or update a child row: a foreign key constraint fails (`zonapromo/Projects`, CONSTRAINT `fk_Projects_Clients1` FOREIGN KEY (`Clients_IDclient`) REFERENCES `Clients` (`IDclient`) ON DELETE NO ACTION ON UPDATE NO ACTION)"

I changed the foreign key setting for the project table hoping it would help and get this:

"Cannot add or update a child row: a foreign key constraint fails (`zonapromo/Projects`, CONSTRAINT `fk_Projects_Clients1` FOREIGN KEY (`Clients_IDclient`) REFERENCES `Clients` (`IDclient`) ON DELETE CASCADE ON UPDATE CASCADE)"

I don't know anything about database work and am really just getting into it. I'm wondering if a php session would allow me to retrieve the client id from the database and have a field in the project form retrieve the data from the session. In turn, the project from would send the clientid into the project table. I have been looking into the WA Cookies Extension and think it can be done, I just can't find how to retrieve the data from the database into the session variable.

Any help would be great.

jc

Sorry for rambling about this...I keep trying new things and feel I'm getting there.

I created a session variable in my register form named email (not sure if thats the name it should have or the actual name of the record column). And in turn I set session value in server behaviors where trigger is "Button: register_submit pressed", session name is email and value is the email address field of the form.

I then created a recordset n the project form where "columns" calls only the clientid from the client table. I then filter ClientEmail from client table = to Session Variable and requesting it shows IDclient from client table. When I test the recordset and enter a test value of a record already in the table it gives me a positive response.

When I test the register form it works as it should but clientId is not transferred to the field I have in the project form requesting it. Don't know if the session is not taking (maybe because I'm testing on my local virtual server) or I'm simply way off track in what I'm trying to do here.

Again. Any help would be great. I don't know if I'm closer or further away.

jc

No takers on this one?

jc

:eek: Been Searching through forum posts to see if I find something similar to what i want. :eek:

I think I found it. I will more than likely try all these, but if any one can point me in the right direction.

From this post, go to number 4.

From this post, all.

And from this knowledge-base post, all.

I'm leaning towards trying the knowledge-base first and going from there. I'm struggling on this one here.

What do you all think?

jc