Devam Ediyor

480821 Address Book

** posted on February 27

What do I need?

=================

A simple script wrote in PHP that can browse a table in a MySQL database, with simple filter option, a simple script that allow import and export to and from the database and a simple script that allow add a single item to the database the database.

Where does the scripts and files should be placed?

=======================================

All the scripts and files should be paleced at [url removed, login to view] (I can do that, once received the source)

- [url removed, login to view]: script that allow browse the database table with simple filter options

- [url removed, login to view]: script that allow import and export to and from the database.

- [url removed, login to view]: script that allow adding a single record to the database.

Data base structure and details:

Database name: planette_abook

username: planette_abook

Password: wp47shwn53

location: localhost

table: address_book

Fields:

company: Customer Company Name (text)

address: Customer address (text)

tel: Customer Telephone (text)

mobile: Customer Mobile phone (text)

contact: Customer contact name(text)

e-mail: Customer e-mail (text)

type: Customer type (text)

Both Company are Contact must not be empty

[url removed, login to view] description.

====================

This script should browse all the records in address_book table as shown in the Address Book [url removed, login to view]

home: should link to [url removed, login to view]

search buttom: execute the search and browse the content of the table using the selected filter.

clear buttom: clar the filter selection and browse all the items of the table

Search text box: the text typed by the user should be used to search in ALL the fields of the table as "sub-string"

sort by pick-list: user can select "Company", "Contact" or "Type"

if select "Company" the result should be order by Company + Contact

if select "Contact" the result should be order by Contact + Company

if select "Type" the result should be order by Type + Company + Contact

The default is "Company"

The links "Edit" and "Delete" at the same row of each record should allow edit or delete the selected record. A confirmation windows alert shuld be used to confirm this action.

[url removed, login to view] description

========================

When any one access this script, the user will be able to select any of the options shown at Administration [url removed, login to view]:

Import (update): Will browse at the local PC for the required CSV file and import the content to the data base. The records must be added to the existing in the database.

If the record allready exits must be overwrite (updated)

Import (re-write): Will browse at the local PC for the required CSV file and first delete all the records at the data base and after that import the content to the data base.

Export: Export the content of the databas in .XLS or CSV format to the PC.

[url removed, login to view] description

=====================

This scripr should allow to insert a new item in the data base.

The Add Contact button is used to add the record to the table. There is NOT allowed a new record with Company and Contact fields empty. There is not need any other verification.

The Clear Form button clear all the fields at the screen caption and the Cancel button close the windows and return to the Address Book screen.

See Add-Customer screen for more details.

What we expect to receive:

=======================

- [url removed, login to view]

- [url removed, login to view]

- [url removed, login to view]

other files (if needed)

written instructions about how to install

Attached files:

[url removed, login to view] that includes:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Address Book [url removed, login to view]

Administration [url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view] (sample file for testing the script)

Beceriler: Her şey Kabul, Makale Yeniden Yazım, Düzenleme, Grafik Tasarımı, Logo Tasarımı, MySQL, PHP

Daha fazlasını görün: windows action script, record data structure, used write book, sub box design, string data structure, search text string, sample received form, phone book data structure, order book data structure, local search script, link list data structure, import administration, write content book, graphic data base, gif txt, book company, design verification testing, data structure sort, data structure link list, data structure book list, data structure book, company search see write, clear search fields, clear string, book data structure

İşveren Hakkında:
( 3 değerlendirme ) Panama, United States

Proje NO: #2226731

Seçilen:

bhupal123

====== Hi Juan, will do it for u. See PMB. Thanks. ======

3 gün içinde 80$ USD
(577 Değerlendirme)
6.6