Na}{

File Content: `database.php`

<?php
class database
{
    public $host_name = "localhost";
    public $database_user = "hotnewsindia";
    public $database_password = "Farscape123!";
    public $database_name = "hotnewsindia";

    private $connection;

    public function connect()
    {
        if (!$this->connection) {
            $this->connection = new mysqli(
                $this->host_name,
                $this->database_user,
                $this->database_password,
                $this->database_name
            );

            if ($this->connection->connect_error) {
                die("Database connection failed: " . $this->connection->connect_error);
            }

            $this->connection->set_charset("utf8");
        }

        return $this->connection;
    }

    public function __destruct()
    {
        if ($this->connection) {
            $this->connection->close();
        }
    }
}

$dba = new database();

class queries extends database
{
    public function charsetOwn()
    {
        $conn = $this->connect();
        return mysqli_set_charset($conn, "utf8");
    }

    public function getData($table, $fields = "*", $conditions = '', $orderBy = '', $limit = '', $offset = '')
    {
        $conn = $this->connect();
        $conn->set_charset("utf8");

        $sql = "SELECT $fields FROM $table";

        if (!empty($conditions)) {
            $sql .= " WHERE ";
            $i = 1;
            $count = count($conditions);
            foreach ($conditions as $key => $val) {
                $clause = (strpos($val, "(") !== false || strpos($val, ")") !== false) ? "$key$val" : "$key='$val'";
                $sql .= $clause . ($i < $count ? " AND " : "");
                $i++;
            }
        }

        if ($orderBy != '') {
            $sql .= " ORDER BY $orderBy";
        }

        if ($limit != '') {
            $offset = ($offset == '') ? 0 : $offset;
            $sql .= " LIMIT $offset, $limit";
        }

        $result = $conn->query($sql);
        if ($result && $result->num_rows > 0) {
            $arr = [];
            while ($row = $result->fetch_assoc()) {
                $arr[] = $row;
            }
            return $arr;
        } else {
            return 0;
        }
    }

    public function getDataOpt($table, $fields = "*", $conditions = '', $orderBy = '', $limit = '', $offset = '', $distinct = '')
    {
        $conn = $this->connect();
        $conn->set_charset("utf8");

        $sql = ($distinct != '') ? "SELECT DISTINCT $fields FROM $table" : "SELECT $fields FROM $table";

        if (!empty($conditions)) {
            $sql .= " WHERE ";
            $i = 1;
            $count = count($conditions);
            foreach ($conditions as $key => $val) {
                $clause = "$key'$val'";
                $sql .= $clause . ($i < $count ? " AND " : "");
                $i++;
            }
        }

        if ($orderBy != '') {
            $sql .= " ORDER BY $orderBy";
        }

        if ($limit != '') {
            $offset = ($offset == '') ? 0 : $offset;
            $sql .= " LIMIT $offset, $limit";
        }

        $result = $conn->query($sql);
        if ($result && $result->num_rows > 0) {
            $arr = [];
            while ($row = $result->fetch_assoc()) {
                $arr[] = $row;
            }
            return $arr;
        } else {
            return 0;
        }
    }

    public function getSafeValue($str)
    {
        if ($str != '') {
            $conn = $this->connect();
            return mysqli_real_escape_string($conn, $str);
        }
        return '';
    }

    public function insertData($table, $conditionArr = '')
    {
        $conn = $this->connect();
        if (!empty($conditionArr)) {
            $fieldsArr = array_keys($conditionArr);
            $valuesArr = array_values($conditionArr);

            $fields = implode(",", $fieldsArr);
            $values = implode("', '", $valuesArr);
            $values = "'" . $values . "'";

            $sql = "INSERT INTO $table($fields) VALUES ($values)";
            $result = $conn->query($sql);
            return $result ? $conn->insert_id : false;
        }
        return false;
    }

    public function deleteData($table, $conditions = '')
    {
        $conn = $this->connect();
        if (!empty($conditions)) {
            $sql = "DELETE FROM $table WHERE ";
            $i = 1;
            $count = count($conditions);
            foreach ($conditions as $key => $val) {
                $sql .= "$key='$val'" . ($i < $count ? " AND " : "");
                $i++;
            }
            return $conn->query($sql);
        }
        return false;
    }

    public function updateData($table, $conditions, $where_field, $where_value)
    {
        $conn = $this->connect();
        if (!empty($conditions)) {
            $sql = "UPDATE $table SET ";
            $i = 1;
            $count = count($conditions);
            foreach ($conditions as $key => $val) {
                $sql .= "$key='$val'" . ($i < $count ? ", " : "");
                $i++;
            }
            $sql .= " WHERE $where_field='$where_value'";
            return $conn->query($sql);
        }
        return false;
    }

    public function disp_date($str)
    {
        return ($str != '') ? date('d-m-Y', strtotime($str)) : '';
    }
}
?>
Name	Size	Permission
.partials.php	3700 bytes	0644
admin-footer.php	3337 bytes	0644
admin-header.php	15427 bytes	0644
database-old.php	6609 bytes	0644
database.php	5318 bytes	0644
functions.php	2073 bytes	0644
sweet_alert_display.php	475 bytes	0644
File Content: database.php

File Content: `database.php`
