Closed

Add 40 new fields to table and 4 php forms

This project was awarded to halezabux for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30-$250 USD
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