In Progress

Basic PHP Client and Orders List Application

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


clientid (number - linking key to orders - we will enter the id when adding a record)


acctnumber (textandnumbers)



status (active/inactive - if inactive disable login)

table: tbladmins

entryid (autonumber)

adminid (numeric)





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)



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

Skills: MySQL, PHP, Software Architecture

See more: table view icon, status icon, reality show template, projects for php developer, php developer myself, login icon create, list icon, i need data entry projects number, inactive icon, icon inactive, data entry form php mysql, data entry application software, currency table list, create you own icon, create icon line, basic icon, client database software, create own icon, php software architecture mysql, orders, create form & connect, basic php, php data table, form connect database mysql, create form connect mysql

About the Employer:
( 33 reviews ) Everett, United States

Project ID: #2395707

Awarded to:


Ready to get started.

$100 USD in 0 days
(106 Reviews)

Hi there, I am ready to get this job done for you.

$120 USD in 3 days
(126 Reviews)

10 freelancers are bidding on average $134 for this job


Can make in 5 days.

$200 USD in 5 days
(37 Reviews)

Hello Please read more than private message thank you

$99 USD in 2 days
(64 Reviews)

I am interested and offer you my services, full working solution will be provided with support. Thanks

$225 USD in 5 days
(64 Reviews)

Hello sir i'm ready to start in this project developing all requirements. Thank you

$100 USD in 8 days
(2 Reviews)

Hello sir, please read pm

$200 USD in 3 days
(2 Reviews)

Please check PMB.

$100 USD in 2 days
(1 Review)

expert in php, mysql, css, javascript, jquery and more

$140 USD in 6 days
(3 Reviews)

hey ABinBoston, please check your PMB :)

$100 USD in 10 days
(1 Review)

Kindly check pmb.

$120 USD in 3 days
(0 Reviews)

This job is a piece of cake for me.

$50 USD in 3 days
(0 Reviews)