Gecko [ myeducation.co.th ]

Name	Size	Permission
Processing	[ DIR ]	drwxr-xr-x
Structure	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
media	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
semantic	[ DIR ]	drwxr-xr-x
seo	[ DIR ]	drwxr-xr-x
webdesign	[ DIR ]	drwxr-xr-x
.htaccess	1.83 KB	-rwxr-xr-x
1Head.php	104 B	-rwxr-xr-x
1HeadMetafacebook.php	604 B	-rwxr-xr-x
1MataTab_Main.php	5.09 KB	-rwxr-xr-x
1MataTab_adwords.php	4.38 KB	-rwxr-xr-x
1MataTab_article.php	4.77 KB	-rwxr-xr-x
1MataTab_develop.php	4.45 KB	-rwxr-xr-x
1MataTab_ecommerce.php	6.25 KB	-rwxr-xr-x
1MataTab_facebookads.php	4.3 KB	-rwxr-xr-x
1MataTab_index.php	7.1 KB	-rwxr-xr-x
1MataTab_khonkaen.php	4.98 KB	-rwxr-xr-x
1MataTab_korat.php	5.66 KB	-rwxr-xr-x
1MataTab_mlm.php	5 KB	-rwxr-xr-x
1MataTab_seo.php	3.47 KB	-rwxr-xr-x
1MataTab_webfarmer.php	4.95 KB	-rwxr-xr-x
1Metafacebook.php	916 B	-rwxr-xr-x
1html.php	2.64 KB	-rwxr-xr-x
1html_End210220.php	979 B	-rwxr-xr-x
2End.php	210 B	-rwxr-xr-x
2Menu.php	5.9 KB	-rwxr-xr-x
2Nav.php	1.97 KB	-rwxr-xr-x
2Nav_article.php	503 B	-rwxr-xr-x
2Nav_banner_article.php	728 B	-rwxr-xr-x
2Nav_banner_ecommerce.php	720 B	-rwxr-xr-x
2Nav_banner_seo.php	730 B	-rwxr-xr-x
2html.php	2.25 KB	-rwxr-xr-x
3End.php	4.31 KB	-rwxr-xr-x
AboutUs.php	22.87 KB	-rwxr-xr-x
BingSiteAuth.xml	85 B	-rwxr-xr-x
Contact.php	304 B	-rwxr-xr-x
Order.php	1.68 KB	-rwxr-xr-x
Pack_Copper.php	9.14 KB	-rwxr-xr-x
PackageCheck.php	114 B	-rwxr-xr-x
Page_Vat.php	150 B	-rwxr-xr-x
Template.php	0 B	-rwxr-xr-x
Template2.php	0 B	-rwxr-xr-x
ads.php	12.6 KB	-rwxr-xr-x
adwords.php	24.06 KB	-rwxr-xr-x
article.php	14.1 KB	-rwxr-xr-x
article_details.php	10.99 KB	-rwxr-xr-x
develop.php	31.47 KB	-rwxr-xr-x
ecommerce.php	37.96 KB	-rwxr-xr-x
ecommercedetail.php	9.15 KB	-rwxr-xr-x
gitlab-gpgkey	3.12 KB	-rwxr-xr-x
index.php	1.67 KB	-rwxr-xr-x
index_Advertising_gold.php	1.37 KB	-rwxr-xr-x
index_Advertising_silver.php	1.4 KB	-rwxr-xr-x
index_Contact.php	2.25 KB	-rwxr-xr-x
index_What_Do.php	8.95 KB	-rwxr-xr-x
index_section.php	3.25 KB	-rwxr-xr-x
index_section1.php	7.21 KB	-rwxr-xr-x
index_section2.php	7.99 KB	-rwxr-xr-x
index_section3.php	4.71 KB	-rwxr-xr-x
index_section4.php	4.33 KB	-rwxr-xr-x
index_section5.php	4.66 KB	-rwxr-xr-x
index_section6.php	4.18 KB	-rwxr-xr-x
index_section7.php	8.37 KB	-rwxr-xr-x
khonkaen.php	10.6 KB	-rwxr-xr-x
korat.php	10.51 KB	-rwxr-xr-x
mlm.php	34.85 KB	-rwxr-xr-x
mlmdetail.php	9.68 KB	-rwxr-xr-x
ror.xml	68.5 KB	-rwxr-xr-x
seo.php	32.83 KB	-rwxr-xr-x
seo3.php	14.61 KB	-rwxr-xr-x
sitemap.html	52.35 KB	-rwxr-xr-x
sitemap.xml	32.02 KB	-rw-r--r--
webdesign.php	35.82 KB	-rwxr-xr-x
webdesigndetail.php	10.47 KB	-rwxr-xr-x
webfarmer.php	15.8 KB	-rwxr-xr-x

