• css
• hip1
  • .vscode
    • 4.1.php
  • 4.2
    • navigation_bar.html
    • page1.php
    • page2.php
    • page3.php
  • 11.2
    • firstpage.php
    • secondpage.php
  • 11.4
    • 11.4.html
    • 11.4.php
  • 11.5
    • page1.html
    • page2.php
    • page3.php
  • 11.9
    • 11.9.html
    • 11.9.php
  • 14.8
    • 14.8A.php
    • auteurs.php
    • timestuff.php
    • uitleningen.php
  • 16.2
    • ajax.php
    • info.php
    • main.php
  • po
    • cssmap
    • js
    • songs
      • text.php
    • albuminfo.php
    • albums.php
    • bandinfo.php
    • bandlist.php
    • concertinfo.php
    • concerts.php
    • functions.php
    • index.php
    • list.php
    • memberinfo.php
    • memberlist.php
    • songplayer.php
  • 10.1.php
  • 10.2.php
  • 10.3.php
  • 10.4.php
  • 11.1.php
  • 11.3.php
  • 11.6.php
  • 11.7.php
  • 11.8.php
  • 11.9.php
  • 12.php
  • 14.1.php
  • 14.2.php
  • 14.3.php
  • 14.4.php
  • 14.5.php
  • 14.6.php
  • 14.7.php
  • 15.1.php
  • 15.2.php
  • 15.php
  • 4.1.php
  • 6.1.php
  • 6.2.php
  • 6.3.php
  • 6.4.php
  • 7.1.php
  • 7.2.php
  • 7.3.php
  • 7.4.php
  • 7.5.php
  • 7.6.php
  • 9.1.php
  • 9.2.php
  • 9.3.php
  • 9.4.php
  • db.php
  • index.php
  • simonkoster.txt
  • test.php
• hip2
  • .vscode
  • afbeeldingen
  • css
  • db.php
  • gamedetails.php
  • games.php
  • genre.php
  • genres.php
  • home.php
  • index.php
  • leden.php
  • liddetails.php
  • menu.php
  • platformen.php
  • reviews.php
