Đang Thực Hiện

120910 App to change order of items

I am looking for a way to efficiently allow a user to order a list of items displayed to them in a form. Currently each item is stored in the database with an extra field named "rank", this is an integer field. The idea is when I grab the items from the database I order them using this field and then spit out the items into a form, one row after another with links for changing the order of the item either up or down in the list. Ideally the first item and the last item will have the appropriate links. That is you cannot move the first item up, nor can you move the last item down.

When a user clicks on one of these links to move an item either up or down, the script should create new "rank" entries for the items displayed and then update the database, grab the latest list correctly ordered and then redraw the interface to reflect the latest order.

Please see the attached PDF file for an idea of what the interface should look like. I am not necessarily going for a pretty design here, and overall am looking for someone to write the central logic of this application more than anything else, as the functionality will be used for any number of item lists. So I am pretty flexible about the items, generic data will suffice, simplistic form will be fine.

As for the technical specifications. I understand something like this can be written in Javascript but I am looking for a client side solution. Also I am working in PHP 5 and using PHP's new PDO database objects for database access. I am also using PostgreSQL but if you prefer to use MySQL to put this together that is fine as the PHP PDO objects make things portable.

A rudimentary table for purposes of this application would have the following field:

item_id

item_title

item_rank

Kỹ năng: Bất kì công việc gì, Nhập liệu, HTML, MySQL, PHP, SQL

Xem thêm: generic data access, create data entry form access, create an access form for data entry, app script form, postgresql any, mysql postgresql, php pdo, pdo, going out app, client change, change the functionality of, design order script, order field, javascript items, mysql data grab, access order, looking someone create app, database table update user interface design, mysql update else, app table, order number mysql, change javascript, change order form mysql, create data entry form mysql, create access database order entry

Về Bên Thuê:
( 2 nhận xét ) Mesa,

Mã Dự Án: #1867076

Đã trao cho:

tashstar

Please see PMB.. Thanks...

$60 USD trong 1 ngày
(0 Đánh Giá)
0.0