| |
'review' AND type <> 'win' ORDER BY $sqlSort";
}else{
$sqlquery = "SELECT * FROM articles WHERE type = '$filter' ORDER BY $sqlSort";
}
print " ";
$DBhost = "localhost";
$DBuser = "austral3_casso";
$DBpass = "casso2127";
$DBName = "austral3_mag";
$mysqli = new mysqli($DBhost,$DBuser,$DBpass,$DBName);
$result = $mysqli->query($sqlquery);
$numArticles = mysqli_num_rows($result);
$endRecord = $_SESSION['page'] * 10;
$startRecord = $endRecord - 10;
if (mysqli_num_rows($result)) {
$articleCount = 1;
$qry = mysqli_data_seek($result, $startRecord);
while ($articleCount <= 10) {
$qry = $result -> fetch_array(MYSQLI_ASSOC);
if ($qry) {
$newText = $qry[text];
$newText = preg_replace('#().*?()#', '$1$2', $newText);
$newText = preg_replace('#().*?()#', '$1$2', $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$newText = str_replace("", "", $newText);
$shortText = substr($newText, 0, 360);
$theDate = $qry[date];
$theDay = substr($theDate, 6, 2);
$theMonth = substr($theDate, 4, 2);
$theYear = substr($theDate, 0, 4);
switch ($theMonth) {
case 1:
$newMonth = "January";
break;
case 2:
$newMonth = "February";
break;
case 3:
$newMonth = "March";
break;
case 4:
$newMonth = "April";
break;
case 5:
$newMonth = "May";
break;
case 6:
$newMonth = "June";
break;
case 7:
$newMonth = "July";
break;
case 8:
$newMonth = "August";
break;
case 9:
$newMonth = "September";
break;
case 10:
$newMonth = "October";
break;
case 11:
$newMonth = "November";
break;
case 12:
$newMonth = "December";
break;
}
print "
$qry[title] // $qry[category] |
 | $theDay $newMonth $theYear
$shortText ... [ more ] |
| ";
}
$articleCount = $articleCount + 1;
}
}
print " |
| $filterCountDisplay Reviews: $numArticles | ";
switch ($numArticles) {
case ($numArticles <= 10):
print "| Pages: $page1Menu | ";
break;
case ($numArticles <= 20):
print "| Pages: $page1Menu $page2Menu | ";
break;
case ($numArticles <= 30):
print "| Pages: $page1Menu $page2Menu $page3Menu | ";
break;
case ($numArticles <= 40):
print "| Pages: $page1Menu $page2Menu $page3Menu $page4Menu | ";
break;
case ($numArticles <= 50):
print "| Pages: $page1Menu $page2Menu $page3Menu $page4Menu $page5Menu | ";
break;
case ($numArticles <= 60):
print "| Pages: $page1Menu $page2Menu $page3Menu $page4Menu $page5Menu $page6Menu | ";
break;
case ($numArticles <= 70):
print "| Pages: $page1Menu $page2Menu $page3Menu $page4Menu $page5Menu $page6Menu $page7Menu | ";
break;
case ($numArticles <= 80):
print "| Pages: $page1Menu $page2Menu $page3Menu $page4Menu $page5Menu $page6Menu $page7Menu $page8Menu | ";
break;
case ($numArticles <= 90):
print "| Pages: $page1Menu $page2Menu $page3Menu $page4Menu $page5Menu $page6Menu $page7Menu $page8Menu $page9Menu | ";
break;
case ($numArticles <= 100):
print "| Pages: $page1Menu $page2Menu $page3Menu $page4Menu $page5Menu $page6Menu $page7Menu $page8Menu $page9Menu $page10Menu | ";
break;
}
print " | ";
$mysqli->close();
?>
|
|
