����
������������������������������������
<?php
include "header.php";
include ("includes/connection.php");

//$limit_row = "SELECT * FROM blog ORDER BY id DESC LIMIT 1, 1";
$query = mysqli_query($conn, "select type FROM partners");
$rows = mysqli_num_rows($query); 
?>

<main class='site-container'>
    <div class='partners'>
        <div class='article container container-small'>
            <header class='hero-simple'><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
            <h1 class='xlarge-heading title'>Partners</h1>
            </header>
            <p class='body-text hero-caption'>Accelerativ proudly partners with organizations that support global startup ecosystem growth.</p>
        </div>
<?php 
if($rows>=1){ 
    $type_store =array();
while($result_ol = mysqli_fetch_array($query)){
    $type_store[] = $result_ol['type'];
   // print_r($type_store);
}   

?>
<?php  if (in_array("Local Partners", $type_store)){
  
?>
<section class='local-sponsors'>
    <div class='section-heading -home flex-container'>
        <h3 class='title'>Local Partners</h3>
    </div>
    <div class='container'>
        <ul class='fi-sponsors'>
    <?php
    $query_2 = mysqli_query($conn, "select * FROM partners where type= 'Local Partners' ");
        while($res_2 = mysqli_fetch_array($query_2)){
     ?> 
    <li class='fi-sponsor'>
        <a target="_blank" class="fi-sponsor-link" href="<?php echo $res_2['links']; ?>"><img src='assets/partners/<?php echo $res_2['image'];?>'></a>
    <?php if ($res_2['description'] != ''){ ?>
    <div class='description'>
        <?php echo base64_decode($res_2['description']); ?>           
    </div>    
    <?php } ?> 
    </li>
    <?php } ?>
   </ul>
  </div>
</section>
<?php  }?>

<?php  if (in_array("Premier Partner Resources", $type_store)){?>
<section class='partners-list'>
        <div class='section-heading -home flex-container'>
            <h3 class='title'>Platinum Partner Resources</h3>
        </div>
        <div class='container'>
         <div class='cards three-cards'>
        <?php 
            $query_2 = mysqli_query($conn, "select * FROM partners where type= 'Premier Partner Resources' ");
            while($res_2 = mysqli_fetch_array($query_2)){
         ?> 
          <div class='card-col'>
           <div class='company-card card'>
            <div class='details'>
                <div class='logo'>
                    <a class='fi-partner-link' href='<?php echo $res_2['links']; ?>' target='_blank'>
                    <img src="assets/partners/<?php echo $res_2['image']; ?>" />
                    </a>
                </div>
               <?php if ($res_2['description'] != ''){ ?>
                <div class='description'>
                    <?php echo base64_decode($res_2['description']); ?>           
                </div>    
                <?php } ?> 
            </div>
           </div>
          </div>
         <?php } ?> 
         </div>
        </div>
</section>
  <?php }   ?>
  
<?php  if (in_array("Acclaimed Partner Resources", $type_store)){?>
<section class='partners-list'>
    <div class='section-heading -home flex-container'>
        <h3 class='title'>Acclaimed Partner Resources</h3>
    </div>
    <div class='container'>
     <div class='cards three-cards'>
           <?php 
            $query_2 = mysqli_query($conn, "select * FROM partners where type= 'Acclaimed Partner Resources' ");
            while($res_2 = mysqli_fetch_array($query_2)){
         ?> 
         
      <div class='card-col'>
       <div class='company-card card'>
        <div class='details'>
            <div class='logo'>
                <a class='fi-partner-link' href='<?php echo $res_2['links']; ?>' target='_blank'>
                 <img src="assets/partners/<?php echo $res_2['image']; ?>" />
                </a>
            </div>
           <?php if ($res_2['description'] != ''){ ?>
                <div class='description'>
                    <?php echo base64_decode($res_2['description']); ?>           
                </div>    
            <?php } ?>
        </div>
       </div>
      </div>
      <?php } ?>
     </div>
    </div>
</section>
<?php } ?>

<?php  if (in_array("Additional Partners", $type_store)){?>
<section class='partners-list'>
    <div class='section-heading -home flex-container'>
        <h3 class='title'>Gold Partner Resources</h3>
    </div>
<div class='container'>
 <div class='cards three-cards'>
        <?php 
           $query_2 = mysqli_query($conn, "select * FROM partners where type= 'Additional Partners' ");
           while($res_2 = mysqli_fetch_array($query_2)){
         ?>
  <div class='card-col'>
   <div class='company-card card'>
    <div class='details'>
        <div class='logo'>
            <a class='fi-partner-link' href='<?php echo $res_2['links']; ?>' target='_blank'>
             <img src="assets/partners/<?php echo $res_2['image']; ?>" />
            </a>
        </div>
         <?php if ($res_2['description'] != ''){ ?>
                <div class='description'>
                    <?php echo base64_decode($res_2['description']); ?>           
                </div>    
            <?php } ?>
    </div>
   </div>
  </div>
 <?php } ?> 
 </div>
</div>
</section>
<?php } ?>
<?php } ?>
</div>
</main>
<style>
    .card-col>.company-card.card {
    display: table;
}
</style>
<?php
include "footer.php";
?>