En cours

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

Compétences : MySQL, PHP, Architecture Logicielle

Voir plus : 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

Concernant l'employeur :
( 33 commentaires ) Everett, United States

N° du projet : #2395707

Décerné à :

exitsol

Ready to get started.

100 $ USD en 0 jours
(106 Commentaires)
5.8
csajit

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

120 $ USD en 3 jours
(126 Commentaires)
5.6

10 freelance ont fait une offre moyenne de 134 $ pour ce travail

Indispensable

Can make in 5 days.

200 $ USD en 5 jours
(37 Commentaires)
6.0
scriptphp87

Hello Please read more than private message thank you

99 $ USD en 2 jours
(64 Commentaires)
6.0
vertexsolutions

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

225 $ USD en 5 jours
(64 Commentaires)
5.8
WSolutionsinc

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

100 $ USD en 8 jours
(2 Commentaires)
2.9
xristianmatos

Hello sir, please read pm

200 $ USD en 3 jours
(2 Commentaires)
2.8
trinity09

Please check PMB.

100 $ USD en 2 jours
(1 Commentaire)
1.8
bikramtpasl

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

140 $ USD en 6 jours
(3 Commentaires)
1.5
asharfraz

hey ABinBoston, please check your PMB :)

100 $ USD en 10 jours
(1 Commentaire)
0.9
sujoykrdas

Kindly check pmb.

120 $ USD en 3 jours
(0 Commentaires)
0.0
rubarita

This job is a piece of cake for me.

50 $ USD en 3 jours
(0 Commentaires)
0.0