[ balkan7 @ 05.11.2006. 23:03 ] @
ne znam zasto mi prikazuje: Warning: Invalid argument supplied for foreach() in /home/xxx/public_html/test/index.php on line 256 Code: case "pregled": //if there is an ID given... if($_GET['id']) { //get the id, put it into a variable, cast to an INT //(for security purposes) $id = (int)$_GET['id']; $query = mysql_query("SELECT * FROM software WHERE kat_id = '$id' AND validen = '1'") or die(mysql_error()); //if no results, show that there are no tutorials //for that category if(mysql_num_rows($query) == 0) { echo "Nema software vo ovaa Kategorija!"; } //else, there is..show em else { //show all products echo "<br> <div align='center'> <table border='0' cellpadding='0' cellspacing='0' width='90%' style='border: 1px solid #336699'> <tr> <td> <table border='0' width='100%' cellpadding='0'> <tr> <td bgcolor='#0099CC'><h3 align='center'>Pregled na Softwares</h3></td> </tr> </table> <table border='0' width='100%' cellpadding='0'> <tr> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Sifra</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Naslov</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Opis</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Kategorija</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>CD & DVD</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Novo?</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Datum</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Izmeni</td> <td style='border: 1px solid #0099CC' bgcolor='#0099CC'>Izbrisi</td> </tr> </div> </table>"; while($row = mysql_fetch_array($query)) { echo "<table border='0' cellpadding='0' cellspacing='0' width='100%'> <tr> <td style='border: 1px solid #0099CC'><b>$row[sifra]</b></td> <td style='border: 1px solid #0099CC'><b>$row[naslov]</b></td> <td style='border: 1px solid #0099CC'>$row[opis]</td> <td style='border: 1px solid #0099CC'>$row[kat_id]</td> <td style='border: 1px solid #0099CC'>$row[cd_id]</td> <td style='border: 1px solid #0099CC'>$row[novo]</td> <td style='border: 1px solid #0099CC'>$row[datum]</td> <td style='border: 1px solid #0099CC'><a href='izmeni.php?action=popravi&id=$row[id]'><img src='sliki/edit.gif' width='24' height='24'></a></td> <td style='border: 1px solid #0099CC'><input type='checkbox' name='row[]' value='$row[id]'> <img src='sliki/delete.gif' width='24' height='24'></td> <form action='index.php?action=brisi' method='post' name='delete'> </tr> "; } echo "</table><br><br><div align='center'> <table border='0' cellpadding='0' cellspacing='0' width='100%'> <tr><td><p align='right'><input type='submit' name='delete' value='Delete'></td></tr></table>"; } } else { echo "Momentalno nema Softwares!"; } break; //-------------------------- //this case takes the submitted //form data of the admin form. //you can either validate, or delete //-------------------------- case "brisi": //if nothing is submitted in the //row[] array, then error! if(empty($_POST['row'])) { echo "Nothing to delete!"; } if(isset($_POST['delete'])) { $delete_array = $_POST['row']; //loop through each individual //item in the array foreach($delete_array as $val) { //delete them! $query = "DELETE FROM software WHERE id = '$val'"; $result = mysql_query($query) or die(mysql_error()); } echo "Product has been successfull delete!"; } break; |