website with sql database


Website details: New Site

The customer requires a website that will automate everything they currently do manually.

They want to go paperless and do everything on line.

This is how things are currently done.

An instruction comes into the secretary from the estate agents (office) with the site details, post code and install date and job type

The job gets filled out onto the sign erectors job sheet for the day Address/post code/ install date/

Sign erector does job and ticks off sheets and sheet comes back in at end of day to be entered in by secretary.

At the end on each week the completed jobs go to the accountant who signs them off and invoices them.

An sql relationship database is needed. (we also need to use this with other businesses)


The front page needs to have a login and registration area. This will be for the estate agents to log their own details (and the details of their office, some estate agent have more than one office) If there is more than one office a drop down menu will be shown and the office address can be populated for that estate agent contact.

The registration will also be for sign erectors and customer office staff.

Types of access after log in

Estate Agent

Once logged in the estate agent will be a presented with a dash board.

This will show the following –

Log a job Job Type, Job Details

How many boards are out (by postcode) (viewed on maps or similar)

Job status (Job Type) or job completed

Outstanding invoices to be paid



Total number of boards out

Boards by Estate agent

Boards by Sign erector

Boards by post code

Boards by date range (from to dates)

Revenue by Estate Agent

Revenue by Sign Erector

Revenue by Post code

Revenue by date range (from to dates)

Job status by Estate agent

Job status by Sign erector

Job status by post code

Job status by date range (from to dates)

Jobs to be invoiced by Estate agent

Jobs to be invoiced by Sign Erector

Jobs to be invoiced by post code

Jobs to be invoiced by date range (from to dates)

Outstanding invoices by Estate agent

Outstanding invoices by Sign Erector

Outstanding invoices by post code

Outstanding invoices by date range (from to dates)

Job lists sent to account to be invoiced

By day

By Week

By Month

By Year

(all with graphs for easy viewing)


Sign Erectors


Incoming Jobs

Job status

Completed jobs

Tables required

1. Office Staff

a. Name

b. Email address

c. Phone number

2. Sign Erectors

a. Name

b. Phone number

c. Email address

d. Van registration

e. Area covered (by post codes)

3. Estate Agents

a. Company name

b. Contact name (see 4)

c. Contact number(see 4)

d. Contact email address

e. Office details(see 4)

4. Estate Agent Offices ( some estate agents have more than one office)

a. Company name

b. Address

c. Contact name

d. Contact number

e. Email address

5. Job Type

a. Initial Visit (included in initial price)

b. Sold Slip (included in initial price)

c. Removal of Board (included in initial price)

d. Re-erection of board (extra cost)

e. Extra Visits (extra cost)

6. Job Details

a. Site

b. Address

c. Post code

d. Installation date

e. Erection/sold slip/Removal/re erect/extra visit date

Skills: HTML, MySQL, PHP, SQL, Website Design

See more: how to create a database driven website, how to connect html to sql database, how to create a website with a database, database website templates, database driven website tutorial, how to connect website to sql database, database driven website template, database website examples, create website sql database, website sql database, changes existing asp net website sql database, joomla website sql database, clone website sql database, website aspnet sql database net sql, sql database schema website, viewing sql database php frontend, search sql database joomla website, update website live sports scores sql database, moving website sql database, generate static website sql database

About the Employer:
( 7 reviews ) manchester, United Kingdom

Project ID: #16598914

58 freelancers are bidding on average £1516 for this job


Hi, Ongoing through the complete detail and reference your requirement is to develop a real estate website through which user can post their house for rent/sell. There will be agents module also. Users will be able More

£3000 GBP in 45 days
(444 Reviews)

Dear Employer, Thanks for your details description. We have reviewed in details and am very pleased to tell you that we are very much interested in your project and this is highly doable at our end. But before p More

£1500 GBP in 30 days
(678 Reviews)

