php - How do I fix an Ajax conflict with jQuery Drag n Drop ranking? -
i have 2 sets of code loadmore button , jqueury drag n drop not work one.
how can merge them function 1 code?
here problem:
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js" type="text/javascript"> this line needed loadmore button , kills ui function of drag , drop elements.
drag n drop:
<title>jquery dynamic drag'n drop</title> <script type="text/javascript" src="jquery-1.3.2.min.js"></script> <script type="text/javascript" src="jquery-ui-1.7.1.custom.min.js"> </script><script type="text/javascript"> $(document).ready(function(){ $(function() { $("#contentleft ul").sortable({ opacity: 0.6, cursor: 'move', update: function() { var order = $(this).sortable("serialize") + '&action=updaterecordslistings'; $.post("updatedb.php", order, function(theresponse){ $("#contentright").html(theresponse); }); } }); }); }); </script> dnd updatedb.php
<?php require("db.php"); $action = mysql_real_escape_string($_post['action']); $updaterecordsarray = $_post['recordsarray']; if ($action == "updaterecordslistings"){ $listingcounter = 1; foreach ($updaterecordsarray $recordidvalue) { $query = "update records set recordlistingid = " . $listingcounter . " recordid = " . $recordidvalue; mysql_query($query) or die('error, insert query failed'); $listingcounter = $listingcounter + 1; } echo '<pre>'; print_r($updaterecordsarray); echo '</pre>'; echo 'if refresh page, see records stay modified.'; }?> dnd main php:
<ul> <?php $query = "select * records order recordlistingid asc"; $result = mysql_query($query); while($row = mysql_fetch_array($result, mysql_assoc)) { ?> <li id="recordsarray_<?php echo $row['recordid']; ?>"><?php echo $row['recordid'] . ". " . $row['recordtext']; ?></li> <?php } ?> </ul> loadmore:
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js" type="text/javascript"></script> <script> $(function() { var page = 1; $("#loadmore").click(function(){ $.ajax({ type:"get", url:"page4.php", data:{page:page}, success: function(response) { $("#data_grid").append(response); page++; } }); }); });</script> loadmore page4.php
<?php //set argument mysql server $connect = mysql_connect("mysql_server","mysql_user","mysql_password"); mysql_select_db("database_name",$connect); $page = isset($_get["page"]) ? $_get["page"] : 1; $limit = 25; $offset = ($page - 1) * $limit; $sql = "select * table2 limit $offset, $limit"; $result = mysql_query($sql); $numrows = mysql_num_rows($result); if($numrows>0) { while($row = mysql_fetch_array($result)) { //get field data , set following row echo "<tr><td>field 1</td><td>field 2</td><td>field 3</td></tr>"; //edit row table data } } else { echo "<tr><td colspan='3'> no more data </td></tr>"; } exit; ?> what missing? can fix this? going have scrap jquery drag n drop? there alternative should using?
background: user rate listed items in order deem fit. total possible items exceed 300,000 user utilize first few hundred , rest used searchable database add odd item list. can 2 codes in question work separately when attempt combination create conflict.
thank time in assisting project.
look here
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js" type="text/javascript"> and
<script type="text/javascript" src="jquery-1.3.2.min.js"></script> are same (jquery file)
so use one
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js" type="text/javascript">
Comments
Post a Comment