Dynamic web directory

Closed

I have an online directory of insurance agents. I have been collecting the agent data through a web form that submits the data by email. Once I receive the email, I have been publishing the directory manually in HTML. That was OK for the first few records, but the directory has grown to several hundred names and now I need to automate the process. Here's the current Directory URL: [url removed, login to view]

I am in a rush, so I want to build this in two parts:

PART I - QUICK FAST PUBLISH

1) Create MySql database and import records (all data in an Excel spreadsheet - see attached sample)

2) Create PHP script to dynamically create Directory from MySqul database (see include file for formatting)

MySqul DATABASE:

- First Name

- Last Name

- Agency

- Address

- City

- State

- Zipcode

- Phone

- Email

- CLTC (YES/NO)

Directory Listing

- <FirstName> <LastName>

- <Agency> (NOTE: If none, then no agency line)

- <Address>, <City>, <State>, <Zipcode>

- <Phone>

- <Email>

- NOTE: IF CLTC=YES, listing needs to be BOLD and RED per attached format sample.

- NOTE: Listings will be sorted by: State, 2) City, 3) Last Name)

- NOTE: I also need a simple way to ADD, EDIT, or DELETE the records.

There is a lot more I want to do with this, but this is the most important and URGENT.

For someone who knows PHP, this should be a SIMPLE and fast project.

Skills: MySQL, PHP

See more: www dynamic agency com, spreadsheet web form, mysql city state database, html form to spreadsheet, alliance data, publish excel to web, web agent, web agency, insurance agent email, import listings, html publishing, excel rush, email collecting, directory listing, php dynamic email form, excel php dynamic, simple address database excel, php import excel file mysql, zipcode city, agency phone, project html insurance, url import data, web parts project, create directory online php, mysql web spreadsheet

Project ID: #1446950

22 freelancers are bidding on average $328 for this job

codeguru786

Hi, we have read all the requirements and we are very confident to do this project from start till end. We definitely have some questions when we discuss project with u. We shall finish this project in timely manner a More

$499 USD in 10 days
(254 Reviews)
8.4
flashzeus

Hi! Please se PMB. Denis. With best regards.

$250 USD in 6 days
(148 Reviews)
7.4
codersam

We are a team of dedicated, serious and highly experienced developers, 24x7 available. After reviewing your project requirement we are highly interested in your project. Please check your Private Message for more detai More

$299 USD in 7 days
(147 Reviews)
7.4
epark

=============please check pm=============

$550 USD in 14 days
(170 Reviews)
7.1
glowsol

Greetings, have done many directory based jobs. For details please visit pmb. Thanks

$500 USD in 10 days
(57 Reviews)
6.8
khanhhuyna

I'm happy to start this right now and will get this done in 4 days. Thanks.

$250 USD in 4 days
(86 Reviews)
6.6
ansi2

Ready to start! Proposal details will follow. Thanks, 2ansi

$250 USD in 3 days
(88 Reviews)
6.3
tonykim100

Hello sir! Please check PMB.

$300 USD in 7 days
(115 Reviews)
6.2
AdamsK

Ready for service sir, thanks.

$250 USD in 3 days
(75 Reviews)
5.6
rfedorov

Hello, i'd like to work with you on this project! Please check kindly the private message for my proposals. Regards, Roman.

$300 USD in 3 days
(26 Reviews)
5.5
realestateweb

I'm looking forward to build a Real Estate agents directory for a website of mine, so maybe we can kill two birds with one stone. Your website seems offline to me, will check later. Note: this bid is for PART I and als More

$250 USD in 2 days
(20 Reviews)
5.2
sapewady

I can do it. let's do the job.

$250 USD in 2 days
(5 Reviews)
4.6
freelancerbuzzo

Ready to start right now.

$250 USD in 3 days
(12 Reviews)
4.4
akjajoo123

experience in php so, your first part can be done in 4 days or less time from myside.

$250 USD in 4 days
(11 Reviews)
4.2
yourspcits

Let's start the work

$400 USD in 15 days
(6 Reviews)
4.1
manionweb

sir, we are interested to do your project. please check rivate message. Thanks

$550 USD in 15 days
(3 Reviews)
1.5
kemplue

hello sir, please see your inbox.

$300 USD in 3 days
(0 Reviews)
0.0
lingeshram

Hi, we have more than 7 year exp in this field. We have excellent ajax control panel for web application. Also we implement your requirement with excellent admin panel where you can analysis every thing in graph also. More

$350 USD in 10 days
(0 Reviews)
0.0
ccu430

We are seriously interested in this job. Please check the pm.

$250 USD in 4 days
(1 Review)
0.0
kawsarahammed

please,check pm.you can belief me.

$350 USD in 10 days
(0 Reviews)
0.0