Code Editor : article.php

<?php
// /var/www/afra/rampagesoft.com/article.php

include '1Head.php';
include '2Nav_article.php';
include '2Nav_banner_article.php';
include 'model/controller/v_config.php';
?>
<style>
    body {
        background: linear-gradient(to right, #00254c, #01172e);
    }

.text_article3 {   
        overflow: auto;
        scrollbar-width: thin;
    scrollbar-color: #44586c #202a33;
    }

/* สำหรับ Chrome, Edge และ Safari */
    .text_article3::-webkit-scrollbar {
        width: 8px;
    }
    .text_article3::-webkit-scrollbar-track {
        background: #252525;
    }
    .text_article3::-webkit-scrollbar-thumb {
        background-color: #555;
        border-radius: 4px;
        border: 1px solid #444;
    }

.text_article3 h3,
    .text_article3 p {
        color: #fff;
    }

</style>

<?PHP
// กำหนดจำนวนบทความต่อหน้า
$perPage = 30;

// ตรวจสอบว่ามีตัวแปร page มาจาก GET หรือไม่
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page <= 0) {
    $page = 1;
}

// คำนวณตำแหน่งเริ่มต้น (offset) ของบทความที่จะดึง
$startIndex = ($page - 1) * $perPage;

// กำหนดค่า HomeIDFixed ตามเงื่อนไขในโค้ด
$HomeIDFixed = '28';

// ******************************
// 1) SELECT COUNT(*) ด้วย Prepared Statement
// ******************************
$totalArticles = 0;
if ($stmtCount = $objConnect->prepare("
    SELECT COUNT(*) AS total
    FROM home
    WHERE StatusHome_ID = 1
      AND StatusShowPage_ID = ?
")) {
    $stmtCount->bind_param("i", $HomeIDFixed);
    $stmtCount->execute();
    $resCount = $stmtCount->get_result();
    if ($rowCount = $resCount->fetch_assoc()) {
        $totalArticles = (int)$rowCount['total'];
    }
    $stmtCount->close();
}

// ******************************
// 2) SELECT บทความ ด้วย Prepared Statement
// ******************************
$articles = [];

// $SQL_Home = "
//  SELECT
//         home.Home_ID,
//         home.Member_ID,
//         member.Member_NameEN,
//         member.Position_ID,
//         position.Position_Name,
//         home.Home_Date,
//         home.Home_Time,
//         home.Home_Visitors,
//         home.Home_Sub,
//         home.Home_Short,
//         home.Home_Category,
//         home.StatusHome_ID,
//         status_home.StatusHome_Name,
//         home.StatusShowPage_ID,
//         status_showpage.StatusShowPage_Name
//     FROM status_showpage
//     INNER JOIN (status_home
//         INNER JOIN (position
//             INNER JOIN (member
//             INNER JOIN home ON member.Member_ID = home.Member_ID)
//         ON position.Position_ID = member.Position_ID)
//     ON status_home.StatusHome_ID = home.StatusHome_ID)
//     ON status_showpage.StatusShowPage_ID = home.StatusShowPage_ID
//     WHERE home.StatusHome_ID = 1
//       AND home.StatusShowPage_ID = ?
//     ORDER BY home.Home_ID DESC
//     LIMIT ?, ?
// ";

$SQL_Home = "
SELECT
    home.Home_ID,
    home.Member_ID,
    home.Home_Date,
    home.Home_Time,
    home.Home_Visitors,
    home.Home_Sub,
    home.Home_Short,
    home.Home_Category,
    home.StatusHome_ID,
    home.StatusShowPage_ID
FROM home
WHERE home.StatusHome_ID = 1
  AND home.StatusShowPage_ID = ?
ORDER BY home.Home_ID DESC
LIMIT ?, ?

if ($stmtHome = $objConnect->prepare($SQL_Home)) {
    $stmtHome->bind_param("iii", $HomeIDFixed, $startIndex, $perPage);
    $stmtHome->execute();
    $resHome = $stmtHome->get_result();
    while ($row = $resHome->fetch_assoc()) {
        $articles[] = $row;
    }
    $stmtHome->close();
}
?>

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "BreadcrumbList",
  "itemListElement":
  [
    {
      "@type": "ListItem",
      "position": 1,
      "name": "หน้าแรก",
      "item": "https://rampagesoft.com/"
    },
    {
      "@type": "ListItem",
      "position": 2,
      "name": "บทความ (Article)",
      "item": "https://rampagesoft.com/article.php"
    }
  ]
}
</script>

