	
<script type="text/javascript" >
$(document).ready(function() {
	/**
	 * GetData with ajax from wp backend
	 */
	function getData(data)
	{
		$.post(ajaxurl, data, function(response) {
			response=JSON.parse(response);
			//console.log( response);
			 var tbl_body = "";
			 $.each(response, function() {
				var tbl_row = "";
				$.each(this, function(k , v) {
				    tbl_row += "<td>"+v+"</td>";
				})
				tbl_body += "<tr>"+tbl_row+"</tr>";                 
			 })
			 $("#musicdbTable tbody").html(tbl_body);
		});
	}
	
	/**
	 * Get the Form data and send it to getData function
	 */
	function getFormData()
	{
		var formData = $('#searchData').serialize();
		var data = {
			'action': 'musicdb_query',
			'data': formData
		};

		getData(data);
	}
	
	// ACTIONS
	$( ":checkbox" ) .on( "click", getFormData );
	
	$( "#search1" ).keyup(function( event ) {
		getFormData();	
	});
	
	$( "#search2" ).keyup(function( event ) {
		getFormData();	
	});

	$( "#extraSearch" ).keyup(function( event ) {
		getFormData();	
	});
	
});
</script>
<style>
div.muzdb_title {
    font-size: 0.8em;
    margin-bottom: 15px;
    font-weight: bolder;
    background-color: #E5E5E5;
    padding-left: 5px;
    padding-top: 5px;
    padding-bottom: 5px;
    border-left: 1px solid #CCC;
    border-right: 1px solid #CCC;
    border-bottom: 1px solid #CCC;
}

table.cart th, #main-content table.cart th, table.cart td, #main-content table.cart td, table.cart tr, #main-content table.cart tr, #content-area table tr, #content-area table td, #content-area table th {
    padding: 0.2em 0.2em;
    max-width: 100px;
}

.page.et_pb_pagebuilder_layout #main-content {
  background-color: white;
}

</style>
<div class="muzdb_title">
	<span>
		Zoek in de Woudschoten muziek bibliotheek
	</span>
</div>
&nbsp;&nbsp;Specificeer in het zoekformulier en selecteer de gewenste opties
<form id="searchData">
<div>
<table class="muzdb_search">
	<tr>
		<td>
			<select name="Osearch1">
				<option value="componist" selected>Componist</option>
				<option value="titel">Titel</option>
			</select>
		</td>
		<td>
			<input type="text" name="search1" id="search1" />
		</td>
	</tr>
	<tr>
		<td>
			<select name="Osearch2">
				<option value="componist">Componist</option>
				<option value="titel" selected>Titel</option>
			</select>
		</td>
		<td>
			<input type="text" name="search2" id="search2" />
		</td>
	</tr>
</table>
</div>
<div class="muzdb_title">
	<span>
		Zoek op bezetting
	</span>
