ok ali kako cu sa Kategoriju i sa CD-a vidis da kaze pod broja a mene treba mi da ono pokazuje sa slovima, zatoa sam postavio 3 table, za Kategoriju i za CD-a.
Code:<?php
//------------------------------------------
//database connection
mysql_connect("localhost", "xxx", "xxx") or die(mysql_error());
mysql_select_db("xxx") or die(mysql_error());
//end database connection
//------------------------------------------
$authlvl = "3";
include("authcheck.php");
include("cstring.php");
echo "<body bgcolor='#C0C0C0'>;";
$novo = "Novo";
//------------------------------------------
if(isset($_COOKIE['authaccess'])) {
mysql_connect($db_Host, $db_Username, $db_Pass);
mysql_select_db($db_Database);
$sql = mysql_query("SELECT last_login FROM $usertable WHERE username = '$_COOKIE[authusername]' LIMIT 0,1");
$ll = mysql_fetch_array($sql);
echo "<div align='right'>[ <small>Posledno Logiran: <font color='red'><i>$ll[last_login]</i></small></font> <img src='sliki/admin.gif' width='24' height='24' alt='$_COOKIE[authusername]'> <a href='izlez.php?logout=yes'><img src='sliki/exit.gif' width='24' height='24' alt='Izlez'></a> ]</font> </font></div><br>";
}
//------------------------------------------
//echo out a navigation panel
echo "
<center><a href='index.php'>Osvezi</a> | <a href='index.php?action=dodaj'>Dodaj Software</a> | <a href='napravi.php?action=kategorija'>Dodaj Nova Kategorija</a> | <a href='napravi.php?action=cd'>Dodaj - CD & DVD</a> | <a href='napravi.php'>Lista</a></center>
";
//------------------------------------------
//------------------------------------------
//begin main navigation (tutorials.php?action=)
switch($_GET['action'])
{
//------------------------------------------
//this case adds a soft.
//pretty self-explanitory
//------------------------------------------
case "dodaj":
//if the form to enter a new
//show it
if(!isset($_POST['dodaj']))
{
echo "
<br>
<div align='center'>
<table border='1' width='500' style='border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF' cellpadding='0'>
<form action='$self?action=dodaj' method='post'>
<tr>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080' bgcolor='#0099CC'><b>Sifra:</b></td>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080'><input type='text' name='sifra' disabled></td>
</tr>
<tr>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080' bgcolor='#0099CC'><b>Naslov:</b></td>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080'><input type='text' name='naslov'></td>
</tr>
<tr>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080' bgcolor='#0099CC'><b>Opis:</b></td>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080'><textarea name='opis' cols='40' rows='5'></textarea></td>
</tr>
<tr>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080' bgcolor='#0099CC'><b>Kategorija:</b></td>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080'>
<select name='kategorija'>
<option>- Izberi -</option>
";
//now what we are doing here is looping through
//the categorys table and getting all the
//categorys and putting them into a select
//so the user can select which category
//the tutorial is on
$query = mysql_query("SELECT * FROM software_kategorija ORDER BY id ASC") or die(mysql_error());
while($row = mysql_fetch_array($query))
{
echo "<option value='$row[id]'>$row[kategorija]";
}
echo "
</select>
</td>
</tr>
<tr>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080' bgcolor='#0099CC'><b>CD & DVD:</b></td>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080'>
<select name='cd'>
<option>- Izberi -</option>
";
//now what we are doing here is looping through
//the categorys table and getting all the
//categorys and putting them into a select
//so the user can select which category
//the tutorial is on
$query = mysql_query("SELECT * FROM software_cd ORDER BY id ASC") or die(mysql_error());
while($row = mysql_fetch_array($query))
{
echo "<option value='$row[id]'>$row[cd]";
}
echo "
</select>
</td>
</tr>
<tr>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080' bgcolor='#0099CC'><b>Novo?</b></td>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080'><input type='checkbox' name='novo' value='1' checked></td>
</tr>
<tr>
<td style='border-style: solid; border-width: 1px' bordercolor='#808080' colspan='2'><center><input type='submit' name='dodaj' value='Dodaj Nov Software'></center></td>
</tr>
</form>
</table>
";
}
//else, error check, enter it
elseif(isset($_POST['dodaj']))
{
$string = "123456789ABCDEFGHIJKLMNPQRSTUVWXYZ";
$sifra = "";
for($i=0; $i<5; $i++){
$y = rand(0,strlen($string)-1);
$sifra .= $string[$y];
}
$naslov = mysql_real_escape_string(strip_tags($_POST['naslov']));
$opis = mysql_real_escape_string(strip_tags($_POST['opis']));
$kategorija = mysql_real_escape_string(strip_tags($_POST['kategorija']));
$cd = mysql_real_escape_string(strip_tags($_POST['cd']));
$novo = mysql_real_escape_string($_POST['novo']);
$datum = date("d/m/Y");
//we begin error checking....
$error_msg = array();
if(empty($naslov))
{
$error_msg[] = "Please insert a naslov!<br />";
}
if(empty($opis))
{
$error_msg[] = "Please insert a opis!<br />";
}
if(empty($kategorija))
{
$error_msg[] = "Please insert a kategorija!<br />";
}
if(empty($cd))
{
$error_msg[] = "Please select CD!<br />";
}
//print the errors, if any
if(count($error_msg)>0)
{
echo "<strong>ERROR:</strong><br>\n";
foreach($error_msg as $err)
echo "$err";
}
//everythings ok, insert it to the DB
else
{
$sql = "INSERT INTO software (sifra, naslov, opis, kat_id, cd_id, novo, datum, validen) VALUES ('$sifra', '$naslov', '$opis', '$kategorija', '$cd', '$novo', '$datum', '1')";
mysql_query($sql) or die(mysql_error());
echo "<br><div align='center'><b>Softwerot e uspesno dodaden!</b></div>";
}
}
break;
//------------------------------------------
//this case gets the specified [ID] in the url
//(tutorials.php?action=viewcategory&id=[ID]
//and gets all the tutorials listed under that
//category ID (cat_id)
//------------------------------------------
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 "<br><div align='center'><b>Nema software vo ovaa Kategorija!</b></div>";
}
//else, there is..show em
else
{
//show all products
echo "<br>
<div align='center'>
<form action='index.php?action=brisi' method='post' name='delete'>
<table border='0' cellpadding='1' cellspacing='0' width='90%' style='border: 1px solid #336699'>
<tr>
<td>
<table border='0' width='100%' cellpadding='0'>
<tr>
<td bgcolor='#0099CC'><p align='center'><b><font size='4'><br>Pregled na Softwares<br> </font></b></td>
</tr>
</table>
<table border='0' width='100%' cellpadding='0'>
<tr>
<td width='55' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Sifra</td>
<td width='220' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Naslov</td>
<td width='350' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Opis</td>
<td width='20' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Kategorija</td>
<td width='30' style='border: 1px solid #0099CC' bgcolor='#0099CC'>CD</td>
<td width='20' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Novo?</td>
<td width='75' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Datum</td>
<td width='45' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Izmeni</td>
<td width='40' style='border: 1px solid #0099CC' bgcolor='#0099CC'>Izbrisi</td>
</tr>";
while($row = mysql_fetch_array($query))
{
echo "
<tr>
<td bgcolor='#668B8B'>$row[sifra]</td>
<td bgcolor='#668B8B'>$row[naslov]</td>
<td bgcolor='#668B8B'>$row[opis]</td>
<td bgcolor='#668B8B'>$row[kat_id]</td>
<td bgcolor='#668B8B'>$row[cd_id]</td>
<td bgcolor='#668B8B'>$row[novo]</td>
<td bgcolor='#668B8B'>$row[datum]</td>
<td bgcolor='#668B8B'><p align='center'><a href='izmeni.php?action=popravi&id=$row[id]'><img src='sliki/edit.gif' width='20' height='20'></a></td>
<td bgcolor='#668B8B'><p align='center'><input type='checkbox' name='row[]' value='$row[id]'></td>
</tr>";
}
echo "</table><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></form>";
}
}
else
{
echo "<br><div align='center'><b>Momentalno nema Softwares!</b></div>";
}
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(isset($_POST['delete']))
{
if(empty($_POST['row']))
{
echo "Nothing to delete!";
}
else
{
$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;
//------------------------------------------
//default case, this is shown default
//in this instance, we are going to make the default case show
//all the categories that you can view tutorials on
//------------------------------------------
default:
$query = mysql_query("SELECT * FROM software_kategorija") or die(mysql_error());
//if the number of rows returned is 0, then say, no categories
if(mysql_num_rows($query) == 0)
{
echo "Nema Kategorii!";
}
//if anything else, then there has to be categories. show em.
else
{
echo "<div align='center'><h1>Software Kategorii:</h1> ";
//while loop to loop through the database and display results!
while($row = mysql_fetch_array($query))
{
echo "
<table border='0' cellpadding = '0' cellspacing='0' width='500'>
<tr>
<td>Ime na Kategorijata:</td>
<td><b>$row[kategorija]</b></td>
</tr>
<tr>
<td><a href='$self?action=pregled&id=$row[id]'>Pogedni ja Kategorijata</a></td>
</tr>
<tr>
<td><hr /></td>
</tr>
</table>
</body>
";
}
}
break;
}
//end navigation
//------------------------------------------
?>
Kategoriju i CD-a
