Kunnen jullie ff kijken? Bedankt...
<?php
error_reporting(E_ALL);
session_start();
?>
<html>
<html>
<head>
<title>Ere-Die-Voetbal</title>
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body>
<div id="border">
<div id="navcontainer">
<ul id="navlist">
<li id="active"><a href="voetbalsite.php" id="current">Onze Producten</a></li>
<li><a href=".html">Voetbalnieuwtjes</a></li>
<li><a href=".html">Het hoe en wat van de Site</a></li>
<li><a href=".html">Links naar andere Sites</a></li>
</ul>
</div>
<a href="index.php"><div id="header"></div></a>
<center>
<h1>Producten</h1>
<?php
$connection = mysql_connect("localhost", "root", "")
or die ("Couldn't connect to server");
$db = mysql_select_db("voetbal", $connection)
or die ("Couldn't connect to server");
//Om de verschillende categorieen te krijgen, gebruik "SELECT DISTINCT categorie FROM product"
/*
** CATEGORY
*/
$query = "SELECT * FROM product";
// Selecteer de waarde uit het formulier
if(isset($_POST['cat']) && $_POST['cat'] != "NULL"){
$query = "SELECT * FROM product WHERE categorie='".$_POST['cat']."'";
$_SESSION['selectedCat'] = $_POST['cat'];
// Selecteer de waarde uit de sessie
}elseif(isset($_SESSION['selectedCat']) && !isset($_POST['cat'])){
$query = "SELECT * FROM product WHERE categorie='".$_SESSION['selectedCat']."'";
// Selecteer alles
}else{
$_SESSION['selectedCat'] = 'NULL';
}
/*
** SPELERSNAAM
*/
// Selecteer de waarde uit het formulier
if(isset($_POST['naam']) && $_POST['naam'] != "NULL"){
$query = "SELECT * FROM product WHERE productID LIKE '%".$_POST['naam']."%'";
$_SESSION['selectedProduct'] = $_POST['naam'];
// Selecteer de waarde uit de sessie
}elseif(isset($_SESSION['selectedProduct']) && !isset($_POST['naam'])){
$query = "SELECT * FROM product WHERE productID LIKE '%".$_SESSION['selectedProduct']."%'";
// Selecteer alles
}else{
$_SESSION['selectedProduct'] = 'NULL';
}
$resultLijst = mysql_query($query)
or die("Query failed: ".mysql_error());
// Formulier een
echo '<form id="formOne" name="formOne" action="'.$_SERVER['PHP_SELF'].'" method="post">'."\r\n";
echo "<h4>Type product:</h4>\r\n";
echo '<select name="cat">'."\r\n";
echo '<option value="NULL">Maak een keuze</option>\r\n';
$query = "SELECT DISTINCT categorie FROM product";
$result = mysql_query($query)
or die("Query failed: ".mysql_error());
while ($row = mysql_fetch_array($result)) {
if(isset($_SESSION['selectedCat']) && $_SESSION['selectedCat'] == $row['categorie']){
$selected = " selected";
}else{
$selected = "";
}
echo "<option value=".$row['categorie']." ".$selected.">".$row['categorie']."</option>\r\n";
}
echo "</select>\r\n";
echo "<input type='submit' name='submit' value='Verstuur'>";
echo "</form>";
// Formulier twee
if(isset($_SESSION['selectedCat']) && $_SESSION['selectedCat'] != "NULL"){
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';
echo "<h4>Naam van de Speler / Team:</h4>";
echo '<select name="naam">';
echo '<option value="NULL">Maak een keuze</option>';
$query = "SELECT ProductID, naam FROM product WHERE categorie = '".$_SESSION['selectedCat']."';";
$result = mysql_query($query)
or die("Query failed: ".mysql_error());
while ($row = mysql_fetch_array($result)) {
if(isset($_SESSION['selectedProduct']) && $_SESSION['selectedProduct'] == $row['ProductID']){
$selected = " selected";
}else{
$selected = "";
}
echo "<option value=".$row['ProductID']." ".$selected.">".$row['naam']."</option>\r\n";
}
echo "</select>";
echo "<input type='submit' name='submit' value='Verstuur'>";
echo "</form>";
}
//Bestellen
/*if(isset($_POST['verstuur'])){
echo 'Naam: '.$_POST['naam'].'<br>
Bestelde Zwaard: '.$_POST['zwaard'].'<br>
Aantal: '.$_POST['aantal'];
}
*/
// Print de resultaten
echo "<TABLE BORDER='2'>";
echo "<TR>";
echo "<TH>Naam</TH><TH>Omschrijving</TH><TH>Categorie</TH>";
echo "</TR>";
while ($row = mysql_fetch_array($resultLijst))
{
echo "<TR>";
echo "<TD>", $row['naam'], "</TD><TD>", $row['beschrijving'], "</TD><TD>", $row['categorie'],"</TD>";
echo "</TR>";
}
echo "</TABLE></center>";
mysql_close($connection);
?>
<a href="bestellen.php?bestellen=1">Bestel SNEL!</a>
<div id="content"></div>
<div id="Eindmarkering">-== Deze Site is gemaakt door Tim Stork & Severijn Heijmans ==-</div>
</div>
</body>
</html>
****Volgende bestandje bestellen.php****
<?php
error_reporting(E_ALL);
session_start();
?>
<html>
<html>
<head>
<title>Ere-Die-Voetbal / Bestellen</title>
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body>
<div id="border">
<div id="navcontainer">
<ul id="navlist">
<li id="active"><a href="voetbalsite.php" id="current">Onze Producten</a></li>
<li><a href=".html">Voetbalnieuwtjes</a></li>
<li><a href=".html">Het hoe en wat van de Site</a></li>
<li><a href=".html">Links naar andere Sites</a></li>
</ul>
</div>
<a href="index.php"><div id="header"></div></a>
<div id="content">
<?php
$connection = mysql_connect("localhost", "root", "");
$db = mysql_select_db("voetbal", $connection)
or die ("Couldn't connect to server");
$_SESSION['mijnWagentje'] = array();
if(isset($_GET['bestellen']) && $_GET['bestellen'] == 1 ){
$_SESSION['mijnWagentje'][] = $_SESSION['selectedProduct'];
}
if(isset($_GET['bestellen'])){
echo "<a href=\"bestellen.php\">";
echo "Opslaan in winkelwagentje!";
echo "</a>";
}
foreach($_SESSION['mijnWagentje'] as $wagen){
}
echo "Type Product: ".$_SESSION['selectedCat'];
echo "<br>";
echo "Naam Product: ";
$query = "SELECT * FROM product WHERE productID=".$_SESSION['selectedProduct'];
$result = mysql_query($query)
or die("Query failed: ".mysql_error());
while ($row = mysql_fetch_array($result)) {
if(isset($_SESSION['selectedProduct']) && $_SESSION['selectedProduct'] == $row['ProductID']){
$selected = " selected";
}else{
$selected = "";
}
echo "->".$row['naam']."\r\n";
}
mysql_close($connection);
?>
</div>
<div id="Eindmarkering">-== Deze Site is gemaakt door Tim Stork & Severijn Heijmans ==-</div>
</body>
</html>
