CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Multipage registration with several tables and report

Print topic Send  topic

Author Message
Benign

Posts: 6
Posted: 07/09/2006, 10:38 AM

Hi:
I am working on a multi step (multipage)registration form that enters the data into several Database tables that have relationships(for example page one data get saved in tableA of database andand page two goes to TableB of database and so on). The registaration form has some dpendent drop down fields[it is very important that I can dpendendent drop downs for example if the user chooses a state he/she can choose from just the cites of that state from the next form). After registartion finished I want the admin to be able to make reports with filtering users and their info. Surely this filtering and making report will look up into several tables of database because of the data is in several tables.
I wonder if making such complicated registration/report application with search engine is possible/easy to develope with CCS3.0?
Please let me know if there is any easy way, tutorial or tips for making this with CCS3.0 and if it is possible.
Thanks
Benign
View profile  Send private message
peterr


Posts: 5971
Posted: 07/09/2006, 11:18 AM

This is not a complicated application and should be quite easy to develop. (this forum created with CCS is much more complicated)
If you don't have experience with CCS then start with the Multi-step Registration example (also at http://examples.codecharge.com/ExamplePack/MultiStepReg...trationGrid.php)
Dependent listboxes are not directly supported, but there is an example at http://examples.codecharge.com/CCSExamplePack2/Dependen...dentListBox.php , and an article at http://support.yessoftware.com/kb_article.asp?article_id=61 , and various tips here on the forums. And if your state and city are on 2 different pages then this is very simple and you can just use standard CCS features.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
Benign

Posts: 6
Posted: 07/09/2006, 7:56 PM

Hi:
Thanks for the reply.
I have seen the Multi step registration form example in your site but it insert data into one table while I need it to do it in several tables with relationship which setting this part is my problem.
The Dependent drop down tables example is exactly what I need.
Can you help me about the seqarch/filtering/report of the registered useres?Is there any example?
Thanks
Benign
View profile  Send private message
peterr


Posts: 5971
Posted: 07/09/2006, 8:36 PM

If you want to update multiple tables from one form then you may need to execute custom queries as shown at http://docs.codecharge.com/studio3/html/ProgrammingTech...eCustomSQL.html
But if you want each step (page) to update a different table then just set each form to insert data into a different table.

Search and filtering is probably the simplest and you can see it everywhere you look at - almost every sample application shows how to do this. Just open any example that includes a grid, or go through any tutorial included in CCS, or use the "Search" option within the wizards/builders (for example Report Builder), or use the Search builder by itself. Most grids display filtered data and reports are no different.
Here are some sample docs:
http://docs.codecharge.com/studio3/html/QuickStart/Crea...archParams.html
http://docs.codecharge.com/studio3/html/QuickStart/Crea...tWhereProp.html
http://docs.codecharge.com/studio3/html/UserGuide/Build...rchBuilder.html
http://docs.codecharge.com/studio3/html/UserGuide/Build...ortBuilder.html
Or you can search the Help for "search".
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.