Find Jobs
Hire Freelancers

PHP/MySQL matrix entry/edit form

$30-250 USD

Completed
Posted over 12 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 1302010

About the project

13 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, could you check pm please?
$80 USD in 3 days
5.0 (40 reviews)
5.4
5.4
13 freelancers are bidding on average $93 USD for this job
User Avatar
Hello Sir, I can do it for you. PHP and logic is my strongest part.
$50 USD in 1 day
5.0 (101 reviews)
6.8
6.8
User Avatar
Hi thank you for posting, expert here
$250 USD in 2 days
5.0 (41 reviews)
6.0
6.0
User Avatar
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 requirement provided by you and based on that we are sharing our approach towards work in PMB Best regards, IntelQ
$200 USD in 2 days
5.0 (8 reviews)
5.0
5.0
User Avatar
Very simple task .I can do immediately
$105 USD in 0 day
5.0 (24 reviews)
4.2
4.2
User Avatar
This is a simple task and i can do this in no time.
$80 USD in 3 days
4.8 (4 reviews)
3.6
3.6
User Avatar
i have done a lot of work with php and mysql, please check pm
$60 USD in 1 day
5.0 (1 review)
2.1
2.1
User Avatar
hello , i am database designer .
$40 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Your project fits my skill set exactly, please check your PM for more info.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, This should be very easy I have done a lot of PHP before. Please check PMB.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Freeland, United States
5.0
5
Member since Nov 8, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.