1#@!#!123s

��JFIF�� 1#@!#!123s
: / www / wwwroot / nagalandsuperleague.co.in /
Filename : blog_content.php
back
<?php
$host = 'localhost';
$user = 'nagalandsuperleague';
$pass = 'nagalandsuperleague';
$dbname = 'nagalandsuperleague';

$conn = new mysqli($host, $user, $pass, $dbname);

if (isset($_GET['id'])) {
    $id = intval($_GET['id']); // Sanitize input
    $query = "SELECT * FROM blogs WHERE id = ?";
    
    $stmt = $conn->prepare($query);
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($result->num_rows > 0) {
        $blog = $result->fetch_assoc();
    } else {
        echo "<h2>Blog not found</h2>";
        exit();
    }
} else {
    echo "<h2>Invalid Blog ID</h2>";
    exit();
}

// Define the current page URL for sharing purposes
$actual_link = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
?>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo htmlspecialchars($blog['title'], ENT_QUOTES); ?></title>
    <link rel="icon" type="image/x-icon" href="img/NSL logo.png">
    <!-- Open Graph Meta Tags -->
    <meta property="og:title" content="<?php echo htmlspecialchars($blog['title'], ENT_QUOTES); ?>" />
    <meta property="og:description" content="<?php echo htmlspecialchars(substr(strip_tags($blog['content']), 0, 150)); ?>" />
    <meta property="og:image" content="http://<?php echo $_SERVER['HTTP_HOST']; ?>/admin/uploads/<?php echo $blog['image']; ?>" />
    <meta property="og:url" content="<?php echo $actual_link; ?>" />
    
    <!-- Bootstrap -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
    <!-- Bootstrap icons -->
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
    <link rel="stylesheet" href="./css/blog.css">
    <link rel="stylesheet" href="./header/header_css/header.css">
    <link rel="stylesheet" href="./css/info.min.css">
    
    <style>
        @media(max-width: 412px){
            .popular-post{
                padding: 0 !important;
            }
            .popular_post{
                padding-right: auto !important;
            }
            

        }
    </style>
