Treba da napravim stranicu koja treba da sadrzi dropdown listu sa svim zanrovima (koje uzima iz tabele zanr, baze Biblioteka). Kako da "uhvatim" žanr koji korisnik odabere prije pritiska na submit dugme? U mom kodu ima neka greška, ali ne znam koja.
Code:
<?php require_once("includes/session.php"); ?>
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php //confirm_logged_in(); ?>
<?php include("includes/header.php"); ?>
<?
include_once("includes/form_functions.php");
if (isset($_POST['submit'])) {
$ime = trim(mysql_prep($_POST['zanr']));
echo $ime;
$result = del_zanr($ime);
if ($result) {
$message = "žanr '{$ime}' je uspješno obrisan.";
} else {
$message = "žanr ne može da se izbriše.";
$message .= "<br />" . mysql_error();
}
} ?>
<table id="structure">
<tr>
<td id="page">
<?php if ($sel_page) { ?>
<h2><?php echo htmlentities($sel_page['menu_name']); ?></h2>
<div class="page-content">
<?php echo strip_tags(nl2br($sel_page['sadrzaj']), "<b><br><p><a>"); ?>
</div>
<?php } else { ?>
<h2>Odaberi žanr</h2>
<form action="del_zanr.php" method="post">
<table>
<?php $ime=dropdown("Odaberi žanr", "ime", "ime", "zanr", "ime", "zanr");
$ime = $_POST[zanr];
?>
<br /><br />
<tr>
<td colspan="2"><input type="submit" name="submit" value="Izbriši žanr" /></td>
</tr>
</table>
</form>
<?php } ?>
</td>
</tr>
</table>
<?php include("includes/footer.php"); ?>
<?php require_once("includes/session.php"); ?>
<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php //confirm_logged_in(); ?>
<?php include("includes/header.php"); ?>
<?
include_once("includes/form_functions.php");
if (isset($_POST['submit'])) {
$ime = trim(mysql_prep($_POST['zanr']));
echo $ime;
$result = del_zanr($ime);
if ($result) {
$message = "žanr '{$ime}' je uspješno obrisan.";
} else {
$message = "žanr ne može da se izbriše.";
$message .= "<br />" . mysql_error();
}
} ?>
<table id="structure">
<tr>
<td id="page">
<?php if ($sel_page) { ?>
<h2><?php echo htmlentities($sel_page['menu_name']); ?></h2>
<div class="page-content">
<?php echo strip_tags(nl2br($sel_page['sadrzaj']), "<b><br><p><a>"); ?>
</div>
<?php } else { ?>
<h2>Odaberi žanr</h2>
<form action="del_zanr.php" method="post">
<table>
<?php $ime=dropdown("Odaberi žanr", "ime", "ime", "zanr", "ime", "zanr");
$ime = $_POST[zanr];
?>
<br /><br />
<tr>
<td colspan="2"><input type="submit" name="submit" value="Izbriši žanr" /></td>
</tr>
</table>
</form>
<?php } ?>
</td>
</tr>
</table>
<?php include("includes/footer.php"); ?>
Funkcija dropdown:
Code:
function dropdown($tekst,$pk, $atrib1, $strTableName, $strOrderField, $strNameOrdinal, $strMethod="asc") {
echo "<select name=\"$strNameOrdinal\">\n";
echo "<option value=\"NULL\">$tekst</option>\n";
$strQuery = "select $pk, $atrib1
from $strTableName
order by $strOrderField $strMethod";
$rsrcResult = mysql_query($strQuery);
while($arrayRow = mysql_fetch_assoc($rsrcResult)) {
$strA = $arrayRow["$pk"];
$strB = $arrayRow["$atrib1"];
echo "<option value=\"$pk\">$strB</option>\n";
}
echo "</select>";
}
function dropdown($tekst,$pk, $atrib1, $strTableName, $strOrderField, $strNameOrdinal, $strMethod="asc") {
echo "<select name=\"$strNameOrdinal\">\n";
echo "<option value=\"NULL\">$tekst</option>\n";
$strQuery = "select $pk, $atrib1
from $strTableName
order by $strOrderField $strMethod";
$rsrcResult = mysql_query($strQuery);
while($arrayRow = mysql_fetch_assoc($rsrcResult)) {
$strA = $arrayRow["$pk"];
$strB = $arrayRow["$atrib1"];
echo "<option value=\"$pk\">$strB</option>\n";
}
echo "</select>";
}