WEBAPPS · DATA · DEVELOPMENT
// PHP · CRUD <?php $stmt = $pdo->prepare( 'SELECT * FROM projecten WHERE status = :status' ); $stmt->execute([ 'status' => 'actief' ]);
-- MySQL · Databeheer SELECT projectnr, omschrijving, COUNT(*) AS totaal FROM inspecties WHERE controle = 'gereed' GROUP BY projectnr ORDER BY totaal DESC;
/* CSS · Interface */ .dashboard { display: grid; grid-template-columns: repeat(3, 1fr); gap: 1.5rem; background: #0b1525; }
// JavaScript · Data const records = data.filter( item => item.actief === true ); const totaal = records.length; console.log(`Records: ${totaal}`);
<!-- HTML · Webapps --> <main class="webapp"> <section id="data"> <h1>Gegevensbeheer</h1> </section> </main>
# GIS · Ruimtelijke data SELECT object_id, type, ST_AsText(geom) AS geometrie FROM leidingen WHERE materiaal IS NOT NULL;
WEBAPPS · DATA · DEVELOPMENT