• hip3
• img
• javascriptcursus
  • _notes
  • css
    • _notes
  • img
    • _notes
    • screenshots
      • _notes
  • js
    • _notes
  • php
    • _notes
    • admin
      • _notes
      • answers.php
      • assignments.php
      • delete_assignment.php
      • edit_assignment.php
      • home.php
      • logout.php
      • new_assignment.php
    • geshi
      • _notes
      • contrib
        • _notes
        • aliased.php
        • cssgen.php
        • cssgen2.php
        • example.php
        • langcheck.php
        • langwiz.php
      • docs
        • _notes
        • api
          • __filesource
            • _notes
            • fsource_geshi_core_geshi.php.html
          • _notes
          • geshi
            • core
              • _notes
              • GeSHi.html
              • _geshi.php.html
          • media
            • _notes
            • images
              • _notes
          • blank.html
          • classtrees_geshi.html
          • elementindex.html
          • elementindex_geshi.html
          • errors.html
          • index.html
          • li_geshi.html
          • packages.html
          • todolist.html
        • geshi-doc.html
        • geshi-doc.txt
      • geshi
        • _notes
        • 4cs.php
        • 6502acme.php
        • 6502kickass.php
        • 6502tasm.php
        • 68000devpac.php
        • abap.php
        • actionscript.php
        • actionscript3.php
        • ada.php
        • algol68.php
        • apache.php
        • applescript.php
        • apt_sources.php
        • asm.php
        • asp.php
        • autoconf.php
        • autohotkey.php
        • autoit.php
        • avisynth.php
        • awk.php
        • bascomavr.php
        • bash.php
        • basic4gl.php
        • bf.php
        • bibtex.php
        • blitzbasic.php
        • bnf.php
        • boo.php
        • c.php
        • c_loadrunner.php
        • c_mac.php
        • caddcl.php
        • cadlisp.php
        • cfdg.php
        • cfm.php
        • chaiscript.php
        • cil.php
        • clojure.php
        • cmake.php
        • cobol.php
        • coffeescript.php
        • cpp-qt.php
        • cpp.php
        • csharp.php
        • css.php
        • cuesheet.php
        • d.php
        • dcs.php
        • delphi.php
        • diff.php
        • div.php
        • dos.php
        • dot.php
        • e.php
        • ecmascript.php
        • eiffel.php
        • email.php
        • epc.php
        • erlang.php
        • euphoria.php
        • f1.php
        • falcon.php
        • fo.php
        • fortran.php
        • freebasic.php
        • fsharp.php
        • gambas.php
        • gdb.php
        • genero.php
        • genie.php
        • gettext.php
        • glsl.php
        • gml.php
        • gnuplot.php
        • go.php
        • groovy.php
        • gwbasic.php
        • haskell.php
        • hicest.php
        • hq9plus.php
        • html4strict.php
        • html5.php
        • icon.php
        • idl.php
        • ini.php
        • inno.php
        • intercal.php
        • io.php
        • j.php
        • java.php
        • java5.php
        • javascript.php
        • jquery.php
        • kixtart.php
        • klonec.php
        • klonecpp.php
        • latex.php
        • lb.php
        • lisp.php
        • llvm.php
        • locobasic.php
        • logtalk.php
        • lolcode.php
        • lotusformulas.php
        • lotusscript.php
        • lscript.php
        • lsl2.php
        • lua.php
        • m68k.php
        • magiksf.php
        • make.php
        • mapbasic.php
        • matlab.php
        • mirc.php
        • mmix.php
        • modula2.php
        • modula3.php
        • mpasm.php
        • mxml.php
        • mysql.php
        • newlisp.php
        • nsis.php
        • oberon2.php
        • objc.php
        • objeck.php
        • ocaml-brief.php
        • ocaml.php
        • oobas.php
        • oracle11.php
        • oracle8.php
        • oxygene.php
        • oz.php
        • pascal.php
        • pcre.php
        • per.php
        • perl.php
        • perl6.php
        • pf.php
        • php-brief.php
        • php.php
        • pic16.php
        • pike.php
        • pixelbender.php
        • pli.php
        • plsql.php
        • postgresql.php
        • povray.php
        • powerbuilder.php
        • powershell.php
        • proftpd.php
        • progress.php
        • prolog.php
        • properties.php
        • providex.php
        • purebasic.php
        • pycon.php
        • python.php
        • q.php
        • qbasic.php
        • rails.php
        • rebol.php
        • reg.php
        • robots.php
        • rpmspec.php
        • rsplus.php
        • ruby.php
        • sas.php
        • scala.php
        • scheme.php
        • scilab.php
        • sdlbasic.php
        • smalltalk.php
        • smarty.php
        • sql.php
        • systemverilog.php
        • tcl.php
        • teraterm.php
        • text.php
        • thinbasic.php
        • tsql.php
        • typoscript.php
        • unicon.php
        • uscript.php
        • vala.php
        • vb.php
        • vbnet.php
        • verilog.php
        • vhdl.php
        • vim.php
        • visualfoxpro.php
        • visualprolog.php
        • whitespace.php
        • whois.php
        • winbatch.php
        • xbasic.php
        • xml.php
        • xorg_conf.php
        • xpp.php
        • yaml.php
        • z80.php
        • zxbasic.php
      • geshi.php
    • adminpage.php
    • assignments.php
    • bookpage.php
    • chapter_titles.php
    • meekrodb.2.3.class.php
    • page.php
  • admin.php
  • hoofdstuk_1.php
  • hoofdstuk_10.php
  • hoofdstuk_11.php
  • hoofdstuk_2.php
  • hoofdstuk_3.php
  • hoofdstuk_4.php
  • hoofdstuk_5.php
  • hoofdstuk_6.php
  • hoofdstuk_7.php
  • hoofdstuk_8.php
  • hoofdstuk_9.php
  • index.php
  • inhoudsopgave.php
  • links.php
  • opdrachten.php
  • playground-preview.php
  • playground.php
  • voorbeeld.php
• l100
  • Lessen
    • les 1.php
    • menu.html
  • opdrachten
    • 4.1.php
    • 4.2.1.html
    • 4.2.1.php
    • 4.2.2.html
  • db.php
  • index.php
  • svenvanderberg.txt
