bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
    include 'includes/db.php';
    
    require 'PHPMailer/class.phpmailer.php';
    require 'PHPMailer/class.smtp.php';
    require "PHPMailer/PHPMailerAutoload.php";
    
    // Fetching data from POST request
    $registrationnumber = $_POST['registrationnumber'] ?? '';
    $subject = $_POST['subject'] ?? '';
    $universityname = $_POST['universityname'] ?? '';
    $session = $_POST['session'] ?? '';
    $courseduration = $_POST['courseduration'] ?? '';
    $dob = $_POST['dob'] ?? '';
    $coursename = $_POST['coursename'] ?? '';
    $name = $_POST['name'] ?? '';
    $fname = $_POST['fathersname'] ?? '';
    $mothersname = $_POST['mothersname'] ?? '';
    $phone = $_POST['phone'] ?? '';
    $email = $_POST['email'] ?? '';
    $address = $_POST['address'] ?? '';
    $postaladdress = $_POST['postaladdress'] ?? '';
    
    // Files handling
    $upload_dir = 'uploads/';
    
    $files = [
        'registration_certificate' => $_FILES['registration_certificate']['tmp_name'] ?? null,
        'degreeimage' => $_FILES['degreeimage']['tmp_name'] ?? null,
        'aadharimage' => $_FILES['aadharimage']['tmp_name'] ?? null,
        'aadharimage1' => $_FILES['aadharimage1']['tmp_name'] ?? null,
        'photo' => $_FILES['photo']['tmp_name'] ?? null,
        'sign' => $_FILES['sign']['tmp_name'] ?? null
    ];
    
    $saved_files = [];
    foreach ($files as $key => $tmp_name) {
        if ($tmp_name) {
            $filename = $upload_dir . time() . "_" . basename($_FILES[$key]['name']);
            if (move_uploaded_file($tmp_name, $filename)) {
                $saved_files[$key] = $filename;
            } else {
                $saved_files[$key] = '';
            }
        } else {
            $saved_files[$key] = '';
        }
    }
    
    // Send email
    $mail = new PHPMailer();
    $mail->IsSMTP();
    $mail->SMTPDebug = 0;
    $mail->SMTPAuth = true;
    $mail->Host = 'smtp.hostinger.com';
    $mail->Username = 'info@paramedicalcouncil.in';
    $mail->Password = 'Welcome@2121@';
    $mail->SMTPSecure = 'ssl';
    $mail->Port = 465;
    
    $mail->setFrom('info@paramedicalcouncil.in', 'Paramedical Council');
    $mail->addAddress('paramedicalcouncil11@gmail.com');
    
    $mail->IsHTML(true);
    $mail->Subject = $subject;
    $mail->Body = "<p>Dear Admin,</p><p>Please find the attached documents for $name.</p>";
    
    // Attach files
    foreach ($saved_files as $file) {
        if ($file) {
            $mail->addAttachment($file);
        }
    }
    
    if ($mail->send()) {
        $amount = ($subject == 'Correction In Certificate') ? 650 : (($subject == 'Good Standing Certificate') ? 5100 : 4500);
    
        // Insert data and file paths into the database
        $insert_sql = "INSERT INTO uploaded_images (registration_certificate, degreeimage, aadharimage, aadharimage1, photo, sign, registrationnumber, subject, universityname, session, courseduration, dob, coursename, name, fathersname, mothersname, phone, email, address, postaladdress) 
                       VALUES ('{$saved_files['registration_certificate']}', '{$saved_files['degreeimage']}', '{$saved_files['aadharimage']}', '{$saved_files['aadharimage1']}', '{$saved_files['photo']}', '{$saved_files['sign']}', '$registrationnumber', '$subject', '$universityname', '$session', '$courseduration', '$dob', '$coursename', '$name', '$fname', '$mothersname', '$phone', '$email', '$address', '$postaladdress')";
        $query = mysqli_query($connection, $insert_sql);
    
        if ($query) {
            
            // print_r($insert_sql);
            
            
            $tran_sql = "INSERT INTO payment(name, email, phone, subject, amount, status, transaction_id) VALUES ('$name','$email','$phone','$subject','$amount','pending','')";
            $tran_query = mysqli_query($connection, $tran_sql);
            if($tran_query){
                $tran_insert_id = mysqli_insert_id($connection);;
                echo '
                    <script>
                        var name = "'.$name.'";
                        var email = "'.$email.'";
                        var phone = "'.$phone.'";
                        var subject = "'.$subject.'";
                        var tranid = "'.$tran_insert_id.'";
                        var amount = "'.$amount.'";
                        window.location.href = "/pg.php?name=" + name + "&email=" + email + "&phone=" + phone + "&subject=" + subject + "&tranid=" + tranid + "&amount=" + amount;
                    </script>
                ';
            }else{
                
            }
            
            // echo '<script>
            //     alert("Email sent and data inserted successfully!");
            //     window.location.href = "/success_page.php";
            // </script>';
        } else {
            echo '<script>
                alert("Email sent but data insertion failed!");
            </script>';
        }
    } else {
        echo '<script>
            alert("Email sending failed!");
        </script>';
    }
?>