close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How to go about doing this?

Thread began 11/09/2009 7:52 pm by jc1cell390254 | Last modified 11/18/2009 6:06 pm by jc1cell390254 | 1844 views | 8 replies |

jc1cell390254

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

Sign in to reply to this post

Dani Chankhour

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.

Sign in to reply to this post

jc1cell390254

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

Sign in to reply to this post

Dani Chankhour

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.

Sign in to reply to this post

jc1cell390254

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

Sign in to reply to this post

jc1cell390254

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

Sign in to reply to this post

jc1cell390254

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

Sign in to reply to this post

jc1cell390254

No takers on this one?

jc

Sign in to reply to this post

jc1cell390254

Holy Cow...my eyes!!!!

: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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...