R14 Bestuur

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

Regio 14 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 = ‘Amstelland – Regio 14′”;

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

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

$R14Voorzitter = $row[‘voorzitter’];

$R14VAdres = $row[‘v_adres’];

$R14VPost_Woonpl = $row[‘v_post_woonpl’];

$R14VTel = $row[‘v_tel’];

$R14VTel2 = $row[‘v_tel2’];

$R14VMail = $row[‘v_mail’];

}

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

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

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

$R14VVoorzitter = $row[‘vvoorzitter’];

$R14VVAdres = $row[‘vv_adres’];

$R14VVPost_Woonpl = $row[‘vv_post_woonpl’];

$R14VVTel = $row[‘vv_tel’];

$R14VVTel2 = $row[‘vv_tel2’];

$R14VVMail = $row[‘vv_mail’];

}

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

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

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

$R14Secretaris = $row[‘Secretaris’];

$R14SAdres = $row[‘s_adres’];

$R14SPost_Woonpl = $row[‘s_post_woonpl’];

$R14STel = $row[‘s_tel’];

$R14STel2 = $row[‘s_tel2’];

$R14SMail = $row[‘s_mail’];

}

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

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

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

$R14Penningmeester = $row[‘Penningmeester’];

$R14PAdres = $row[‘p_adres’];

$R14PPost_Woonpl = $row[‘p_post_woonpl’];

$R14PTel = $row[‘p_tel’];

$R14PTel2 = $row[‘p_tel2’];

$R14PMail = $row[‘p_mail’];

}

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

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

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

$R14Lid1 = $row[‘Lid1’];

$R14L1Adres = $row[‘l1_adres’];

$R14L1Post_Woonpl = $row[‘l1_post_woonpl’];

$R14L1Tel = $row[‘l1_tel’];

$R14L1Tel2 = $row[‘l1_tel2’];

$R14L1Mail = $row[‘l1_mail’];

}

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

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

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

$R14Lid2 = $row[‘Lid2’];

$R14L2Adres = $row[‘l2_adres’];

$R14L2Post_Woonpl = $row[‘l2_post_woonpl’];

$R14L2Tel = $row[‘l2_tel’];

$R14L2Tel2 = $row[‘l2_tel2’];

$R14L2Mail = $row[‘l2_mail’];

}

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

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

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

$R14Lid3 = $row[‘Lid3’];

$R14L3Adres = $row[‘l3_adres’];

$R14L3Post_Woonpl = $row[‘l3_post_woonpl’];

$R14L3Tel = $row[‘l3_tel’];

$R14L3Tel2 = $row[‘l3_tel2’];

$R14L3Mail = $row[‘l3_mail’];

}

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

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

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

$R14Lid4 = $row[‘Lid4’];

$R14L4Adres = $row[‘l4_adres’];

$R14L4Post_Woonpl = $row[‘l4_post_woonpl’];

$R14L4Tel = $row[‘l4_tel’];

$R14L4Tel2 = $row[‘l4_tel2’];

$R14L4Mail = $row[‘l4_mail’];

}

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

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

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

$R14Ledenraad = $row[‘Ledenraad’];

$R14LAdres = $row[‘l_adres’];

$R14LPost_Woonpl = $row[‘l_post_woonpl’];

$R14LTel = $row[‘l_tel’];

$R14LTel2 = $row[‘l_tel2’];

$R14LMail = $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 = ‘Amstelland – Regio 14′”;

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

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

$R14Rnaam = $row[‘r_naam’];

$R14Redactie = $row[‘Redactie’];

$R14RAdres = $row[‘r_adres’];

$R14RPost_Woonpl = $row[‘r_post_woonpl’];

$R14RTel = $row[‘r_tel’];

$R14RTel2 = $row[‘r_tel2’];

$R14RMail = $row[‘r_mail’];

}

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

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

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

$R14Redactie_L1 = $row[‘Redactie_L1’];

$R14RL1Adres = $row[‘rl1_adres’];

$R14RL1Post_Woonpl = $row[‘rl1_post_woonpl’];

