Em Andamento

Simple database web application.

A simple web based demo application is required. Here's the specifications:

1. it contains four tables, business, hours, user, changes tables, all sql definition will be given as attached.

2. the web application must be written in php, use mysql as database, all web pages are tempalte driven.

3. the web page template contains a 728 x 90 graphic logo at the top, anything you can create.

4. use a clean, simple and modern Look and Feel templates.

5. user can log in using email and password.

6. user can retrieve password by email. (an php email script is also attached for reference.)

7. after log in, user can add a new business to his account. ( a php script does the db insert can be see as reference)

8. after log in, user can update the information of any business in his account.

9. after log in, user can deactive the status any business in his account to inactive.

10. after each of the 7-9 is exectuted, a row is inserted into the changes table with the following data. user id, time, action update, biz id, userip)

what the application should not do.

if a user is not logged in a session, he should not be allowed to any changes, in another word, the authentication is required before 4-6 can be executed, disallow hacking by methods such as enter the url with parameters.

Before and after your bid, makes sure send me some reference of your previous work.

50% payment after it is finished and runs well on your test environment. 50% payment after it is installed and tested runs on my godaddy hosting.

If you need to clearfy anything or have any question, pm me anytime.

tables

user with fields: userid(int), email(String), password (String), status(int, default 1), group(int, default 1), createdDate(time), lastLoginTime(Time), lastLoginIP(String)

business with field, businessId(int, auto), names (String), userid(int, reference user table), address1(String), address2(String), city(String), state(String), postal code(String), phonenumber(10digit string), fax(10 digits string), comment(text).

hours with field, businessId(int, reference business table), monday(String), tuesday(String), wednesday(String), thursday(String), friday(String), Saturaday(String), Sunday(String). potential values 11:00am-11:00pm, default closed.

changes with fields: user id(int, reference user table), time (timestamp), action(String), businessID(int, reference business table), ip(String)

Habilidades: Design Gráfico, JSP, PHP, Design de Sites

Ver mais: work values, web data logo, web templates create, web templates business, web php templates, web pages template, web application specifications, web anything, user specifications template, top templates web, top group, templates web pages, template code web, sure web, state auto, sql database business, new web templates, new web demo, new templates web pages, new business names logo, sql create database, mysql city state database, account page templates, logo auto create, jsp web

Acerca do Empregador:
( 12 comentários ) OTTAWA, Canada

ID do Projeto: #155088