File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/Zencefilli/php_files/dbconnect.php

<?php
	class Database
{
     
    private $host = "localhost";
    private $db_name = "zencefilli_derman";
    private $username = "zencefilli_derman_user";
    private $password = "Kh{tMv?%.l9q";
    public $conn;
     
    public function dbConnection()
	{
     
	    $this->conn = null;    
        try
		{
            $this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);
			$this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$this->conn->exec("set names utf8");			
        }
		catch(PDOException $exception)
		{
            echo "Connection error: " . $exception->getMessage();
        }
         
        return $this->conn;
    }
    public function runQuery($sql)
	{
		$stmt = $this->conn->prepare($sql);
		return $stmt;
	}
}

class USER
{

private $conn;
	
	public function __construct()
	{
		$database = new Database();
		$db = $database->dbConnection();
		$this->conn = $db;
    }
	
	public function runQuery($sql)
	{
		$stmt = $this->conn->prepare($sql);
		return $stmt;
	}
	 public function lastInsertId() {
        return $this->conn->lastInsertId();
    }
	public function is_loggedin()
	{
		if(isset($_SESSION['user_session']) && isset($_SESSION['user_session_username']) && isset($_SESSION['user_session_category']))
		{
			return true;
		}
	}

public function redirect($url)
	{
		header("Location: $url");
	}
	
	public function doLogout()
	{
		session_destroy();
		unset($_SESSION['user_session']);
		unset($_SESSION['user_session_username']);
		unset($_SESSION['user_session_category']);
		unset($_SESSION['user_session_email']);
		unset($_SESSION['user_name']);
		unset($_SESSION['user_phone']);
		unset($_SESSION['user_session_foto']);
		return true;
	}

}

Batal

⬅ Naik ke Zencefilli 1 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘dbconnect.php	php	1.7 KB	2024-08-11 03:31	✏️ Edit 👁️ View