MySQL Drag and Drop Record Sorting - PHP ScriptMySQL Drag and Drop Record Sorting - PHP Script
This is a database record sorting script. This will help to sort our records to our own order.MySQL Drag and Drop Record Sorting - PHP Script
This is a database record sorting script. This will help to sort our records to our own order.Overview
Description
This is a database record sorting script. In most of times when we are developing a database driven application or web page, most of times we need to sort our records to our own order. This is a simple drag and drop User Interface to give sorting facility to user. Applying this script to your web application/script is simple. The script is mainly based on root files "order_texts.php" and drag/saveImageOrder.php".
Features
- Database Record Sorting
- Drag and Drop UI
- Simple to Apply
Included
- Help at Demo Page (index.php)
- All JS files for drag and drop UI at drag folder
- order_texts.php file is the script and help.txt will include How To Apply
Requirements
- PHP 4, PHP 5 or PHP 7
- MySQL
Instructions
This is a database record sorting script. Applying this script to your web application/script is simple. The script is mainly based on root files "order_texts.php" and drag/saveImageOrder.php".
Change DB Connection File your table to the script
1. Open "Connections/sys.php" script in your script editor
2. Update Script to link your database
$hostname_sys = "localhost";
$database_sys = "mydbname";
$username_sys = "dbusername";
$password_sys = "dbpassword";
Associate your table to the script
1. Open "order_texts.php" script in your script editor
2. Change table name "order_records" to "YouTableName" in the recordset in line 38
3. Change table name "order_records" to "YouTableName" in line 62
4. Change column name "$row_selected['title']" to "$row_selected['YouColumnName']" in line 154 and 156
Other items by this author
Category | Scripts & Code / PHP Scripts / Database |
First release | 19 January 2016 |
Last update | 11 July 2017 |
Files included | .php, .css, .html, Javascript .js |
Software version | PHP 4.x, PHP 5.x, PHP 5.0, PHP 5.1, PHP 5.2, PHP 5.3, PHP 5.4, PHP 5.5, PHP 5.6 |
Database | MySQL 4.x, MySQL 5.x |
Tags | php, MySQL |