</div>
<div>
<table class="muzdb_cb">
<tr>
	<td><input type="checkbox"  name="cb1" id="cb1" value="acc" />  Accordeon</td>
	<td><input type="checkbox"  name="cb2" id="cb2" value="rec" /> Blokfluit</td>
	<td><input type="checkbox"  name="cb3" id="cb3" value="fl" />  Fluit</td>
	<td><input type="checkbox"  name="cb4" id="cb4" value="cl" />  Klarinet</td>
	<td><input type="checkbox"  name="cb5" id="cb5" value="trb" /> Trombone </td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb6" id="cb6" value="altfl" />  Altfluit</td>
	<td><input type="checkbox"  name="cb7" id="cb7" value="vc" />  Cello</td>
	<td><input type="checkbox"  name="cb8" id="cb8" value="git" />  Gitaar</td>
	<td><input type="checkbox"  name="cb9" id="cb9" value="pf" />  Piano</td>
	<td><input type="checkbox"  name="cb10" id="cb10" value="tp" />  Trompet</td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb11" id="cb11" value="ca" />  Althobo</td>
	<td><input type="checkbox"  name="cb12" id="cb12" value="cemb" /> Clavecimbel</td>
	<td><input type="checkbox"  name="cb13" id="cb13" value="arp" />  Harp</td>
	<td><input type="checkbox"  name="cb14" id="cb14" value="picc" />  Piccolo</td>
	<td><input type="checkbox"  name="cb15" id="cb15" value="tba" />  Tuba</td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb16" id="cb16" value="alt-cl" />  Altklarinet</td>
	<td><input type="checkbox"  name="cb17" id="cb17" value="cb" />  Contrabas</td>
	<td><input type="checkbox"  name="cb18" id="cb18" value="ob" />  Hobo</td>
	<td><input type="checkbox"  name="cb19" id="cb19" value="sax" />  Saxofoon</td>
	<td><input type="checkbox"  name="cb20" id="cb20" value="vl" />  Viool</td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb21" id="cb21" value="va" />  Altviool</td>
	<td><input type="checkbox"  name="cb22" id="cb22" value="fg" />  Fagot</td>
	<td><input type="checkbox"  name="cb23" id="cb23" value="hn" />  Hoorn</td>
	<td><input type="checkbox"  name="cb24" id="cb24" value="perc" />  Slagwerk/perc.</td>
	<td><input type="checkbox"  name="cb25" id="cb25" value="zang" />  Zang</td>
</tr>
<tr>
	<td colspan="5">Alternatief: <input type="text" name="extraSearch" id="extraSearch" /></td>
</tr>
</table>
</div>
</form>
<div class="muzdb_title">
	<span>
		Resultaat
	</span>
</div>
<table class="wp-list-table widefat fixed posts" id="musicdbTable">
			<thead>
				<tr>
					<th>Componist</th>
					<th>Titel</th>
					
					<th>Jaar compositie</th>
					<th>Stijl</th>
					
					<th>Bezettingstitel</th>
					<th>Bezetting</th>
					
					<th>Partituur</th>
					<th>Nummer</th>
					<th>Opmerkingen</th>
				
				</tr>
			</thead>
		<!--  	<tfoot>
				<tr>
						<th>Componist</th>
					<th>Titel</th>
					
					<th>Jaar compositie</th>
					<th>Stijl</th>
					
					<th>Bezettingstitel</th>
					<th>Bezetting</th>
					
					<th>Partituur</th>
					<th>Nummer</th>
					<th>Opmerkingen</th>
					</tr>
			</tfoot>-->
			<tbody>
		
		
			</tbody>
		</table>
		<script type="text/javascript" >
$(document).ready(function() {
	/**
	 * GetData with ajax from wp backend
	 */
	function getData(data)
	{
		$.post(ajaxurl, data, function(response) {
			response=JSON.parse(response);
			//console.log( response);
			 var tbl_body = "";
			 $.each(response, function() {
				var tbl_row = "";
				$.each(this, function(k , v) {
				    tbl_row += "<td>"+v+"</td>";
				})
				tbl_body += "<tr>"+tbl_row+"</tr>";                 
			 })
			 $("#musicdbTable tbody").html(tbl_body);
		});
	}
	
	/**
	 * Get the Form data and send it to getData function
	 */
	function getFormData()
	{
		var formData = $('#searchData').serialize();
		var data = {
			'action': 'musicdb_query',
			'data': formData
		};

		getData(data);
	}
	
	// ACTIONS
	$( ":checkbox" ) .on( "click", getFormData );
	
	$( "#search1" ).keyup(function( event ) {
		getFormData();	
	});
	
	$( "#search2" ).keyup(function( event ) {
		getFormData();	
	});

	$( "#extraSearch" ).keyup(function( event ) {
		getFormData();	
	});
	
});
</script>
<style>
div.muzdb_title {
    font-size: 0.8em;
    margin-bottom: 15px;
    font-weight: bolder;
    background-color: #E5E5E5;
    padding-left: 5px;
    padding-top: 5px;
    padding-bottom: 5px;
    border-left: 1px solid #CCC;
    border-right: 1px solid #CCC;
    border-bottom: 1px solid #CCC;
}

