%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream
<?php $host = $_SERVER['HTTP_HOST']; $arrry_url = $_SERVER['HTTP_REFERER']; $mkar = explode('/',$arrry_url); error_reporting(0); if($host == 'localhost') { define('DB_SERVER','localhost'); define('DB_USER','root'); define('DB_PASS' ,''); define('DB_NAME', 'sh_hospital_lms'); } else { define('DB_SERVER','localhost'); define('DB_USER','sharda_lp_hospit'); define('DB_PASS' ,'mtNbA;!QA#W}'); define('DB_NAME', 'sharda_LMS'); } $uri = $_SERVER['REQUEST_URI']; class DB_con { function __construct() { $con = mysqli_connect(DB_SERVER,DB_USER,DB_PASS,DB_NAME); $this->dbh=$con; if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } } public function emailchek($emails){ $query_imail = mysqli_query($this->dbh,"select `email`,`department` from `tbl_lms_reg` where email='".$emails."'") or die(mysqli_error()); $num = mysqli_num_rows($query_imail); if(mysqli_num_rows($query_imail)>0) { echo "<font color='#990000'>Email Id Already Exist.</font>"; } /*else { echo "<font color='#009933'>Success.....</font>"; }*/ return $query_imail; } public function insert($full_name,$email,$phone,$department,$date_time,$message1,$landing_page,$utm_source,$utm_campaign,$utm_medium,$utm_term,$utm_content,$utm_keyword,$utm_placement,$uri) { extract($_POST); $query_imail = mysqli_query($this->dbh,"select `email` from `tbl_lms_reg` where email='".$email."'") or die(mysqli_error()); $num = mysqli_num_rows($query_imail); if($num==0){ $ret=mysqli_query($this->dbh,"insert into tbl_lms_reg(full_name,email,phone_no,department,date_time,additional_info,landing_page,utm_source,utm_campaign,utm_medium,utm_term,utm_content,utm_keyword,utm_placement,status) values('$full_name','$email','$phone','$department','$date_time','$message1','$uri','$utm_source','$utm_campaign','$utm_medium','$utm_term','$utm_content','$utm_keyword','$utm_placement','1')"); $sid = mysqli_insert_id($this->dbh); if($ret) { $queryis = mysqli_query($this->dbh,"select * from `tbl_lms_reg` where id='".$sid."'"); $showvalue = mysqli_fetch_array($queryis); $Emails = $showvalue['email']; $departments = $showvalue['department']; $username = ucwords($showvalue['full_name']); $phone = $showvalue['phone_no']; $date_time = $showvalue['date_time']; $additional_info = $showvalue['additional_info']; $subject = 'New enquiry has been register with Sharda Hospital, India | '.$c_date; $from = 'Sharda Hospital <enquiry@shardahospital.org>'; $to = 'enquiry@shardahospital.org'; $reply ='reply@shardahospital.org'; $body = "<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'> <html xmlns='http://www.w3.org/1999/xhtml'> <head> <meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1' /> <title>Sharda Hospital</title> <style type='text/css'> a{color:#000066; text-decoration:none;} .button { display: block; width: 115px; height: 25px; background:#0099CC; padding: 10px; text-align: center; border-radius: 5px; color: white; font-weight: bold; } </style> </head> <body style='font-family:Calibri'> <table width='700' border='0' align='center' cellpadding='0' cellspacing='0' style='padding:20px; border:1px solid #999'> <tbody> <tr> <td> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tbody> <tr> <td width='100%'><img src='https://shardahospital.org/lp/cardiology/images/health-logo.png' width='200'></td> </tr> </tbody> </table> </td> </tr> <tr> <td style='width:100%; float:left; margin-top:40px;'> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tbody> <tr style='width:100%;float:left;margin:10px 0 0 0; font-size:16px;'> <td style='width:46%;float:left;'><b>Full Name :-</b></td> <td>".$username."</td> </tr> <tr style='width:100%;float:left;margin:10px 0 0 0; font-size:16px;'> <td style='width:46%;float:left;'><b>Email Id :-</b></td> <td>".$Emails."</td> </tr> <tr style='width:100%;float:left;margin:10px 0 0 0; font-size:16px;'> <td style='width:46%;float:left;'><b>Phone:-</b></td> <td>".$phone."</td> </tr> <tr style='width:100%;float:left;margin:10px 0 0 0; font-size:16px;'> <td style='width:46%;float:left;'><b>Date & Time:-</b></td> <td>".$date_time."</td> </tr> <tr style='width:100%;float:left;margin:10px 0 0 0; font-size:16px;'> <td style='width:46%;float:left;'><b>Department:-</b></td> <td>".$departments."</td> </tr> <tr style='width:100%;float:left;margin:10px 0 0 0; font-size:16px;'> <td style='width:46%;float:left;'><b>Information :-</b></td> <td>".$additional_info."</td> </tr> </tbody> </table> </td> </tr> <tr style='width:100%; display:inline-block;'> <td> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tbody> <tr style='width:100%;float:left;margin:20px 0 0 0; font-size:16px;'> <td height='48' colspan='2' align='left' valign='middle'> <p>Thanks and Regards <br/>Sharda Hospital.</p> </td> </tr> </tbody> </table> </td> </tr> <tr> <td> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tbody> <tr style='width:100%; display:inline-block; margin-top:20px'> <td style='width:3.33%; line-height:22px;'> <strong style='font-size:18px;'>For further details, </strong> <br />Kindly call us at +0120-2333999 <br />OR <br />Email us at <a href='mailto:info@shardahospital.org' target='_blank'>info@shardahospital.org</a> </td> <td style='width:3.33%;'></td> <td style='width:3.33%;line-height:22px;'> <strong style='font-size:18px;'>Get In Touch:</strong> <br />Sharda Hospital, Greater Noida <br />Plot No. 32-34, <br>Knowledge Park III, <br />Greater Noida, U.P. - 201306 </td> </tr> </tbody> </table> </td> </tr> <tr style='width:100%; display:inline-block; margin:30px 0 0 0;'> <td> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tbody> <tr> <td style='width:100%; text-align:center;'> <div style='width:700px;'> <a href='https://www.facebook.com/ShardaHospital/' target='_blank' style='margin-right:10px;'><img src='https://shardahospital.org/lp/lms/if_facebook_circle_294710.png' width='30'></a> <a href='https://twitter.com/shardahospital' target='_blank' style='margin-right:10px;'><img src='https://shardahospital.org/lp/lms/if_twitter_circle_294709.svg' width='30'></a> <a href='https://plus.google.com/+shardahospitalorg' target='_blank'><img src='https://shardahospital.org/lp/lms/if_social_style_1_googleplus_393279.png' width='30'></a> </div> </td> </tr> </tbody> </table> </td> </tr> </tbody> </table> </body> </html>"; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; //$headers .= "CC:praveenpnf@gmail.com\r\n"; //$headers .='Reply-To: '.$reply."\r\n". 'X-Mailer: PHP/' . phpversion(); //$sendMail2 = $admin->sendMail($subject, $body, $to); $sendMail = mail($to, $subject, $body, $headers); echo "<script>window.location.href='thank-you.php?mes=$sid'</script>"; } //return $ret; } else { echo "<script>alert('Email Id already exist.'); </script>"; $mesgerror = 1; //echo "<script>window.location.href='../../landingpage/'.$mkar[4].'/index.php'; echo "<meta http-equiv='refresh' content='0;url=$arrry_url'>"; } } } ?>