Hello I'm interesting your project very well I'm a Good expert of PHP, AngularJS, Java, Mysql, HTML, CSS, Math, Algorithm. I m quite well experienced in these jobs. Let's go ahead with me I want to service for y More

£1600 GBP in 15 days
(692 Reviews)

Greetings, I am very thankful for this opportunity. It’s really exciting that we have similar kind of expertise and work experience: [login to view URL] [login to view URL] [login to view URL] http://w More

£3402 GBP in 30 days
(85 Reviews)

Hi, We have a team of designer and developer who will work as per your requirement and finish in your deadline. We are TOP rated in the Freelancer and believe in the quality of work. We are an expert in Custom W More

£1473 GBP in 20 days
(540 Reviews)

Hello! Can start the work right now! Have great experience on CMS, Frameworks, Mockup Designs, Template Customizations, PHP/PHP5, Sql databases, Software Architecture, JavaScript, jQuery, HTML5, CSS, Responsive. More

£1340 GBP in 26 days
(228 Reviews)

Hi There, Thanks for your valuable time. :-) Please check below points : 1. Brief Website details: New Site The customer requires a website that will automate everything they currently do manually. Th More

£1390 GBP in 22 days
(795 Reviews)

Hello, Greetings from Votive Technologies!! We have gone through your requirement and as per my understanding, you want to build a website as per requirement. We have already developed that kind of similar featur More

£999 GBP in 20 days
(508 Reviews)

Hi, We have expertise in the different business domain. We will surely love to do your assigned work as per project demands. We had successfully completed many projects with various price ranges as per client’s need More

£1000 GBP in 20 days
(238 Reviews)

Hi There, Greetings!! * As you required, We can surely help you to build a responsive & elegant website for estate agents + Staff members + Sign Erectors. * We are a team of creative designers & highly experienced More

£2000 GBP in 30 days
(222 Reviews)

Dear Sir, Hope you are doing well. After carefully reviewing the requirements of the job description, I feel that we are very much suitable for the job. We can start working now . please give a chance to work for More

£1444 GBP in 21 days
(326 Reviews)

Hello Sir! With the reference of your description I would like to inform you that we are the most eligible freelancer here with whom you can discuss this project. After our discussion I am sure you will love to More

£1666 GBP in 30 days
(208 Reviews)

Hi there, We are a team with expertise in Backend / Frontend Development with PHP, MySQL and other Web Technologies. Ping me so that I can send you the backend(s) we have worked on. Our offer includes free bug More

£800 GBP in 20 days
(225 Reviews)

Hello, Having gone through the requirements, your detailed description was very useful to give me an overall idea of what you're looking to accomplish, yet I have lots of questions pertaining the detailed implementa More

£12500 GBP in 60 days
(91 Reviews)

Hi, I am Anna with more than 6 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, More

£1250 GBP in 20 days
(149 Reviews)

//** READY TO START RIGHT AWAY **// With the reference of your description I would like to inform you that we are the most eligible freelancer here with whom you can discuss this project. After our discussion I am s More

£1000 GBP in 25 days
(349 Reviews)

Hello, Greetings! I will deliver you a professionally designed, Well Coded (for better indexing in search engine), & efficient (quick loading & SEO optimized) website. I'll automate the process following all the gui More

£1111 GBP in 20 days
(94 Reviews)

Hello, I have read the project description an understood the functionality and flow of the website. I can certainly do my best to achieve the best outcome and fulfill your project requirements. I would like to be More

£2700 GBP in 30 days
(105 Reviews)

Hello! I have got acquainted with your website with sql database project requirements and have a proposal as well as some questions that we should discuss. My name is Alex. I am a representative of web agency Pix More

£1500 GBP in 30 days
(46 Reviews)

Hello twenty10, Reviewed your project description thoroughly. Yes, we can help you with this project. We have very good experience in website designing and development using WordPress, PHP, CodeIgniter, CakePHP, La More

£1250 GBP in 33 days
(75 Reviews)