SMTPDebug = 3; // Enable verbose debug output
$mail->isSMTP(); // Set mailer to use SMTP
$mail->Host = 'rokamauka.com'; // Specify main and backup SMTP servers
$mail->SMTPAuth = true; // Enable SMTP authentication
$mail->Username = 'info@rokamauka.com'; // SMTP username
$mail->Password = 'Sunil@2021'; // SMTP password
$mail->SMTPSecure = 'tls'; // Enable TLS encryption, `ssl` also accepted
$mail->Port = 587; // TCP port to connect to
$mail->From = 'info@rokamauka.com';
$mail->FromName = 'Rokamauka.com';
$mail->addAddress('info@rokamauka.com', 'Rokamauka.com'); // Add a recipient
$mail->addAddress('info@rokamauka.com');
$mail->addAddress('kotarajindia@gmail.com');
// Name is optional
$mail->addReplyTo('kotarajindia@gmail.com', 'Information');
$mail->addCC('info@rokamauka.com');
$mail->addBCC('info@rokamauka.com');
$mail->WordWrap = 50; // Set word wrap to 50 characters
$mail->addAttachment('/var/tmp/file.tar.gz'); // Add attachments
$mail->addAttachment('/tmp/image.jpg', 'new.jpg'); // Optional name
$mail->isHTML(true); // Set email format to HTML
$mail->Subject = 'Active Account - Rokamauka.com';
$mail->Body = 'Name'.$name.' Phone '.$phone.' Email '.$email.' Wedding Date '.$wedingdate.' Remark '.$remark.'';
if(!$mail->send()) {
echo 'Message could not be sent.';
echo 'Mailer Error: ' . $mail->ErrorInfo;
} else {
$sql4 = "INSERT INTO enqury (name, event_date,email,remark,phone,current_date_1,msg_from)
VALUES ('$name', '$wedingdate','$email','$remark','$phone','$currentdate','Vendor Detail')";
$result4 = $conn->query($sql4);
echo $mag_link = '';
}
}
if(!empty($_GET['vendor_id'])){
$vendor_id = $_GET['vendor_id'];
$sql = "SELECT * FROM vendor_profile where id=$vendor_id";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$business_title = $row['Heading'];
$buss_name_code = $row['buss_name_code'];
$vendor_cat =$row['vendor_cat'];
$sql55_cat = "SELECT * FROM category where id='$vendor_cat'";
$result66_cat = $conn->query($sql55_cat);
$row88_cat = $result66_cat->fetch_assoc();
$categoryfor = $row88_cat['categoryfor'];
$cat_title = $row88_cat['title'];
$business_id = $row['id'];
$thumnil_image = $row['thumnil_image'];
$city = $row['city'];
$sql_city = "SELECT * FROM city where id='$city'";
$result_city = $conn->query($sql_city);
$row_city = $result_city->fetch_assoc();
$title_city = $row_city['title'];
$localty = $row['localty'];
$sql_localty = "SELECT * FROM sub_category where id='$localty'";
$result_city_local = $conn->query($sql_localty);
$row_city_local = $result_city_local->fetch_assoc();
$localty = $row_city_local['name'];
$avg_price = $row['avg_price'];
$address = $row['address'];
$mobile = $row['mobile'];
$user_id = $row['user_id'];
$video_business = $row['video'];
$sql55 = "SELECT * FROM paid_member where vendor_id='$user_id' order by id desc";
$result66 = $conn->query($sql55);
$row88 = $result66->fetch_assoc();
$payment_status = $row88['payment_status'];
$payentdatae = $row88['expire_date'];
if($payment_status==1){
if($payentdatae>$currentdate){
$paysta = "PlanActive";
}else{
$paysta = "NotActive";
}
}else{
$paysta ="paymentstaus";
}
$video = $row['video'];
$vendor_gallery = $row['vendor_gallery'];
$discription = $row['discription'];
$discrioption_detail = base64_decode($discription);
$facilities = $row['facilities'];
$facilities_array = unserialize(base64_decode($facilities));
}
}
}
?>