120910 App to change order of items

Đã hoàn thành Đã đăng vào Mar 2, 2007 Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

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

Nhập liệu HTML MySQL Odd Jobs PHP SQL

ID dự án: #1867076

Về dự án

1 đề xuất Dự án từ xa Jul 11, 2012 đang mở

Được trao cho:

tashstar

Please see PMB.. Thanks...

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