• l101
  • lessen
    • les1.php
    • les1menu.html
  • opdrachten
    • H4
      • 4.1.php
      • 4.2.php
    • 4.1.php
    • 4.2.html
    • 4.2.php
  • db.php
  • frisoderuiter.txt
  • index.php
• l102
  • .vscode
  • db.php
  • index.php
  • thorstenkorving.txt
• l103
  • DestanYildirim.txt
  • db.php
  • index.php
  • les1.php
  • menu.html
• l104
  • 4.1.php
  • 4.2.php
  • db.php
  • index.php
  • menu.html
  • ryankobus.txt
• l105
  • H4
    • 1.php
  • klas 5
    • P2
      • phpserver
        • H4
          • 4.2
            • menu.html
            • website 1.php
            • website 2.php
  • db.php
  • index.php
  • jedidjafabriek.txt
• l106
  • werkmap
    • aan elkaar
      • 1efile.php
      • hoem.php
      • idk.php
      • nynm.php
    • nog een file.php
  • Mats Rooijakkers.txt
  • db.php
  • index.php
• l107
  • phpserver
    • Opdrachten
      • H4
        • 4.2
          • hoofdpagina.php
          • menu.php
        • 4.1.php
  • KaiHolzinger.txt
  • db.php
  • index.php
• l108
  • 4.1.php
  • Daan_Schmitz.txt
  • db.php
  • index.php
• l109
  • db.php
  • index.php
• l110
  • db.php
  • index.php
• l111
  • db.php
  • index.php
• l112
  • db.php
  • index.php
• l113
  • .vscode
  • db.php
  • index.php
• l114
  • db.php
  • index copy.php
  • index.php
• l115
  • db.php
  • index.php
• l116
  • db.php
  • index.php
• l117
  • db.php
  • index.php
• l118
  • index.php
• l119
  • db.php
  • index.php
• l120
  • db.php
  • index.php
• l200
  • Hoofdstuk 4
    • 4.1.php
    • 4.2.php
    • menu.php
    • pag1.php
    • pag2.php
    • pag3.php
  • Hoofdstuk 6
    • 6.2.6.1.php
    • 6.2.6.2.php
    • 6.2.6.3.php
  • db.php
  • index.php
  • marielleharte.txt
• l201
  • JaydenHillebrandt.txt
  • db.php
  • index.php
• l202
  • 4.1.php
  • 6.1-4.php
  • db.php
  • index.php
  • markvossebeld.txt
  • menu.php
• l203
  • db.php
  • index.php
• l204
  • db.php
  • index.php
  • nawarkodaesat.txt
  • vastevoettekst.php
  • voorbeeld.php
• l205
  • db.php
  • index.php
  • matteoxu.txt
• l206
  • db.php
  • index.php
  • nisrinefaress.txt
• l207
  • db.php
  • index.php
• l208
  • db.php
  • index.php
• l209
  • db.php
  • index.php
• l210
  • db.php
  • index.php
• l211
  • db.php
  • index.php
• l212
  • db.php
  • index.php
• l213
  • db.php
  • index.php
• l214
  • db.php
  • index.php
• l215
  • db.php
  • index.php
• test
  • fcgi
    • test.html
  • perl
    • test.html
  • php
    • test.html
    • test.php
  • python
    • test.html
  • ssi
    • test.html
• x100
  • .vscode
  • A3.php
  • B2.php
  • C2.php
  • D2.php
  • E1.php
  • H4.php
  • I1_1.php
  • I1_2.php
  • K1.php
  • L1.php
  • M1.php
  • SachaDubbelman_V5.txt
  • db.php
  • index.php
• x101
  • A4.php
  • B1.php
  • C2.php
  • D2.php
  • E1.php
  • F4.php
  • MatsRooijakkers_V5c.txt
  • db.php
  • index.php
• x102
  • .vscode
  • A4.php
  • B1.php
  • D2.php
  • D6.php
  • F4.php
  • H4.php
  • I1.php
  • I1_1.php
  • I1_2.php
  • chahidachamlal_v5.txt
  • db.php
  • index.php
• x103
  • A4.php
  • I1_1.php
  • I1_2.php
  • I2_1.php
  • J2_1.php
  • J2_2.php
  • K3_1.php
  • L2_1.php
  • L2_2.php
  • M1_1.php
  • M1_2.php
  • MaxBoesBoxem_V5b.txt
  • db.php
  • index.php
