prepare($data); $stmt->execute(); $row = $stmt->rowCount(); return $row; } function sendMail($message,$subject,$cemail){ //$headers = "From: www.servius.in" . "\r\n"; //$headers .= 'MIME-Version: 1.0' . "\r\n"; //$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; //mail($cemail,$subject,$message,$headers); require 'phpmailer/PHPMailerAutoload.php'; $mail = new PHPMailer(); $mail->IsHTML(true); $mail->isSMTP(); $mail->Host = "servius.in"; $mail->SMTPSecure = "ssl"; $mail->Port = 465; $mail->SMTPAuth = true; $mail->Username = 'accounts@servius.in'; $mail->Password = 'Servius_2015'; $mail->setFrom('accounts@servius.in', 'accounts@servius.in'); $mail->addAddress($cemail); $mail->Subject = $subject; $mail->Body = $message; if ($mail->send()) echo "Mail sent"; else echo "not send"; } function sendMailrma($message,$subject,$cemail){ //$headers = "From: www.servius.in" . "\r\n"; //$headers .= 'MIME-Version: 1.0' . "\r\n"; //$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; //mail($cemail,$subject,$message,$headers); require 'phpmailer/PHPMailerAutoload.php'; $mail = new PHPMailer(); $mail->IsHTML(true); $mail->isSMTP(); $mail->Host = "servius.in"; $mail->SMTPSecure = "ssl"; $mail->Port = 465; $mail->SMTPAuth = true; $mail->Username = 'rma@servius.in'; $mail->Password = 'Servius_2015'; $mail->setFrom('rma@servius.in', 'rma@servius.in'); $mail->addAddress($cemail); $mail->Subject = $subject; $mail->Body = $message; if ($mail->send()) echo "Mail sent"; else echo "not send"; } function sendMailfrompartner($message,$subject){ require 'phpmailer/PHPMailerAutoload.php'; $mail = new PHPMailer(); $mail->IsHTML(true); $mail->isSMTP(); $mail->Host = "servius.in"; $mail->SMTPSecure = "ssl"; $mail->Port = 465; $mail->SMTPAuth = true; $mail->Username = 'rma@servius.in'; $mail->Password = 'Servius_2015'; $mail->setFrom('rma@servius.in', 'rma@servius.in'); $mail->addAddress('rma@servius.in'); $mail->Subject = $subject; $mail->Body = $message; if ($mail->send()) echo "Mail sent"; else echo "not sent"; } function sendMailfromcontact($message){ require 'phpmailer/PHPMailerAutoload.php'; $mail = new PHPMailer(); $mail->IsHTML(true); $mail->isSMTP(); $mail->Host = "servius.in"; $mail->SMTPSecure = "ssl"; $mail->Port = 465; $mail->SMTPAuth = true; $mail->Username = 'rma@servius.in'; $mail->Password = 'Servius_2015'; $mail->setFrom('rma@servius.in', 'rma@servius.in'); $mail->addAddress('rma@servius.in'); $mail->Subject = 'Mail from Contact form'; $mail->Body = $message; if ($mail->send()) echo "Mail sent"; else echo "not sent"; } function sendSMS($message,$number){ //put the name; //$name = "name"; //put the message; $message = $message; //put the comma separated mobile number; $mobileNumber= $number; //put the email id; //$email="abc@gmail.com"; //$message="Hi ".$name." we received your request. from number is: ".$mobileNumber." and from email ".$email; //put the sender id; $senderId="SRVIUS"; $serverUrl="msg.msgclub.net"; //put the auth key; $authKey="ea964787e02bd06a2e4e7a467ef495a"; $route="1"; sendsmsGET($mobileNumber,$senderId,$route,$message,$serverUrl,$authKey); }////////////////end sms function sendsmsGET($mobileNumber,$senderId,$routeId,$message,$serverUrl,$authKey) { $getData = 'mobileNos='.$mobileNumber.'&message='.urlencode($message).'&senderId='.$senderId.'&routeId='.$routeId; //API URL $url="http://".$serverUrl."/rest/services/sendSMS/sendGroupSms?AUTH_KEY=".$authKey."&".$getData; // init the resource $ch = curl_init($url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $curl_scraped_page = curl_exec($ch); curl_close($ch); $curl_scraped_page; } $s = "SELECT * FROM `ur_webdata` INNER JOIN `ur_admin` ON ur_webdata.id = ur_admin.id Where ur_admin.id = 1 "; $stmt = $dbh->query($s); $result = $stmt->fetch( PDO::FETCH_ASSOC); $web_title =$result['web_title']; $web_url = $result['web_url']; $h_logo = $result['web_headlogo']; $f_logo = $result['web_footlogo']; $favicon = $result['web_favicon']; $copyright = $result['web_copy']; $smalltext = $result['web_text']; $headertext = $result['web_text1']; $contact_email = $result['contact_email']; $contact_number = $result['admin_contact']; $contact_address = $result['admin_address']; date_default_timezone_set("Asia/Kolkata"); $create_date1 = date("y-m"); $create_date = date("d-m-y"); $create_time = date("H:i:s A"); ?>