ilmoittaudu.php kaavake:

<form action="register_function" method="post">
  <table id="form"><tr><td class="label"><label for="name">Nimi:</label></td>
  <td><input type="text" id="name" name="name" /></td></tr></br>
  <tr><td class="label"><label for="email">Sähköpostiosoite:</label></td>
  <td><input type="text" id="email" name="email" /></td></tr></br>
  <tr><td class="label"><label for="nick">Nimimerkki:</label></td>
  <td><input type="text" id="nick" name="nick" /></td></tr></br>
  <tr><td class="label"><label for="message">Kerro itsestäsi:</label></td>
  <td><textarea id="comments" name="message" rows="5"></textarea></td></tr></br>
  <tr><td>&nbsp;</td><td><button type="submit">Ilmottaudu!</button></td></tr>
  </table>
</form>

register_function.php:

<?php

// Open database connection
$conn = mysql_connect('localhost', 'skfin', 'salasanatähän');
mysql_select_db('skfin');

// Data cleaning function
function clean_data($string) {
  if (get_magic_quotes_gpc()) {
    $string = stripslashes($string);
  }
  $string = strip_tags($string);
  return mysql_real_escape_string($string);
}

// Pick up the cleaned form data
$name = clean_data($_POST['name']);
$email = clean_data($_POST['email']);
$nick = clean_data($_POST['nick']);
$message = clean_data($_POST['message']);

$query = "INSERT INTO registeration (name, email, nick, message) VALUES ('$name', '$email', '$nick', '$message')";
mysql_query($query);

// Close connection
mysql_close($conn);


header("Location: kiitos"); // MOVE THIS TO BOTTOM OF THE SCRIPT WHEN USED!!!

admin.php form:

<form action="attendee" method="post">
  <table id="form"><tr><td class="label"><label for="user">User:</label></td>
  <td><input type="text" id="user" name="user" /></td></tr></br>
  <tr><td class="label"><label for="password">Password:</label></td>
  <td><input type="password" id="password" name="password" /></td></tr></br>
  <tr><td>&nbsp;</td><td><button type="submit">Use the force</button></td></tr>
  </table>
</form>

attendee.php tietojen haku:

<?php
$user = $_POST['user'];
$password = $_POST['password'];

// Open database connection
$conn = mysql_connect('localhost', $user, $password);
mysql_select_db('skfin');

$query  = "SELECT name, email, nick, message FROM registeration";
$result = mysql_query($query);

while(list($name,$email,$nick,$message)= mysql_fetch_row($result))
{
    echo "Nimi:&nbsp;&nbsp;&nbsp;$name <br>" .
         "Sähköpostiosoite:&nbsp;&nbsp;&nbsp;$email <br>" .
         "Nimimerkki:&nbsp;&nbsp;&nbsp;$nick <br>" .
         "Kerro itsestäsi:&nbsp;&nbsp;&nbsp;$message <br><br>";
}
mysql_close($conn);
?>