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

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -