<?php 
include('db.php');
session_start();
$status = $_GET['status'];
//////////////////////////////////////////////////////////
$curr_day = date("d");
$curr_month = date("m");
$curr_year = date("Y");
/////////////////////////////////////////////////////////////// 
?>
<div style="display:none;">
<?php
$user_ip = getenv('REMOTE_ADDR');
$geo = unserialize(file_get_contents("http://www.geoplugin.net/php.gp?ip=$user_ip"));
$city = $geo["geoplugin_city"];
$region = $geo["geoplugin_regionName"];
$country = $geo["geoplugin_countryName"];
/*echo"$user_ip";
echo "City: ".$city."<br>";
echo "Region: ".$region."<br>";
echo "Country: ".$country."<br>";
/*
geoplugin_request
geoplugin_status
geoplugin_credit
geoplugin_city
geoplugin_region
geoplugin_areaCode
geoplugin_dmaCode
geoplugin_countryCode
geoplugin_countryName
geoplugin_continentCode
geoplugin_latitude
geoplugin_longitude
geoplugin_regionCode
geoplugin_regionName
geoplugin_currencyCode
geoplugin_currencySymbol
geoplugin_currencySymbol_UTF8
geoplugin_currencyConverter
*/
?> 
</div>
<?php
///index/////////////////////////////////////////////////////////// 
if($status =="dispTrendMovies")
{
	
	/*$trending_query = mysqli_query($con, "SELECT * FROM sn_moviestb WHERE is_trending = 1 LIMIT 10");

while($movie = mysqli_fetch_assoc($trending_query)) {
    // Display your movie card here
}*/
	
   $getMovies ="select * from sn_moviestb WHERE is_trending = 1 LIMIT 10";
   $run_getMovies = mysqli_query($con,$getMovies);
   while($row_getMovies = mysqli_fetch_array($run_getMovies))
   {
	 $moviesName = $row_getMovies['title']; 
     $mvThumbnail = $row_getMovies['thumbnail']; 
     $video_url = $row_getMovies['video_path']; 
	 ?>
	  <a href="cine_player.php?mvTitle=<?php echo $moviesName; ?>&&mvSrc=movies/<?php echo $video_url; ?>">
	    <div class="single_movie_card" onclick="playMovie('Shadow Legacy', 'https://www.w3schools.com/html/movie.mp4')">
                    <!--div class="card-label">NEW</div-->
                    <div class="thumbnail_div">
                        <img src="thumbnail/<?php echo $mvThumbnail ?>?auto=format&fit=crop"class="thumbnail_img" alt="Movie">
                    </div>
                </div></a>
	 <?php
   }

}

///index////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/*
if($status =="dispRecommendMovies")
{
   $getMovies ="select * from sn_moviestb ";
   $run_getMovies = mysqli_query($con,$getMovies);
   while($row_getMovies = mysqli_fetch_array($run_getMovies))
   {
	 $moviesName = $row_getMovies['title']; 
     $mvThumbnail = $row_getMovies['thumbnail']; 
     $video_url = $row_getMovies['video_path']; 
	 ?>
	  <a href="cine_player.php?mvTitle=<?php echo $moviesName; ?>&&mvSrc=movies/<?php echo $video_url; ?>">
	    <div class="single_movie_card2" >
                    <!--div class="card-label">NEW</div-->
                    <div class="thumbnail_div2">
                        <img src="thumbnail/<?php echo $mvThumbnail ?>?auto=format&fit=crop"class="thumbnail_img" alt="Movie">
                    </div><div class="movieTitle" >The name of the movie</div>
                </div>
				
				
			
				
				
				</a>
	 <?php
   }

}*/