$R14RL1Tel = $row[‘rl1_tel’];

$R14RL1Tel2 = $row[‘rl1_tel2’];

$R14RL1Mail = $row[‘rl1_mail’];

}

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

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

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

$R14Redactie_L2 = $row[‘Redactie_L2’];

$R14RL2Adres = $row[‘rl2_adres’];

$R14RL2Post_Woonpl = $row[‘rl2_post_woonpl’];

$R14RL2Tel = $row[‘rl2_tel’];

$R14RL2Tel2 = $row[‘rl2_tel2’];

$R14RL2Mail = $row[‘rl2_mail’];

}

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

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

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

$R14Redactie_L3 = $row[‘Redactie_L3’];

$R14RL3Adres = $row[‘rl3_adres’];

$R14RL3Post_Woonpl = $row[‘rl3_post_woonpl’];

$R14RL3Tel = $row[‘rl3_tel’];

$R14RL3Tel2 = $row[‘rl3_tel2’];

$R14RL3Mail = $row[‘rl3_mail’];

}

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

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

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

$R14Eindredactie1 = $row[‘Eindredactie1’];

$R14ER1Adres = $row[‘er1_adres’];

$R14ER1Post_Woonpl = $row[‘er1_post_woonpl’];

$R14ER1Tel = $row[‘er1_tel’];

$R14ER1Tel2 = $row[‘er1_tel2’];

$R14ER1Mail = $row[‘er1_mail’];

}

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

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

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

$R14Eindredactie2 = $row[‘Eindredactie2’];

$R14ER2Adres = $row[‘er2_adres’];

$R14ER2Post_Woonpl = $row[‘er2_post_woonpl’];

$R14ER2Tel = $row[‘er2_tel’];

$R14ER2Tel2 = $row[‘er2_tel2’];

$R14ER2Mail = $row[‘er2_mail’];

}

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

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

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

$R14Beheer_BSP = $row[‘Beheer_BSP’];

$R14BAdres = $row[‘b_adres’];

$R14BPost_Woonpl = $row[‘b_post_woonpl’];

$R14BTel = $row[‘b_tel’];

$R14BTel2 = $row[‘b_tel2’];

$R14BMail = $row[‘b_mail’];

}

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

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

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

$R14Ledensecretaris = $row[‘Ledensecretaris’];

$R14LSAdres = $row[‘ls_adres’];

$R14LSPost_Woonpl = $row[‘ls_post_woonpl’];

$R14LSTel = $row[‘ls_tel’];

$R14LSTel2 = $row[‘ls_tel2’];

$R14LSMail = $row[‘ls_mail’];

}

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

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

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

$R14Wedstrijdcommissie = $row[‘Wedstrijdcommissie’];

$R14WAdres = $row[‘w_adres’];

$R14WPost_Woonpl = $row[‘w_post_woonpl’];

$R14WTel = $row[‘w_tel’];

$R14WTel2 = $row[‘w_tel2’];

$R14WMail = $row[‘w_mail’];

}

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

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

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

$R14Wedstrijdcommissie1 = $row[‘Wedstrijdcommissie1’];

$R14W1Adres = $row[‘w1_adres’];

$R14W1Post_Woonpl = $row[‘w1_post_woonpl’];

$R14W1Tel = $row[‘w1_tel’];

$R14W1Tel2 = $row[‘w1_tel2’];

$R14W1Mail = $row[‘w1_mail’];

}

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

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

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

$R14Wedstrijdcommissie1 = $row[‘Wedstrijdcommissie1’];

$R14W1Adres = $row[‘w1_adres’];

$R14W1Post_Woonpl = $row[‘w1_post_woonpl’];

$R14W1Tel = $row[‘w1_tel’];

$R14W1Tel2 = $row[‘w1_tel2’];

$R14W1Mail = $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 = ‘Amstelland – Regio 14′”;

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

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

$R14Overige_Functie = $row[‘Overige_Functie’];

$R14Overige = $row[‘Overige’];

$R14OAdres = $row[‘o_adres’];

