Page 1 of 1

PHP - Please help me with a DataMapper related project!

Posted: Thu Oct 18, 2012 7:24 pm
by benbama
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