#include <infodrom.style>
#include <debian.style>
#include "party.style"

<page title="Debian Birthday Party -- Sign on">

<h1 align=center>Debian Birthday Party</h1>

<p>Please sign on if you would like to attend so we can organize
enough food and fluids for you.  We don't want you to die on
starvation at the party, that'd hurt the project too much.</p>

<p>The party will cost you about &euro;&nbsp;15.00.</p>

<form method=post action=insert.php3>

<br><input name=name type=text size=50 maxlen=100> <b>Name</b> 
<br><input name=email type=text size=50 maxlen=100> <b>E-Mail</b>
<br><input name=city type=text size=50 maxlen=100> <b>City</b>
<br><input name=country type=text size=50 maxlen=100> <b>Country</b>
<br><select name=food>
<option value="meat">anything
<option value="vegetarian">vegetarian
<option value="vegan">vegan
</select> <b>Food</b>
<br><select name=type>
<option value="Developer">Debian Developer
<option value="User">Debian User
<option value="Geek">Regular Geek
<option value="Guest" selected>Guest
</select> <b>Type</b>
<br><?
  $dbh = pg_pconnect ("<dbconnstring>")
	       or die("Unable to connect to SQL server");

  $query  = "SELECT day,weekday FROM party_dates ORDER BY day";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
    $row = pg_fetch_array ($sth, $nr);

    printf ("<input name=\"%s\" value=\"1\" type=\"checkbox\"> %s&nbsp;&nbsp;",
	   $row['day'], $row['weekday']);
  }
?> <b>Days</b>

<br><input type=submit value="Sign on">
</form>

<h3>Things to take with you</h3>

<ul>
<li> Sleeping bag, camping mat
#<li> plate, mug, knife, fork
<li> additional non-default fluids or food
<li> if computer then network and power connectors
</ul>

</page>

# Local variables:
# mode: html
# mode: auto-fill
# end: