<table width="100%" border=1>
<tr>
<td colspan="2">Добавени категории до момента</td>
</tr>
<?php
include ("../config.php");
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query="SELECT * FROM `kategorii` ORDER BY cats ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$cats=mysql_result($result,$i,"cats");
$id_cat=mysql_result($result,$i,"id_cat");
echo "<tr><td width=80%>$cats</td><td width=20%><a href=pro.php?page=del&id_cat=$id_cat>Изтрии</a></td></tr>";
$i++;
}
?>
</table>
<br>
<br>
<table border=0>
<form action=pro.php?page=addcat method=post name=form>
<tr>
<td>Категория</td>
<td><input name=cats type=text class=form size="50"></td>
</tr>
<tr>
<td> <br></td>
<td><input type=submit name=Submit value=Добави class=form></td>
</tr>
</table>
</form>
<?php
if($_POST['Submit']){
$cats = $_POST['cats'];
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query = "INSERT INTO `kategorii` ( `id_cat` , `cats`)
VALUES (
'NULL', '$cats'
);";
$ok = mysql_query($query);
if($ok){
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=pro.php?page=addcat\">";
}else{
echo "Възникна грешка";
}
};
?>
