1<?php include('_banner.php'); ?>

    <!-- Page Title -->
    <div class="page-title">
      <div>
        <div class="container">
          <div class="row d-flex justify-content-center text-center">
            <div class="col-lg-8">
			  <br/><br/><br/><br/>
                        
            </div>
          </div>
        </div>
      </div>
      <nav class="breadcrumbs">
        <div class="container">
          <ol>            
			  <li class="current">Home</li>	  
			  <li><a href="news.php">News and Updates</a></li>		  
			  <li><a href="programme.php">Programmes</a></li>
			  <li><a href="gallery.php">Gallery</a></li>         
          </ol>
        </div>
      </nav>
    </div><!-- End Page Title -->
	
	

    <!-- Hero Section -->
    <section id="hero" class="hero section">

      <div class="container">
        <div class="row gy-4">
          <div class="col-lg-6 order-2 order-lg-1 d-flex flex-column justify-content-center">
            <h1 data-aos="fade-up">
<?php
	                    $query5  = "SELECT * FROM page_tbl WHERE  page_name ='home_slide_top'";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$text = $info5['text'];
						$text = str_replace("\n", '<br />', $text);	
						print $text;
?> 			
			</h1>
            <p data-aos="fade-up" data-aos-delay="100">

<?php
	                    $query5  = "SELECT * FROM page_tbl WHERE  page_name ='home_slide_down'";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$text = $info5['text'];
						$text = str_replace("\n", '<br />', $text);	
						print $text;
?> 			
			
			</p>
            <div class="d-flex flex-column flex-md-row" data-aos="fade-up" data-aos-delay="200">
              <a href="about.php" class="btn-get-started">About Us <i class="bi bi-arrow-right"></i></a>
             
            </div>
          </div>
          <div class="col-lg-6 order-1 order-lg-2 hero-img" data-aos="zoom-out">
            <!--<img src="assets/img/hero-img.png" class="img-fluid animated" alt="">-->
			<?php
	                    $query5  = "SELECT * FROM  post_more_picture WHERE  art_id = 'home_slide_top' ORDER BY id DESC";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$filename = $info5['filename'];
						
						print "<img src=\"admin/piks/$filename\" alt='' class='img-fluid'>";
					?>
          </div>
        </div>
      </div>

    </section><!-- /Hero Section -->


    <section id="about" class="about section">

      <div class="container" data-aos="fade-up">
        <div class="row gx-0">

          <div class="col-lg-6 d-flex flex-column justify-content-center" data-aos="fade-up" data-aos-delay="200">
            <div class="content">
              <h3>Who We Are</h3>
<?php
	                    $query5  = "SELECT * FROM page_tbl WHERE  page_name = 'who-we-are'";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$text = $info5['text'];
						$text = str_replace("\n", '<br />', $text);	
						print $text;
