public function getUsers()
{
$lijst = null;
$sql = "SELECT * FROM user";
$resultaat = mysql_query($sql, $this->connectie);
while ($rij = mysql_fetch_array($resultaat)) {
$user = new User($rij['Id'], $rij['Name'], $rij['Account'], $rij['Password'], $rij['Role'], $rij['Email'], toDDMMYYYY($rij['DateAdded']));
$lijst[] = $user;
}
return $lijst;
}
public function getCarByFolderName($foldername)
{
$sql = "SELECT * FROM car\n\t\t\tWHERE foldername = '{$foldername}'";
$resultaat = mysql_query($sql, $this->connectie);
$count = mysql_num_rows($resultaat);
if ($count == 1) {
$rij = mysql_fetch_array($resultaat);
$car = new Car($rij['Id'], $rij['SiteId'], $rij['CarBrandId'], $rij['Type'], $rij['TypeShort'], $rij['PreviewLink'], toDDMMYYYY($rij['DateAdded']), $rij['State'], toDDMMYYYY($rij['DateApproved']), $rij['FolderName'], $rij['PressContactId'], $rij['UserIdAdded'], $rij['UserIdApproved'], $rij['DetailTypeId'], $rij['DefaultPictureId'], $rij['LRClicks'], $rij['HRClicks'], $rij['Views'], $rij['ReleaseDate'], $rij['MovieFolder']);
return $car;
} else {
return null;
}
}
public function getCars()
{
$lijst = null;
$sql = "SELECT * FROM car";
$resultaat = mysql_query($sql, $this->connectie);
while ($rij = mysql_fetch_array($resultaat)) {
$car = new Car($rij['Id'], $rij['SiteId'], $rij['CarBrandId'], $rij['Type'], $rij['TypeShort'], $rij['PreviewLink'], toDDMMYYYY($rij['DateAdded']), $rij['State'], toDDMMYYYY($rij['DateApproved']), $rij['FolderName'], $rij['PressContactId'], $rij['UserIdAdded'], $rij['UserIdApproved'], $rij['DetailTypeId'], $rij['DefaultPictureId'], $rij['LRClicks'], $rij['HRClicks'], $rij['Views'], $rij['ReleaseDate'], $rij['MovieFolder']);
$lijst[] = $car;
}
return $lijst;
}
<div class="table-responsive">
<table class="table table-bordered table-striped">
<thead>
<tr>
<th width="35%">Conference</th>
<th width="15%">Start Date</th>
<th width="15%">End Date</th>
<th width="15%">Status</th>
<th width="20%" colspan="3">Action</th>
</tr>
</thead>
<tbody>
<?php
foreach ($conferences as $conference) {
echo '<tr>' . '<td><b>' . $conference->naam . '</b></td>' . '<td><span class="label label-success">' . toDDMMYYYY($conference->startdatum) . '</span></td>' . '<td><span class="label label-danger">' . toDDMMYYYY($conference->einddatum) . '</span></td>' . '<td>' . $conference->status->naam . '</td>' . '<td class="actioncol"><a href="' . site_url() . '/conference/modify/' . $conference->id . '">Modify</a></td><td class="actioncol"><a href="' . site_url() . '/conference/manage/' . $conference->id . '">Manage</a></td><td class="actioncol"><a href="' . site_url() . '/conference/archive/' . $conference->id . '">Archive</a></td>' . '</tr>';
echo "\n";
}
?>
</tbody>
</table>
</div>
</div>
</div>
<!-- END PROJECTS BLOCK -->
</div>
</div>
</div>