• x104
  • A3.php
  • D1.php
  • DestanYildirim_VWO5.txt
  • E1.php
  • F1.php
  • H1.php
  • J1_1.php
  • J1_2.php
  • L1.php
  • db.php
  • index.php
• x105
  • .vscode
    • db.php
  • A4.php
  • B1.php
  • C2.php
  • CamielvanVliet_vwo5.txt
  • F1.php
  • H3.php
  • I1_1.php
  • I1_2.php
  • db.php
  • index.php
• x106
  • .vscode
  • A1.php
  • A3.php
  • B1.php
  • C1.php
  • D2.php
  • E1.php
  • F.php
  • F1.php
  • G1.php
  • H2.php
  • H3.php
  • K1.php
  • M.php
  • WoutvanLuijn_vwo5.txt
  • db.php
  • i1.php
  • index.php
• x107
  • A4.php
  • B1.php
  • C1.php
  • D2.php
  • E1.php
  • F.php
  • F2.php
  • G1.php
  • PascalPieters_VWO.txt
  • db.php
  • index.php
• x108
  • .vscode
    • B1_X108.php
    • B6_X108.php
  • Python Bestanden
    • .ipynb_checkpoints
  • A1.php
  • B2.php
  • C2.php
  • D2.php
  • E2.php
  • F4.php
  • G1.php
  • H4.php
  • I2_1.php
  • I2_2.php
  • J1.php
  • K3.php
  • db.php
  • index.php
  • pepijnbookelaar_V5.txt
• x109
  • .vscode
  • A3.php
  • B1.php
  • C2.php
  • D1.php
  • F2.php
  • H2.php
  • antoinesie_v5.txt
  • db.php
  • index.php
• x110
  • A4.php
  • B1.php
  • C1.php
  • D2.php
  • E1.php
  • F1.php
  • F2.php
  • H2.php
  • MerlijnEggink_v5.txt
  • db.php
  • index.php
• x111
  • .vscode
  • Python Bestanden
    • .ipynb_checkpoints
      • namen-checkpoint.txt
  • A4.php
  • B2.php
  • C2.php
  • D2.php
  • E2.php
  • F3.php
  • H2.php
  • db.php
  • index.php
  • okkeloman_V5.txt
• x112
  • .vscode
  • A4.php
  • B1.php
  • C2.php
  • D2.php
  • E1.php
  • F1.php
  • G1.php
  • H2.php
  • I1_1.php
  • I1_2.php
  • J2.php
  • OtKrewinkel_V5.txt
  • db.php
  • index.php
• x113
  • A3.php
  • B2.php
  • C2.php
  • D2.php
  • E1.php
  • F2.php
  • H4.php
  • I1.php
  • J1.php
  • L1.php
  • index.php
  • syb.txt
• x114
  • index.php
• x115
  • A1.php
  • B2.php
  • C2.php
  • D2.php
  • E2.php
  • J1.php
  • db.php
  • index.php
• 100
• 123456
  • .vscode
  • H5 2425
    • H6.php
    • les1.php
    • les1b.php
  • V5 2425
    • les1.php
  • ajax
  • db.php
  • footer.html
  • index.php
  • js.html
  • les.php
• index.php
• wf.php

hip1/po/bandinfo.php