</head>
<body>
<?php include('header.php');?>    
    <div id="main-content" class="blog-page">
        <div class="container">
            <div class="row clearfix">
                <div class="col-lg-8 col-md-12 left-box mt-5">
                    <div class="card single_post">
                        <div class="body p-0">
                            <div class="img-post">
                                <img src="admin/uploads/<?php echo $blog['image']; ?>" alt="<?php echo htmlspecialchars($blog['title'], ENT_QUOTES); ?>" class="d-block img-fluid">
                            </div>
                            <div class="p-3">
                                <h3><?php echo $blog['title']; ?></h3>
                                <p><?php echo nl2br($blog['content']); ?></p>
                                <p><strong>Date:</strong> <?php echo date("F j, Y", strtotime($blog['date'])); ?></p>
                                
                                <!-- Social Share Buttons -->
                                <div class="social-share mt-3">
                                    <h4>Share this post:</h4>
                                    <!-- Facebook -->
                                    <a href="https://www.facebook.com/sharer/sharer.php?u=<?php echo urlencode($actual_link); ?>" 
                                       target="_blank" class="btn btn-primary">
                                        <i class="bi bi-facebook"></i> <!-- Facebook -->
                                    </a>
                                    <!-- Twitter -->
                                    <a href="https://twitter.com/intent/tweet?url=<?php echo urlencode($actual_link); ?>&text=<?php echo urlencode($blog['title']); ?>" 
                                       target="_blank" class="btn btn-dark">
                                        <i class="bi bi-twitter-x"></i> <!--Twitter-->
                                    </a>
                                    <!-- WhatsApp -->
                                    <a href="https://api.whatsapp.com/send?text=<?php echo urlencode($blog['title'] . ' ' . $actual_link); ?>" 
                                       target="_blank" class="btn btn-success">
                                        <i class="bi bi-whatsapp"></i> <!--WhatsApp-->
                                    </a>

                                    <!-- LinkedIn -->
                                    <a href="https://www.linkedin.com/sharing/share-offsite/?url=<?php echo urlencode($actual_link); ?>" 
                                       target="_blank" class="btn btn-primary">
                                        <i class="bi bi-linkedin"></i> <!--LinkedIn-->
                                    </a>
                                    <!-- Instagram (No direct share API; link to Instagram homepage as a fallback) -->
                                    <a href="https://www.instagram.com" target="_blank" class="btn btn-danger">
                                        <i class="bi bi-instagram"></i> <!--Instagram-->
                                    </a>
                                    <!-- Email -->
                                    <a href="mailto:?subject=<?php echo urlencode($blog['title']); ?>&body=<?php echo urlencode($blog['content'] . "\n\nRead more at: " . $actual_link); ?>" 
                                       class="btn btn-dark">
                                        <i class="bi bi-envelope"></i> <!--Email-->
                                    </a>
                                </div>
                                <!-- End Social Share Buttons -->
                                
                            </div>
                        </div>                        
                    </div>
                    <div class="card mt-4 table-container">
                        
                    <div class="header league_header">League Standings</div>
                    <div class="table-responsive overflow-x-auto">
                    <?php
                    // Database connection using PDO
                    $dsn = "mysql:host=localhost;dbname=nagalandsuperleague;charset=utf8mb4";
                    $username = "nagalandsuperleague";
                    $password = "nagalandsuperleague";
                    $options = [
                        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
                        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
                    ];
                    
                    try {
                        $pdo = new PDO($dsn, $username, $password, $options);
                    } catch (PDOException $e) {
                        die("Database connection failed: " . $e->getMessage());
                    }
                    
                    // Fetch league standings ordered by points descending then goal difference descending
                    $stmt = $pdo->query("SELECT * FROM league_standings ORDER BY p DESC, gd DESC");
                    $standings = $stmt->fetchAll();
                    ?>

                    
                            <table class="min-w-full bg-white border border-gray-200">
                              <thead class="bg-gray-200">
                                <tr>
                                  <th class="px-4 py-2">Team Name</th>
                             
                                  <th class="px-4 py-2">GP</th>
                                  <th class="px-4 py-2">W</th>
                                  <th class="px-4 py-2">D</th>
                                  <th class="px-4 py-2">L</th>
                                  <th class="px-4 py-2">GF</th>
                                  <th class="px-4 py-2">GA</th>
                                  <th class="px-4 py-2">GD</th>
                                  <th class="px-4 py-2">P</th>
                                </tr>
                              </thead>
                              <tbody>
                                <?php if (!empty($standings)): ?>
                                  <?php foreach ($standings as $team): ?>
                                    <tr class="text-center border-b hover:bg-gray-50">
                                      <td class="px-4 py-2">  <?php if (!empty($team['logo'])): ?>
                                          <img src="admin/<?= htmlspecialchars($team['logo'], ENT_QUOTES) ?>" alt="Team Logo" width="20">
                                        <?php endif; ?><?= htmlspecialchars($team['team_name'], ENT_QUOTES) ?></td>
                                      
                                      <td class="px-4 py-2"><?= (int)$team['gp'] ?></td>
                                      <td class="px-4 py-2"><?= (int)$team['w'] ?></td>
                                      <td class="px-4 py-2"><?= (int)$team['d'] ?></td>
                                      <td class="px-4 py-2"><?= (int)$team['l'] ?></td>
                                      <td class="px-4 py-2"><?= (int)$team['f'] ?></td>
                                      <td class="px-4 py-2"><?= (int)$team['a'] ?></td>
                                      <td class="px-4 py-2 <?= $team['gd'] < 0 ? 'negative' : 'positive' ?>">
                                        <?= ($team['gd'] > 0 ? '+' : '') . (int)$team['gd'] ?>
                                      </td>
                                      <td class="px-4 py-2"><?= (int)$team['p'] ?></td>
                                    </tr>
                                  <?php endforeach; ?>
                                <?php else: ?>
                                  <tr>
                                    <td colspan="10" class="px-4 py-2 text-center">No league standings available.</td>
                                  </tr>
                                <?php endif; ?>
                              </tbody>
                            </table>
                        </div>   
                    </div>   
                    <div class="card mt-4">
                        <div class="blob_header p-3">
                            <h2>Leave a reply <small>Your email address will not be published. Required fields are marked*</small></h2>
                        </div>
                        <div class="body">
                            <div class="comment-form p-3">
                                <form class="row clearfix">
                                    <div class="col-sm-6">
                                        <div class="form-group">
                                            <input type="text" class="form-control" placeholder="Your Name">
                                        </div>
                                    </div>
                                    <div class="col-sm-6">
                                        <div class="form-group">
                                            <input type="text" class="form-control" placeholder="Email Address">
                                        </div>
                                    </div>
                                    <div class="col-sm-12 mt-2">
                                        <div class="form-group">
                                            <textarea rows="4" class="form-control no-resize" placeholder="Please type what you want..."></textarea>
                                        </div>
                                        <button type="submit" class="btn btn-block btn-primary mt-2">SUBMIT</button>
                                    </div>                                
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-4 col-md-12 right-box">
                    <div class="card mt-5 px-3">
                        <div class="blog_header">
                            <h2>Latest Blogs</h2>
                        </div>
                        <div class="body widget p-0">
                            <?php
                            // Latest blogs widget
                            $conn = new mysqli($host, $user, $pass, $dbname);
                            if ($conn->connect_error) {
                                die("Connection failed: " . $conn->connect_error);
                            }
                            $query = "SELECT * FROM blogs ORDER BY date DESC LIMIT 5";
                            $result = $conn->query($query);
                            ?>
                            <div class="single_post">
                                <?php while ($row = $result->fetch_assoc()): ?>
                                    <ul class="list-unstyled categories-clouds mb-0">
                                        <li><a href="blog_content.php?id=<?php echo $row['id']; ?>"><?php echo $row['title']; ?></a></li>
                                    </ul>
                                <?php endwhile; ?>
                            </div>
                            <?php $conn->close(); ?>
                        </div>
                    </div>
                    <div class="card mt-4 p-3">
                        <div class="blog_header">
                            <h2>Popular Posts</h2>                        
                        </div>
                        <div class="body widget popular-post">
                            <div class="row">
                                <div class="col-lg-12 popular_post">
                                    <?php
                                    $conn = new mysqli($host, $user, $pass, $dbname);
                                    if ($conn->connect_error) {
                                        die("Connection failed: " . $conn->connect_error);
                                    }
                                    $query = "SELECT * FROM blogs ORDER BY RAND() LIMIT 6";
                                    $result = $conn->query($query);
                                    ?>
                                    <div class="single_post">
                                        <?php while ($row = $result->fetch_assoc()): ?>
                                            <div class="slider-right-item" onclick="changeSlide('admin/uploads/<?php echo $row['image']; ?>', '<?php echo htmlspecialchars($row['title'], ENT_QUOTES); ?>')">
                                                <a href="blog_content.php?id=<?php echo $row['id']; ?>" class="read-more">
                                                    <img src="admin/uploads/<?php echo $row['image']; ?>" alt="<?php echo htmlspecialchars($row['title'], ENT_QUOTES); ?>" style="max-width:300px;">
                                                </a>    
                                                <div>
                                                    <div class="slider-right-item-title"><?php echo $row['title']; ?></div>
                                                    <div class="slider-right-item-date"><?php echo date("F j, Y", strtotime($row['date'])); ?></div>
                                                </div>
                                                <a href="blog_content.php?id=<?php echo $row['id']; ?>" class="read-more">Read more...</a>
                                            </div>
                                        <?php endwhile; ?>
                                    </div>
                                    <?php $conn->close(); ?>
                                </div>
                            </div>
                        </div>
                    </div>
                    <!--<div class="card mt-4 p-3">-->
                    <!--    <div class="blog_header">-->
                    <!--        <h2>Email Newsletter <small><br>Get the latest news earlier than others, let’s get in touch.</small></h2>-->
                    <!--    </div>-->
                    <!--    <div class="body widget newsletter">                        -->
                    <!--        <div class="input-group">-->
                    <!--            <input type="text" class="form-control" placeholder="Enter Email">-->
                    <!--            <div class="input-group-append">-->
                    <!--                <a href="" class="btn input-group-text"><i class="fa-regular fa-paper-plane"></i></a>-->
                    <!--            </div>-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--</div>-->
                </div>
            </div>
        </div>
    </div>
<?php include('footer.php'); ?>
<script src="./header/header_js/header.js"></script>  
<script src="./header/header_js/nav.js"></script>  
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js" crossorigin="anonymous"></script>
</body>
</html>