Nieuwsbrief abonnees

{source} 

<?php
// Connect de database
$db = JFactory::getDbo();
$query = $db->getQuery(true);

$query =”SELECT
`h29z1_acymailing_subscriber`.`name`,
`h29z1_acymailing_subscriber`.`subid`,
`h29z1_acymailing_subscriber`.`email`,
`h29z1_acymailing_listsub`.`listid`
FROM
`h29z1_acymailing_subscriber`,
`h29z1_acymailing_listsub`
WHERE
`h29z1_acymailing_subscriber`.`subid` = `h29z1_acymailing_listsub`.`subid` AND `h29z1_acymailing_listsub`.`listid` = 1
ORDER BY
`h29z1_acymailing_subscriber`.`name` ASC”;

$db->setQuery($query); $db->execute(); $aantal=$db->getNumRows();
$results = $db->loadObjectList();
?>

 

<p class=”signaal”><H3>Namen van <?=$aantal;?> geregistreerde abonnees.</H3></p>
<p align=”center”><i><small>Gebruik desnoods de zoekfunctie van uw browser.</i></p><hr />
<p>

 

</h2><p class=”signaal”></p>
<table class=”table table-striped”>
<tr><td><H5><b>Naam</a></td><td><H5><b>E-mailadres</td><td>

<?php

 

// Toon de gevonden gegevens
foreach($results as $result){
echo”<tr><td>” . $result->name . “</td><td>” . $result->email .”</td><td>” .$result->hits .”</td></tr>”;
}?>

</table>

{/source}

{pagebuilderck 15}

Comments are closed.