Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(strLen($_POST['txtPio'][0])>0){
- $size=sizeOf($_POST['txtPio']);
- $ids=array();
- $count=0;
- $q=mysql_query("select id from tbl_articles where menu_show='1'");
- while($r=mysql_fetch_array($q)){
- $ids[$count]=$r['id'];
- $count++;
- }
- for($i=0;$i<$size;$i++){
- $query="update tbl_articles set menu_pio='".mysql_real_escape_string($_POST['txtPio'][$i])."' where id='".mysql_real_escape_string($ids[$i])."'";
- mysql_query($query);
- }
- }
- ?>
- <form method="post" name="frmMenu">
- <table>
- <tr>
- <td width="25"></td>
- <td><input type="text" name="is_change" id="is_change" value="0" style="visibility:hidden;"></td>
- <td style="padding-left:35px;"><b><u>Order of Menu</u></b></td>
- </tr>
- <?php
- $count = 1;
- $q=mysql_query("select menu,menu_pio from tbl_articles where menu_show='1'");
- while($r=mysql_fetch_array($q)){
- $out = "<tr>\n<td>";
- $out .= $count;
- $out .= "</td>\n<td>";
- $out .= $r['menu'];
- $out .= "</td>\n<td style=\"padding-left:35px;\">";
- $out .= "<input type=\"text\" size=\"2\" readonly name=\"txtPio[]\" id=\"txtPio['".strVal($count-1)."']\" value=\"".$r['menu_pio']."\" style=\"margin-right:20px;\">";
- $out .= "<input type=\"button\" value=\"/\\\" onclick=\"up('".strVal($count)."')\" id=\"btnUp".strVal($count-1)."\">";
- $out .= "<input type=\"button\" value=\"\\/\" onclick=\"down('".strVal($count)."')\" id=\"btnDw".strVal($count-1)."\">";
- $out .= "</td>\n";
- $out .= "</tr>\n\n";
- echo $out;
- $count++;
- }
- echo mysql_error();
- ?>
- <tr><td> </td></tr>
- <tr><td colspan="3" align="center">
- <input type="submit" value="Save">
- </td></tr>
- </table>
- <script type="text/javascript">
- var end=<?php echo ($count-2) ?>;
- document.getElementById('btnUp0').style.visibility="hidden";
- document.getElementById('btnDw'+end).style.visibility="hidden";
- function down(id){
- var one=document.forms['frmMenu'].getElementsByTagName('input')[(1+(id*3))-3];
- var two=document.forms['frmMenu'].getElementsByTagName('input')[(1+(id*3))];
- var sub1=one.value;
- var sub2=two.value;
- one.value=sub2;
- two.value=sub1;
- document.getElementById("is_change").value="1";
- }
- function up(id){
- var one=document.forms['frmMenu'].getElementsByTagName('input')[(1+(id*3))-3];
- var two=document.forms['frmMenu'].getElementsByTagName('input')[(1+((id)*3)-6)];
- var sub1=one.value;
- var sub2=two.value;
- one.value=sub2;
- two.value=sub1;
- document.getElementById("is_change").value="1";
- }
- </script>
Add Comment
Please, Sign In to add comment