R16 Bestuur

[insert_php]
require_once(“_regio/regio16.php”);
[/insert_php]

Regio 16 bestuur

[insert_php]

require_once(“_Regio_includes/config.php”);

// Create connection
$conn = new mysqli(DB_SERVER, DB_USER, DB_PASS, DB_NAME);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}

$sql = “SELECT voorzitter,v_adres,v_post_woonpl,v_tel,v_tel2,v_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Voorzitter = $row[‘voorzitter’];

$R16VAdres = $row[‘v_adres’];

$R16VPost_Woonpl = $row[‘v_post_woonpl’];

$R16VTel = $row[‘v_tel’];

$R16VTel2 = $row[‘v_tel2’];

$R16VMail = $row[‘v_mail’];

}

$sql = “SELECT vvoorzitter,vv_adres,vv_post_woonpl,vv_tel,vv_tel2,vv_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16VVoorzitter = $row[‘vvoorzitter’];

$R16VVAdres = $row[‘vv_adres’];

$R16VVPost_Woonpl = $row[‘vv_post_woonpl’];

$R16VVTel = $row[‘vv_tel’];

$R16VVTel2 = $row[‘vv_tel2’];

$R16VVMail = $row[‘vv_mail’];

}

$sql = “SELECT Secretaris,s_adres,s_post_woonpl,s_tel,s_tel2,s_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Secretaris = $row[‘Secretaris’];

$R16SAdres = $row[‘s_adres’];

$R16SPost_Woonpl = $row[‘s_post_woonpl’];

$R16STel = $row[‘s_tel’];

$R16STel2 = $row[‘s_tel2’];

$R16SMail = $row[‘s_mail’];

}

$sql = “SELECT Penningmeester,p_adres,p_post_woonpl,p_tel,p_tel2,p_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Penningmeester = $row[‘Penningmeester’];

$R16PAdres = $row[‘p_adres’];

$R16PPost_Woonpl = $row[‘p_post_woonpl’];

$R16PTel = $row[‘p_tel’];

$R16PTel2 = $row[‘p_tel2’];

$R16PMail = $row[‘p_mail’];

}

$sql = “SELECT Lid1,l1_adres,l1_post_woonpl,l1_tel,l1_tel2,l1_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Lid1 = $row[‘Lid1’];

$R16L1Adres = $row[‘l1_adres’];

$R16L1Post_Woonpl = $row[‘l1_post_woonpl’];

$R16L1Tel = $row[‘l1_tel’];

$R16L1Tel2 = $row[‘l1_tel2’];

$R16L1Mail = $row[‘l1_mail’];

}

$sql = “SELECT Lid2,l2_adres,l2_post_woonpl,l2_tel,l2_tel2,l2_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Lid2 = $row[‘Lid2’];

$R16L2Adres = $row[‘l2_adres’];

$R16L2Post_Woonpl = $row[‘l2_post_woonpl’];

$R16L2Tel = $row[‘l2_tel’];

$R16L2Tel2 = $row[‘l2_tel2’];

$R16L2Mail = $row[‘l2_mail’];

}

$sql = “SELECT Lid3,l3_adres,l3_post_woonpl,l3_tel,l3_tel2,l3_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Lid3 = $row[‘Lid3’];

$R16L3Adres = $row[‘l3_adres’];

$R16L3Post_Woonpl = $row[‘l3_post_woonpl’];

$R16L3Tel = $row[‘l3_tel’];

$R16L3Tel2 = $row[‘l3_tel2’];

$R16L3Mail = $row[‘l3_mail’];

}

$sql = “SELECT Lid4,l4_adres,l4_post_woonpl,l4_tel,l4_tel2,l4_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Lid4 = $row[‘Lid4’];

$R16L4Adres = $row[‘l4_adres’];

$R16L4Post_Woonpl = $row[‘l4_post_woonpl’];

$R16L4Tel = $row[‘l4_tel’];

$R16L4Tel2 = $row[‘l4_tel2’];

$R16L4Mail = $row[‘l4_mail’];

}