$R14OPost_Woonpl = $row[‘o_post_woonpl’];

$R14OTel = $row[‘o_tel’];

$R14OTel2 = $row[‘o_tel2’];

$R14OMail = $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 = ‘Amstelland – Regio 14′”;

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

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

$R14Overige_Functie = $row[‘Overige_Functie’];

$R14Overige = $row[‘Overige’];

$R14OAdres = $row[‘o_adres’];

$R14OPost_Woonpl = $row[‘o_post_woonpl’];

$R14OTel = $row[‘o_tel’];

$R14OTel2 = $row[‘o_tel2’];

$R14OMail = $row[‘o_mail’];

}

$sql = “SELECT BANK, WEBSITE FROM Tbl_Leden_Regio Where Regio = ‘Amstelland – Regio 14′”;

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

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

$R14BANK = $row[‘BANK’];

$R14WEBSITE = $row[‘WEBSITE’];

}

[/insert_php]

Export (csv)Export (pdf)

[insert_php]
echo ‘

NaamAdresPostcode en WoonplaatsTelefoonTelefoonE-mail adres
Voorzitter
‘;
echo $R14Voorzitter ;
echo ‘		‘;
echo $R14VAdres;
echo ‘		‘;
echo $R14VPost_Woonpl;
echo ‘		‘;
echo $R14VTel;
echo’		‘;
echo $R14VTel2;
echo’		 mail

‘;

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

Vice Voorzitter
‘;
echo $R14VVoorzitter ;
echo ‘		‘;
echo $R14VVAdres;
echo ‘		‘;
echo $R14VVPost_Woonpl;
echo ‘		‘;
echo $R14VVTel;
echo’		‘;
echo $R14VVTel2;
echo’		 mail

‘;
}

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

Penningmeester
‘;
echo $R14Penningmeester ;
echo ‘		‘;
echo $R14PAdres;
echo ‘		‘;
echo $R14PPost_Woonpl;
echo ‘		‘;
echo $R14PTel;
echo’		‘;
echo $R14PTel2;
echo’		 mail

‘;
}

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

Secretaris
‘;
echo $R14Secretaris ;
echo ‘		‘;
echo $R14SAdres;
echo ‘		‘;
echo $R14SPost_Woonpl;
echo ‘		‘;
echo $R14STel;
echo’		‘;
echo $R14STel2;
echo’		 mail

‘;
}

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

Lid 1
‘;
echo $R14Lid1 ;
echo ‘		‘;
echo $R14L1Adres;
echo ‘		‘;
echo $R14L1Post_Woonpl;
echo ‘		‘;
echo $R14L1Tel;
echo’		‘;
echo $R14L1Tel2;
echo’		 mail

‘;
}

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

Lid 2
‘;
echo $R14Lid2 ;
echo ‘		‘;
echo $R14L2Adres;
echo ‘		‘;
echo $R14L2Post_Woonpl;
echo ‘		‘;
echo $R14L2Tel;
echo’		‘;
echo $R14L2Tel2;
echo’		 mail

‘;
}

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

Lid 3
‘;
echo $R14Lid3 ;
echo ‘		‘;
echo $R14L3Adres;
echo ‘		‘;
echo $R14L3Post_Woonpl;
echo ‘		‘;
echo $R14L3Tel;
echo’		‘;
echo $R14L3Tel2;
echo’		 mail

‘;
}

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

Lid 4
‘;
echo $R14Lid4 ;
echo ‘		‘;
echo $R14L4Adres;
echo ‘		‘;
echo $R14L4Post_Woonpl;
echo ‘		‘;
echo $R14L4Tel;
echo’		‘;
echo $R14L4Tel2;
echo’		 mail

‘;
}

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

Ledenraad
‘;
echo $R14Ledenraad ;
echo ‘		‘;
echo $R14LAdres;
echo ‘		‘;
echo $R14LPost_Woonpl;
echo ‘		‘;
echo $R14LTel;
echo’		‘;
echo $R14LTel2;
echo’		 mail

‘;
}

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

