Đang Thực Hiện

117133 PHP/mySQL

I'm looking for a PHP page where the "CaseWorker" will login, creat "clients" and view their "Clients". See Client tabel for what info is needed. For each client we will include "budget" for each month and "$spent" for each month per client. I want the CaseWorker to be able to view this info and then update the info by entering it into a PHP form. After updating they will be returned to the "view" for their clients. Additional fields in the php page will be needed such as $spent for all clients for a given caseworker. Each CaseWorker must log in to view their clients and one master account must be created to view all client data. Page should be arranged like an Excel spreadsheet (simple, clean, easy to read)

# of CaseWorkers = unlimited

# of Clients = currently less than 40

mySQL db has been created with the following tables/fields.

CASEWORKER:

CaseWorkerID (primary)

CaseWorkerName

CaseWorkerPhone

CaseWorkerEmail

CaseLoad (total number of clients for this CaseWorker)

CLIENT:

ClientID (primary)

CaseWorkerID (based on CaseWorker who enters the data as determined by CaseWorker login)

ClientName

StreetAddress

City

State

ZipCode

ClientPhone

#Adults (hand entered into php page)

#Children (hand entered into php page)

SignupDate (hand entered into php page)

BUDGET2007:

ClientID

BudgetJan

BudgetFeb

BudgetMarch

(continues for all 12 months)

$SpentJan

$SpentFeb

$SpentMarch

(continues for all 12 months)

Kỹ năng: Bất kì công việc gì, HTML, Javascript, MySQL, PHP, An ninh Web

Xem thêm: spreadsheet javascript, javascript less, mysql client, php master, account creat, client form excel, php form mysql page, zipcode city, javascript spreadsheet, php view data, mysql view update, php data view, mysql page number, php excel read, master php, mysql spreadsheet, master budget include, php spreadsheet, creat excel, excel update mysql, creat page, excel form account, mysql clean, javascript simple spreadsheet, mysql clean data

Về Bên Thuê:
( 1 nhận xét )

Mã Dự Án: #1863300

Đã trao cho:

akinwale

Hello, I have gone through your project requirements and I can implement a complete solution for you within three days. I've also noticed that the current database design isn't flexible enough (for instance, you'll hav Thêm

$95 USD trong 3 ngày
(84 Đánh Giá)
6.4