PK     ;<�Z��]��   �   	  Model.phpnu �[���        <?php
namespace App\Core;

class Model{

    // public $db_handle;

    // function __construct() {
    //     $this->db_handle = new \App\Core\Database;
    // }
}


?>PK     ;<�Z�����  �    View.phpnu �[���        <?php

namespace App\Core;

class View
{

    public static function render($view, $args = [])
    {
        extract($args, EXTR_SKIP);

        $file = dirname(dirname(dirname(__FILE__))) . '/resources/views/' . $view . '.php';

        if (is_readable($file)) {
            require_once $file;
        } else {
            throw new \Exception("$file not found");
        }
    }
}
PK     ;<�Z[M�  �    Database.phpnu �[���        <?php

namespace App\Core;

class Database
{
    private static $host;
    private static $user;
    private static $password;
    private static $database;
    private static $conn;

    private static $instance;

    function __construct()
    {

        self::$host = env('DB_HOST');
        self::$user = env('DB_USERNAME');
        self::$password = env('DB_PASSWORD');
        self::$database = env('DB_DATABASE');

        self::$conn = self::connectDB();

        //Server Config
        self::$conn->query("SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");
        // ini_set('memory_limit', '-1');
    }

    public static function connect()
    {
        if (is_null(self::$instance)) {
            self::$instance = new self();
        }
        return self::$instance;
    }

    public static function connectDB()
    {
        $conn = mysqli_connect(self::$host, self::$user, self::$password, self::$database);
        return $conn;
    }

    public static function runBaseQuery($query)
    {
        $result = self::$conn->query($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        $resultset = [];
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $resultset[] = $row;
            }
        }
        return $resultset;
    }


    public static function runQuery($query, $param_type, $param_value_array)
    {
        $sql = self::$conn->prepare($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        self::bindQueryParams($sql, $param_type, $param_value_array);
        $sql->execute();
        $result = $sql->get_result();

        $resultset = [];
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $resultset[] = $row;
            }
        }

        return $resultset;
    }
    
    //modify
    public static function runQueries($query)
    {
        $sql = self::$conn->prepare($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        $sql->execute();
        $result = $sql->get_result();
        return $result;
    }

    public static function transBegin()
    {
        return self::$conn->begin_transaction();
    }

    public static function transCommit()
    {
        return self::$conn->commit();
    }

    public  static function transRollback()
    {
        return self::$conn->rollback();
    }
    public static function bindQueryParams($sql, $param_type, $param_value_array)
    {
        $param_value_reference[] = &$param_type;
        for ($i = 0; $i < count($param_value_array); $i++) {
            $param_value_reference[] = &$param_value_array[$i];
        }
        call_user_func_array(array(
            $sql,
            'bind_param'
        ), $param_value_reference);
    }

    public static function insert($query, $param_type, $param_value_array)
    {
        $sql = self::$conn->prepare($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        self::bindQueryParams($sql, $param_type, $param_value_array);
        $sql->execute();
        if ($sql->errno) {
            return $sql->error;
        }
        $insertId = $sql->insert_id;
        return $insertId;
    }

    public static function update($query, $param_type, $param_value_array)
    {
        $sql = self::$conn->prepare($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        self::bindQueryParams($sql, $param_type, $param_value_array);
        $sql->execute();
        if ($sql->errno) {
            return $sql->error;
        }
        return  $sql->affected_rows;
    }

    public static function select($query, $param_type, $param_value_array)
    {
        $sql = self::$conn->prepare($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        self::bindQueryParams($sql, $param_type, $param_value_array);
        $sql->execute();
        $result = $sql->get_result();

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $resultset[] = $row;
                foreach ($resultset as $resultsetRow) {
                    foreach ($resultsetRow as $resultsetRowRow) {
                        return $resultsetRowRow;
                    }
                }
            }
        } else {
            return '';
        }
    }


    public static function selectBaseQuery($query)
    {
        $result = self::$conn->query($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $resultset[] = $row;
                foreach ($resultset as $resultsetRow) {
                    foreach ($resultsetRow as $resultsetRowRow) {
                        return $resultsetRowRow;
                    }
                }
            }
        } else {
            return '';
        }
    }

    public static function insertBaseQuery($query)
    {
        $sql = self::$conn->prepare($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        $sql->execute();
        if ($sql->errno) {
            return $sql->error;
        }
        $insertId = $sql->insert_id;
        return $insertId;
    }


    public static function updateBaseQuery($query)
    {
        $sql = self::$conn->prepare($query);
        if (self::$conn->error) {
            return self::$conn->error;
        }
        $sql->execute();
        if ($sql->errno) {
            return $sql->error;
        }
        return  $sql->affected_rows;
    }
}
PK     ;<�ZJ����
  �
    Mail.phpnu �[���        <?php
namespace App\Core; 

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;

class Mail extends PHPMailer{


    public static function sendEmail($args){
        $mail_sent = 0;

        //validation
        if(empty($args['to_email']) || empty($args['subject']) || (empty($args['html_body']) && empty($args['email_body']))){
            return "Email, Subject and Message are required.";
        }

        $to_email = $args['to_email'];
        $to_name = empty($args['to_name']) ? '' : $args['to_name'] ;
        $subject = $args['subject'];
        $html_body = empty($args['html_body']) ? '' : $args['html_body'] ;
        $email_body = empty($args['email_body']) ? '' : $args['email_body'] ;
 
        try{
            $mail = new PHPMailer;

            $mail->SMTPDebug = SMTP::DEBUG_OFF;   
            $mail->isSMTP();                                            //Send using SMTP
            $mail->Host       = MAIL_HOST;							         //Set the SMTP server to send through
            $mail->SMTPAuth   = true;                                  //Enable SMTP authentication
            $mail->Username   = MAIL_USERNAME;                     				//SMTP username
            $mail->Password   = MAIL_PASSWORD;                               //SMTP password
            $mail->SMTPSecure = MAIL_ENCRYPTION;         //Enable TLS encryption; `PHPMailer::ENCRYPTION_SMTPS` encouraged
            $mail->Port       = MAIL_PORT;     

            $mail->setFrom(MAIL_FROM_ADDRESS, MAIL_FROM_NAME);
            $mail->addAddress($to_email,$to_name);

            // $mail->addReplyTo('info@example.com', 'Information');
            // $mail->addCC('cc@example.com');
            // $mail->addBCC('bcc@example.com');

            //Attachments
            // $mail->addAttachment('/var/tmp/file.tar.gz');         //Add attachments
            // $mail->addAttachment('/tmp/image.jpg', 'new.jpg');    //Optional name
           
            $mail->Subject = $subject;

            if(!empty($html_body)) {
                $mail->isHTML(true);
                $mail->AltBody = $email_body;
                $mail->Body    = $html_body;
            } else{
                $mail->Body    = $email_body;
            }

             // added Gmail hack
            $mail->SMTPOptions = array(
                    'ssl' => array(
                        'verify_peer' => false,
                        'verify_peer_name' => false,
                        'allow_self_signed' => true
                    )
            );

            if($mail->send()) $mail_sent = 1;
        }
        catch (Exception $e) {
            return "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
        }

        return $mail_sent;
    }


}
PK     ;<�Z�/��1   1     Controller.phpnu �[���        <?php

namespace App\Core;

class Controller
{
}
PK       ;<�Z��]��   �   	                Model.phpnu �[���        PK       ;<�Z�����  �              �   View.phpnu �[���        PK       ;<�Z[M�  �              �  Database.phpnu �[���        PK       ;<�ZJ����
  �
              p  Mail.phpnu �[���        PK       ;<�Z�/��1   1               �$  Controller.phpnu �[���        PK      s  �$    