Guest User

Untitled

a guest
Feb 18th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.30 KB | None | 0 0
  1. <?php
  2.  
  3. if(strLen($_POST['txtPio'][0])>0){
  4. $size=sizeOf($_POST['txtPio']);
  5.  
  6. $ids=array();
  7. $count=0;
  8. $q=mysql_query("select id from tbl_articles where menu_show='1'");
  9. while($r=mysql_fetch_array($q)){
  10. $ids[$count]=$r['id'];
  11. $count++;
  12. }
  13.  
  14. for($i=0;$i<$size;$i++){
  15. $query="update tbl_articles set menu_pio='".mysql_real_escape_string($_POST['txtPio'][$i])."' where id='".mysql_real_escape_string($ids[$i])."'";
  16. mysql_query($query);
  17. }
  18.  
  19. }
  20.  
  21. ?>
  22.  
  23. <form method="post" name="frmMenu">
  24. <table>
  25. <tr>
  26. <td width="25"></td>
  27. <td><input type="text" name="is_change" id="is_change" value="0" style="visibility:hidden;"></td>
  28. <td style="padding-left:35px;"><b><u>Order of Menu</u></b></td>
  29. </tr>
  30.  
  31. <?php
  32. $count = 1;
  33. $q=mysql_query("select menu,menu_pio from tbl_articles where menu_show='1'");
  34. while($r=mysql_fetch_array($q)){
  35. $out = "<tr>\n<td>";
  36. $out .= $count;
  37. $out .= "</td>\n<td>";
  38. $out .= $r['menu'];
  39. $out .= "</td>\n<td style=\"padding-left:35px;\">";
  40.  
  41. $out .= "<input type=\"text\" size=\"2\" readonly name=\"txtPio[]\" id=\"txtPio['".strVal($count-1)."']\" value=\"".$r['menu_pio']."\" style=\"margin-right:20px;\">";
  42. $out .= "<input type=\"button\" value=\"/\\\" onclick=\"up('".strVal($count)."')\" id=\"btnUp".strVal($count-1)."\">";
  43. $out .= "<input type=\"button\" value=\"\\/\" onclick=\"down('".strVal($count)."')\" id=\"btnDw".strVal($count-1)."\">";
  44.  
  45.  
  46. $out .= "</td>\n";
  47.  
  48. $out .= "</tr>\n\n";
  49. echo $out;
  50. $count++;
  51. }
  52. echo mysql_error();
  53. ?>
  54.  
  55. <tr><td>&#160;</td></tr>
  56. <tr><td colspan="3" align="center">
  57. <input type="submit" value="Save">
  58. </td></tr>
  59. </table>
  60.  
  61.  
  62. <script type="text/javascript">
  63. var end=<?php echo ($count-2) ?>;
  64. document.getElementById('btnUp0').style.visibility="hidden";
  65. document.getElementById('btnDw'+end).style.visibility="hidden";
  66.  
  67. function down(id){
  68. var one=document.forms['frmMenu'].getElementsByTagName('input')[(1+(id*3))-3];
  69. var two=document.forms['frmMenu'].getElementsByTagName('input')[(1+(id*3))];
  70. var sub1=one.value;
  71. var sub2=two.value;
  72. one.value=sub2;
  73. two.value=sub1;
  74. document.getElementById("is_change").value="1";
  75. }
  76.  
  77. function up(id){
  78. var one=document.forms['frmMenu'].getElementsByTagName('input')[(1+(id*3))-3];
  79. var two=document.forms['frmMenu'].getElementsByTagName('input')[(1+((id)*3)-6)];
  80. var sub1=one.value;
  81. var sub2=two.value;
  82. one.value=sub2;
  83. two.value=sub1;
  84. document.getElementById("is_change").value="1";
  85. }
  86.  
  87. </script>
Add Comment
Please, Sign In to add comment