Beispiel #1
0
</h2>

        <form action="edit_product.php?product= <?php 
echo urlencode($current_product["id"]);
?>
" method="post">
        <p>Menu Name:
              <input type="text" name="menu_name" value = "<?php 
echo htmlentities($current_product["menu_name"]);
?>
" />
        </p>
        <p>Position :
	    <select name = "position">
             <?php 
$product_set = find_products_for_windows($current_product["subject_id"]);
$product_count = mysqli_num_rows($product_set);
//  if($product_count!=0)
//	{
for ($count = 1; $count <= $product_count + 1; $count++) {
    echo "<option value=\"{$count}\"";
    if ($current_product["position"] == $count) {
        echo "selected";
    }
    echo ">{$count}</option>";
}
//		}
//	else
//		{
//		 echo   "<option value=" ;
//		 echo $product_count+1;
Beispiel #2
0
<?php

require_once "../includes/session.php";
require_once "../includes/db_connection.php";
require_once "../includes/functions.php";
$current_window = find_window_by_id($_GET["window"], false);
if (!$current_window) {
    redirect_to("manage_content.php");
}
$product_set = find_products_for_windows($current_window["id"]);
if (mysqli_num_rows($product_set) > 0) {
    $_SESSION["message"] = "Can't delete a subject with products.";
    redirect_to("new_window.php?window = {$current_window["id"]}");
}
$id = $current_window["id"];
$query = "DELETE FROM  windows WHERE id = {$id} LIMIT 1";
$result = mysqli_query($conn, $query);
if ($result && mysqli_affected_rows($conn) == 1) {
    $_SESSION["message"] = "Window deleted.";
    redirect_to("manage_content.php");
} else {
    $_SESSION["message"] = "Window deletion failed.";
    redirect_to("new_window.php?window = {$id}");
}
?>

Beispiel #3
0
function public_navigation($window_array, $product_array)
{
    $output = "<ul class= \" windows \" >";
    $window_set = find_all_windows();
    while ($windows = mysqli_fetch_assoc($window_set)) {
        $output .= "<li ";
        $output .= " >";
        $output .= "<a ";
        if ($window_array && $windows["id"] == $window_array["id"]) {
            $output .= " class=\"selected\"";
        }
        $output .= " href =\"index.php?window=";
        $output .= urlencode($windows["id"]);
        $output .= " \">";
        $output .= htmlentities($windows["menu_name"]);
        $output .= " </a>";
        if ($window_array["id"] == $windows["id"] || $product_array["subject_id"] == $windows["id"]) {
            $product_set = find_products_for_windows($windows["id"]);
            $output .= "<ul id=\"products\">";
            while ($products = mysqli_fetch_assoc($product_set)) {
                $output .= "<li ";
                if ($product_array && $products["id"] == $product_array["id"]) {
                    $output .= " class= \"selected\" ";
                }
                $output .= ">";
                $output .= " <a href = \"index.php?product= ";
                $output .= urlencode($products["id"]);
                $output .= " \">";
                $output .= htmlentities($products["menu_name"]);
                $output .= " </a></li>";
            }
            $output .= " </ul>";
            mysqli_free_result($product_set);
        }
        $output .= "</li>";
    }
    mysqli_free_result($window_set);
    $output .= "</ul>";
    return $output;
}