ah okee en viel het mee?
weet je al het verschil tussen een int en een varchar?
[size=xsmall]
Toevoeging op 29/10/2012 21:33:54:[/size]
Sander ik heb even een gewijzigde tabel structuur naar je pm gestuurd.
[size=xsmall]
Toevoeging op 29/10/2012 21:37:48:[/size]
<?php
// zet vragen op de hoogste name="x" waarde ofwel het aantal vragen.
error_reporting(E_ALL);
$user = array('user_id' => 0, 'user_name' => '', 'user_email' => '');
if(isset($_POST['user_name'])) $user['user_name'] = $_POST['user_name'];
if(isset($_POST['user_email'])) $user['user_email'] = $_POST['user_email'];
$connection = connect();
function connect() {
$connection = mysql_connect("localhost","root","")
or die ('request "Unable to connect to MySQL server."');
$db = mysql_select_db("test", $connection)
or die ('request "Unable to select database."');
return $connection;
}
function validate() {
return true;
}
function getuserinfo($connection) {
$email = strtolower(mysql_real_escape_string($_POST['user_email']));
$name = strtolower(mysql_real_escape_string($_POST['user_name']));
$sql = "SELECT * FROM user_accounts WHERE user_email='".$email."'";
$result = mysql_query($sql, $connection);
if(mysql_num_rows($result) == 1) {
return mysql_fetch_assoc($result);
}
if(filter_var($email, FILTER_VALIDATE_EMAIL)) {
$sql = "INSERT INTO user_accounts VALUES ('', '".$name."', '".$email."')";
if($result = mysql_query($sql, $connection))
return array('user_id' => mysql_insert_id($connection), 'user_name' => $name, 'user_email' => $email);
}
return 0;
}
function savetodatabase($connection) {
global $user;
$sql = "DELETE FROM event_presence WHERE visitor_id=".$user['user_id'];
$result = mysql_query($sql, $connection);
$sql = "SELECT MAX(id) AS max FROM `events`";
$result = mysql_query($sql, $connection);
$row = mysql_fetch_assoc($result);
$max = $row['max'];
for($i = 1 ; $i <= $max ; $i++) {
if(isset($_POST[$i])) {
$sql = "INSERT INTO event_presence VALUES ('".$i."', '".$user['user_id']."', '".$_POST[$i]."')";
mysql_query($sql, $connection);
}
}
}
if($_SERVER['REQUEST_METHOD'] == 'POST') {
$user = getuserinfo($connection);
if(isset($_POST['save'])){
if(validate())
savetodatabase($connection);
}
}
$sql = "SELECT * FROM events LEFT JOIN event_presence ON id = event_id AND visitor_id=".$user['user_id'];
$result = mysql_query($sql, $connection);
?>
<!DOCTYPE html>
<html>
<body>
<form name="input" action="test.php" method="post">
<p class="naam">
<label>Uw naam:
<input type="text" name="user_name" id="user_name" value="<?php echo $user['user_name']; ?>" />
</label>
<label>Uw e-mail adres:
<input type="text" name="user_email" id="user_email" value="<?php echo $user['user_email']; ?>" />
</label>
<input type="submit" name="load" id="load" value="Haal mijn lijst op" />
</p>
<?php if($user['user_id']) { ?>
<table class="mytable">
<tr>
<th>datum</th>
<th>activiteit</th>
<th>zaal open</th>
<th>aanvang</th>
<th>lokatie</th>
<th>Deelname</th>
</tr>
<?php while($row = mysql_fetch_assoc($result)) { ?>
<tr>
<td><? echo $row['event_date']; ?></td>
<td><? echo $row['event_name']; ?></td>
<td><? echo $row['event_open']; ?></td>
<td><? echo $row['event_start']; ?></td>
<td><? echo $row['event_location']; ?></td>
<td>
<label><input type="radio"<? if($row['present'] == 'ja') echo ' checked="checked"';
?> name="<? echo $row['id']; ?>" value="ja" />Ja</label><br />
<label><input type="radio"<? if($row['present'] == 'nee') echo ' checked="checked"';
?> name="<? echo $row['id']; ?>" value="nee" />Nee</label><br />
<label><input type="radio"<? if($row['present'] == 'misschien') echo ' checked="checked"';
?> name="<? echo $row['id']; ?>" value="misschien" />Misschien</label>
</td>
</tr>
<?php } ?>
</table>
<input type="submit" name="save" value="Opslaan">
<?php } else { ?>
email verplicht invullen!
<?php } ?>
</form>
</body>
</html>