$sql = “SELECT Ledenraad,l_adres,l_post_woonpl,l_tel,l_tel2,l_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Ledenraad = $row[‘Ledenraad’];

$R16LAdres = $row[‘l_adres’];

$R16LPost_Woonpl = $row[‘l_post_woonpl’];

$R16LTel = $row[‘l_tel’];

$R16LTel2 = $row[‘l_tel2’];

$R16LMail = $row[‘l_mail’];

}

// naam redactie en 1e redactielid

$sql = “SELECT Redactie,r_naam,r_adres,r_post_woonpl,r_tel,r_tel2,r_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Rnaam = $row[‘r_naam’];

$R16Redactie = $row[‘Redactie’];

$R16RAdres = $row[‘r_adres’];

$R16RPost_Woonpl = $row[‘r_post_woonpl’];

$R16RTel = $row[‘r_tel’];

$R16RTel2 = $row[‘r_tel2’];

$R16RMail = $row[‘r_mail’];

}

$sql = “SELECT Redactie_L1,rl1_adres,rl1_post_woonpl,rl1_tel,rl1_tel2,rl1_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Redactie_L1 = $row[‘Redactie_L1’];

$R16RL1Adres = $row[‘rl1_adres’];

$R16RL1Post_Woonpl = $row[‘rl1_post_woonpl’];

$R16RL1Tel = $row[‘rl1_tel’];

$R16RL1Tel2 = $row[‘rl1_tel2’];

$R16RL1Mail = $row[‘rl1_mail’];

}

$sql = “SELECT Redactie_L2,rl2_adres,rl2_post_woonpl,rl2_tel,rl2_tel2,rl2_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Redactie_L2 = $row[‘Redactie_L2’];

$R16RL2Adres = $row[‘rl2_adres’];

$R16RL2Post_Woonpl = $row[‘rl2_post_woonpl’];

$R16RL2Tel = $row[‘rl2_tel’];

$R16RL2Tel2 = $row[‘rl2_tel2’];

$R16RL2Mail = $row[‘rl2_mail’];

}

$sql = “SELECT Redactie_L3,rl3_adres,rl3_post_woonpl,rl3_tel,rl3_tel2,rl3_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Redactie_L3 = $row[‘Redactie_L3’];

$R16RL3Adres = $row[‘rl3_adres’];

$R16RL3Post_Woonpl = $row[‘rl3_post_woonpl’];

$R16RL3Tel = $row[‘rl3_tel’];

$R16RL3Tel2 = $row[‘rl3_tel2’];

$R16RL3Mail = $row[‘rl3_mail’];

}

$sql = “SELECT Eindredactie1,er1_adres,er1_post_woonpl,er1_tel,er1_tel2,er1_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Eindredactie1 = $row[‘Eindredactie1’];

$R16ER1Adres = $row[‘er1_adres’];

$R16ER1Post_Woonpl = $row[‘er1_post_woonpl’];

$R16ER1Tel = $row[‘er1_tel’];

$R16ER1Tel2 = $row[‘er1_tel2’];

$R16ER1Mail = $row[‘er1_mail’];

}

$sql = “SELECT Eindredactie2,er2_adres,er2_post_woonpl,er2_tel,er2_tel2,er2_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Eindredactie2 = $row[‘Eindredactie2’];

$R16ER2Adres = $row[‘er2_adres’];

$R16ER2Post_Woonpl = $row[‘er2_post_woonpl’];

$R16ER2Tel = $row[‘er2_tel’];

$R16ER2Tel2 = $row[‘er2_tel2’];

$R16ER2Mail = $row[‘er2_mail’];

}

$sql = “SELECT Beheer_BSP,b_adres,b_post_woonpl,b_tel,b_tel2,b_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Beheer_BSP = $row[‘Beheer_BSP’];

$R16BAdres = $row[‘b_adres’];

$R16BPost_Woonpl = $row[‘b_post_woonpl’];

$R16BTel = $row[‘b_tel’];

$R16BTel2 = $row[‘b_tel2’];

