관리-도구

편집 파일: smtp.php

<?php

class Smtp
{
	var $mysqli;
	var $dbpref;
	function __construct($arr)
	{
		$this->mysqli=$arr['mysqli'];
		$this->dbpref=$arr['dbpref'];
	}

function totalSMTP()
	{
		$mysqli=$this->mysqli;
		$dbpref=$this->dbpref;
		$table=$dbpref.'quick_smtp_setting';
		$sql=$mysqli->query("SELECT COUNT(*) as 'total' FROM `$table`");
		$run = $sql->fetch_object();
		return $run->total;

}
   
      function insert($title,$fromemail,$hostname,$port,$username,$password,$encryption,$fromname,$replyname,$replyemail)
      {
          $mysqli=$this->mysqli;
          $pref=$this->dbpref;
          $date=time();
          $sql="INSERT INTO `".$pref."quick_smtp_setting`(title,hostname,port,encryption,fromname,fromemail,username,password,replyname,replyemail,created_at)VALUES('".$title."','".$hostname."','".$port."','".$encryption."','".$fromname."','".$fromemail."','".$username."','".$password."','".$replyname."','".$replyemail."','".$date."')";
          if ($mysqli->query($sql) === TRUE)
          {
            return 1; 
          }
          else{
                return 0;
            }
       }