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

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

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:

exitsol

Ready to get started.

$100 USD in 0 days
(106 Reviews)
5.8
csajit

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

$120 USD in 3 days
(126 Reviews)
5.6

10 freelancers are bidding on average $134 for this job

Indispensable

Can make in 5 days.

$200 USD in 5 days
(37 Reviews)
6.0
scriptphp87

Hello Please read more than private message thank you

$99 USD in 2 days
(64 Reviews)
6.0
vertexsolutions

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

$225 USD in 5 days
(64 Reviews)
5.8
WSolutionsinc

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

$100 USD in 8 days
(2 Reviews)
2.9
xristianmatos

Hello sir, please read pm

$200 USD in 3 days
(2 Reviews)
2.8
trinity09

Please check PMB.

$100 USD in 2 days
(1 Review)
1.8
bikramtpasl

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

$140 USD in 6 days
(3 Reviews)
1.5
asharfraz

hey ABinBoston, please check your PMB :)

$100 USD in 10 days
(1 Review)
0.9
sujoykrdas

Kindly check pmb.

$120 USD in 3 days
(0 Reviews)
0.0
rubarita

This job is a piece of cake for me.

$50 USD in 3 days
(0 Reviews)
0.0