Redactie 1
‘;
echo $R14Redactie ;
echo ‘		‘;
echo $R14RAdres;
echo ‘		‘;
echo $R14RPost_Woonpl;
echo ‘		‘;
echo $R14RTel;
echo’		‘;
echo $R14RTel2;
echo’		 mail

‘;
}

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

Redactie 2
‘;
echo $R14Redactie_L1 ;
echo ‘		‘;
echo $R14RL1Adres;
echo ‘		‘;
echo $R14RL1Post_Woonpl;
echo ‘		‘;
echo $R14RL1Tel;
echo’		‘;
echo $R14RL1Tel2;
echo’		 mail

‘;
}

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

Redactie 3
‘;
echo $R14Redactie_L2 ;
echo ‘		‘;
echo $R14RL2Adres;
echo ‘		‘;
echo $R14RL2Post_Woonpl;
echo ‘		‘;
echo $R14RL2Tel;
echo’		‘;
echo $R14RL2Tel2;
echo’		 mail

‘;
}

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

Redactie 4
‘;
echo $R14Redactie_L3 ;
echo ‘		‘;
echo $R14RL3Adres;
echo ‘		‘;
echo $R14RL3Post_Woonpl;
echo ‘		‘;
echo $R14RL3Tel;
echo’		‘;
echo $R14RL3Tel2;
echo’		 mail

‘;
}

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

Eindredactie 1
‘;
echo $R14Eindredactie1 ;
echo ‘		‘;
echo $R14ER1Adres;
echo ‘		‘;
echo $R14ER1Post_Woonpl;
echo ‘		‘;
echo $R14ER1Tel;
echo’		‘;
echo $R14ER1Tel2;
echo’		 mail

‘;
}

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

Eindredactie 2
‘;
echo $R14Eindredactie2 ;
echo ‘		‘;
echo $R14ER2Adres;
echo ‘		‘;
echo $R14ER2Post_Woonpl;
echo ‘		‘;
echo $R14ER2Tel;
echo’		‘;
echo $R14ER2Tel2;
echo’		 mail

‘;
}

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

Beheer Service Punt
‘;
echo $R14Beheer_BSP ;
echo ‘		‘;
echo $R14BAdres;
echo ‘		‘;
echo $R14BPost_Woonpl;
echo ‘		‘;
echo $R14BTel;
echo’		‘;
echo’		 mail

‘;
}

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

Ledensecretaris
‘;
echo $R14Ledensecretaris ;
echo ‘		‘;
echo $R14LSAdres;
echo ‘		‘;
echo $R14LSPost_Woonpl;
echo ‘		‘;
echo $R14LSTel;
echo’		‘;
echo $R14LSTel2;
echo’		 mail

‘;
}

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

Wedstrijdcommissie 1
‘;
echo $R14Wedstrijdcommissie ;
echo ‘		‘;
echo $R14WAdres;
echo ‘		‘;
echo $R14WPost_Woonpl;
echo ‘		‘;
echo $R14WTel;
echo’		‘;
echo $R14WTel2;
echo’		 mail

‘;
}

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

Wedstrijdcommissie 2
‘;
echo $R14Wedstrijdcommissie1 ;
echo ‘		‘;
echo $R14W1Adres;
echo ‘		‘;
echo $R14W1Post_Woonpl;
echo ‘		‘;
echo $R14W1Tel;
echo’		‘;
echo $R14W1Tel2;
echo’		 mail

‘;
}

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

Overige Functie
‘;
echo $R14Overige_Functie ;
echo ‘		‘;
echo $R14OAdres;
echo ‘		‘;
echo $R14OPost_Woonpl;
echo ‘		‘;
echo $R14OTel;
echo’		‘;
echo $R14OTel2;
echo’		 mail

‘;
}

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

Regioblad‘;
echo $R14Rnaam ;
echo ‘

‘;
}

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

Bank‘;
echo $R14BANK ;
echo ‘

‘;
}

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

Website‘;
echo $R14WEBSITE ;
echo ‘

‘;
}

[/insert_php]