Ana Sayfa / Kod ve Scriptler / MySQL Drag and Drop Record Sorting - PHP Script

MySQL Drag and Drop Record Sorting - PHP Script

Veritabanı kayıtlarını kendi sıralamanıza göre düzenleyen bir betik.

  • Yayın tarihi19 Ocak 2016
  • Nerede çalışırPHP 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
  • VeritabanıMySQL 4.x, MySQL 5.x
  • Paket içeriği.php, .css, .html, JavaScript .js
  • Son güncelleme11 Temmuz 2017
  • Canlı demoVar
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 dragfolder
  • 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