$R16BMail = $row[‘b_mail’];

}

$sql = “SELECT Ledensecretaris,ls_adres,ls_post_woonpl,ls_tel,ls_tel2,ls_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Ledensecretaris = $row[‘Ledensecretaris’];

$R16LSAdres = $row[‘ls_adres’];

$R16LSPost_Woonpl = $row[‘ls_post_woonpl’];

$R16LSTel = $row[‘ls_tel’];

$R16LSTel2 = $row[‘ls_tel2’];

$R16LSMail = $row[‘ls_mail’];

}

$sql = “SELECT Wedstrijdcommissie,w_adres,w_post_woonpl,w_tel,w_tel2,w_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Wedstrijdcommissie = $row[‘Wedstrijdcommissie’];

$R16WAdres = $row[‘w_adres’];

$R16WPost_Woonpl = $row[‘w_post_woonpl’];

$R16WTel = $row[‘w_tel’];

$R16WTel2 = $row[‘w_tel2’];

$R16WMail = $row[‘w_mail’];

}

$sql = “SELECT Wedstrijdcommissie1,w1_adres,w1_post_woonpl,w1_tel,w1_tel2,w1_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Wedstrijdcommissie1 = $row[‘Wedstrijdcommissie1’];

$R16W1Adres = $row[‘w1_adres’];

$R16W1Post_Woonpl = $row[‘w1_post_woonpl’];

$R16W1Tel = $row[‘w1_tel’];

$R16W1Tel2 = $row[‘w1_tel2’];

$R16W1Mail = $row[‘w1_mail’];

}

$sql = “SELECT Wedstrijdcommissie1,w1_adres,w1_post_woonpl,w1_tel,w1_tel2,w1_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Wedstrijdcommissie1 = $row[‘Wedstrijdcommissie1’];

$R16W1Adres = $row[‘w1_adres’];

$R16W1Post_Woonpl = $row[‘w1_post_woonpl’];

$R16W1Tel = $row[‘w1_tel’];

$R16W1Tel2 = $row[‘w1_tel2’];

$R16W1Mail = $row[‘w1_mail’];

}

$sql = “SELECT Overige_Functie,Overige,o_adres,o_post_woonpl,o_tel,o_tel2,o_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Overige_Functie = $row[‘Overige_Functie’];

$R16Overige = $row[‘Overige’];

$R16OAdres = $row[‘o_adres’];

$R16OPost_Woonpl = $row[‘o_post_woonpl’];

$R16OTel = $row[‘o_tel’];

$R16OTel2 = $row[‘o_tel2’];

$R16OMail = $row[‘o_mail’];

}

$sql = “SELECT Overige_Functie,Overige,o_adres,o_post_woonpl,o_tel,o_tel2,o_mail FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16Overige_Functie = $row[‘Overige_Functie’];

$R16Overige = $row[‘Overige’];

$R16OAdres = $row[‘o_adres’];

$R16OPost_Woonpl = $row[‘o_post_woonpl’];

$R16OTel = $row[‘o_tel’];

$R16OTel2 = $row[‘o_tel2’];

$R16OMail = $row[‘o_mail’];

}

$sql = “SELECT BANK, WEBSITE FROM Tbl_Leden_Regio Where Regio = ‘De Heuvelrug – Regio 16′”;

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {

$R16BANK = $row[‘BANK’];

$R16WEBSITE = $row[‘WEBSITE’];

}

[/insert_php]

Export (csv)Export (pdf)

[insert_php]
echo ‘

NaamAdresPostcode en WoonplaatsTelefoonTelefoonE-mail adres
Voorzitter
‘;
echo $R16Voorzitter ;
echo ‘		‘;
echo $R16VAdres;
echo ‘		‘;
echo $R16VPost_Woonpl;
echo ‘		‘;
echo $R16VTel;
echo’		‘;
echo $R16VTel2;
echo’		 mail

‘;