table.cart th, #main-content table.cart th, table.cart td, #main-content table.cart td, table.cart tr, #main-content table.cart tr, #content-area table tr, #content-area table td, #content-area table th {
    padding: 0.2em 0.2em;
    max-width: 100px;
}

.page.et_pb_pagebuilder_layout #main-content {
  background-color: white;
}

</style>
<div class="muzdb_title">
	<span>
		Zoek in de Woudschoten muziek bibliotheek
	</span>
</div>
&nbsp;&nbsp;Specificeer in het zoekformulier en selecteer de gewenste opties
<form id="searchData">
<div>
<table class="muzdb_search">
	<tr>
		<td>
			<select name="Osearch1">
				<option value="componist" selected>Componist</option>
				<option value="titel">Titel</option>
			</select>
		</td>
		<td>
			<input type="text" name="search1" id="search1" />
		</td>
	</tr>
	<tr>
		<td>
			<select name="Osearch2">
				<option value="componist">Componist</option>
				<option value="titel" selected>Titel</option>
			</select>
		</td>
		<td>
			<input type="text" name="search2" id="search2" />
		</td>
	</tr>
</table>
</div>
<div class="muzdb_title">
	<span>
		Zoek op bezetting
	</span>
</div>
<div>
<table class="muzdb_cb">
<tr>
	<td><input type="checkbox"  name="cb1" id="cb1" value="acc" />  Accordeon</td>
	<td><input type="checkbox"  name="cb2" id="cb2" value="rec" /> Blokfluit</td>
	<td><input type="checkbox"  name="cb3" id="cb3" value="fl" />  Fluit</td>
	<td><input type="checkbox"  name="cb4" id="cb4" value="cl" />  Klarinet</td>
	<td><input type="checkbox"  name="cb5" id="cb5" value="trb" /> Trombone </td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb6" id="cb6" value="altfl" />  Altfluit</td>
	<td><input type="checkbox"  name="cb7" id="cb7" value="vc" />  Cello</td>
	<td><input type="checkbox"  name="cb8" id="cb8" value="git" />  Gitaar</td>
	<td><input type="checkbox"  name="cb9" id="cb9" value="pf" />  Piano</td>
	<td><input type="checkbox"  name="cb10" id="cb10" value="tp" />  Trompet</td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb11" id="cb11" value="ca" />  Althobo</td>
	<td><input type="checkbox"  name="cb12" id="cb12" value="cemb" /> Clavecimbel</td>
	<td><input type="checkbox"  name="cb13" id="cb13" value="arp" />  Harp</td>
	<td><input type="checkbox"  name="cb14" id="cb14" value="picc" />  Piccolo</td>
	<td><input type="checkbox"  name="cb15" id="cb15" value="tba" />  Tuba</td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb16" id="cb16" value="alt-cl" />  Altklarinet</td>
	<td><input type="checkbox"  name="cb17" id="cb17" value="cb" />  Contrabas</td>
	<td><input type="checkbox"  name="cb18" id="cb18" value="ob" />  Hobo</td>
	<td><input type="checkbox"  name="cb19" id="cb19" value="sax" />  Saxofoon</td>
	<td><input type="checkbox"  name="cb20" id="cb20" value="vl" />  Viool</td>
</tr>
<tr>
	<td><input type="checkbox"  name="cb21" id="cb21" value="va" />  Altviool</td>
	<td><input type="checkbox"  name="cb22" id="cb22" value="fg" />  Fagot</td>
	<td><input type="checkbox"  name="cb23" id="cb23" value="hn" />  Hoorn</td>
	<td><input type="checkbox"  name="cb24" id="cb24" value="perc" />  Slagwerk/perc.</td>
	<td><input type="checkbox"  name="cb25" id="cb25" value="zang" />  Zang</td>
