In Progress

PHP/MySQL matrix entry/edit form

I need a PHP page/script that will manage the relationships between two tables. We have one table that includes vendors (currently has 18 rows) and one that has capabilities (about 60 rows). We want what looks like a spreadsheet with the vendors listed across the top and the skills down the left. Wherever a vendor has a specific capability, a checkbox should be checked. When the user saves the data, a third table should be updated with the values as tuples.

For example, if the vendor "Process Lab" has a VID of 7 and the skill called "Weight Reduction" has an SID of 402, the script should insert/update a record that will include 7 in the VID field and 402 in the SID field. Each record in this third table might have a sequential ID.

The skill IDs will range from 0 to 999. If the SID is divisible by 100 it will be treated as a category rather than a skill and it will not be used in the third table. On screen, the SID 400 would display "Analytical Services", and the details (including 402, Weight Reduction) will then be listed below it.

This table has to be functional, not beautiful, it will not be used by the public. The table rows that are categories need to have a class assigned so they can look different than the other rows, but just enough that it's easy to keep track of where in the table you are editing. Alternate columns should be slightly tinted for the same reason, if you assign the class I can take care of the details.

On the final site, the contents of the third table will be used to display those vendors that offer a specific service or to display which services are offered by a specific vendor. This script is just a visual way of letting the managers easily control what vendors are offering which services.

I'm sure this is a simple task for those who have done it before but I'm having trouble getting started. This contract will be awarded promptly once a capable freelancer has entered an attractive bid.

Skills: MySQL, PHP

See more: mysql entry matrix, mysql php form entry, mysql matrix entry, matrix php mysql, php editing matrix table, php mysql matrix display, php mysql edit matrix, php edit matrix, mysql matrix, php mysql matrix, php mysql edit entry, skills offer freelancer, offer data entry services, vendor freelancer, top skill freelancer, top freelancer skills, table top range, skill categories, simple contract service, services contract form, php form freelancer, offering services freelancer, look php, want editing freelancer, field freelancer

About the Employer:
( 5 reviews ) Freeland, United States

Project ID: #1302010

Awarded to:

hiukim

Hi, could you check pm please?

$80 USD in 3 days
(40 Reviews)
5.4

15 freelancers are bidding on average $93 for this job

nrifriends

Please check your PM.

$150 USD in 4 days
(48 Reviews)
6.9
netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

$100 USD in 1 day
(77 Reviews)
6.6
webn

Hello Sir, I can do it for you. PHP and logic is my strongest part.

$50 USD in 1 day
(91 Reviews)
6.5
diegou

Hi thank you for posting, expert here

$250 USD in 2 days
(36 Reviews)
5.8
opensourceintelq

Dear Sir, We have the qualified team of developers(web & mobile), designers and SEO experts. We aim not to be just one other ONE STOP COMPANY but we aim to be BEST IN OUT ART. We have gone through the requiremen More

$200 USD in 2 days
(3 Reviews)
4.7
stefanache

Hello, Please see PMB. Thanks.

$40 USD in 3 days
(15 Reviews)
4.8
kpremkumarcse

This is a simple task and i can do this in no time.

$80 USD in 3 days
(4 Reviews)
3.8
sujasheena

Very simple task .I can do immediately

$105 USD in 0 days
(14 Reviews)
3.6
giorgioferroli

i have done a lot of work with php and mysql, please check pm

$60 USD in 1 day
(1 Review)
2.1
mahmed0715

hi,i wanna do this.see inbox for details.thanks.

$35 USD in 3 days
(1 Review)
1.9
harbinder2011

hello , i am database designer .

$40 USD in 1 day
(0 Reviews)
0.0
Richieuk

Hi Your project fits my skill set exactly, please check your PM for more info.

$100 USD in 7 days
(0 Reviews)
0.0
MrHumble

Hello, This should be very easy I have done a lot of PHP before. Please check PMB.

$30 USD in 1 day
(0 Reviews)
0.0
theoldfather

I have been coding for 4 years and this sounds like a quick job to me. I'll even throw it in AJAX for you so it is updated on the fly.

$80 USD in 1 day
(0 Reviews)
0.0