MySQL Drag and Drop Record Sorting – PHP Script

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

Related