?>
              <div class="text-center text-lg-start">
                <a href="about.php" class="btn-read-more d-inline-flex align-items-center justify-content-center align-self-center">
                  <span>Read More</span>
                  <i class="bi bi-arrow-right"></i>
                </a>
              </div>
            </div>
          </div>

          <div class="col-lg-6 d-flex align-items-center" data-aos="zoom-out" data-aos-delay="200">
					<?php
	                    $query5  = "SELECT * FROM  post_more_picture WHERE  art_id = 'home_intro' ORDER BY id DESC";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$filename = $info5['filename'];
						
						print "<img src=\"admin/piks/$filename\" alt='' class='img-fluid animated'>";
					?>
           
          </div>

        </div>
      </div>

    </section><!-- /About Section -->

 
    <!-- Values Section -->
    <section id="values" class="values section">

       <!-- Section Title -->
      <div class="container section-title" data-aos="fade-up">
        <h2>What we do</h2>
      </div><!-- End Section Title -->
      <div class="container">

        <div class="row gy-4">

          <div class="col-lg-4" data-aos="fade-up" data-aos-delay="100">
            <div class="card">
              <?php
						$query5  = "SELECT * FROM page_tbl WHERE  page_name ='what-we-do1'";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$text = $info5['text'];
						$text = str_replace("\n", '<br />', $text);	
						print $text;
						
						$query5  = "SELECT * FROM  post_more_picture WHERE  art_id = 'what-we-do1' ORDER BY id DESC";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$filename = $info5['filename'];
						
						print "<img src=\"admin/piks/$filename\" alt='' class='img-fluid'>";
			  ?>
			
            </div>
          </div><!-- End Card Item -->

          <div class="col-lg-4" data-aos="fade-up" data-aos-delay="200">
            <div class="card">	
              <?php
						$query5  = "SELECT * FROM page_tbl WHERE  page_name ='what-we-do2'";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$text = $info5['text'];
						$text = str_replace("\n", '<br />', $text);	
						print $text;
						
						
	                    $query5  = "SELECT * FROM  post_more_picture WHERE  art_id = 'what-we-do2' ORDER BY id DESC";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$filename = $info5['filename'];
						
						print "<img src=\"admin/piks/$filename\" alt='' class='img-fluid'>";
			  ?>
			    
            </div>
          </div><!-- End Card Item -->

          <div class="col-lg-4" data-aos="fade-up" data-aos-delay="300">
            <div class="card">
			  <?php
						$query5  = "SELECT * FROM page_tbl WHERE  page_name ='what-we-do3'";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$text = $info5['text'];
						$text = str_replace("\n", '<br />', $text);	
						print $text;
						
						$query5  = "SELECT * FROM  post_more_picture WHERE  art_id = 'what-we-do3' ORDER BY id DESC";
						$result5 = mysqli_query($conn, $query5) or die(mysqli_error($conn));	
						$info5 = mysqli_fetch_array($result5);
						$filename = $info5['filename'];
						
						print "<img src=\"admin/piks/$filename\" alt='' class='img-fluid'>";
			  ?>
              
            </div>
          </div><!-- End Card Item -->

        </div>

      </div>

    </section><!-- /Values Section -->


    <!-- Recent Posts Section -->
    <section id="recent-posts" class="recent-posts section">

      <!-- Section Title -->
      <div class="container section-title" data-aos="fade-up">
        <h2>Recent News and Updates</h2>
        
      </div><!-- End Section Title -->

      <div class="container">

        <div class="row gy-5">


<?php
$query  = "SELECT * FROM post WHERE category = 'event'  ORDER BY id DESC LIMIT 0, 6";
$result = mysqli_query($conn,$query) or die(mysqli_error($conn));

if (mysqli_num_rows($result) == 0) {
 print "SORRY: no data...";
 
}else{
			while($info = mysqli_fetch_array($result))
			{
			 		 
				$id=$info['id'];
				
				$image_name=$info['image_name'];
				$title=$info['title'];
				$date_day=$info['date_day'];
				$date_month=$info['date_month'];
				$date_year=$info['date_year'];
				$body=$info['body'];
				$posted_by=$info['posted_by'];
				$category=$info['category'];
				$cat=$info['artist_id'];
				
				
					$query_artist  = "SELECT * FROM series WHERE id = '$cat'";
					$result_artist = mysqli_query($conn,$query_artist) or die(mysqli_error($conn));
						$data = mysqli_fetch_array($result_artist);
							$name=$data['series_name'];
					
				$date="$date_day-$date_month-$date_year";	
				$date = strtotime($date); 	
				$date = date('d M Y', $date);
				
				$body = str_replace("\n", '<br />', $body);	
				
				$limit_body = substr($body, 0, 200)."...";
				$limit_body = str_replace("\n", '<br />', $limit_body);	
				
				if($image_name != ""){
					$image_path="<img src=\"admin/piks/$image_name\" class='img-fluid'>";
				}else{
					//$image_path="<img src=\"images/afriseem_logo.jpeg\" class='img-fluid'>";
					$image_path="";
				}
				
				print '
				
				
          <div class="col-xl-4 col-md-6">
            <div class="post-item position-relative h-100" data-aos="fade-up" data-aos-delay="100">

              <div class="post-img position-relative overflow-hidden">
                '.$image_path.'
                
              </div>

              <div class="post-content d-flex flex-column">

                <h3 class="post-title">'.$title.'</h3>
				
                <div class="meta d-flex align-items-center"> 
                '.$limit_body.'                
                </div>

                <hr>

                <a href="news-details.php?id='.$id.'" class="readmore stretched-link"><span>Continue reading</span><i class="bi bi-arrow-right"></i></a>

              </div>

            </div>
          </div><!-- End post item ------------------------------ -->
		  
		  
                ';
				
			}
			
	}		
			
?> 




        </div>

      </div>

    </section><!-- /Recent Posts Section -->



 

<?php include('_footer.php'); ?>