Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Design
/
fileman
/
Fusion
/
Modal
:
drag01.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<!DOCTYPE html> <html> <head> <title> Example of Dynamic Drag and Drop table rows in PHP Mysql </title> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script> </head> <body> <div class="container"> <h3 class="text-center"> Example of Dynamic Drag and Drop table rows in PHP Mysql </h3> <table class="table table-bordered"> <tr> <th>#</th> <th>Name</th> <th>Defination</th> </tr> <tbody class="row_position"> <?php //require('db_config.php'); // private $host = 'analogdepat.mysql.db'; //private $user = 'analogdepat'; //private $password = "Un92pac007"; //private $database = "analogdepat"; $mysqli = new mysqli("analogdepat.mysql.db", "analogdepat", "Un92pac007", "analogdepat"); $sql = "SELECT * FROM sorting_items ORDER BY position_order"; $users = $mysqli->query($sql); while($user = $users->fetch_assoc()){ ?> <tr id="<?php echo $user['id'] ?>"> <td><?php echo $user['id'] ?></td> <td><?php echo $user['title'] ?></td> <td><?php echo $user['description'] ?></td> </tr> <?php } ?> </tbody> </table> </div> <!-- container / end --> </body> <script type="text/javascript"> $( ".row_position" ).sortable({ delay: 150, stop: function() { var selectedData = new Array(); $('.row_position>tr').each(function() { selectedData.push($(this).attr("id")); }); updateOrder(selectedData); } }); function updateOrder(data) { $.ajax({ url:"move_rows.php", type:'post', data:{position:data}, success:function(){ alert('your change successfully saved'); } }) } </script> </html>