Notice: Undefined index: afdeling in C:\xampp\htdocs\training\training_toevoegen.php on line 16
Notice: Undefined index: afdeling in C:\xampp\htdocs\training\class\training.php on line 34
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\training\class\training.php on line 34
training_toevoegen.php
<?php
include "class/afdeling.php";
include "class/subafdeling.php";
include "class/categorie.php";
include "class/subcategorie.php";
include "class/type_training.php";
include "class/training.php";
$err=false;
if(isset($_POST['submit'])){
$training_id=mysql_escape_string($_POST['tid']);
$training_naam=mysql_escape_string($_POST['training']);
$beschrijving=mysql_escape_string($_POST['beschrijving']);
$afdeling=mysql_escape_string($_POST['afdeling']);
$training = new training();
$training_toevoegen = $training->training_toevoegen($training_id,$training_naam,$beschrijving);
$training_afdeling_toevoegen = $training->training_afdeling($afdeling,$training_id);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="stylesheet" type="text/css" href="stylesheet.css" />
</head>
<body>
<form name="servForm" action="<?php $PHP_SELF; ?>" method="post" >
<div>
<table border="0">
<tr>
<?php
$training = new training();
$nieuw_id = $training->select_laatste_training();
?>
<td><input type="hide" name="tid" readonly="readonly" value="<?php echo $nieuw_id; ?>" style="text-align:right" /></td>
</tr>
<tr><td><input type="text" name="training" size="30" /></td></tr>
<tr><td><input type="text" name="beschrijving" size="30" /></td><td>
<?php
$afdeling = new afdeling();
$resultaat = $afdeling->select_afdelingen();
if($resultaat){
$a = 0;
while($row = mysql_fetch_array($resultaat))
{
if($a++ %5 == 0) echo "<tr>";
?>
<td align="center"><input type="checkbox" name="afdeling[]" value="<?php echo $row['id']; ?>" /></td>
<td style="text-align:left"><?php echo $row["afdeling"]; ?></td>
<?php
if($a %5 == 0) echo "</tr>";
}
}
?>
<tr>
<td><label>
<input type="submit" name="submit" value="Toevoegen" />
</label></td>
</tr>
</form>
class: training.php
<?php
require_once 'Singleton.php';
class training {
public $training_id, $training, $beschrijving;
protected $connect;
protected $sql;
public function __construct() {
$this->connect = Singleton::getconnect();
}
public function __destruct() {
$this->connect = null;
}
public function select_laatste_training() {
$query = "SELECT id, naam_training AS training, beschrijving AS beschrijving FROM training ORDER BY id DESC LIMIT 1";
$resultaat = mysql_query($query);
$rij = mysql_fetch_array($resultaat);
return $rij["id"] + 1;
}
public function training_toevoegen($training_id,$training,$beschrijving){
$subafdeling="INSERT INTO training SET id='".$training_id."',naam_training='".$training."', beschrijving='".$beschrijving."'";
return $resultaat_subafdeling=mysql_query($subafdeling);
}
public function training_afdeling($afdeling,$training_id){
foreach($_POST["afdeling"] as $afdeling)
{
$query = "INSERT INTO training_afdeling(afdeling_id, training_id) VALUES('$afdeling', '$training_id')";
$result7 = mysql_query($query);
}
}
}
?>