IF ($R16VVoorzitter == ”){
}
else
{
echo ‘

Vice Voorzitter
‘;
echo $R16VVoorzitter ;
echo ‘		‘;
echo $R16VVAdres;
echo ‘		‘;
echo $R16VVPost_Woonpl;
echo ‘		‘;
echo $R16VVTel;
echo’		‘;
echo $R16VVTel2;
echo’		 mail

‘;
}

IF ($R16Penningmeester == ”){
}
else
{
echo ‘

Penningmeester
‘;
echo $R16Penningmeester ;
echo ‘		‘;
echo $R16PAdres;
echo ‘		‘;
echo $R16PPost_Woonpl;
echo ‘		‘;
echo $R16PTel;
echo’		‘;
echo $R16PTel2;
echo’		 mail

‘;
}

IF ($R16Secretaris == ”){
}
else
{
echo ‘

Secretaris
‘;
echo $R16Secretaris ;
echo ‘		‘;
echo $R16SAdres;
echo ‘		‘;
echo $R16SPost_Woonpl;
echo ‘		‘;
echo $R16STel;
echo’		‘;
echo $R16STel2;
echo’		 mail

‘;
}

IF ($R16Lid1 == ”){
}
else
{
echo ‘

Lid 1
‘;
echo $R16Lid1 ;
echo ‘		‘;
echo $R16L1Adres;
echo ‘		‘;
echo $R16L1Post_Woonpl;
echo ‘		‘;
echo $R16L1Tel;
echo’		‘;
echo $R16L1Tel2;
echo’		 mail

‘;
}

IF ($R16Lid2 == ”){
}
else
{
echo ‘

Lid 2
‘;
echo $R16Lid2 ;
echo ‘		‘;
echo $R16L2Adres;
echo ‘		‘;
echo $R16L2Post_Woonpl;
echo ‘		‘;
echo $R16L2Tel;
echo’		‘;
echo $R16L2Tel2;
echo’		 mail

‘;
}

IF ($R16Lid3 == ”){
}
else
{
echo ‘

Lid 3
‘;
echo $R16Lid3 ;
echo ‘		‘;
echo $R16L3Adres;
echo ‘		‘;
echo $R16L3Post_Woonpl;
echo ‘		‘;
echo $R16L3Tel;
echo’		‘;
echo $R16L3Tel2;
echo’		 mail

‘;
}

IF ($R16Lid4 == ”){
}
else
{
echo ‘

Lid 4
‘;
echo $R16Lid4 ;
echo ‘		‘;
echo $R16L4Adres;
echo ‘		‘;
echo $R16L4Post_Woonpl;
echo ‘		‘;
echo $R16L4Tel;
echo’		‘;
echo $R16L4Tel2;
echo’		 mail

‘;
}

IF ($R16Ledenraad == ”){
}
else
{
echo ‘

Ledenraad
‘;
echo $R16Ledenraad ;
echo ‘		‘;
echo $R16LAdres;
echo ‘		‘;
echo $R16LPost_Woonpl;
echo ‘		‘;
echo $R16LTel;
echo’		‘;
echo $R16LTel2;
echo’		 mail

‘;
}

IF ($R16Redactie == ”){
}
else
{
echo ‘

Redactie 1
‘;
echo $R16Redactie ;
echo ‘		‘;
echo $R16RAdres;
echo ‘		‘;
echo $R16RPost_Woonpl;
echo ‘		‘;
echo $R16RTel;
echo’		‘;
echo $R16RTel2;
echo’		 mail

‘;
}

IF ($R16Redactie_L1 == ”){
}
else
{
echo ‘

Redactie 2
‘;
echo $R16Redactie_L1 ;
echo ‘		‘;
echo $R16RL1Adres;
echo ‘		‘;
echo $R16RL1Post_Woonpl;
echo ‘		‘;
echo $R16RL1Tel;
echo’		‘;
echo $R16RL1Tel2;
echo’		 mail

‘;
}

IF ($R16Redactie_L2 == ”){
}
else
{
echo ‘

Redactie 3
‘;
echo $R16Redactie_L2 ;
echo ‘		‘;
echo $R16RL2Adres;
echo ‘		‘;
echo $R16RL2Post_Woonpl;
echo ‘		‘;
echo $R16RL2Tel;
echo’		‘;
echo $R16RL2Tel2;
echo’		 mail

‘;
}

