Server : LiteSpeed System : Linux in-mum-web1949.main-hosting.eu 5.14.0-503.40.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Mon May 5 06:06:04 EDT 2025 x86_64 User : u595547767 ( 595547767) PHP Version : 7.4.33 Disable Function : NONE Directory : /home/u595547767/domains/nilasevasamithi.com/public_html/admin/ |
<?php
/* Database connection */
include_once 'connect.php';
// storing request (ie, get/post) global array to a variable
$requestData= $_REQUEST;
$id1=$_POST['id'];
//Banners area begin
if($id1=='banner'){
$columns = array(
// datatable column index => database column name
0 =>'banner_id',
1 => 'banner_title',
2 => 'banner_subtitle',
3 => 'banner_image'
);
// getting total number records without any search
$sql = "SELECT banner_id, banner_title, banner_subtitle, banner_image ";
$sql.=" FROM tbl_banners";
$query=mysqli_query($con, $sql) or die("view_data.php: get banners");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT banner_id, banner_title, banner_subtitle, banner_image ";
$sql.=" FROM tbl_banners WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND ( banner_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR banner_subtitle LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR banner_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get banners");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get banners");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_banner.php?id=" . $row['banner_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["banner_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["banner_title"];
$nestedData[] = $row["banner_subtitle"];
$nestedData[] = "<img src='".$row["banner_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Banners
//notifications
if($id1=='notification'){
$columns = array(
// datatable column index => database column name
0 =>'note_id',
1 => 'note_data',
);
// getting total number records without any search
$sql = "SELECT note_id, note_data ";
$sql.=" FROM tbl_notifications";
$query=mysqli_query($con, $sql) or die("view_data.php: get notifications");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT note_id, note_data ";
$sql.=" FROM tbl_notifications WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND ( note_data LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR note_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get notifications");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get notifications");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_notification.php?id=" . $row['note_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["note_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["note_data"];
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End notifications
//Service area begin
if($id1=='service'){
$columns = array(
// datatable column index => database column name
0 =>'service_id',
1 => 'service_description',
2 => 'service_image'
);
// getting total number records without any search
$sql = "SELECT service_id, service_name, service_description, service_image ";
$sql.=" FROM tbl_services";
$query=mysqli_query($con, $sql) or die("view_data.php: get services");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT service_id, service_name, service_description, service_image ";
$sql.=" FROM tbl_services WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND ( service_name LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR service_description LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR service_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get services");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get services");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_service.php?id=" . $row['service_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["service_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["service_name"];
$nestedData[] = $row["service_description"];
$nestedData[] = "<img src='".$row["service_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Service
//Partner area begin
if($id1=='partner'){
$columns = array(
// datatable column index => database column name
0 =>'partner_id',
1 => 'partner_image'
);
// getting total number records without any search
$sql = "SELECT partner_id, partner_image ";
$sql.=" FROM tbl_partners";
$query=mysqli_query($con, $sql) or die("view_data.php: get partner");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT partner_id, partner_image";
$sql.=" FROM tbl_partners WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (parner_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR partner_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get partner");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get partner");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_partner.php?id=" . $row['partner_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["partner_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = "<img src='".$row["partner_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Partner
//Story area begin
if($id1=='story'){
$columns = array(
// datatable column index => database column name
0 =>'story_id',
1 => 'story_content',
2 => 'story_image'
);
// getting total number records without any search
$sql = "SELECT story_id, story_content, story_image ";
$sql.=" FROM tbl_story";
$query=mysqli_query($con, $sql) or die("view_data.php: get partner");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT story_id, story_content, story_image ";
$sql.=" FROM tbl_story WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (story_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR story_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get partner");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get partner");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_story.php?id=" . $row['story_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["story_id"]."' title='Delete'> </i></a>";
$st=$row["story_content"];
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $st;
$nestedData[] = "<img src='".$row["story_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Story
//Impact area begin
if($id1=='impact'){
$columns = array(
// datatable column index => database column name
0 =>'impact_id',
1 => 'impact_count',
2 => 'impact_content',
3 => 'impact_image'
);
// getting total number records without any search
$sql = "SELECT impact_id, impact_count, impact_content, impact_image ";
$sql.=" FROM tbl_impact";
$query=mysqli_query($con, $sql) or die("view_data.php: get impact");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT impact_id, impact_count, impact_content, impact_image";
$sql.=" FROM tbl_impact WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (impact_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR impact_count LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR impact_content LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get impact");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get impact");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_impact.php?id=" . $row['impact_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["impact_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["impact_count"];
$nestedData[] = $row["impact_content"];
$nestedData[] = "<img src='".$row["impact_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Impact
//Quote area begin
if($id1=='quote'){
$columns = array(
// datatable column index => database column name
0 =>'quote_id',
1 => 'quote_content'
);
// getting total number records without any search
$sql = "SELECT quote_id, quote_content";
$sql.=" FROM tbl_quote";
$query=mysqli_query($con, $sql) or die("view_data.php: get quote");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT quote_id, quote_content";
$sql.=" FROM tbl_quote WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (quote_content LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR quote_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get quote");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get quote");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_quote.php?id=" . $row['quote_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["quote_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["quote_content"];
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Quote
//Achievements area begin
if($id1=='achieve'){
$columns = array(
// datatable column index => database column name
0 =>'achieve_id',
1 => 'achieve_name',
2 => 'achieve_content',
3 => 'achieve_image'
);
// getting total number records without any search
$sql = "SELECT achieve_id, achieve_name, achieve_content, achieve_image ";
$sql.=" FROM tbl_achievement";
$query=mysqli_query($con, $sql) or die("view_data.php: get achieve");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT achieve_id, achieve_name, achieve_content, achieve_image";
$sql.=" FROM tbl_achievement WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (achieve_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR achieve_name LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR achieve_content LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get achieve");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get achieve");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_achievement.php?id=" . $row['achieve_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["achieve_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["achieve_name"];
$nestedData[] = $row["achieve_content"];
$nestedData[] = "<img src='".$row["achieve_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Achievements
//Child laws area begin
if($id1=='childlaws'){
$columns = array(
// datatable column index => database column name
0 =>'childlaws_id',
1 => 'childlaws_title',
2 => 'childlaws_content',
3 => 'childlaws_image'
);
// getting total number records without any search
$sql = "SELECT childlaws_id, childlaws_title, childlaws_content, childlaws_image ";
$sql.=" FROM tbl_childlaws";
$query=mysqli_query($con, $sql) or die("view_data.php: get childlaws");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT childlaws_id, childlaws_title, childlaws_content, childlaws_image";
$sql.=" FROM tbl_childlaws WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (childlaws_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR childlaws_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR childlaws_content LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get childlaws");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get childlaws");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_childlaws.php?id=" . $row['childlaws_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["childlaws_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["childlaws_title"];
$nestedData[] = $row["childlaws_content"];
$nestedData[] = "<img src='".$row["childlaws_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Child laws
//Team area begin
if($id1=='team'){
$columns = array(
// datatable column index => database column name
0 =>'team_id',
1 => 'team_name',
2 => 'team_type',
3 => 'team_designation',
4 => 'team_image'
);
// getting total number records without any search
$sql = "SELECT team_id, team_name, team_type, team_designation,team_image ";
$sql.=" FROM tbl_team";
$query=mysqli_query($con, $sql) or die("view_data.php: get team");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT team_id, team_name, team_type, team_designation, team_image";
$sql.=" FROM tbl_team WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (team_designation LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR team_name LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR team_type LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get team");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get team");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_team.php?id=" . $row['team_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["team_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["team_name"];
$nestedData[] = $row["team_type"];
$nestedData[] = $row["team_designation"];
$nestedData[] = "<img src='".$row["team_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Team
//Happiness program area begin
if($id1=='happyprogram'){
$columns = array(
// datatable column index => database column name
0 =>'program_id',
1 => 'program_image'
);
// getting total number records without any search
$sql = "SELECT program_id, program_image ";
$sql.=" FROM tbl_happyprogram";
$query=mysqli_query($con, $sql) or die("view_data.php: get happyprogram");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT program_id, program_image ";
$sql.=" FROM tbl_happyprogram WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (program_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR program_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get happyprogram");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get happyprogram");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_happyprogram.php?id=" . $row['program_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["program_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = "<img src='".$row["program_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Happiness Program
//Team photo area begin
if($id1=='teamphoto'){
$columns = array(
// datatable column index => database column name
0 =>'photo_id',
1 => 'photo_team'
);
// getting total number records without any search
$sql = "SELECT photo_id, photo_team ";
$sql.=" FROM tbl_teamphoto";
$query=mysqli_query($con, $sql) or die("view_data.php: get teamphoto");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT photo_id, photo_team";
$sql.=" FROM tbl_teamphoto WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (photo_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR photo_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get teamphoto");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get teamphoto");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_teamphoto.php?id=" . $row['photo_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["photo_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = "<img src='".$row["photo_team"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End TeamPhoto
//Media Report area begin
if($id1=='mediareport'){
$columns = array(
// datatable column index => database column name
0 =>'media_id',
1 => 'media_image'
);
// getting total number records without any search
$sql = "SELECT media_id, media_image ";
$sql.=" FROM tbl_mediareport";
$query=mysqli_query($con, $sql) or die("view_data.php: get mediareport");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT media_id, media_image";
$sql.=" FROM tbl_mediareport WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (media_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR media_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get mediareport");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get mediareport");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_mediareport.php?id=" . $row['media_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["media_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = "<img src='".$row["media_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End mediareport
//video Report area begin
if($id1=='videoreport'){
$columns = array(
// datatable column index => database column name
0 =>'video_id',
1 => 'video_link'
);
// getting total number records without any search
$sql = "SELECT video_id, video_link ";
$sql.=" FROM tbl_videoreport";
$query=mysqli_query($con, $sql) or die("view_data.php: get videoreport");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT video_id, video_link";
$sql.=" FROM tbl_videoreport WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (video_link LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR video_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get videoreport");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get videoreport");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_videoreport.php?id=" . $row['video_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["video_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["video_link"];
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End videoreport
//Newsletter area begin
if($id1=='newsletter'){
$columns = array(
// datatable column index => database column name
0 =>'newsletter_id',
1 =>'newsletter_title',
2 =>'newsletter_file',
3 => 'newsletter_title'
);
// getting total number records without any search
$sql = "SELECT newsletter_id, newsletter_title, newsletter_file, newsletter_image ";
$sql.=" FROM tbl_newsletter";
$query=mysqli_query($con, $sql) or die("view_data.php: get newsletter");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT newsletter_id, newsletter_title, newsletter_file, newsletter_image ";
$sql.=" FROM tbl_newsletter WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (newsletter_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR newsletter_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR newsletter_file LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get newsletter");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get newsletter");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_newsletter.php?id=" . $row['newsletter_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["newsletter_id"]."' title='Delete'> </i></a>";
$rf=$row['newsletter_file'];
$pdf=substr(strrchr($rf, '/'), 1);
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row['newsletter_title'];
$nestedData[] = $pdf;
$nestedData[] = "<img src='".$row["newsletter_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End newletter
//event area begin
if($id1=='event'){
$columns = array(
// datatable column index => database column name
0 =>'event_id',
1 => 'event_title',
2 => 'event_content',
3 => 'event_date',
4 => 'event_image'
);
// getting total number records without any search
$sql = "SELECT event_id, event_title, event_content, event_date, event_image ";
$sql.=" FROM tbl_events";
$query=mysqli_query($con, $sql) or die("view_data.php: get event");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT event_id, event_title, event_content, event_date, event_image";
$sql.=" FROM tbl_events WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (event_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR event_content LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR event_date LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get event");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get event");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_event.php?id=" . $row['event_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["event_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["event_title"];
$nestedData[] = $row["event_content"];
$nestedData[] = $row["event_date"];
$nestedData[] = "<img src='".$row["event_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End event
//Gallery area begin
if($id1=='gallery'){
$columns = array(
// datatable column index => database column name
0 =>'gallery_id',
1 =>'gallery_type',
2 => 'gallery_image'
);
// getting total number records without any search
$sql = "SELECT gallery_id, gallery_type, gallery_image ";
$sql.=" FROM tbl_gallery";
$query=mysqli_query($con, $sql) or die("view_data.php: get gallery");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT gallery_id, gallery_type, gallery_image ";
$sql.=" FROM tbl_gallery WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (gallery_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR gallery_type LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR gallery_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get gallery");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get gallery");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_gallery.php?id=" . $row['gallery_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["gallery_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row['gallery_type'];
$nestedData[] = "<img src='".$row["gallery_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End Gallery
//annualreport area begin
if($id1=='annualreport'){
$columns = array(
// datatable column index => database column name
0 =>'report_id',
1 =>'report_title',
2 =>'report_file',
3 => 'report_image'
);
// getting total number records without any search
$sql = "SELECT report_id, report_title, report_file, report_image ";
$sql.=" FROM tbl_annualreport";
$query=mysqli_query($con, $sql) or die("view_data.php: get annualreport");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT report_id, report_title, report_file, report_image ";
$sql.=" FROM tbl_annualreport WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (report_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR report_file LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR report_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get annualreport");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get annualreport");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_annualreport.php?id=" . $row['report_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["report_id"]."' title='Delete'> </i></a>";
$rf=$row['report_file'];
$pdf=substr(strrchr($rf, '/'), 1);
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row['report_title'];
$nestedData[] = $pdf;
$nestedData[] = "<img src='".$row["report_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End annualreport
//csractivity area begin
if($id1=='csractivity'){
$columns = array(
// datatable column index => database column name
0 =>'csractivity_id',
1 => 'csractivity_title'
);
// getting total number records without any search
$sql = "SELECT csractivity_id, csractivity_title";
$sql.=" FROM tbl_csractivity";
$query=mysqli_query($con, $sql) or die("view_data.php: get csractivity");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT csractivity_id, csractivity_title";
$sql.=" FROM tbl_csractivity WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (csractivity_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR csractivity_id LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get csractivity");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get csractivity");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_csractivity.php?id=" . $row['csractivity_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["csractivity_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["csractivity_title"];
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End csractivity
//csrsubactivity area begin
if($id1=='csrsubactivity'){
$columns = array(
// datatable column index => database column name
0 =>'csrsub_id',
1 => 'csractivity_id',
2 => 'csrsub_title',
3 => 'csrsub_list',
4 => 'csrsub_image'
);
// getting total number records without any search
$sql = "SELECT csrsub_id, csractivity_id, csrsub_title, csrsub_list, csrsub_image ";
$sql.=" FROM tbl_csrsubactivity";
$query=mysqli_query($con, $sql) or die("view_data.php: get csractivity");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT csrsub_id, csractivity_id, csrsub_title, csrsub_list, csrsub_image";
$sql.=" FROM tbl_csrsubactivity WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (csrsub_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR csrsub_list LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR csrsub_image LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get csractivity");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get csractivity");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_csrsubactivity.php?id=" . $row['csrsub_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["csrsub_id"]."' title='Delete'> </i></a>";
$sql1 = "SELECT csractivity_title ";
$sql1.=" FROM tbl_csractivity WHERE csractivity_id=" . $row['csractivity_id'] ."";
$query1=mysqli_query($con, $sql1);
while( $row1=mysqli_fetch_array($query1) ) {
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row1["csractivity_title"];
$nestedData[] = $row["csrsub_title"];
$nestedData[] = $row["csrsub_list"];
$nestedData[] = "<img src='".$row["csrsub_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End csractivity
//testimonial area begin
if($id1=='testimonial'){
$columns = array(
// datatable column index => database column name
0 =>'testimonial_id',
1 => 'testimonial_name',
2 => 'testimonial_designation',
3 => 'testimonial_content',
4 => 'testimonial_image'
);
// getting total number records without any search
$sql = "SELECT testimonial_id, testimonial_name, testimonial_designation, testimonial_content, testimonial_image ";
$sql.=" FROM tbl_testimonial";
$query=mysqli_query($con, $sql) or die("view_data.php: get testimonial");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT testimonial_id, testimonial_name, testimonial_designation, testimonial_content, testimonial_image ";
$sql.=" FROM tbl_testimonial WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (testimonial_name LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR testimonial_designation LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR testimonial_content LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get testimonial");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get testimonial");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_testimonial.php?id=" . $row['testimonial_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["testimonial_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["testimonial_name"];
$nestedData[] = $row["testimonial_designation"];
$nestedData[] = $row["testimonial_content"];
$nestedData[] = "<img src='".$row["testimonial_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End testimonial
//servicedetails area begin
if($id1=='servicedetails'){
$columns = array(
// datatable column index => database column name
0 =>'servicedetails_id',
1 =>'service_id',
2 =>'servicedetails_title',
3 =>'servicedetails_content',
4 =>'servicedetails_image'
);
// getting total number records without any search
$sql = "SELECT servicedetails_id, service_id, servicedetails_title, servicedetails_content, servicedetails_image ";
$sql.=" FROM tbl_servicedetails";
$query=mysqli_query($con, $sql) or die("view_data.php: get servicedetails");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT servicedetails_id, service_id, servicedetails_title, servicedetails_content, servicedetails_image ";
$sql.=" FROM tbl_servicedetails WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND ( servicedetails_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR servicedetails_content LIKE '".$requestData['search']['value']."%' ";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get servicedetails");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get servicedetails");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_servicedetails.php?id=" . $row['servicedetails_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["servicedetails_id"]."' title='Delete'> </i></a>";
$sql1 = "SELECT service_name ";
$sql1.=" FROM tbl_services WHERE service_id=" . $row['service_id'] ."";
$query1=mysqli_query($con, $sql1);
while( $row1=mysqli_fetch_array($query1) ) {
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row1['service_name'];
$nestedData[] = $row['servicedetails_title'];
$nestedData[] = $row['servicedetails_content'];
$nestedData[] = "<img src='".$row["servicedetails_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End servicedetails
//serviceimpact area begin
if($id1=='serviceimpact'){
$columns = array(
// datatable column index => database column name
0 =>'serviceimpact_id',
1 => 'service_id',
2 => 'serviceimpact_title',
3 => 'serviceimpact_content',
4 => 'serviceimpact_image'
);
// getting total number records without any search
$sql = "SELECT serviceimpact_id, service_id, serviceimpact_title, serviceimpact_content, serviceimpact_image ";
$sql.=" FROM tbl_serviceimpact";
$query=mysqli_query($con, $sql) or die("view_data.php: get serviceimpact");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT serviceimpact_id, service_id, serviceimpact_title, serviceimpact_content, serviceimpact_image";
$sql.=" FROM tbl_serviceimpact WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (serviceimpact_image LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR serviceimpact_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR serviceimpact_content LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get serviceimpact");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get serviceimpact");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_serviceimpact.php?id=" . $row['serviceimpact_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["serviceimpact_id"]."' title='Delete'> </i></a>";
$sql1 = "SELECT service_name ";
$sql1.=" FROM tbl_services WHERE service_id=" . $row['service_id'] ."";
$query1=mysqli_query($con, $sql1);
while( $row1=mysqli_fetch_array($query1) ) {
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row1['service_name'];
$nestedData[] = $row["serviceimpact_title"];
$nestedData[] = $row["serviceimpact_content"];
$nestedData[] = "<img src='".$row["serviceimpact_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End serviceimpact
//work with us area begin
if($id1=='work'){
$columns = array(
// datatable column index => database column name
0 =>'work_id',
1 => 'work_title',
2 => 'work_requirement',
3 => 'work_image'
);
// getting total number records without any search
$sql = "SELECT work_id, work_title, work_requirement, work_image ";
$sql.=" FROM tbl_workwithus";
$query=mysqli_query($con, $sql) or die("view_data.php: get work");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT work_id, work_title, work_requirement, work_image";
$sql.=" FROM tbl_workwithus WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (work_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR work_requirement LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR work_image LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get work");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get work");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_workwithus.php?id=" . $row['work_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["work_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["work_title"];
$nestedData[] = $row["work_requirement"];
$nestedData[] = "<img src='".$row["work_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End work
//donate with us area begin
if($id1=='donate'){
$columns = array(
// datatable column index => database column name
0 =>'donate_id',
1 => 'donate_title',
2 => 'donate_amount',
3 => 'donate_image'
);
// getting total number records without any search
$sql = "SELECT donate_id, donate_title, donate_amount, donate_image ";
$sql.=" FROM tbl_donate";
$query=mysqli_query($con, $sql) or die("view_data.php: get donate");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData; // when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT donate_id, donate_title, donate_amount, donate_image";
$sql.=" FROM tbl_donate WHERE 1=1";
if( !empty($requestData['search']['value']) ) { // if there is a search parameter, $requestData['search']['value'] contains search parameter
$sql.=" AND (donate_title LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR donate_amount LIKE '".$requestData['search']['value']."%' ";
$sql.=" OR donate_image LIKE '".$requestData['search']['value']."%' )";
}
$query=mysqli_query($con, $sql) or die("view_data.php: get donate");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.
$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." ";
/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc */
$query=mysqli_query($con, $sql) or die("view_data.php: get donate");
$data = array();
$i=1;
while( $row=mysqli_fetch_array($query) ) { // preparing an array
$ed="<a href='update_donate.php?id=" . $row['donate_id'] ." ' class='sb2-2-1-edit'><i class='fa fa-pencil-square-o' title='Edit'></i></a>";
$de="<a href='#myModal' class='sb2-2-1-delete' data-toggle='modal'><i class='fa fa-trash-o delete' data-id='".$row["donate_id"]."' title='Delete'> </i></a>";
$nestedData=array();
$nestedData[] = $i;
$nestedData[] = $row["donate_title"];
$nestedData[] = $row["donate_amount"];
$nestedData[] = "<img src='".$row["donate_image"]."' height='80px'>";
$nestedData[] = $ed;
$nestedData[] = $de;
$data[] = $nestedData;
$i++;
}
$json_data = array(
"draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval( $totalData ), // total number of records
"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data // total data array
);
echo json_encode($json_data); // send data as json format
}
//End donate
?>