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;
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;