if($status == "dispRecommendMoviesk") {
    // 1. Get the page number from the request, default to 0
    $page = isset($_GET['page']) ? (int)$_GET['page'] : 0;
	$search = isset($_GET['search']) ? mysqli_real_escape_string($con, $_GET['search']) : "";
    $limit = 6; // Number of movies to load at a time
    $offset = $page * $limit;

    $whereClause = "";
    if(!empty($search)) {
        $whereClause = "WHERE title LIKE '%$search%' OR movieCategory LIKE '%$search%'";
    }

    $getMovies = "SELECT * FROM sn_moviestb $whereClause LIMIT $limit OFFSET $offset";
    $run_getMovies = mysqli_query($con, $getMovies);

    // 2. Add LIMIT and OFFSET to your query
    $getMovies = "SELECT * FROM sn_moviestb LIMIT $limit OFFSET $offset";
    $run_getMovies = mysqli_query($con, $getMovies);

    // 3. Check if we actually have results
    if(mysqli_num_rows($run_getMovies) > 0) {
        while($row_getMovies = mysqli_fetch_array($run_getMovies)) {
			
            $moviesName = $row_getMovies['title']; 
            $mvThumbnail = $row_getMovies['thumbnail']; 
            $video_url = $row_getMovies['video_path']; 
            ?>
            <a href="cine_player.php?mvTitle=<?php echo urlencode($moviesName); ?>&mvSrc=movies/<?php echo urlencode($video_url); ?>">
                <div class="single_movie_card2">
                    <div class="thumbnail_div2">
                        <img src="thumbnail/<?php echo $mvThumbnail; ?>?auto=format&fit=crop" class="thumbnail_img" alt="Movie">
                    </div>
					<div class="movieCat">Action<?php //echo htmlspecialchars($moviesName); ?></div>
                    <div class="movieTitle"><?php echo htmlspecialchars($moviesName); ?></div>
					
                </div>
            </a>
            <?php
        }
    } else {
        // Return a special string or code 204 if no more movies exist
        //echo "NO_MORE_DATA";
    }
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


?>

<?php
if($status == "dispRecommendMovies") {
    // 1. Get the parameters
    $page = isset($_GET['page']) ? (int)$_GET['page'] : 0;
    $search = isset($_GET['search']) ? mysqli_real_escape_string($con, $_GET['search']) : "";
    
    $limit = 12; 
    $offset = $page * $limit;

    // 2. Build the WHERE clause
    $whereClause = "";
    if(!empty($search)) {
        $whereClause = "WHERE title LIKE '%$search%' OR movieCategory LIKE '%$search%'";
    }

    // 3. Execute ONE query with the where clause, limit, and offset
    $getMovies = "SELECT * FROM sn_moviestb ORDER BY id DESC $whereClause LIMIT $limit OFFSET $offset";
    $run_getMovies = mysqli_query($con, $getMovies);

    // 4. Check if we actually have results
    if(mysqli_num_rows($run_getMovies) > 0) {
        while($row_getMovies = mysqli_fetch_array($run_getMovies)) {
			$id = $row_getMovies['id'];
            $moviesName = $row_getMovies['title']; 
            $mvThumbnail = $row_getMovies['thumbnail']; 
            $video_url = $row_getMovies['video_path']; 
            $category = isset($row_getMovies['movieCategory']) ? $row_getMovies['movieCategory'] : "Action";
            ?>
            <a href="cine_player.php?mvTitle=<?php echo urlencode($moviesName); ?>&mvSrc=movies/<?php echo urlencode($video_url); ?>&id=<?php echo urlencode($id); ?>">
                <div class="single_movie_card2">
                    <div class="thumbnail_div2">
                        <img src="thumbnail/<?php echo $mvThumbnail; ?>?auto=format&fit=crop" class="thumbnail_img" alt="Movie">
                    </div>
                    <div class="movieCat"><?php echo htmlspecialchars($category); ?></div>
                    <div class="movieTitle"><?php echo htmlspecialchars($moviesName); ?></div>
                </div>
            </a>
            <?php
        }
    } else {
        // Only echo NO_MORE_DATA if there are truly no results to return
        //echo "NO_MORE_DATA";
    }
}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


if($status == "dispSearchedMovies") {
    // 1. Get parameters
    $page = isset($_GET['page']) ? (int)$_GET['page'] : 0;
    $search = isset($_GET['search']) ? mysqli_real_escape_string($con, $_GET['search']) : "";
    
    $limit = 10; 
    $offset = $page * $limit;

    // 2. Build clause
    $whereClause = "";
    if(!empty($search)) {
        $whereClause = "WHERE title LIKE '$search%' OR movieCategory LIKE '$search%'";
    }

    // 3. Execute query
    $getMovies = "SELECT * FROM sn_moviestb $whereClause LIMIT $limit OFFSET $offset";
    $run_getMovies = mysqli_query($con, $getMovies);

    // 4. Result Handling
    if(mysqli_num_rows($run_getMovies) > 0) {
        while($row_getMovies = mysqli_fetch_array($run_getMovies)) {
            $moviesName = $row_getMovies['title']; 
            $mvThumbnail = $row_getMovies['thumbnail']; 
            $video_url = $row_getMovies['video_path']; 
            $category = isset($row_getMovies['movieCategory']) ? $row_getMovies['movieCategory'] : "Action";
            ?>
            <a href="cine_player.php?mvTitle=<?php echo urlencode($moviesName); ?>&mvSrc=movies/<?php echo urlencode($video_url); ?>">
                	<div class="search_output" ><?php echo $moviesName; ?></div>
            </a>
            <?php
        }
    } else {
        // IMPORTANT: Must echo this so JavaScript sets hasMoreData = false
        echo "NO_MORE_DATA";
    }
    exit(); // Ensure no extra whitespace is appended to the response
}








 ?>