<div class="row pad-botm">
            <div class="col-md-12">
                <h1 class="header-line text_header_article" itemprop="name">
                    บทความ RAMPAGESOFT Ideas Lab
                </h1>

<div class="alert" itemprop="description">
                    <p itemprop="name">ความปลอดภัยคือหัวใจหลัก</p>
                    <span itemprop="description" class="text-index-3">
                       หนึ่งในคุณสมบัติเด่นของ RAMPAGESOFT Ideas Lab การให้บริการโซลูชันด้าน ความปลอดภัยสำหรับเซิร์ฟเวอร์คลาวด์ (VPS)
                       ซึ่งเป็นหัวใจสำคัญสำหรับธุรกิจที่ให้บริการออนไลน์ เช่น เว็บไซต์ เว็บแอปพลิเคชัน การเชื่อมต่อ API หรือระบบ ฟังก์ชั่น ฟีเจอร์ต่างๆ
                    </span>
                    <br><br>

<strong itemprop="name">
                       <p itemprop="name">พื้นที่แห่งการพัฒนาไอเดีย ไคเซ็น (KAIZEN)</p>
                    </strong>
                    <span itemprop="description" class="text-index-3">
                       เพิ่มความปลอดภัย ขยายโอกาสธุรกิจในโลกออนไลน์ RAMPAGESOFT Ideas Lab พร้อมเดินเคียงข้างคุณ
                       ความปลอดภัย ความคิดสร้างสรรค์ นวัตกรรม ประสิทธิภาพ คือสิ่งที่เรายึดมั่น และการพัฒนา KAIZEN
                    </span>
                </div>

</div>
        </div>

