348960 User Database Management

We require a database management system with two tables: customer table and reference table.

Customers can register on the site and the admin can login and update customer table with relevant information. When new customer registers, COMPANY NAME is automatically populated to be used as a drop/down list on reference table.

Admin will need access to all customer information and be able to edit/update data using text and/or drop down list on customer table.

Customer login/registration form needs the following fields:

1- COMPANY NAME (also used as login username - required)

2- Password (password reminder function also required)

3- full name (required)

4- Phone (required)

5- Email (required)

6- company registration number (optional)

7- company VAT number (optional)

Customer Table needs the following fields:

1- ref

2- date

3- customer full name

4- vrm

5- category


7- commission

8- paid

Reference Table needs the following fields:

1- ref

2- date

3- customer full name

4- vrm

5- category

6- status

7- COMPANY NAME (drop down list)

8- commission

9- paid

10- comments

Customer table and reference table are linked via COMPANY NAME.

Reference Table needs to allow admin to copy/paste of a row from external website (see [url removed, login to view])

System Process:

1- Customer registers on site.

2- Admin logs in to back end to edit update reference table.

3- Customer logs into site to see changes made by admin in step 2.

System Requirements:

1- Customer can only see his profile when logged in (customer table).

2- Admin can edit reference table.

3- Customer can only see the rows from customer table if the “STATUS” in that row = ON HIRE (see [url removed, login to view]) eg: show “REF” 225979 and 225841 but DO NOT show “REF” 225932

4- Search box is needed for reference table.

5- Admin can filter search results on reference table by company name.

Квалификация: Разное, Ввод данных, MySQL, PHP, Установка скриптов, Дизайн сайтов

Показать больше table customer, show full name, hire via linked in, database hire, customer table, access information management, email database management, back end database, profile database, database management, customer management, copy paste comments, company logs, database copy script, status update website script, update status script php, status update script, drop filter fields, customer login access database, drop list database

О работодателе:
( 27 отзыв(-а, -ов) ) WORCESTER, United Kingdom

ID проекта: #2094786



We can do this, Please see PMB.

$400 USD за 6 дней(-я)
(121 отзывов(-а))