<?php
// require_once("/var/www/php70/navnath/msacommon/lib/php/include/dbPDO.php");
require_once("lib/php/include/dbPDO.php");

class newsletter {
	function __construct() {
		$this->db_admin = CommonPDOConnector::connect('ConnectToAdmin');
	}

    function subscribeNewsletter( $data = [] ) {
        $email = $data['email'] ?? '';
        $domain = $data['domain'] ?? '';
        $subscribe = $data['subscribe'] ?? 1;
        $detail = isset( $data['detail'] ) ? json_encode( $data['detail'] ) : '{}';

        $sql = "INSERT IGNORE INTO subscribe_email ( email,domain,subscribe,detail ) 
                VALUES ( '$email', '$domain',  '$subscribe', '$detail' )";

        $stmt = $this->db_admin->prepare($sql);
        $result = $stmt->execute();

        return $result;
    }
}

?>