Hide
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<div><a href='index.php'>Return to search</a></div>
<body>
    <?php
    include('../db.php');
    include('functions.php');
    #Display band name
    $band_id = $_GET['band_id'];
    $query1 = "select * from bands where band_id = $band_id";
    $result1 = mysqli_query($db, $query1) or die(mysqli_error($db));
    $row1 = mysqli_fetch_array($result1);
    echo "<h1>$row1[name]</h1>
    <div>Formed in: $row1[found_year]</div>";
    if($row1['disb_year']){
        echo "<div>Disbanded in: $row1[disb_year]</div>";
    }
    else{
        echo "<div>Currently active</div>";
    }
    #Display current band members
    $query2 = "select * from band_members bm, members m where band_id = $band_id and year_left is null and bm.member_id = m.member_id order by first_name, last_name, artist_name";
    $result2 = mysqli_query($db, $query2) or die(mysqli_error($db));
    echo "<h3>Current members:</h3>";
    while($row2 = mysqli_fetch_array($result2)){
        $fullname = nameDetermine($row2);
        echo "<h4><a href=memberinfo.php?member_id=$row2[member_id]>$fullname</a></h4>";
        #Display band specific information on the member
        echo "<div>Year joined: ";
        if($row2['year_joined']){
            echo $row2['year_joined'];
        }
        else{
            echo "unknown";
        }
        echo "</div>
        <div>Instruments: ";
        $textdisplay = "";
        $query3 = "select * from instrument_bm ibm, instruments i where bandm_id = ".$row2['bandm_id']." and ibm.instrument_id = i.instrument_id order by i.instrument_id";
        $result3 = mysqli_query($db, $query3) or die(mysqli_error($db));
        while($row3 = mysqli_fetch_array($result3)){
            $textdisplay = $textdisplay.$row3['instrument_name'].", ";
        }
        $textdisplay = substr_replace($textdisplay, "", strlen($textdisplay)-2, 2);
        echo "$textdisplay</div>";
    }
    #Display past band members
    $query4 = "select * from band_members bm, members m where band_id = $band_id and year_left is not null and bm.member_id = m.member_id order by first_name, last_name, artist_name";
    $result4 = mysqli_query($db, $query4) or die(mysqli_error($db));
    echo "<h3>Past members:</h3>";
    while($row4 = mysqli_fetch_array($result4)){
        $fullname = nameDetermine($row4);
        echo "<h4><a href=memberinfo.php?member_id=$row4[member_id]>$fullname</a></h4>";
        #Display band specific information on the member
        echo "<div>Year joined: ";
        if($row4['year_joined']){
            echo $row4['year_joined'];
        }
        else{
            echo "unknown";
        }
        echo "</div>
        <div>Year left: $row4[year_left]</div>
        <div>Instruments: ";
        $textdisplay = "";
        $query5 = "select * from instrument_bm ibm, instruments i where bandm_id = ".$row4['bandm_id']." and ibm.instrument_id = i.instrument_id order by i.instrument_id";
        $result5 = mysqli_query($db, $query5) or die(mysqli_error($db));
        while($row5 = mysqli_fetch_array($result5)){
            $textdisplay = $textdisplay.$row5['instrument_name'].", ";
        }
        $textdisplay = substr_replace($textdisplay, "", strlen($textdisplay)-2, 2);
        echo "$textdisplay</div>";
    }
    #Display up to 5 albums
    $query6 = "select * from albums where band_id = $band_id order by release_date DESC, album_id";
    $result6 = mysqli_query($db, $query6) or die(mysqli_error($db));
    echo "<h3>Albums: <p><a href=albums.php?band_id=$band_id>Show all</a></p></h3>";
    $albumshow=0;
    while($row6 = mysqli_fetch_array($result6)){
        $albumshow+=1;
    }
    if($albumshow>5){
        $albumshow=5;
    }
    $result6 = mysqli_query($db, $query6) or die(mysqli_error($db));
    for($i=0; $i<$albumshow; $i++){
        $row6 = mysqli_fetch_array($result6);
        $date = convertdate($row6['release_date']);
        echo "<div><a href=albuminfo.php?album_id=$row6[album_id]>$row6[name]</a> ($date)<p>Type: $row6[type]</p></div>";
    }
    $query7 = "select * from concerts c, concert_bands cb where band_id = $band_id and cb.concert_id = c.concert_id order by concert_date DESC, cb.concert_id";
    $result7 = mysqli_query($db, $query7) or die(mysqli_error($db));
    echo "<h3>Concerts: <p><a href=concerts.php?band_id=$band_id>Show all</a></p></h3>";
    $concertshow=0;
    while($row7 = mysqli_fetch_array($result7)){
        $concertshow+=1;
    }
    if($concertshow>3){
        $concertshow=3;
    }
    $result7 = mysqli_query($db, $query7) or die(mysqli_error($db));
    for($i=0; $i<$concertshow; $i++){
        $row7 = mysqli_fetch_array($result7);
        $date = convertdate($row7['concert_date']);
        echo "<div><a href=concertinfo.php?concert_id=$row7[concert_id]>$row7[location]</a> ($date)</div>";
    }
    ?>
</body>
</html>

Resultaat