prepare("select * from `tbl_article` where `delete_flag` = 0 and `show_first` = 1");
$firstArticle -> execute();
if($firstArticle -> rowCount() > 0){
while($firstArticleRows = $firstArticle -> fetch(PDO::FETCH_ASSOC)){
$updateDate0 = explode(" ",$firstArticleRows['update_date']);
$date0 = miladiToJalali2($updateDate0[0]);
?>
![<?php echo $firstArticleRows['title']; ?>](<?php echo $firstArticleRows['image']; ?>)
prepare($selectArticleSql);
$selectArticlePrepare -> execute();
if($selectArticlePrepare -> rowCount() > 0){
while($selectArticleRows = $selectArticlePrepare -> fetch(PDO::FETCH_ASSOC)){
$updateDate = explode(" ",$selectArticleRows['update_date']);
$date = miladiToJalali2($updateDate[0]);
?>
مقاله ای یافت نشد!
query($sql1);
$number = $query->rowCount();
if($number > 9) {
$total_page = (ceil($number / $per_page));
if ($total_page > 1) {
for ($i = 1; $i <= $total_page; $i++) {
if ($i == $page) {
echo "$i";
} else {
echo "" . $i . "";
}
}
}
}
}elseif(isset($_GET['g'])){
$g2 = intval($_GET['g']);
$sql1 = "SELECT * FROM `tbl_article` WHERE `delete_flag` = 0 and `group_id` =".$g2;
$query = $connect->query($sql1);
$number = $query->rowCount();
if($number > 9) {
$total_page = (ceil($number / $per_page));
if ($total_page > 9) {
for ($i = 1; $i <= $total_page; $i++) {
if ($i == $page) {
echo "$i";
} else {
echo "" . $i . "";
}
}
}
}
}else{
$sql1 = "SELECT * FROM `tbl_article` WHERE `delete_flag` = 0";
$query = $connect->query($sql1);
$number = $query->rowCount();
if($number > 9) {
$total_page = (ceil($number / $per_page));
if ($total_page > 1) {
for ($i = 1; $i <= $total_page; $i++) {
if ($i == $page) {
echo "$i";
} else {
echo "" . $i . "";
}
}
}
}
}
?>