{"id":13,"date":"2016-08-29T15:50:27","date_gmt":"2016-08-29T15:50:27","guid":{"rendered":"http:\/\/bouwcentrumrotterdam.nl\/?page_id=13"},"modified":"2017-01-20T10:26:33","modified_gmt":"2017-01-20T10:26:33","slug":"de-organisaties","status":"publish","type":"page","link":"https:\/\/bouwcentrumrotterdam.nl\/?page_id=13","title":{"rendered":"Organisatie-onderdelen"},"content":{"rendered":"

[insert_php]
\n\/\/ STARTEN SESSION
\nsession_start();
\n\/\/ VERBINDEN MET DATABASE
\n$link=mysqli_connect(‘rdbms.strato.de’, ‘U2684683’, ‘guin6591’, ‘DB2684683’);
\nif ($link==false)
\n\t{
\n\tprintf(“Er kan geen verbinding worden gemaakt met de database. Foutmelding: %s\\n”, mysqli_connect_error());
\n\t}<\/p>\n

\/\/ QUERY VOOR AFDELINGSLIJST
\n$result = mysqli_query($link, ”
\nSELECT
\n\te.id AS afd_id,
\n\te.cluster_id,
\n\te.naam AS afd_naam,
\n\te.startjaar,
\n\te.eindjaar,
\n\te.beschrijving,
\n\te.manager2,
\n\te.huisvesting,
\n\te.afloop,
\n\tc.id AS groepid,
\n\tc.naam AS groepsnaam,
\n\tc.volgorde
\nFROM
\n\tentity AS e
\nINNER JOIN
\n\tcluster AS c ON e.cluster_id = c.id
\nORDER BY
\n\tvolgorde, startjaar, afd_naam
\n“);<\/p>\n

\/\/ RESULTATEN NAAR ARRAY $DATA
\n$data = array();
\n$i = 0;
\nwhile ($lijst = mysqli_fetch_array($result,MYSQL_ASSOC))
\n\t{
\n\tforeach ($lijst as $sleutel => $waarde)
\n\t\t{
\n\t\t$data[$i][$sleutel] = $waarde;
\n\t\t}
\n\t$i++;
\n\t}<\/p>\n

mysqli_free_result($result);
\nmysqli_close($link);<\/p>\n

\/\/ IS ER POST
\nif (isset($_POST[‘AFD’]))
\n\t{
\n\t$nr=$_POST[‘AFD’]; \/\/ IS DE TABEL-ID
\n\t$cnt = count($data);
\n\tfor($no = 0; $no < $cnt; ++$no)\n\t\t{\n\t\t$var = $data[$no];\n\t\t$nummer[$no] = $var['afd_id'];\n\t\tif ($nr==$nummer[$no])\n\t\t\t{\n\t\t\techo('\n\n‘);
\n\t\t\techo(‘<\/p>\n\n\n\n\n\n\n
‘);
\n\t\t\techo $var[‘afd_naam’];
\n\t\t\techo(‘<\/b><\/td>\n		‘);
\n\t\t\techo $var[‘groepsnaam’];
\n\t\t\techo(‘<\/td>\n<\/tr>\n

‘);
\n\t\t\techo(‘<\/p>\n

‘);
\n\t\t\techo(‘<\/td>\n		Actief van ‘);
\n\t\t\techo $var[‘startjaar’] . ‘ tot ‘ . $var[‘eindjaar’];
\n\t\t\techo(‘<\/td>\n<\/tr>\n

‘);
\n\t\t\techo(‘<\/p>\n

Beschrijving\/doelstelling<\/b>
‘);
\n\t\t\techo $var[‘beschrijving’];
\n\t\t\techo(‘<\/td>\n<\/tr>\n

‘);<\/p>\n

\t\t\tif (($var[‘manager2’])<>“Selecteer persoon uit deze lijst:”)
\n\t\t\t\t{
\n\t\t\t\techo(‘<\/p>\n

Directie\/leiding\/initiatiefnemer<\/b>
‘);
\n\t\t\t\t$pid=$var[‘manager2’];
\n\t\t\t\t$link=mysqli_connect(‘rdbms.strato.de’, ‘U2684683’, ‘guin6591’, ‘DB2684683′);
\n\t\t\t\t$result = mysqli_query($link, “SELECT * FROM person WHERE id=’$pid’ “);
\n\t\t\t\t$pers = mysqli_fetch_array($result);
\n\t\t\t\techo $pers[‘prenom’] . ‘ ‘ . $pers[‘prefix’] . ‘ ‘ . $pers[‘name’];
\n\t\t\t\techo(‘<\/td>\n<\/tr>\n

‘);
\n\t\t\t\t}<\/p>\n

\t\t\tif (($var[‘huisvesting’])<>“”)
\n\t\t\t\t{
\n\t\t\t\techo(‘<\/p>\n

Huisvesting<\/b>
‘);
\n\t\t\t\techo $var[‘huisvesting’];
\n\t\t\t\techo(‘<\/td>\n<\/tr>\n

‘);
\n\t\t\t\t}<\/p>\n

\t\t\tif (($var[‘afloop’])<>“”)
\n\t\t\t\t{
\n\t\t\t\techo(‘<\/p>\n

Wat is ermee gebeurd?<\/b>
‘);
\n\t\t\t\techo $var[‘afloop’];
\n\t\t\t\techo(‘<\/td>\n<\/tr>\n

‘);
\n\t\t\t\t}<\/p>\n

\t\t\techo(‘<\/table>\n

‘);
\n\t\t\t}
\n\t\t}
\n\t}<\/p>\n

\/\/ NAAR FORMULIER\/TABEL
\necho(‘<\/p>\n

‘);
\necho(‘<\/p>\n‘);<\/p>\n

$_SESSION[‘$volgorde’]=’0′;
\n$cnt = count($data);<\/p>\n

for($i = 0; $i < $cnt; ++$i)\n\t{\n\t$var = $data[$i];\n\t$nummer[$i] = $var['afd_id'];\n\t$volgorde=$var['cluster_id'];\n\tif ($volgorde<>$_SESSION[‘$volgorde’])
\n\t\t{
\n\t\techo(‘<\/p>\n

\n\n
‘);
\n\t\techo $var[‘groepsnaam’];
\n\t\techo(‘<\/td>\n<\/tr>\n

‘);
\n\t\t}
\n\techo(‘<\/p>\n

‘);
\n\tif (($var[‘beschrijving’])<>“”)
\n\t\t{
\n\t\techo(‘		‘);
\n\tif (($var[‘startjaar’])<>“0”)
\n\t\t{
\n\t\techo $var[‘startjaar’];
\n\t\t}
\n\techo(‘<\/td>\n		‘);
\n\tif (($var[‘eindjaar’])<>“0”)
\n\t\t{
\n\t\techo ’tot ‘ . ‘ ‘ . $var[‘eindjaar’];
\n\t\t}
\n\techo(‘<\/td>\n<\/tr>\n

‘);
\n\t$_SESSION[‘$volgorde’]=$volgorde;
\n\t}<\/p>\n

echo(‘<\/table>\n

‘);
\necho(‘<\/p><\/form>\n

‘);<\/p>\n

[\/insert_php]<\/p>\n","protected":false},"excerpt":{"rendered":"

[insert_php] \/\/ STARTEN SESSION session_start(); \/\/ VERBINDEN MET DATABASE $link=mysqli_connect(‘rdbms.strato.de’, ‘U2684683’, ‘guin6591’, ‘DB2684683’); if ($link==false) { printf(“Er kan geen verbinding worden gemaakt met de database. Foutmelding: %s\\n”, mysqli_connect_error()); } \/\/ QUERY VOOR AFDELINGSLIJST $result = mysqli_query($link, ” SELECT e.id AS afd_id, e.cluster_id, e.naam AS afd_naam, e.startjaar, e.eindjaar, e.beschrijving, e.manager2, e.huisvesting, e.afloop, c.id AS groepid, c.naam … <\/p>\n

Lees verder “Organisatie-onderdelen”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-13","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=\/wp\/v2\/pages\/13","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13"}],"version-history":[{"count":285,"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=\/wp\/v2\/pages\/13\/revisions"}],"predecessor-version":[{"id":1181,"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=\/wp\/v2\/pages\/13\/revisions\/1181"}],"wp:attachment":[{"href":"https:\/\/bouwcentrumrotterdam.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}