����
������������������������������������
<?php
include "header.php";
include ("includes/connection.php");
$limit = 6;  
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };  
$start_from = ($page-1) * $limit;  

//$limit_row = "SELECT * FROM blog ORDER BY id DESC LIMIT 1, 1";
$query = mysqli_query($conn, "select * FROM blog ORDER BY id DESC");
$rows = mysqli_num_rows($query); 
$result = mysqli_fetch_array($query);
//echo "select * from blog where id != (SELECT id FROM blog ORDER BY id DESC LIMIT 1) ORDER BY id ASC LIMIT $start_from, $limit";
$query_2 = mysqli_query($conn, "select * from blog where id != (SELECT id FROM blog ORDER BY id DESC LIMIT 1) ORDER BY id ASC LIMIT $start_from, $limit");
$rows_2 = mysqli_num_rows($query_2); 

?>

</header>
    <p><link href="http://fonts.googleapis.com/css?family=Raleway:500,400,300" rel="stylesheet" type="text/css" /></p>
<div id="top-stories-global">
    <div class="jumbotron container">
        <div class="row">
            <div class="col-md-6 col-sm-10 left-content">
              <div class="subscribe">SUBSCRIBE</div>
                <br />
                  <div class="join-number">&amp; JOIN <strong>50,000+</strong></div>
                <br />
    <div class="fellow-entrepreneurs">fellow entrepreneurs</div>
    <ul class="text-list subs-features">
        <li>New Content Every Week</li>
        <li>Exclusive Access to Our Webinars</li>
        <li>Invites to Free Events In Your Area</li>
    </ul>
            </div>
<div class="col-md-4 col-sm-10 right-content"><!-- <img alt='' class='img-responsive img-arrow' src='http://FI.co/system/upload/blog-header-arrow.jpg'> --> <img alt="" class="img-responsive img-computer" src="system/upload/blog-header-image.jpg" />
 <form action="https://expertswebservices.us4.list-manage.com/subscribe/post?u=f1eec0b79908d61d671e3c9e0&amp;id=d338ffccfe" class="validate need-gdpr-consent" id="mc-embedded-subscribe-form" method="post" name="mc-embedded-subscribe-form" target="_blank" data-gdpr-consent-form-identifier="insights">
    <div class="form-row">
        <div class="input-block"><input required="" placeholder="Name" type="text" name="FIRST" value="" id="mce-FIRST" /></div>
    </div>
    <div class="form-row">
        <div class="input-block"><input required="" placeholder="Email Address" type="email" name="EMAIL" value="" id="mce-EMAIL" /></div>
    </div>
<!-- real people should not fill this in and expect good things - do not remove this or risk form bot signups --> <input id="SIGNUP" name="SIGNUP" type="hidden" value="blogheader" /> <input name="b_a67c4487fff22ab8e545f2142_304033816c" tabindex="-1" type="hidden" value="" />
    <div class="form-row">
        <div class="input-block"><input type="submit" name="subscribe" value="SUBSCRIBE" /></div>
    </div>
 </form>
</div>

  </div>
 </div>
</div>

<div class='featured-section featured-insight flex-container'>
    <div class='wrapper clickable-card-container'>
        <div class='featured-hero image-area' style='background-image: url(%27https_/FI.co/system/posts/zCalcuPiggyBank.html);'></div>
            <div class='featured-details'>
                <div class='wrapper content-area'>
                    <span class='tag -small'><?php echo $result['type'];?></span>
                     <h2 class='title large-heading'><a href="insight/beginner-startup-investing-venture-fund-operations-and-legal-setup.html"><?php echo $result['title'];?></a></h2>
                    <div class='article-post-details'>
                        By<span class='author'><?php echo $result['author'];?></span>on
                        <span class='date'><?php echo $result['created_date'];?></span>
                    </div>
                </div>
<footer class='card-footer links-area'>
    <a class="more read-more-link clickable-card-target-link" href="#"><span class='text'>Read more</span>
        <span class='icon ion-plus'></span>
    </a>
    <ul class='social-share'>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-twitter'></span>
            </a>
        </li>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-facebook'></span>
            </a>
        </li>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-linkedin'></span>
            </a>
        </li>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-googleplus'></span>
            </a>
        </li>
    </ul>
</footer>
     </div>
   </div>
</div>

<div class='cards-container container'>
    <div class='grid cards three-cards'>
    <?php 
     if($rows_2>=1){
        while($res_2 = mysqli_fetch_array($query_2)){
     ?> 
    <div class='card-col'>
       <div class='card article-card clickable-card-container'>
            <img class='image image-area' src='assets/insight/<?php echo $res_2['image']?>'>
        <div class='article-details-wrapper wrapper content-area'>
            <div class='details'>
                    <span class='tag -small -fi-news'><?php echo $res_2['type']; ?></span>
                    <h4 class='title'><?php echo $res_2['title']; ?></h4>
                    <div class='article-post-details'>
                        By<span class='author'><?php echo $res_2['author']; ?></span>on
                        <span class='date'><?php echo $res_2['created_date']; ?></span>
                    </div>
            </div>
        </div>
<footer class='card-footer links-area'>
    <a class="more read-more-link clickable-card-target-link" href="#">
        <span class='text'>Read more</span>
        <span class='icon ion-plus'></span>
    </a>
    <ul class='social-share'>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-twitter'></span>
            </a>
        </li>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-facebook'></span>
            </a>
        </li>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-linkedin'></span>
            </a>
        </li>
        <li class='item'>
            <a class='link' href='#'>
            <span class='icon ion-social-googleplus'></span>
            </a>
        </li>
    </ul>
  </footer>
 </div>
</div>

<?php }} ?>
</div>

 <?php
$query_page = mysqli_query($conn, "SELECT COUNT(id) FROM blog where id != (SELECT id FROM blog ORDER BY id DESC LIMIT 1)");
$rows_page = mysqli_num_rows($query_page); 
$result_page = mysqli_fetch_array($query_page);

$total_records = $result_page[0];  
$total_pages = ceil($total_records / $limit);  
$pagLink = "<div class='new-pagination' style='text-align: center;'><nav class='pagination' role='navigation' aria-label='pager'><span class='page'><a href='index.php?page=".($page-1)."' class='button'>Previous</a>";  
for ($i=1; $i<=$total_pages; $i++) {  
    $pagLink .= "<a href='insights.php?page=".$i."'>".$i."</a>";  
};

echo $pagLink . "<a href='insights.php?page=".($page+1)."' class='button'>NEXT</a></span></div></div>";  

?>   

</div>

<section class='call-to-action'>
    <div class='container'>
        <h2 class='title'>Are you ready to join the world&#39;s premier startup launch program?</h2>
        <a class="btn btn-cta" href="join.php"><span class='text'>Start Accelerating</span></a>
    </div>
</section>

<?php
include "footer.php";
?>