<div class="row">
        <?php
        foreach ($articles as $article) {
            $HomeID       = $article["Home_ID"];
            $HomeSub      = $article["Home_Sub"];
            $HomeShort        = urldecode($article["Home_Short"]); 
            //$HomeShort    = $article["Home_Short"];
            $HomeDate     = $article["Home_Date"];
            $HomeVisitors = $article["Home_Visitors"];

// ตรวจสอบ HomeSub ว่าถ้าเป็น "-" ให้เป็นค่าว่าง
            $Check_HomeSub2 = ($HomeSub == "-") ? "" : $HomeSub;

// ตรวจสอบ HomeShort ถ้าเป็น "-" ให้เป็นจุด
            $Check_HomeShort2 = ($HomeShort == "-") ? "." : $HomeShort;

// ตัดความยาวของ Short2 ลงเหลือสัก ~200 ตัวอักษร
            $Check_HomeShort2 = mb_strimwidth($Check_HomeShort2, 0, 200, "...", "UTF-8");

// จัดรูปแบบวันที่
            $dateObj = date_create($HomeDate);
            $NewDate = date_format($dateObj, "F d , Y");

// 3) ดึงรูปภาพ (Limit 1)
            $imageURL = "";
            if ($stmtImg = $objConnect->prepare("
                SELECT ImgHome_Img
                FROM img_home
                WHERE Home_ID = ?
                ORDER BY ImgHome_Sort ASC
                LIMIT 1
            ")) {
                $stmtImg->bind_param("i", $HomeID);
                $stmtImg->execute();
                $resImg = $stmtImg->get_result();
                if ($rowImg = $resImg->fetch_assoc()) {
                    $HomeImg_Img    = $rowImg["ImgHome_Img"];

if (preg_match('/^https?:\/\//i', $HomeImg_Img)) {
                        $imageURL = $HomeImg_Img;

}else{

$localImagePath = "model/upload/img/IMG_Home/" . $HomeImg_Img;
                        $originalURL    = "https://rampagesoft.com/" . $localImagePath;
                        $newURL         = "https://maracar.rampagesoft.com/" . $localImagePath;
    
                        if (file_exists($localImagePath)) {
                            $imageURL = $originalURL;
                        } else {
                            $imageURL = $newURL;
                        }

}

}
                $stmtImg->close();
            }
            ?>

<div class="col-xs-4 col-sm-4 col-md-4 md_mobile">
                
                <script type="application/ld+json">
                {
                    "@context": "http://schema.org",
                    "@type": "Article",
                    "mainEntityOfPage": {
                        "@type": "WebPage",
                        "@id": "<?= 'https://rampagesoft.com/article_details.php?ID=' . $HomeID . '&Name=' . urlencode($Check_HomeSub2); ?>"
                    },
                    "headline": "<?= $Check_HomeSub2; ?>",
                    "description": "<?= $Check_HomeShort2; ?>",
                    "image": "<?= $imageURL; ?>",
                    "datePublished": "<?= date('c', strtotime($HomeDate)); ?>",
                    "author": {
                        "@type": "Person",
                        "name": "RAMPAGESOFT"
                    },
                    "publisher": {
                        "@type": "Organization",
                        "name": "Rampagesoft",
                        "logo": {
                            "@type": "ImageObject",
                            "url": "http://rampagesoft.com/img/Logo/LOGO_RAMPAGESOFT_2023.webp"
                        }
                    }
                }
                </script>

<div style="color: #e2dede;">
                    <a href="article_details.php?ID=<?= $HomeID; ?>&Name=<?= urlencode($Check_HomeSub2); ?>"
                       style="color: #e3dede;text-decoration: none;">
                        <figure style="background: linear-gradient(to right, #182a3f, #050e19);">
                            <?php if(!empty($imageURL)): ?>

<img class="img-responsive img-center img_article"
                                 property="image"
                                 src="<?= $imageURL; ?>"
                                 alt="<?= $Check_HomeSub2; ?> บทความ rampagesoft ข่าวสาร AFRA APACHE"
                                 loading="lazy"
                            />
                            <?php endif; ?>
                        </figure>

<div class="row">
            <div class="col-md-12">
                <?php
                // คำนวณจำนวนหน้าทั้งหมด
                $totalPages = ($perPage > 0) ? ceil($totalArticles / $perPage) : 1;
                if ($totalPages < 1) {
                    $totalPages = 1;
                }

if ($totalPages > 1):
                ?>
                <nav aria-label="Page navigation">
                    <ul class="pagination">
                        
                        <li class="<?= ($page <= 1) ? 'disabled' : '' ?>">
                            <a href="?page=<?= ($page <= 1 ? 1 : $page - 1) ?>" aria-label="Previous">
                                <span aria-hidden="true">&laquo;</span>
                            </a>
                        </li>

<?php for($p=1; $p<=$totalPages; $p++): ?>
                        <li class="<?= ($p == $page) ? 'active' : '' ?>">
                            <a href="?page=<?= $p; ?>"><?= $p; ?></a>
                        </li>
                        <?php endfor; ?>

<li class="<?= ($page >= $totalPages) ? 'disabled' : '' ?>">
                            <a href="?page=<?= ($page >= $totalPages ? $totalPages : $page + 1) ?>" aria-label="Next">
                                <span aria-hidden="true">&raquo;</span>
                            </a>
                        </li>
                    </ul>
                </nav>
                <?php endif; ?>
            </div>
        </div>

</div>
</div>

<?php include '3End.php'; ?>

${this.title}

Code Editor : article.php