IF ($R16Redactie_L3 == ”){
}
else
{
echo ‘

Redactie 4
‘;
echo $R16Redactie_L3 ;
echo ‘		‘;
echo $R16RL3Adres;
echo ‘		‘;
echo $R16RL3Post_Woonpl;
echo ‘		‘;
echo $R16RL3Tel;
echo’		‘;
echo $R16RL3Tel2;
echo’		 mail

‘;
}

IF ($R16Eindredactie1 == ”){
}
else
{
echo ‘

Eindredactie 1
‘;
echo $R16Eindredactie1 ;
echo ‘		‘;
echo $R16ER1Adres;
echo ‘		‘;
echo $R16ER1Post_Woonpl;
echo ‘		‘;
echo $R16ER1Tel;
echo’		‘;
echo $R16ER1Tel2;
echo’		 mail

‘;
}

IF ($R16Eindredactie2 == ”){
}
else
{
echo ‘

Eindredactie 2
‘;
echo $R16Eindredactie2 ;
echo ‘		‘;
echo $R16ER2Adres;
echo ‘		‘;
echo $R16ER2Post_Woonpl;
echo ‘		‘;
echo $R16ER2Tel;
echo’		‘;
echo $R16ER2Tel2;
echo’		 mail

‘;
}

IF ($R16Beheer_BSP == ”){
}
else
{
echo ‘

Beheer Service Punt
‘;
echo $R16Beheer_BSP ;
echo ‘		‘;
echo $R16BAdres;
echo ‘		‘;
echo $R16BPost_Woonpl;
echo ‘		‘;
echo $R16BTel;
echo’		‘;
echo’		 mail

‘;
}

IF ($R16Ledensecretaris == ”){
}
else
{
echo ‘

Ledensecretaris
‘;
echo $R16Ledensecretaris ;
echo ‘		‘;
echo $R16LSAdres;
echo ‘		‘;
echo $R16LSPost_Woonpl;
echo ‘		‘;
echo $R16LSTel;
echo’		‘;
echo $R16LSTel2;
echo’		 mail

‘;
}

IF ($R16Wedstrijdcommissie == ”){
}
else
{
echo ‘

Wedstrijdcommissie 1
‘;
echo $R16Wedstrijdcommissie ;
echo ‘		‘;
echo $R16WAdres;
echo ‘		‘;
echo $R16WPost_Woonpl;
echo ‘		‘;
echo $R16WTel;
echo’		‘;
echo $R16WTel2;
echo’		 mail

‘;
}

IF ($R16Wedstrijdcommissie1 == ”){
}
else
{
echo ‘

Wedstrijdcommissie 2
‘;
echo $R16Wedstrijdcommissie1 ;
echo ‘		‘;
echo $R16W1Adres;
echo ‘		‘;
echo $R16W1Post_Woonpl;
echo ‘		‘;
echo $R16W1Tel;
echo’		‘;
echo $R16W1Tel2;
echo’		 mail

‘;
}

IF ($R16Overige_Functie == ”){
}
else
{
echo ‘

Overige Functie
‘;
echo $R16Overige_Functie ;
echo ‘		‘;
echo $R16OAdres;
echo ‘		‘;
echo $R16OPost_Woonpl;
echo ‘		‘;
echo $R16OTel;
echo’		‘;
echo $R16OTel2;
echo’		 mail

‘;
}

IF ($R16Rnaam == ”){
}
else
{
echo ‘

Regioblad‘;
echo $R16Rnaam ;
echo ‘

‘;
}

IF ($R16BANK == ”){
}
else
{
echo ‘

Bank‘;
echo $R16BANK ;
echo ‘

‘;
}

IF ($R16WEBSITE == ”){
}
else
{
echo ‘

Website‘;
echo $R16WEBSITE ;
echo ‘

‘;
}

[/insert_php]