Bueno como prometí aquí está el code tal cual me funciona.
Code para la page del form form1.php (aunque podria estar todo en una página.
Código:
<?php
$t="regi1";
$link = mysql_connect("localhost","root","");
mysql_select_db("downstation_com",$link);
$result = mysql_query("select * from $t order by titol_noti",$link);
$row = mysql_fetch_array($result);
echo "<center><table border='0' ='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' bgcolor='#000000' width='50%' align='center'>\n";
echo "<tr><td bgcolor='#6B7B92'><img src='img/pixel.gif' width='3' height='1' border='0'><font color='white' size='3'><b>".$row['nom_reg']."</b></font></td></tr>\n";
echo "</table><br></center>\n";
echo "<form method='post' action='pruevas.php?t=$t'>\n";
echo "<center><table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' bgcolor='#000000' width='50%' align='center'>\n";
echo "<tr><td bgcolor='#FFFFFF'><b></b></td><td bgcolor='#FFFFFF'><b></b></td><td bgcolor='#FFFFFF'></td></tr>\n";
while($row = mysql_fetch_array($result))
{
echo "<tr><td bgcolor='#FFFFFF'><input type='checkbox' name='id_noti[]' value=".$row[id]."></td>\n";
if ($row[on_off]=="on")
{
echo "<td bgcolor='#FFFFFF'>ON</td>\n";
}
else if ($row[on_off]=="off")
{
echo "<td bgcolor='#FFFFFF'>OFF</td>\n";
}
echo "<td bgcolor='#FFFFFF'><b>".$row['titol_noti'].".</b><br></td></tr>\n";
}
echo "</table><br><input type='submit' name='online' value='Online'> <input type='submit' name='offline' value='Offline'> <input type='submit' name='elimina' value='Eliminar'></center>\n";
echo "</form><br><br>\n";
mysql_free_result($result);
echo "<center><a href='index2.php'>Veure noticies que estan online.</a></center>"
?>
Code para la pagina que procesa y actualiza la base de datos.
Código:
<?php
$HTTP_POST_VARS["id_noti"];
$t="regi1";
$link = mysql_connect("localhost","root","");
mysql_select_db("downstation_com",$link);
if (isset($online))
{
foreach ($id_noti as $id2)
{
$sql = mysql_query("UPDATE $t SET on_off='on' where id='$id2'",$link);
}
if (!$sql)
{
echo "No es van poder actualitzar les noticies\n";
}
else
{
$result = mysql_query("select * from $t",$link);
$row = mysql_fetch_array($result);
echo "<center><table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' bgcolor='#000000' width='50%' align='center'>\n";
echo "<tr><td bgcolor='#6B7B92'><img src='img/pixel.gif' width='3' height='1' border='0'><font color='white' size='3'><b>".$row['nom_reg']."</b></font></td></tr>\n";
echo "</table><br></center>\n";
echo "<form method='post' action='pruevas.php?t=$t'>\n";
echo "<center><table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' bgcolor='#000000' width='50%' align='center'>\n";
echo "<tr><td bgcolor='#FFFFFF'><b></b></td><td bgcolor='#FFFFFF'><b></b></td><td bgcolor='#FFFFFF'></td></tr>\n";
while($row = mysql_fetch_array($result))
{
echo "<tr><td bgcolor='#FFFFFF'><input type='checkbox' name='id_noti[]' value=".$row[id]."></td>\n";
if ($row[on_off]=="on")
{
echo "<td bgcolor='#FFFFFF'>ON</td>\n";
}
else if ($row[on_off]=="off")
{
echo "<td bgcolor='#FFFFFF'>OFF</td>\n";
}
echo "<td bgcolor='#FFFFFF'><b>".$row['titol_noti'].".</b><br>\n";
echo "</td></tr>\n";
}
echo "</table><br><input type='submit' name='online' value='Online'> <input type='submit' name='offline' value='Offline'> <input type='submit' name='elimina' value='Eliminar'></center>\n";
echo "</form>\n";
mysql_free_result($result);
}
}
else if(isset($offline))
{
foreach ($id_noti as $id2)
{
$sql = mysql_query("UPDATE $t SET on_off='off' where id='$id2'",$link);
}
if (!$sql)
{
echo "No es va poder actualitzar\n";
}
else
{
$result = mysql_query("select * from $t",$link);
$row = mysql_fetch_array($result);
echo "<center><table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' bgcolor='#000000' width='50%' align='center'>\n";
echo "<tr><td bgcolor='#6B7B92'><img src='img/pixel.gif' width='3' height='1' border='0'><font color='white' size='3'><b>".$row['nom_reg']."</b></font></td></tr>\n";
echo "</table><br></center>\n";
echo "<form method='post' action='pruevas.php?t=$t'>\n";
echo "<center><table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' bgcolor='#000000' width='50%' align='center'>\n";
echo "<tr><td bgcolor='#FFFFFF'><b></b></td><td bgcolor='#FFFFFF'><b></b></td><td bgcolor='#FFFFFF'></td></tr>\n";
while($row = mysql_fetch_array($result))
{
echo "<tr><td bgcolor='#FFFFFF'><input type='checkbox' name='id_noti[]' value=".$row[id]."></td>\n";
if ($row[on_off]=="on")
{
echo "<td bgcolor='#FFFFFF'>ON</td>\n";
}
else if ($row[on_off]=="off")
{
echo "<td bgcolor='#FFFFFF'>OFF</td>\n";
}
echo "<td bgcolor='#FFFFFF'><b>".$row['titol_noti'].".</b><br></td></tr>\n";
}
echo "</table><br><input type='submit' name='online' value='Online'> <input type='submit' name='offline' value='Offline'> <input type='submit' name='elimina' value='Eliminar'></center>\n";
echo "</form>\n";
mysql_free_result($result);
}
}
echo "<center><a href='index2.php'>Veure noticies que estan online.</a></center>"
?>
Me gustaría que lo comentaseis un poco. Tengo algunos problemas para hacer classes, la de webstudio sobre paginación es genial os postearé algunas de mis dudas a cerca de s