I gang

Add 40 new fields to table and 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, create table php, time add, time table, table, php forms, mobile forms, forms mysql, edit email forms, mysql add fields, add edit view, date calculation, mobile php mysql, table php, mysql create table fields, add quote, text table, add access, mysql create table, edit table php, php add edit database, create mysql php forms, access quote database, mobile mysql, access forms php

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

Projekt-ID: #1003354

Tildelt til:

halezabux

Hi,Let's start on this. Thanks.

$40 USD på 1 dag
(50 bedømmelser)
6.4

8 freelancere byder i gennemsnit $43 for dette job

danieloraca

PMB first as usual :)

$50 USD in 0 dage
(45 bedømmelser)
5.2
Abdulaziz01

Hi, lets start now. Please check PM.

$50 USD in 0 dage
(4 bedømmelser)
3.7
dataentry17

I m ready to start now.I have already done this kind jobs in past. @@ Please check PM @@

$40 USD in 0 dage
(9 bedømmelser)
3.4
thethird

i am new for the site but with great experience of 3 years on the field just try me u will be satisfied!

$30 USD in 0 dage
(1 bedømmelse)
1.1
wxiang15

Please check my PM.

$50 USD på 1 dag
(0 bedømmelser)
0.0
milaniya

Hello, my name is Marina. I would like to bid on this project and would be able to complete the work on time you requested. I have extensive experience in working on php projects. I have a great desire to cooperate wit Mere

$40 USD in 3 dage
(0 bedømmelser)
0.0
asadAhanjra

hello, i can complete this project confidently...

$43 USD in 2 dage
(0 bedømmelser)
0.0