<?php
/*
ein formular auf dem wir neue einträge in 
die Teilnehmer Tabelle machen 

tln_namen
tln_birthday
tln_height
tln_gen_id

+ post formular
+ radio button group 
*/

$db = oci_connect('hr', 'hr', 'kurs2.wifi');
if (empty($_POST)) { 
  
  $sql = "select gen_id, gen_name from gender";
  $q = oci_parse($db, $sql);
  $r = oci_execute($q, OCI_DEFAULT);
  $table = array();  
  while ($row = oci_fetch_array($q, OCI_ASSOC)) { 
    $table[] = $row;	
  }   
  
?>
<h2>Insert Teilnehmer</h2>
<form class="form-horizontal" role="form" 
    action='<?php $PHP_SELF; ?>' method='post'>
  <label for="name" >Name</label>
  <input type='text' name='name'/><br>
  <label for="height" >Height</label>
  <input type='text' name='height'/><br>
  <label for="birthday" >Birthday</label>
  <input type='text' name='birthday'/><br>
  <div class="form-group">  
    <?php foreach ($table as $gen) {
printf("<input type='radio' name='gender' value='%s'>%s</input>\n", 
	     $gen['GEN_ID'], $gen['GEN_NAME']);	   
	} 
	?>  
  
  </div>  
  <div class="col-sm-offset-2 col-sm-10">
    <input type="submit" value="Suchen" class="btn"/> 
  </div>
</form>
<?php
} else {
$sql = 
"insert into teilnehmer (
  tln_id,
  tln_name,
  tln_height,
  tln_birthday,
  tln_gen_id
  ) values (
  seq.nextval,
  :b_tln_name,
  :b_tln_height,
  to_date(:b_tln_birthday, 'yyyy.mm.dd'),
  :b_tln_gender
  )";
           
  $q = oci_parse($db, $sql);
  
  /*
  foreach ($_POST as $name => $value) {
    oci_bind_by_name($q, ":b_tln_".$name,  $value );
	echo "$name $value<br>\n";
  }	
  */
  oci_bind_by_name($q, ":b_tln_name",  $_POST['name'] );
  oci_bind_by_name($q, ":b_tln_height",  $_POST['height'] );
  oci_bind_by_name($q, ":b_tln_birthday",  $_POST['birthday'] );
  oci_bind_by_name($q, ":b_tln_gender",  $_POST['gender'] );

  try {
    $r = oci_execute($q);
  } catch (Exception $e) {
    echo "Warning?";
	# print_r($e);
  }
}