CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 passing data with variables

Print topic Send  topic

Author Message
Futurama56

Posts: 1
Posted: 12/05/2004, 5:19 PM

I have spent countless hours trying to figure a very basic thing out. Here is the setup.

User enters site, and does a search for a job, a record is returned and the user decides to apply for the job by clicking "Apply Now" which sends them to another form to fill in Name, Address....Etc, but how can I link the Job they click "apply", say the ID, onto the new form they are filling out so that once there application is submitted, a new record is created with a field of "id" to reference the job they just applied for.

Page breakdown

index.php (job description linked to "positions" table in mysql)
apply.php (job application form linked to "application" table in mysql)

This should not be hard to do, but I cannot figure out which variables and howto setup, I have tried using Declare Variable, Retrieve Value for Control...etc, but cannot get the right ones working.

What I need

A breakdown of what "Actions" to use on what pages, and how to pull the data from one into the other, from the ID associated with the job listing to the ID field in the application form that is then added to the application table.

Thanks, I have project deadline coming up FAST >> HOURS and need help.
View profile  Send private message
Lim
Posted: 12/05/2004, 9:18 PM

You need to associate the "Apply Now" link with the id or primary key of the job record. In other words, when you click on the link, a GET parameter is appended to the URL similar to the following example: ".php?job_id=1002".

In the new form, you can either use custom coding to retrieve and set the job_id parameter or you can define a field in the form which retrieves its value from the GET parameter.

Andrew
Posted: 12/06/2004, 2:23 AM

I can get the id into the url on the apply page, but I still cannot pull that value down into the application table.

so I can get

http://www.root.com/jobs/testapply.php?id=1&PHPSESSID=6...a071af3c22f6093

But I cannot
pull id=1 into the application form

I need the code and a very detailed HOWTO for this, total newbie here!
Damian Hupfeld
Posted: 12/06/2004, 3:39 AM

You need to add the job database into the source of the new page grid/form
with the parameter id=id


regards
Damian Hupfeld
http://www.nexthost.com.au/services.php




"Andrew" <Andrew@forum.codecharge> wrote in message
news:541b4333d40149@news.codecharge.com...
>I can get the id into the url on the apply page, but I still cannot pull
>that
> value down into the application table.
>
> so I can get
>
> http://www.root.com/jobs/testapply.php?id=1&PHPSESSID=6...a071af3c22f6093
>
> But I cannot
> pull id=1 into the application form
>
> I need the code and a very detailed HOWTO for this, total newbie here!
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


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.