I gang

Add 40 new fields to table and update 4 php forms

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)

Færdigheder: MySQL, PHP

Se mere: mobile php files, time add, time table, table, php forms, mobile forms, forms mysql, email add, edit email forms, mysql add fields, add edit view, mysql view update, date calculation, update database mysql, mobile php mysql, mysql create table fields, mysql update database, update database email, add quote, text table, add access, mysql create table, edit table php, php add edit database, create mysql php forms

Om arbejdsgiveren:
( 156 bedømmelser ) Bridgwater, United Kingdom

Projekt-ID: #999946

Tildelt til:

exitsol

Lets get started

$40 USD in 0 dage
(107 bedømmelser)
5.8