Closed

Basic PHP Client and Orders List Application

This project was awarded to exitsol for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
12
Project Description

I need a simple php application created that does the following

connect to a mysql database
allow admins to view/add/edit/delete clients
allow admins to view/add/edit/delete admins
allow admins to view/add/edit/delete orders
allow clients to login and see only their orders (read only)
allow admins to login and view/edit data


table: tblclients
entryid(autonumber)
clientid (number - linking key to orders - we will enter the id when adding a record)
clientname
acctnumber (textandnumbers)
username
password
status (active/inactive - if inactive disable login)

table: tbladmins
entryid (autonumber)
adminid (numeric)
lastname
firstname
username
password

table: tblorders (just a 1 line entry for each order)
entryid (auto number)
orderid (numeric)
clientid (numeric - linking key to clients)
invoiceno (numeric field)
orderdate (date field - use a popup date selector)
items (just a number field)
amount (currency)
status (dropdown for pending, paid, cancelled)

table:tblstatus (used to set status dropdown)
statusid (autonumber)
status

Functions

Allow Admin to view a list of clients
Allow Admin to add edit delete a client
Allow Admin to view a list of orders - all clients
Allow Admin to add edit delete an order

When viewing a client record - Allow admin to view a list of client orders (that client only - clientid is linking key)
When viewing a client record - Allow admin to add- edit - delete a new client order

Allow admin to view a list of admin records
Allow admin to view - add- edit delete a new admin record
Allow Adimin to list/view/edit/add items to status table 9used for status dropdown in tblorders)

When a client signs in - allow client to see only their own orders
allow client to view/edit an order
allow client to add a new order
no deletes

This is basically a list/view/add database without complicated features
I will use this to build upon myself, and will post additional mini-projects for the developer as I add features
To keep the costs low, I do not need the developer to spend a lot of time formatting the template screens - i can do that
I just need the tabs to show the data in tables, and when icon is clicked - go to edit form
- you can leave all else, we will remove and format items on he template as needed

The template i wish to use is here [url removed, login to view]
I purchased the template and I will provide the template to you
I will use the forms, tables, styling included in the template

i will also assist you by helping any way possible
I have a hosting acct with php5x running and can create the mySQL database and tables as needed

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