AddedPane-select-returned-ActionPlan.php

<?php
include('Connection.php');
session_start();
// SETTINGS
$record_per_page = 10;
$page = '';

if(isset($_POST["page"]))
{
	$page = $_POST["page"];
}
else
{
	$page = 1;
}

$start_from = ($page - 1) * $record_per_page;
$sql = "SELECT id,title,color,start,end,proponent,situation,place,semester,notes FROM `student_council` 
inner join events on events.student_council_idstudent_council = student_council.idstudent_council
where  student_council.organization_ID = '".$_SESSION['OrgID']."'
 and Situation = 'Returned' order by start LIMIT $start_from,$record_per_page";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0 )
{
	echo '<table class = "table">
	<tr>
				<th>Title</th>
				<th>Date</th>
				<th>Place</th>
				<th>Status</th>
				<th>Functions</th>
			</tr>';
	while($row = mysqli_fetch_array($result))
	{
		echo '<tr class = "danger">
					<td class = "user_id" data-idpass ="'.$row["id"].'">' .$row["title"].'</td>
					<td class ="firstname" data-column="emp_firstname">'.substr($row["start"],0,10).'</td>
					<td class ="lastname" data-column="emp_lastname" data-id2 = "'.$row["place"].'">'.$row["place"].'</td>
					<td class ="password" data-column="emp_password" data-id3 = "'.$row["situation"].'">'.$row["situation"].'</td>
					<td>
					<a id = "btn_view" data-toggle="modal" data-target="#myModal" data-id4="'.$row["id"].'" class="btn btn-sm btn-info">
					<span class="glyphicon glyphicon-eye-open"></span> View</a>
					<a id = "btn_edit" data-toggle="modal" data-target="#myModal" data-id5="'.$row["id"].'" class="btn btn-sm btn-primary">
					<span class="glyphicon glyphicon-pencil"></span> Edit</a>
					</td>
			</tr>';
	}
}
else
{
	echo '<table class = "table">
	<thead>
		<tr>
			<td colspan = "6" class = "text-center"><kbd>Returned</kbd> from Action Plan</td>
		<tr>
	</thead>
	';
	echo '<tr>
					<td colspan = "6" class = "text-center"> No returned events yet </td>
				</tr>';
}
echo '</table>';

$page_query = "SELECT id,title,color,start,end,proponent,situation,place,semester,notes FROM `student_council` 
inner join events on events.student_council_idstudent_council = student_council.idstudent_council
where  student_council.organization_ID = '".$_SESSION['OrgID']."'
 and Situation = 'Returned'";
$page_result = mysqli_query($conn, $page_query);
$total_records = mysqli_num_rows($page_result);
$total_pages = ceil($total_records/$record_per_page);
echo '<div class = "text-center">';
for($i = 1; $i <= $total_pages; $i++)
{
		echo'<button class = "pagination_link btn btn-default" id = "'.$i.'" style= "cursor:pointer; border:1px solid #ccc;">'.$i.'</button>';
}
echo '</div>';

?>