public function load($iRecordID)
{
$oCon = new connection();
$sSQL = "SELECT RecordID, Title, Artist, Price, GenreID, PhotoPath\n\t\t\t\tFROM tbrecords \n\t\t\t\tWHERE RecordID = " . $iRecordID;
$oResultSet = $oCon->query($sSQL);
$aRow = $oCon->fetchArray($oResultSet);
$this->iRecordID = $aRow['RecordID'];
$this->sTitle = $aRow['Title'];
$this->sArtist = $aRow['Artist'];
$this->fPrice = $aRow['Price'];
$this->iGenreID = $aRow['GenreID'];
$this->iPhotoPath = $aRow['PhotoPath'];
$oCon->close();
}
<?php
require_once 'dotclear/inc/prepend.php';
$con = new connection($dbuser, $dbpass, $dbhost, $dbbase);
$blog = new blog($con, DB_PREFIX, 1, dc_encoding);
$news = $blog->getLastNews(3, 'actualite');
if ($news->isEmpty()) {
echo " <p>Aucune actualité</p>\n";
} else {
while (!$news->EOF()) {
echo ' <h3>', $news->f('post_titre'), "</h3>\n";
echo ' <h4>', strftime('%x', strtotime($news->f('post_dt'))), "</h4>\n";
echo ' ', $news->f('post_content'), "\n\n";
$news->moveNext();
}
}
$con->close();
?>
<p class="tous"><a href="/actualite/">Toutes les actualités</a></p>
</div>
<!-- Fin Actualité -->
<!-- Début Derniers Articles -->
<div id="articles">
<?php
OW_liste_document(array('type' => 'A'), 3, 'Derniers articles…');
?>
<p class="tous"><a href="/articles/">Tous les articles</a></p>
</div>
<!-- Fin Derniers Articles -->
</div>
