<?php
if (isset($_GET['prijsvraag']) && !isset($_POST['search'])) {
if ($_GET['prijsvraag']) {
echo '<div id=prijsvraagcontainer>';
echo '<div class=header>';
echo '<h2>Prijsvraag</h2>';
echo '<div class=line></div>';
echo '</div>';
echo '<div class=prijsvraag>';
echo '<img src=' . getElementById(97, "image") . '></img>';
echo '<div class=rankbutton>97</div>' . '<h2>' . utf8_encode(getElementById(97, 'artist')) . ' : ' . utf8_encode(getElementById(97, 'title')) . '</h2>';
echo '<div class=context> Test Test </div>';
echo '<div class=vraag><h3>VRAAG </h3> Hoeveel nummers heeft Cast Roméo & Juliette gemaakt?</div>';
echo '</div>';
echo '<div class=header>';
echo '<h2>Doe mee aan de prijsvraag</h2>';
echo '<div class=line></div>';
echo '</div>';
echo '<div class=form>';
echo '<form method="post" action="#" >';
echo '<label>Naam</label>';
echo '<br/>';
echo '<input name=naam type=text required maxlength="40">';
echo '<br/>';
echo '<label>E-mail <div id="gray">(wordt niet verspreid)</div></label>';
echo '<br/>';
echo '<input name=email type=email required maxlength="40">';
echo '<br/>';
echo '<label>Antwoord</label>';
echo '<br/>';
City: <input id="form_city" type="text" name="city" value=""><br>
Postal code: <input id="form_postc" type="text" name="postc" value=""><br>
Phone: <input id="form_phone" type="text" name="phone"value=""><br>
<input type="submit"/>
</form>
<button onclick="populate()">GO</button><br>
<p>Create New Customer</p>
<p>Search a Car</p>
<p>Rent a Car for Customer</p>
<script type="text/javascript">
function populate(){
<?php
$querystring = 'SELECT * FROM customer WHERE customer.CID= "' . document . getElementById("form_id") . value . '"';
$query = mysqli_query($con, $querystring);
$info = mysqli_fetch_array($query);
?>
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
document.getElementById("form_fname").value="WHOA";
}
</script>
</div>
<?php
if (!isset($_GET['songperday']) && !isset($_POST['search']) && !isset($_GET['prijsvraag']) && !isset($_GET['detail']) && !isset($_GET['id'])) {
if (isset($_GET['completetop100'])) {
$r = mt_rand(1, 100);
for ($i = 100; $i > 0; $i--) {
if ($i >= $r) {
echo '<a href=index.php?detail=true&id=' . $i . '>' . '<div class=boxred style="display:inline-block; margin-left:' . (mt_rand(1, 3) / 10 + 0.13) * 6 . '%">' . getElementById($i, 'id') . '</div>' . '<div id=contexttop100>' . '<span class=red>' . utf8_encode(getElementById($i, 'artist')) . ": " . utf8_encode(getElementById($i, 'title') . '</span>' . '</div></a>');
echo '<br>';
} else {
echo '<a href=index.php?detail=true&id=' . $i . '>' . '<div class=boxgray style="display:inline-block; margin-left:' . (mt_rand(1, 3) / 10 + 0.13) * 6 . '%">' . getElementById($i, 'id') . '</div>' . '<div id=contexttop100>' . '<span class=grey>' . utf8_encode(getElementById($i, 'artist')) . ": " . utf8_encode(getElementById($i, 'title') . '</span>' . '</div></a>');
echo '<br>';
}
}
}
}
if (isset($title)) {
if (contains(getElementById($i, 'title'), $_POST['search'])) {
if ($foundamount < 26) {
echo utf8_encode(getElementById($i, 'artist')) . ": " . utf8_encode(getElementById($i, 'title'));
echo '<br>';
echo '<br>';
$found = true;
}
$foundamount++;
}
}
$artist = getElementById($i, 'artist');
if (isset($artist)) {
if (contains(getElementById($i, 'artist'), $_POST['search'])) {
if ($foundamount < 26) {
echo utf8_encode(getElementById($i, 'artist')) . ": " . utf8_encode(getElementById($i, 'title'));
echo '<br>';
echo '<br>';
$found = true;
}
$foundamount++;
}
}
}
if (!$found) {
echo 'No result for ' . utf8_encode($_POST['search']);
} else {
echo '<br>';
echo 'Displaying ' . ($foundamount < 26 ? $foundamount : 25) . ($foundamount > 1 ? " items " : " item ") . " out of " . $foundamount . ($foundamount > 1 ? " items " : " item ") . ".";
}
}
}
if ($id != 100) {
$nextid = $id + 1;
}
if (isset($previousid)) {
echo '<a href=index.php?detail=true&id=' . $previousid . '>' . '<div class=previousid>' . $previousid . '</div></a>';
}
echo '<br>';
echo '<div class=currentid> ' . $id . '</div>' . '<br><span class="title">' . utf8_encode(getElementById($id, 'title')) . '</span>';
echo '<br>';
if (isset($nextid)) {
echo '<a href=index.php?detail=true&id=' . $nextid . '>' . '<div class=nextid>' . $nextid . '</div></a>';
}
echo '<div class=videocontainer>';
echo '<iframe width="100%" height="100%"
src=' . getElementById($id, 'youtube') . '>
</iframe>';
echo '</div>';
echo '<br>';
echo '</div>';
echo '<div class=comments>';
echo '<br/>';
echo '<h3>Reageer op dit bericht</h3>';
echo '<div class=line></div>';
echo '<form method=post action="#">';
echo '<br/>';
echo '<label>Naam</label>';
echo '<br/>';
echo '<input type=text name=name maxlength="255" required>';
echo '<br/><br/>';
echo '<label>E-mail<span class="gray"> (wordt niet getoond)</span></label>';
echo '<div id="songwrapper">';
echo '<img src="' . getElementById($i, 'image') . '" alt=image class=imagesong>';
echo '<a href=index.php?detail=true&id=' . $i . '>' . '<div class="rankbutton">' . $i . '</div>' . '<div class=title>' . utf8_encode(getElementById($i, 'title')) . '</div>' . '</a>';
echo '<br>';
echo '<div class=context>' . utf8_encode(getElementById($i, 'context')) . '</div>';
echo '<br>';
echo '</div>';
}
break;
}
} else {
echo 'Je moet nog wachten tot morgen wanneer je dit kan zien.';
break;
}
} else {
echo 'Input more songs.';
break;
}
} else {
for ($i = 100; $i > 95; $i -= 1) {
echo '<div id="songwrapper">';
echo '<img src="' . getElementById($i, 'image') . '" alt=image class=imagesong>';
echo '<a href=index.php?detail=true&id=' . $i . '>' . '<div class="rankbutton">' . $i . '</div>' . '<div class=title>' . utf8_encode(getElementById($i, 'title')) . '</div>' . '</a>';
echo '<br>';
echo '<div class=context>' . utf8_encode(getElementById($i, 'context')) . '</div>';
echo '<br>';
echo '</div>';
}
}
}
}
