A więc jak w temacie jeśli chcesz wyświetlić na jednej stronie listę wszystkich artykuły .
Można wykonać coś takiego .
<?php
require_once __DIR__.'/maincore.php';
require_once THEMES.'templates/header.php';
add_to_title ('tytuł');
set_meta("description"," opis strony www deskryption.");
add_to_head("<style type='text/css'>.fc{
border: 1px solid #1a1a1a;
border-radius: 10px;
padding: 5px;
}
.fc1{
background-color: #0000FF;
border-top: 1px solid #1a1a1a;
border-bottom: 2px solid #000080;
border-radius: 9px;
padding: 10px;
font-size: 16px; /* Zmieniono rozmiar czcionki na 16px */
}
.lc{
border: 1px solid #1a1a1a;
border-radius: 9px;
padding: 5px;
}
.lc1{
background-color: #0000FF;
border-top: 1px solid #1a1a1a;
border-bottom: 2px solid #1a1a1a;
border-radius: 9px;
padding: 1px;
}
</style>");
echo "<table align='center' ><tbody><tr>";
echo "<td class='fc' width='50%' >";
echo " <div align='center' class='fc1'></div><p><p>";
$qresult=dbquery("SELECT * FROM ".DB_ARTICLES." ORDER BY article_datestamp DESC LIMIT 15");
if(dbrows($qresult)!=0){
echo "<table width="100%" cellpadding="0" cellspacing="0">";
while($data=dbarray($qresult)){
echo "<tr>n<td class='small' align='left'><b><a href='".BASEDIR."/infusions/articles/articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."'>";
echo trimlink($data['article_subject'], 30)."</a></b></td>n<td class='small' align='right'>[".$data['article_reads']."]</td>n</tr>n";
}
echo "</table>";
}
echo "</td>n";
echo "<td class='lc' width='50%' >";
echo " <div class='lc1' align='center'><b></b></div><p><p>";
$qresult=dbquery("SELECT * FROM ".DB_ARTICLES." ORDER BY article_reads DESC LIMIT 15");
if(dbrows($qresult)!=0){
echo "<table width="100%" cellpadding="0" cellspacing="0">";
while($data=dbarray($qresult)){
echo "<tr>n<td class='small' align='left'><b><a href='".BASEDIR."/infusions/articles/articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."'>";
echo trimlink($data['article_subject'], 30)."</a></b></td>n<td class='small' align='right'>[".$data['article_reads']."]</td></tr>n";
}
echo "</table>";
}
echo "</td></tr></tbody></table>";
closeside();
require_once THEMES.'templates/footer.php';
?>
Jeśli chcesz wyświetlić w panelu , nie sprawdzałem ale powinno działać.
<?php
add_to_head("<style type='text/css'>.fc{
border: 1px solid #1a1a1a;
border-radius: 10px;
padding: 5px;
}
.fc1{
background-color: #0000FF;
border-top: 1px solid #1a1a1a;
border-bottom: 2px solid #000080;
border-radius: 9px;
padding: 10px;
font-size: 16px; /* Zmieniono rozmiar czcionki na 16px */
}
.lc{
border: 1px solid #1a1a1a;
border-radius: 9px;
padding: 5px;
}
.lc1{
background-color: #0000FF;
border-top: 1px solid #1a1a1a;
border-bottom: 2px solid #1a1a1a;
border-radius: 9px;
padding: 1px;
}
</style>");
echo "<table align='center' ><tbody><tr>";
echo "<td class='fc' width='50%' >";
echo " <div align='center' class='fc1'></div><p><p>";
$qresult=dbquery("SELECT * FROM ".DB_ARTICLES." ORDER BY article_datestamp DESC LIMIT 15");
if(dbrows($qresult)!=0){
echo "<table width="100%" cellpadding="0" cellspacing="0">";
while($data=dbarray($qresult)){
echo "<tr>n<td class='small' align='left'><b><a href='".BASEDIR."/infusions/articles/articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."'>";
echo trimlink($data['article_subject'], 30)."</a></b></td>n<td class='small' align='right'>[".$data['article_reads']."]</td>n</tr>n";
}
echo "</table>";
}
echo "</td>n";
echo "<td class='lc' width='50%' >";
echo " <div class='lc1' align='center'><b></b></div><p><p>";
$qresult=dbquery("SELECT * FROM ".DB_ARTICLES." ORDER BY article_reads DESC LIMIT 15");
if(dbrows($qresult)!=0){
echo "<table width="100%" cellpadding="0" cellspacing="0">";
while($data=dbarray($qresult)){
echo "<tr>n<td class='small' align='left'><b><a href='".BASEDIR."/infusions/articles/articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."'>";
echo trimlink($data['article_subject'], 30)."</a></b></td>n<td class='small' align='right'>[".$data['article_reads']."]</td></tr>n";
}
echo "</table>";
}
echo "</td></tr></tbody></table>";
closeside(); ?>
Zmiana limitu ilości artykułów.
article_reads DESC LIMIT 15");
Czy ten post był przydatny.