</tr>
<tr>
	<td colspan="5">Alternatief: <input type="text" name="extraSearch" id="extraSearch" /></td>
</tr>
</table>
</div>
</form>
<div class="muzdb_title">
	<span>
		Resultaat
	</span>
</div>
<table class="wp-list-table widefat fixed posts" id="musicdbTable">
			<thead>
				<tr>
					<th>Componist</th>
					<th>Titel</th>
					
					<th>Jaar compositie</th>
					<th>Stijl</th>
					
					<th>Bezettingstitel</th>
					<th>Bezetting</th>
					
					<th>Partituur</th>
					<th>Nummer</th>
					<th>Opmerkingen</th>
				
				</tr>
			</thead>
		<!--  	<tfoot>
				<tr>
						<th>Componist</th>
					<th>Titel</th>
					
					<th>Jaar compositie</th>
					<th>Stijl</th>
					
					<th>Bezettingstitel</th>
					<th>Bezetting</th>
					
					<th>Partituur</th>
					<th>Nummer</th>
					<th>Opmerkingen</th>
					</tr>
			</tfoot>-->
			<tbody>
		
		
			</tbody>
		</table>
		{"id":363,"date":"2014-07-29T19:31:27","date_gmt":"2014-07-29T20:31:27","guid":{"rendered":"http:\/\/zomercursuswoudschoten.nl\/wordpress\/?page_id=363"},"modified":"2023-08-07T19:28:09","modified_gmt":"2023-08-07T20:28:09","slug":"muziek-bibliotheek","status":"publish","type":"page","link":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363","title":{"rendered":"Muziekbibliotheek"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; collapsed=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-363","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Muziekbibliotheek - Zomer Cursus Woudschoten<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Muziekbibliotheek - Zomer Cursus Woudschoten\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363\" \/>\n<meta property=\"og:site_name\" content=\"Zomer Cursus Woudschoten\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-07T20:28:09+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"[musicdb]\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363\",\"url\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363\",\"name\":\"Muziekbibliotheek - Zomer Cursus Woudschoten\",\"isPartOf\":{\"@id\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/#website\"},\"datePublished\":\"2014-07-29T20:31:27+00:00\",\"dateModified\":\"2023-08-07T20:28:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Muziekbibliotheek\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/#website\",\"url\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/\",\"name\":\"Zomer Cursus Woudschoten\",\"description\":\"Zomer Cursus Woudschoten\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"nl-NL\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Muziekbibliotheek - Zomer Cursus Woudschoten","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"nl_NL","og_type":"article","og_title":"Muziekbibliotheek - Zomer Cursus Woudschoten","og_url":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363","og_site_name":"Zomer Cursus Woudschoten","article_modified_time":"2023-08-07T20:28:09+00:00","twitter_card":"summary_large_image","twitter_description":"[musicdb]","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363","url":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363","name":"Muziekbibliotheek - Zomer Cursus Woudschoten","isPartOf":{"@id":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/#website"},"datePublished":"2014-07-29T20:31:27+00:00","dateModified":"2023-08-07T20:28:09+00:00","breadcrumb":{"@id":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?page_id=363#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/"},{"@type":"ListItem","position":2,"name":"Muziekbibliotheek"}]},{"@type":"WebSite","@id":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/#website","url":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/","name":"Zomer Cursus Woudschoten","description":"Zomer Cursus Woudschoten","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"nl-NL"}]}},"_links":{"self":[{"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=\/wp\/v2\/pages\/363"}],"collection":[{"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=363"}],"version-history":[{"count":7,"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=\/wp\/v2\/pages\/363\/revisions"}],"predecessor-version":[{"id":2975,"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=\/wp\/v2\/pages\/363\/revisions\/2975"}],"wp:attachment":[{"href":"https:\/\/nieuw.vriendenzomercursuswoudschoten.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}