fundraiser.php

<?php
session_start();
include("header.php");	
?>
</header>

<div id="cta" class="section">

<div class="section-bg" style="background-image: url(img/charity/downloadfile.jpg);" data-stellar-background-ratio="0.5"></div>


<div class="container">

<div class="row">

<div class="col-md-offset-2 col-md-8">
<div class="cta-content text-center">
<h1>FUND RAISER</h1>
</div>
</div>

</div>

</div>

</div>



<div id="causes" class="section">

<div class="container">

<div class="row">

<?php
	$sql = "SELECT * FROM fund_raiser where status=Active";
	$qsql = mysqli_query($con,$sql);
	while($rs = mysqli_fetch_array($qsql))
	{
		$perc=0;
$sqlfund_collection = "SELECT SUM(paid_amt) FROM fund_collection where fund_raiser_id=$rs[0] AND status=Active";
$qsqlfund_collection = mysqli_query($con,$sqlfund_collection);
$rsfund_collection = mysqli_fetch_array($qsqlfund_collection);


 $perc = ($rsfund_collection[0] * 100 / $rs[fund_amount])
?>
<div class="col-md-4">
	<div class="causes">
		<div class="causes-img">
		<a href="funraiserdetailed.php?fund_raiser_id=<?php echo $rs[0]; ?>">		
		<?php
		if($rs[banner_img] == "")
		{
			echo "<img src=img/no-image-icon.png style=height: 300px;>";
		}
		else if(file_exists("imgfundraiser/".$rs[banner_img]))
		{
			echo "<img src=imgfundraiser/".$rs[banner_img]. "  style=height: 300px;>";
		}
		else
		{
			echo "<img src=img/no-image-icon.png style=height: 300px; >";	
		}
		?>
		</a>
		</div>
		<div class="causes-progress">
		<div class="causes-progress-bar">
		<div style="width: <?php echo $perc; ?>%;">
		<span><?php echo $perc ?>%</span>
		</div>
		</div>
		<div>
		<span class="causes-raised">Raised: <strong>₹<?php echo $rsfund_collection[0]; ?></strong></span>
		<span class="causes-goal">Goal: <strong>₹<?php echo $rs[fund_amount]; ?></strong></span>
		</div>
		</div>
		<div class="causes-content">
		<h3><a href="funraiserdetailed.php?fund_raiser_id=<?php echo $rs[0]; ?>"><?php echo  $rs[title]; ?></a></h3>
		<p><?php echo  $string = substr($rs[fund_raiser_description],0,100)....; ?></p>
		<a href="funraiserdetailed.php?fund_raiser_id=<?php echo $rs[0]; ?>" class="primary-button causes-donate">Donate Now</a>
		</div>
	</div>
</div>
<?php
	}
?>

<div class="clearfix visible-md visible-lg"></div>
</div>

</div>

</div>

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