| 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/writer/ |
Upload File : |
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
function getCategories(){
include 'connections.php';
$sql = "SELECT category_id, category_name FROM categories";
$result = $conn->query($sql);
$categories = array();
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
array_push($categories, array("id" => $row["category_id"],"name" => $row["category_name"]));
}
} $conn->close(); return $categories;
}
function getTwoTopBlogs(){
include 'connections.php';
$sql = "SELECT p.id id, p.title title,p.featured_image featured_image,p.html_description descr,p.short_desc short_desc, u.name uname,u.image uimage,p.updated_date udate,c.name category FROM posts p join category c on p.category_id = c.id join users u on p.created_by = u.id order by p.id desc LIMIT 2;";
$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"],"short_desc" => $row["short_desc"],"id" => $row["id"],"title" => $row["title"],"desc" => $row["descr"],"uname" => $row["uname"],"uimage" => $row["uimage"],"udate" => $row["udate"],"category" => $row["category"]));
}
} $conn->close(); return $posts;
}
function getThreeBlogsByCategory($cat_name){
include 'connections.php';
$sql = "SELECT p.author_name,p.id id, p.post_title title,p.post_slug slug, 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 like '%$cat_name%' order by p.id desc limit 3";
$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("author_name" => $row["author_name"],"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"], "slug" => $row["slug"]));
}
} $conn->close(); return $posts;
}
function getAllOtherPosts(){
include 'connections.php';
$sql = "SELECT p.author_name,p.id id, p.post_title title,p.post_slug slug, 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 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"], "slug" => $row["slug"]));
}
} $conn->close(); return $posts;
}
function getAllCategoryPosts($category_id){
include 'connections.php';
$sql = "SELECT p.author_name,p.id id, p.post_title title,p.post_slug slug, 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 p.category_id in($category_id) 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("author_name" => $row["author_name"],"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"], "slug" => $row["slug"]));
}
} $conn->close(); return $posts;
}
function getSearchPosts($category_id){
include 'connections.php';
$sql = "SELECT p.author_name,p.id id, p.post_title title,p.post_slug slug, 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 like '%$category_id%' or p.post_title like '%$category_id%' 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("author_name" => $row["author_name"],"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"], "slug" => $row["slug"]));
}
} $conn->close(); return $posts;
}
function getAllPosts(){
include 'connections.php';
$sql = "SELECT p.author_name,p.id id, p.title title,p.featured_image featured_image,p.html_description descr,p.short_desc short_desc, u.name uname,u.image uimage,p.updated_date udate,c.name category FROM posts p join category c on p.category_id = c.id join users u on p.created_by = u.id 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"],"short_desc" => $row["short_desc"],"id" => $row["id"],"title" => $row["title"],"desc" => $row["descr"],"uname" => $row["uname"],"uimage" => $row["uimage"],"udate" => $row["udate"],"category" => $row["category"]));
}
} $conn->close(); return $posts;
}
function getPostDetail($id){
include 'connections.php';
$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,meta_title,meta_desc,meta_keywords 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.id=$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["title"] = $row["title"];
$current_post["desc"] = $row["descr"];
$current_post["uname"] = $row["uname"];
$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(); return $current_post;
}
function getPostSlugDetail($id){
include 'connections.php';
$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,meta_title,meta_desc,meta_keywords 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["title"] = $row["title"];
$current_post["desc"] = $row["descr"];
$current_post["uname"] = $row["uname"];
$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(); return $current_post;
}
function getRelatedPosts($category){
include 'connections.php';
$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(); return $posts;
}
function getDescrptionOnlyTest(){
include 'connections.php';
$sql = "SELECT p.html_description descr FROM posts p join category c on p.category_id = c.id join users u on p.created_by = u.id order by p.id asc LIMIT 1;";
$result = $conn->query($sql);
$current_post = array();
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$current_post["desc"] = $row["descr"];
}
} $conn->close(); return $current_post;
}
function insertPost($title, $desc, $short_desc, $image, $user, $category){
include 'connections.php';
$sql = "insert into posts (title, html_description, short_desc, featured_image, created_by,category_id) values ('$title','$desc','$short_desc','$image',$user,$category);";
$result = $conn->query($sql);
if ($conn->query($sql) === TRUE) {
return true;
} else {
return false;
}
}
function updatePost($title, $desc, $short_desc, $image, $user, $category,$update_id){
include 'connections.php';
$sql = "update posts set title = '$title', html_description='$desc', short_desc='$short_desc', featured_image='$image', created_by=$user,category_id=$category where id = '$update_id'";
$result = $conn->query($sql);
if ($conn->query($sql) === TRUE) {
return true;
} else {
return false;
}
}
?>