Waarde weergevens in dropdown.
de callsign staat in een sessie wanneer iemand is ingelogt.
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?php
if($_POST['type'] == "Single Battle"){
echo' <br><center>';
echo' <form method="post">';
echo' Select Loser:';
echo' <br><br>';
echo' <select name="loser" id="loser">';
//Get singles from database
$sql = "SELECT callsign FROM users";
$res = mysql_query($sql) or die (mysql_error());
while($list = mysql_fetch_object($res)) {
echo' <option value="'.$list->callsign.'">'.$list->callsign.'</option>';
}
echo' </select>';
echo' <br><br>';
echo' <input name="submit1" type="submit" id="submit1" value="Next" />';
echo' </form></center>';
tablefooter();
}
?>
if($_POST['type'] == "Single Battle"){
echo' <br><center>';
echo' <form method="post">';
echo' Select Loser:';
echo' <br><br>';
echo' <select name="loser" id="loser">';
//Get singles from database
$sql = "SELECT callsign FROM users";
$res = mysql_query($sql) or die (mysql_error());
while($list = mysql_fetch_object($res)) {
echo' <option value="'.$list->callsign.'">'.$list->callsign.'</option>';
}
echo' </select>';
echo' <br><br>';
echo' <input name="submit1" type="submit" id="submit1" value="Next" />';
echo' </form></center>';
tablefooter();
}
?>
1: Checken in de query:
Code (php)
1
2
2
$sql = "SELECT callsign FROM users WHERE callsign <> '" . mysql_escape_string($_SESSION['callsign']) . "'";
of
2: Checken wanneer je de callsigns print:
Code (php)
1
2
3
4
2
3
4
while($list = mysql_fetch_object($res))
if ($_SESSION['callsign'] != $list->callsign) {
echo' <option value="'.$list->callsign.'">'.$list->callsign.'</option>';
}
if ($_SESSION['callsign'] != $list->callsign) {
echo' <option value="'.$list->callsign.'">'.$list->callsign.'</option>';
}
Verder nog een tip:
Gebruik als je 'variabele data,' zoals dus de callsign, print in HTML de functie htmlentities. Anders krijg je problemen met de callsign "<SUF>Mouzz" of zo...
dus:
Code (php)
1
echo '<option value="' . htmlentities($list->callsign) . '">' . htmlentities($list->callsign) . '</option>';
Gewijzigd op 01/01/1970 01:00:00 door Maarten