Completed

Add 40 new fields to table and 4 php forms

This project was successfully completed by halezabux for $40 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
8
Project Description

I need 40 new fields added to a database table, two php forms edited and two php forms created.

In tbl_quotes there are currently the following fields:

id

title

first_name

last_name

email

mobile

email_cc

email_bcc

date_day

date_date

date_month

date_year

location

access

package

start_time_hour

start_time_minute

start_time_time

finish_time_hour

finish_time_minute

finish_time_time

setup_time

additional_item

promotional_code

total_quote

follow_up

additional_qty

date_added

I would like to make the following changes:

date_day, date_date, date_month, date_year should become event_date [date]

start_time_hour, start_time_minute, start_time_time should become start_time [time]

finish_time_hour, finish_time_minute, finish_time_time should become finish_time [time]

I would like the following fields to be added:

company_name [varchar(255)]

advert_source [varchar(255)]

address_line_1 [varchar(255)]

address_line_2 [varchar(255)]

address_town [varchar(255)]

address_county [varchar(255)]

address_postcode [varchar(255)]

telephone [varchar(255)]

leave_base_time [time]

arrive_venue_time [time]

leave_venue_time [time]

arrive_base_time [time]

event_occasion [varchar(255)]

venue_address_1 [varchar(255)]

venue_address_2 [varchar(255)]

venue_town [varchar(255)]

venue_county [varchar(255)]

venue_postcode [varchar(255)]

number_of_guests [varchar(255)]

subject_1 [varchar(255)]

subject_2 [varchar(255)]

subject_3 [varchar(255)]

subject_4 [text]

payment_1_date [date]

payment_1_method [varchar(255)]

payment_1_amount [double]

payment_2_date [date]

payment_2_method [varchar(255)]

payment_2_amount [double]

payment_3_date [date]

payment_3_method [varchar(255)]

payment_3_amount [double]

customer_notes [text]

admin_notes [text]

event_status [varchar(255)]

dj_name [varchar(255)]

dj_address [varchar(255)]

dj_fee [varchar(255)]

submitted_feedback [text]

publish_feedback [varchar(255)]

You will need to edit the following files:

[url removed, login to view]

admin/[url removed, login to view]

Your will need to create the following files:

admin/[url removed, login to view] to view all the fields in the table

admin/[url removed, login to view] to edit all the fields in the table (no quote calculation required)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online