EmPowerYou
Registered
Имам проблем с урока за пренареждане на навигационното меню. Пренареждам си менюто както си искам и като изпратя формата то си е пак както преди, не се променя.
red.php
prered.php
Защо не става не знам, на демото урока си работи...
red.php
Код:
<HTML>
<HEAD>
<script type="text/javascript">
function move(fbox, tbox) {
var arrFbox = new Array();
var arrTbox = new Array();
var arrLookup = new Array();
var i;
for(i=0; i<tbox.options.length; i++) {
arrLookup[tbox.options[i].text] = tbox.options[i].value;
arrTbox[i] = tbox.options[i].text;
}
var fLength = 0;
var tLength = arrTbox.length
for(i=0; i<fbox.options.length; i++) {
arrLookup[fbox.options[i].text] = fbox.options[i].value;
if(fbox.options[i].selected && fbox.options[i].value != "") {
arrTbox[tLength] = fbox.options[i].text;
tLength++;
} else {
arrFbox[fLength] = fbox.options[i].text;
fLength++;
}
}
arrFbox.sort();
fbox.length = 0;
tbox.length = 0;
var c;
for(c=0; c<arrFbox.length; c++) {
var no = new Option();
no.value = arrLookup[arrFbox[c]];
no.text = arrFbox[c];
fbox[c] = no;
}
for(c=0; c<arrTbox.length; c++) {
var no = new Option();
no.value = arrLookup[arrTbox[c]];
no.text = arrTbox[c];
tbox[c] = no;
}
}
function selectAll(box) {
for(var i=0; i<box.length; i++) {
box[i].selected = true;
}
}
</script>
</HEAD>
<BODY>
<form method="POST" name="combo_box" ACTION="prered.php">
<table cellpadding="4" cellspacing="0" border="0">
<tr>
<td>
<select multiple size="10" name="list1[]" id="list1" style="width:150" onDblClick="move(document.combo_box.list1,document.combo_box.list2)">
<?
$user="***";
$password="***";
$database="***";
mysql_connect("db4.awardspace.com",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);
$query="SELECT * FROM sydyrzhanie order by red ";
$result=mysql_query($query)
or die ("Zaqwkata ne mozhe da se izpylni!");
$broi=mysql_num_rows($result);
while ($row = mysql_fetch_array($result))
{
$id=$row["id"];
$name=$row["name"];
echo "<option value='$id'>$name</option>";
}
mysql_close();
?>
</select>
</td>
<td align="center" valign="middle">
<input type="button" onClick="move(this.form.list2,this.form.list1)" value="<<" id=button1 name=button1>
<input type="button" onClick="move(this.form.list1,this.form.list2)" value=">>" id=button2 name=button2>
</td>
<td>
<select multiple size="10" name="list2[]" id="list2" style="width:150" onDblClick="move(document.combo_box.list2,document.combo_box.list1)">
</select>
</td>
</tr>
<tr><td align="center" colspan="3">
<input type="submit" name="submit_button" value="Submit" onClick="selectAll(document.combo_box.list2);">
</td></tr>
</table>
</form>
</BODY>
</HTML>
prered.php
Код:
<HTML>
<HEAD>
</HEAD>
<BODY>
<?
$list2[]=$HTTP_POST_VARS['list2[]'];
$kolko=count($list2);
$user="***";
$password="***";
$database="***";
mysql_connect("db4.awardspace.com",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);
for($red=0; $red<($kolko-1); $red++){
$id=$list2[$red];
$query = "Update sydyrzhanie SET red='$red' Where id='$id'";
$result=mysql_query($query)
or die ("Zaqvkta ne mozhe da se izpylni!");
}
echo "<BR><BR><B>Връзките в менюто бяха пренаредени успешно!</B>";
mysql_close();
?>
<BR><B><A href="red.php">Ново пренареждане/ Виж резултата</A></B>
</BODY>
</HTML>
Защо не става не знам, на демото урока си работи...