PHP/MySQL Database - Matching CDL drivers to open positions

What we need: A MySQL database with a PHP interface to match CDL drivers with local jobs within a predetermined radius of their zip code.

Driver interface fields

- Drive Name

- Distance willing to drive

- City

- State

- Driver Zip Code

- Zip code Array (need to be able to paste in a comma delimited string of zip codes. If zip codes could be automatically populated based on the Drive Zip Code and Distance willing to drive, it's be great, but if not, the Zip Code Array can be obtained through [url removed, login to view])

- Excluded Carriers

- Notes

Job Interface Fields

- Zip Code of Job

- Carrier

- Job Number

- Estimated Salary

- Description

There should be a Dashboard that shows which Drivers match what Jobs. Basically, the tool will need to check the Driver Zip Code Array and if one of the zip codes matches a Zip Code of a Job, it will display their Driver information along with the details of the job on the Dashboard. There needs to be the ability to add & remove jobs and drivers from the database. If a Carrier is listed in the Driver's "Excluded Carriers", it should not show up in the potential matches for that driver. Also, if a Driver has turned a position down, it needs to be marked off so that it doesn't show up again for that driver as a potential match.

There are 4 carriers that cannot be input into the Job Interface, they have to be manually searched on the carrier's website. There will need to be a place in the Driver Interface to input the last date each of the 4 carriers was searched for each driver.

I have attached an example Excel spreadsheet that does everything needed. The full file is too large to function effectively, hence why we want to switch to a PHP/MySQL database.

If it helps, here are the locations in the example Excel spreadsheet

Formula location: A2


Formula location: S2


Habilidades: Codeigniter, HTML, MySQL, PHP, SQL

Veja mais: employees information system php mysql database, sending flash data php mysql database flash cs3, php mysql database creator, php mysql database query script, php mysql database webpage examples, post ajax php mysql database, php mysql database load script, parse xml php mysql database, upload video php mysql database, php mysql database remote, admin approval using php mysql database, business directory listings php mysql database, php mysql database populate form selected, php mysql database manipulation, simple php mysql database

Acerca do Empregador:
( 2 comentários ) Wapwallopen, United States

ID do Projeto: #15345007

Concedido a:


I have 100% job completion rate:) I have above 5yr of experience in Web Development & Designing, Web application development. Relevant Skills and Experience My strengths are in PHP, Codeigniter, Laravel, Wordpress, M Mais

$260 USD em 10 dias
(15 Comentários)

15 freelancers estão ofertando em média $460 para esse trabalho


Hello, and thanks for the opportunity to bid on your project. Relevant Skills and Experience Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expe Mais

$526 USD in 10 dias
(206 Comentários)

Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 8+ years of experience and I'm here for you! My Mais

$777 USD in 10 dias
(121 Comentários)

Hello..I am expert working on Codeignitor and i can do your work. Relevant Skills and Experience I have in-depth knowledge of php, mysql, javascript , jquery, paypal integrations, API's, css, html, html5, wordpress. I Mais

$500 USD in 10 dias
(285 Comentários)

Web developer, 7+ yrs of experience in development and designing Relevant Skills and Experience I am good in PHP*(Laravel,, C#, YII, CakePHP, Codeigniter), HTML*,CSS, MySQL, Ms-SQL,Twitter BootStrap, Mongo DB, Mais

$400 USD in 10 dias
(93 Comentários)
$444 USD in 6 dias
(52 Comentários)

Hi Thanks for your posting. I have many experiences in php, mysql, web developing, so if you hire me, I can finish this project perfectly. **** I checked the excel file you sent. I have many experiences in mysql, Mais

$500 USD in 10 dias
(40 Comentários)

Hello? Relevant Skills and Experience How are you? I am good in php and My SQL Proposed Milestones $555 USD - 1

$555 USD in 10 dias
(23 Comentários)

HTML, MySQL, PHP, SQL 7 Yrs of experience Relevant Skills and Experience PHP,HTML,Website design,Shopify,Magento,Drupal, open cart,E-Commerce, Wordpress EXPERIENCE IN ALL THE FRAMEWORKS. Proposed Milestones $500 USD Mais

$500 USD in 10 dias
(57 Comentários)

Dear Hiring Manager, I had a look at your given job post and came to know that you are looking for Website developer to build unique website as per your requirement. Relevant Skills and Experience [login to view URL] Mais

$250 USD in 10 dias
(47 Comentários)

Hey, I have checked job description and quite interested in working with you. I have core expertise in Codeigniter, HTML, MySQL, PHP, SQL Relevant Skills and Experience I have 6 years of exp. Proposed Milestones $5 Mais

$555 USD in 10 dias
(10 Comentários)

Hello, Having read your job description, I feel to be a good fit for this job, as I have hands on experience working on the PHP, Mysql, HTML, JQuery Frameworks, as well as Major CMS's like Joomla, WordPress and Mag Mais

$555 USD in 10 dias
(13 Comentários)

Hello, I am very interested in the project and you would like to apply to it. I'm a web developer with 7 years experience in PHP, MYSQL, CSS3, HTML5 and deep knowledge Wordpress, WP pluggin, development issues Mais

$250 USD in 10 dias
(6 Comentários)
$277 USD in 10 dias
(3 Comentários)

Hi, I have reviewed your requirement and I can do this job as per your requirement. I have a advanced skills in WORDPRESS , Laravel, Angular JS ,PHP, Codeigniter,MYSQL, Joomla,JavaScript, API Integration,Plugins , Mais

$555 USD in 10 dias
(1 Comentário)