| Server IP : 82.197.83.129 / Your IP : 216.73.216.166 [ Web Server : LiteSpeed System : Linux us-bos-web1456.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u489457460 ( 489457460) PHP Version : 7.3.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u489457460/domains/syoft.com/public_html/blogs/application/controllers/ |
Upload File : |
<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Blog extends CI_Controller
{
public function blog_list()
{
$q = $this->db->query("SELECT * FROM `categories` where status='1' ");
$data['categories'] = $q->result_array();
$this->load->view('admin/blog_list', $data);
}
public function details()
{
$slug = $this->uri->segment(3);
$q = $this->db->query("SELECT * FROM `blog` where status='1' order by id desc limit 4");
$data['main_blog_list'] = $q->result_array();
$q = $this->db->query("SELECT b.*,c.`category_name`,categblog_listory_slug FROM `blog` b inner join categories c
LEFT JOIN blog a ON c.category_id = a.category_id where b.status='1' and b.post_slug='$slug' limit 1");
$data['view_data'] = $q->row_array();
$q = $this->db->query("SELECT * FROM `blog_comments` where post_id='" . $data['view_data']['id'] . "' order by comment_id desc");
$data['blog_comments'] = $q->result_array();
$q = $this->db->query("SELECT category_slug,c.`category_name`,c.category_id, COUNT(a.id) AS `posts_count` FROM categories c LEFT JOIN blog a ON c.category_id = a.category_id GROUP BY c.`category_name` ORDER BY
c.`category_name`");
$data['right_categories_list'] = $q->result_array();
$this->load->view('user/blog_detail', $data);
}
public function category()
{
$slug = $this->uri->segment(3);
$q = $this->db->query("SELECT * FROM `categories` where status='1' and category_slug='$slug'");
$data['view_data'] = $q->row_array();
$q = $this->db->query("SELECT b.*,c.`category_name` FROM `blog` b inner join categories c
ON c.category_id = b.category_id where b.status='1' and c.category_slug='$slug' order by b.id desc");
$data['blog_list'] = $q->result_array();
//echo $this->db->last_query();exit;
$q = $this->db->query("SELECT category_slug,c.`category_name`,c.category_id, COUNT(a.id) AS `posts_count` FROM categories c LEFT JOIN blog a ON c.category_id = a.category_id GROUP BY c.`category_name` ORDER BY
c.`category_name`");
$data['right_categories_list'] = $q->result_array();
$this->load->view('user/category_posts', $data);
}
public function index()
{
$q = $this->db->query("SELECT b.*,c.category_name FROM `blog` b inner join categories c on b.category_id=b.category_id where b.status='1' group by b.id order by b.id desc limit 3,10");
$data['blog_list'] = $q->result_array();
$q = $this->db->query("SELECT b.*,c.category_name FROM `blog` b inner join categories c on b.category_id=b.category_id where b.status='1' group by b.id order by b.id desc limit 0,3");
$data['main_blog_list'] = $q->result_array();
$q = $this->db->query("SELECT category_slug,c.`category_name`,c.category_id, COUNT(a.id) AS `posts_count` FROM categories c LEFT JOIN blog a ON c.category_id = a.category_id GROUP BY c.`category_name` ORDER BY
c.`category_name`");
$data['right_categories_list'] = $q->result_array();
$this->load->view('user/guides', $data);
}
public function datatable()
{
$limit = isset($_GET['start']) ? $_GET['start'] : '';
$offset = isset($_GET['length']) ? $_GET['length'] : '';
$sort_col_index = array(0 => 'created_date');
$sort_by = isset($_GET['iSortCol_0']) ? $sort_col_index[$_GET['iSortCol_0']] : 'id';
$sort_dir = isset($_GET['sSortDir_0']) ? $_GET['sSortDir_0'] : 'desc';
$search_key = isset($_GET['sSearch']) ? $_GET['sSearch'] : '';
$order_by = ' ORDER BY ' . $sort_by . ' ' . $sort_dir;
if ($limit != '') {
$limit_cond = "LIMIT $limit,$offset ";
}
$search = $_GET['search']['value'];
$serach_by = '';
if ($search != '') {
$serach_by = " where post_title LIKE '%$search%'";
}
$result_data = $this->db->query("SELECT * from blog $serach_by $order_by $limit_cond")->result_array();
$count_data = $this->db->query("SELECT count(id) as datacount from blog $serach_by ")->row_array();
$total_count = $count_data['datacount'];
$result["iTotalDisplayRecords"] = $total_count;
$result["sEcho"] = !empty($_GET['sEcho']) ? $_GET['sEcho'] : '';
$result['status'] = 1;
$result["iTotalRecords"] = $total_count;
$result['aaData'] = array();
$content = '';
$key = 0;
//echo '<pre>';print_r($result_data);
foreach ($result_data as $res) {
$checked = '';
if ($res['status'] == 1)
$checked = 'checked';
$result['aaData'][$key][] = $res['post_title'];
$result['aaData'][$key][] = '<label class="switch" >
<input type="checkbox" class="success changestatus" ' . $checked . ' data-table="blog" data-did="' . $res['id'] . '" data-colid="id">
<span class="slider round"></span>
</label>';
$result['aaData'][$key][] = date('d,M,Y', strtotime($res['added_date']));
$result['aaData'][$key][] = '<a class="btn btn-success btn-sm text-white editclass" data-did="' . $res['id'] . '" data-toggle="tooltip" data-original-title="Edit"><i class="fa fa-pencil"></i></a>
<a class="btn btn-danger btn-sm text-white delclass" data-table="blog" data-colid="id" data-did="' . $res['id'] . '" data-table="exams_list" data-toggle="tooltip" data-original-title="Delete"><i class="fa fa-trash-o"></i></a>
';
$key++;
}
echo json_encode($result);
//$data=$this->load->view('admin/datatable');
}
public function edit_blog()
{
$id = $this->input->post('id');
$q = $this->db->query("SELECT * FROM `blog` where id='$id'");
$data['view_data'] = $q->row_array();
$q = $this->db->query("SELECT * FROM `categories` where status='1' ");
$data['categories'] = $q->result_array();
$this->load->view("admin/edit_blog", $data);
}
public function save_comment()
{
$system_array = array(
'name' => $this->input->post('name'),
'comment' => $this->input->post('comment'),
'email' => $this->input->post('email'),
'post_id' => $this->input->post('post_id'),
'added_date' => date('Y-m-d H:i:s')
);
$this->db->insert('blog_comments', $system_array);
$data['status'] = 1;
$data['msg'] = 'Comment Saved Successfully';
echo json_encode($data);
exit;
}
public function save_data()
{
$post_title = $this->input->post('post_title');
$post_slug = $this->seo_friendly_url($post_title);
$post_desc = $this->input->post('post_desc');
$system_array = array(
'post_title' => $post_title,
'post_slug' => $post_slug,
'post_desc' => $post_desc,
'status' => 1,
'author_name' => $this->input->post('posted_by'),
'meta_title' => $this->input->post('category_meta_title'),
'meta_desc' => $this->input->post('category_meta_desc'),
'meta_keywords' => $this->input->post('category_meta_keywords'),
'category_id' => $this->input->post('category_id'),
'added_date' => date('Y-m-d H:i:s')
);
// print_r($system_array);exit;
if (isset($_FILES['course_image']['name']) && $_FILES['course_image']['name'] != '') {
$date = date('Ymdhis');
$configVideo['upload_path'] = 'uploads/post_images/';
$configVideo['allowed_types'] = '*';
$configVideo['overwrite'] = FALSE;
$configVideo['remove_spaces'] = TRUE;
$banner_image = $date . $_FILES['course_image']['name'];
$configVideo['file_name'] = $banner_image;
$this->load->library('upload', $configVideo);
$this->upload->initialize($configVideo);
if (!$this->upload->do_upload('course_image')) {
echo $this->upload->display_errors();
} else {
$videoDetails1 = $this->upload->data();
$course_image = $tumbnail = $videoDetails1['file_name'];
$helthy['thumbnail'] = $tumbnail;
$config = array(
"source_image" => $videoDetails1['full_path'],
"new_image" => 'uploads/post_images/thumbnails/' . $banner_image,
"maintain_ratio" => FALSE,
"width" => 350,
"height" => 180
);
$config['image_library'] = 'gd2';
// creating thumbnail
$this->load->library('image_lib');
// Set your config up
$this->image_lib->initialize($config);
// Do your manipulation
// $this->image_lib->resize();
if (!$this->image_lib->resize()) {
echo $this->image_lib->display_errors();
}
}
$system_array['post_image'] = $banner_image;
}
$this->db->insert('blog', $system_array);
$this->session->set_flashdata('error', 'Data Saved Successfully');
redirect('blog/blog_list');
$data['status'] = 1;
$data['msg'] = 'Data Saved Successfully';
echo json_encode($data);
exit;
}
function seo_friendly_url($string)
{
$string = str_replace(array('[\', \']'), '', $string);
$string = preg_replace('/\[.*\]/U', '', $string);
$string = preg_replace('/&(amp;)?#?[a-z0-9]+;/i', '-', $string);
$string = htmlentities($string, ENT_COMPAT, 'utf-8');
$string = preg_replace('/&([a-z])(acute|uml|circ|grave|ring|cedil|slash|tilde|caron|lig|quot|rsquo);/i', '\\1', $string);
$string = preg_replace(array('/[^a-z0-9]/i', '/[-]+/'), '-', $string);
return strtolower(trim($string, '-'));
}
public function update_data()
{
$id = $this->input->post('id');
$post_title = $this->input->post('post_title');
$post_slug = $this->input->post('post_slug');
$post_desc = $this->input->post('post_desc');
$system_array = array(
'post_title' => $post_title,
'post_slug' => $post_slug,
'post_desc' => $post_desc,
'author_name' => $this->input->post('posted_by'),
'meta_title' => $this->input->post('category_meta_title'),
'meta_desc' => $this->input->post('category_meta_desc'),
'meta_keywords' => $this->input->post('category_meta_keywords'),
'category_id' => $this->input->post('category_id'),
'added_date' => date('Y-m-d')
);
if (isset($_FILES['course_image']['name']) && $_FILES['course_image']['name'] != '') {
$date = date('Ymdhis');
$configVideo['upload_path'] = 'uploads/post_images/';
$configVideo['allowed_types'] = '*';
$configVideo['overwrite'] = FALSE;
$configVideo['remove_spaces'] = TRUE;
$banner_image = $date . $_FILES['course_image']['name'];
$configVideo['file_name'] = $banner_image;
$this->load->library('upload', $configVideo);
$this->upload->initialize($configVideo);
if (!$this->upload->do_upload('course_image')) {
echo $this->upload->display_errors();
} else {
$videoDetails1 = $this->upload->data();
$course_image = $tumbnail = $videoDetails1['file_name'];
$helthy['thumbnail'] = $tumbnail;
$config = array(
"source_image" => $videoDetails1['full_path'],
"new_image" => 'uploads/post_images/thumbnails/' . $banner_image,
"maintain_ratio" => FALSE,
"width" => 350,
"height" => 170
);
$config['image_library'] = 'gd2';
// creating thumbnail
$this->load->library('image_lib');
// Set your config up
$this->image_lib->initialize($config);
// Do your manipulation
// $this->image_lib->resize();
if (!$this->image_lib->resize()) {
echo $this->image_lib->display_errors();
}
}
$system_array['post_image'] = $banner_image;
}
$this->db->where('id', $id);
$this->db->update('blog', $system_array);
$this->session->set_flashdata('error', 'Data Saved Successfully');
redirect('blog/blog_list');
$data['status'] = 1;
$data['msg'] = 'Data Saved Successfully';
echo json_encode($data);
exit;
}
function estimateReadingTime($text, $wpm = 200)
{
$totalWords = str_word_count(strip_tags($text));
$minutes = floor($totalWords / $wpm);
$seconds = floor($totalWords % $wpm / ($wpm / 60));
return array(
'minutes' => $minutes,
'seconds' => $seconds
);
}
public function blog_page_data($id)
{
$servername = "localhost";
$username = "u489457460_syoft_admin";
$password = "Syoft_Admin_450Z";
$dbname = "u489457460_syoft_blogs";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT u.about_admin as udesc,u.designation as udesignation,p.author_name,p.id id, p.post_title title,p.post_image featured_image,p.post_desc descr, u.admin_name uname,u.image uimage,p.added_date udate,c.category_name category,meta_title,meta_desc,meta_keywords,p.category_id FROM blog p join categories c on p.category_id = c.category_id join wl_admins u on p.created_by = u.admin_id where p.post_slug='$id';";
$result = $conn->query($sql);
$current_post = array();
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
$current_post["id"] = $row["id"];
$current_post["category_id"] = $row["category_id"];
$current_post["title"] = $row["title"];
$current_post["desc"] = $row["descr"];
$current_post["uname"] = $row["uname"];
$current_post["author_name"] = $row["author_name"];
$current_post["featured_image"] = $row["featured_image"];
$current_post["uimage"] = $row["uimage"];
$current_post["udate"] = $row["udate"];
$current_post["category"] = $row["category"];
// $current_post["short_desc"] = $row["short_desc"];
$current_post["udesignation"] = $row["udesignation"];
// $current_post["ufacebook"] = $row["ufacebook"];
// $current_post["ulink"] = $row["ulink"];
$current_post["udesc"] = $row["udesc"];
$current_post["meta_title"] = $row["meta_title"];
$current_post["meta_desc"] = $row["meta_desc"];
$current_post["meta_keywords"] = $row["meta_keywords"];
}
}
$conn->close();
$category = $current_post["category"];
$sql = "SELECT u.about_admin as udesc,u.designation as udesignation,p.id id, p.post_title title,p.post_image featured_image,p.post_desc descr, u.admin_name uname,u.image uimage,p.added_date udate,c.category_name category FROM blog p join categories c on p.category_id = c.category_id join wl_admins u on p.created_by = u.admin_id where c.category_name = '$category' order by p.id desc;";
$result = $conn->query($sql);
$posts = array();
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
array_push($posts, array("featured_image" => $row["featured_image"], "id" => $row["id"], "title" => $row["title"], "desc" => $row["descr"], "uname" => $row["uname"], "uimage" => $row["uimage"], "udate" => $row["udate"], "category" => $row["category"]));
}
}
$conn->close();
$data["current_post"] = $current_post;
$data["allposts"] = $posts;
$read_time = $this->estimateReadingTime($data["current_post"]['desc']);
$data["blog_read_time"] = $read_time['minutes'];
$q = $this->db->query("SELECT * FROM `blog` where status='1' order by id desc limit 4");
$data['main_blog_list'] = $q->result_array();
$q = $this->db->query("SELECT u.about_admin as udesc,u.designation as udesignation,p.author_name,p.id id, p.post_title title,p.post_image featured_image,p.post_desc descr, u.admin_name uname,u.image uimage,p.added_date udate,c.category_name category FROM blog p join categories c on p.category_id = c.category_id join wl_admins u on p.created_by = u.admin_id where c.category_id = '".$current_post["category_id"]."' order by p.id desc limit 3");
$data['allposts'] = $q->result_array();
$this->load->view('blog-page', $data);
// echo "<br>";
// print_r($current_post);
// echo "<br>";
}
public function subscribe()
{
if (isset($_SERVER['HTTP_ORIGIN'])) {
header("Access-Control-Allow-Origin: {$_SERVER['HTTP_ORIGIN']}");
header('Access-Control-Allow-Credentials: true');
header('Access-Control-Max-Age: 86400'); // cache for 1 day
}
// Access-Control headers are received during OPTIONS requests
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD']))
header("Access-Control-Allow-Methods: GET, POST, OPTIONS");
if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']))
header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
exit(0);
}
$email = $this->input->post('subscribe_email');
$data = "<table width='600' cellpadding='2' cellspacing='0' border='0'>
<tr><td colspan='2'align='center'><b>Subscribe Email Details</b></td></tr>
<tr><td> </td><td> </td></tr>
<tr><td>Email:</td><td>".$email."</td></tr>
</table>";
$to = 'info@syoft.com';
$email = 'support@syoft.com';
$subject = "Syoft Subscribe Email";
$message = $data;
$headers = "From: <$email> \r\n";
//$headers .= "Cc: $cc \r\n";
$headers.= "Content-Type: text/html; charset=ISO-8859-1 \r\n";
$headers .= "MIME-Version: 1.0 \r\n";
if(mail($to,$subject,$message,$headers))
{
$data1=array();
$data1['status'] = 1;
$data1['msg'] = 'Data Saved Successfully';
echo json_encode($data1);
exit;
}
}
}