Hello everyone,
I apologize if my question makes me look like a dummy, but I am fairly new to the PHP world. I am working on a project, and I am at the point where DataMapper “skills” are required, and I am struggling a little bit. Hence, I would appreciate if any of you would help me solve this issue.
The web site I am working on is:
http://cber.cba.ua.edu/PHP2/econimpact2.php
Here are the name/id for each object on the web page:
Please select a county : => ‘county’
Please select an industry => ‘industry’
Operating employment => ‘jobs’
Operating wages => ‘wages’
I have also set up a database that contains the following tables:
Table name: counties; columns: id, name
Table name: industries; columns: id, name
Table name: counties industries; columns:
county_id, industry_id, FDoutput, DEearnings, DEemployment, FDearnings, FDvalueadded.
So if for example you selected Chilton for a county, and Utilities for an industry, the “identity’ of the selection on the database would be:
county_id = 11; industry_id = 6; + the other the values for FDoutput, FDearnings …..
As you can see from the web page, 4 UNIQUE calculations need to be made that depend on the amount/numbers that visitor put in Operating employment and Operating wages fields.
This is where I am stuck and am not able to go any further. I am not sure what exact code I should write to pull the data from the database, based on the county and industry selection. Once I get those numbers saved on 4 separate variables, then I have no problem performing the necessary calculations.
I would REALLY appreciate if somebody could help me with this!
Sincerely,
Ben
PHP - Please help me with a DataMapper related project!
Moderator: General Moderators