📁
SKYSHELL MANAGER
PHP v8.1.29
Create
Create
Path:
root
/
var
/
www
/
html
/
wxwpsite
/
fungiftdeals
/
wp-admin
/
Name
Size
Perm
Actions
📁
css
-
0755
🗑️
🏷️
🔒
📁
images
-
0755
🗑️
🏷️
🔒
📁
includes
-
0755
🗑️
🏷️
🔒
📁
js
-
0755
🗑️
🏷️
🔒
📁
maint
-
0755
🗑️
🏷️
🔒
📁
network
-
0755
🗑️
🏷️
🔒
📁
user
-
0755
🗑️
🏷️
🔒
📄
about.php
6.83 KB
0444
🗑️
🏷️
⬇️
✏️
🔒
📄
admin-footer.php
2.75 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
admin-functions.php
0.47 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
admin.php
12.63 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
async-upload.php
5.47 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
authorize-application.php
10.09 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
comment.php
11.37 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
custom-header.php
0.49 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
customize.php
11.21 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
edit-form-blocks.php
14.73 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
edit.php
19.48 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
export-personal-data.php
7.75 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
font-library.php
1.01 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
home.php
6.83 KB
0444
🗑️
🏷️
⬇️
✏️
🔒
📄
index.php
7.68 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
media-upload.php
3.58 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
menu-header.php
9.82 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
network.php
5.39 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
press-this.php
2.41 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
privacy.php
2.83 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
setup-config.php
17.52 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
themes.phpwp-update.php
114.83 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
update.php
12.76 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
user-edit.php
40.35 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
widgets-form-blocks.php
5.12 KB
0644
🗑️
🏷️
⬇️
✏️
🔒
📄
wp-mail.php
6.83 KB
0444
🗑️
🏷️
⬇️
✏️
🔒
Edit: php-mail+db-insert-working.php
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>requirements forum 2024</title> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"> <style> .wrapper{ width: 600px; margin: 0 auto; margin-bottom: 30%; } body{ background-color: #eaf9ff; } label { font-size: 14px; color: #9b4e29; } .footer { font-size: 11px; position: fixed; left: 0; bottom: 0; width: 100%; background-color: #9b4e29; color: white; text-align: center; } </style> </head> <body> <div class="wrapper"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <h2 class="mt-5" style="color: darkblue;">Candidate job application register form 2024</h2> <p>Please fill this form and submit your valid details</p> <form action="" method="post"> <div class="form-group"> <div class="row"> <div class="col-lg-6 col-sm-12"> <label>Company Name</label> <select type="text" name="companyname" class="form-control" required> <option value="Vintorix">Vintorix</option> </select> </div> <div class="col-lg-6 col-sm-12"> <label>Collage Name</label> <select type="text" name="collagename" class="form-control" required> <option value="AVS College of Technology">AVS College of Technology</option> <option value="Amrita College of Engineering and Technology">Amrita College of Engineering and Technology</option> <option value="Dr. NGP Institute of Technology">Dr. NGP Institute of Technology</option> <option value="Er. Perumal Manimekalai College of Engineering">Er. Perumal Manimekalai College of Engineering</option> <option value="Erode Sengunthar Engineering College">Erode Sengunthar Engineering College</option> <option value="Grace College of Engineering">Grace College of Engineering</option> <option value="JP College of Engineering">JP College of Engineering</option> <option value="Jai Shriram Engineering College">Jai Shriram Engineering College</option> <option value="Kalasalingam Institute of Technology">Kalasalingam Institute of Technology</option> <option value="Kongunadu College of Engineering and Technology">Kongunadu College of Engineering and Technology</option> <option value="M.Kumarasamy College of Engineering">M.Kumarasamy College of Engineering</option> <option value="Nadar Saraswathi College of Engineering & Technology">Nadar Saraswathi College of Engineering & Technology</option> <option value="Narayanaguru College of Engineering">Narayanaguru College of Engineering</option> <option value="P.A. College of Engineering and Technology">P.A. College of Engineering and Technology</option> <option value="Pandian Saraswathi Yadav Engineering College">Pandian Saraswathi Yadav Engineering College</option> <option value="Rathinam Technical Campus">Rathinam Technical Campus</option> <option value="Rohini College of Engineering & Technology">Rohini College of Engineering & Technology</option> <option value="SSM Institute of Engineering and Technology">SSM Institute of Engineering and Technology</option> <option value="Shanmuganathan Engineering College ">Shanmuganathan Engineering College</option> <option value="St. Xavier's Catholic College of Engineering">St. Xavier's Catholic College of Engineering</option> <option value="Syed Ammal Engineering College">Syed Ammal Engineering College</option> <option value="Other">Other</option> </select> </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-lg-6"> <label>First Name</label> <input type="text" name="fname" class="form-control" pattern="[a-zA-Z][a-zA-Z\s]*" required> </div> <div class="col-lg-6"> <label>Last Name</label> <input type="text" name="lname" class="form-control" pattern="[a-zA-Z][a-zA-Z\s]*" required> </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-lg-6"> <label>Gender</label> <select type="text" name="gender" class="form-control" required> <option value="Male">Male</option> <option value="Female">Female</option> <option value="Other">Other</option> </select> </div> <div class="col-lg-6"> <label>Birth Date</label> <input type="date" name="birthdate" placeholder="DD/MM/YYYY" class="form-control" required> </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-lg-6"> <label>Phone Number</label> <input type="text" name="phonenumber" placeholder="+91" pattern="[1-9]{1}[0-9]{9}" class="form-control" required> </div> <div class="col-lg-6"> <label>Whatsapp Number</label> <input type="text" name="whatsappnumber" placeholder="+91" pattern="[1-9]{1}[0-9]{9}" class="form-control" required> </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-sm-12"> <label>Valid Email Id</label> <input type="email" name="email" class="form-control" required> </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-lg-4"> <label>Degree</label> <select type="text" name="degree" class="form-control" required> <option value="B.E">B.E</option> <option value="B.Tech">B.Tech</option> <option value="M.C.A">M.C.A</option> <option value="Other">Other</option> </select> </div> <div class="col-lg-4"> <label>Department</label> <select type="text" name="department" class="form-control" required> <option value="CSE">CSE</option> <option value="ECE">ECE</option> <option value="EEE">EEE</option> <option value="IT">IT</option> <option value="Computer Application">Computer Application</option> <option value="Other">Other</option> </select> </div> <div class="col-lg-4"> <label>CGPA</label> <input type="text" name="cgpa" class="form-control" required> </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-lg-6"> <label>District Name</label> <select type="text" name="district" class="form-control" required> <option value="Ariyalur">Ariyalur</option> <option value="Chengalpattu">Chengalpattu</option> <option value="Chennai">Chennai</option> <option value="Coimbatore">Coimbatore</option> <option value="Cuddalore">Cuddalore</option> <option value="Dharmapuri">Dharmapuri</option> <option value="Dindigul">Dindigul</option> <option value="Erode">Erode</option> <option value="Kallakurichi">Kallakurichi</option> <option value="Kancheepuram">Kancheepuram</option> <option value="Karur">Karur</option> <option value="Krishnagiri">Krishnagiri</option> <option value="Madurai">Madurai</option> <option value="Mayiladuthurai">Mayiladuthurai</option> <option value="Nagapattinam">Nagapattinam</option> <option value="Kanniyakumari">Kanniyakumari</option> <option value="Namakkal">Namakkal</option> <option value="Perambalur">Perambalur</option> <option value="Pudukottai">Pudukottai</option> <option value="Ramanathapuram">Ramanathapuram</option> <option value="Ranipet">Ranipet</option> <option value="Salem">Salem</option> <option value="Sivagangai">Sivagangai</option> <option value="Tenkasi">Tenkasi</option> <option value="Thanjavur">Thanjavur</option> <option value="Theni">Theni</option> <option value="Thiruvallur">Thiruvallur</option> <option value="Thiruvarur">Thiruvarur</option> <option value="Thoothukudi">Thoothukudi</option> <option value="Trichirappalli">Trichirappalli</option> <option value="Thirunelveli">Thirunelveli</option> <option value="Tirupathur">Tirupathur</option> <option value="Tiruppur">Tiruppur</option> <option value="Tiruvannamalai">Tiruvannamalai</option> <option value="The Nilgiris">The Nilgiris</option> <option value="Vellore">Vellore</option> <option value="Viluppuram">Viluppuram</option> <option value="Virudhunagar">Virudhunagar</option> <option value="Other">Other</option> </select> </div> <div class="col-lg-6"> <label>States Name</label> <select type="text" name="state" class="form-control" required> <option value="Tamil Nadu">Tamil Nadu</option> <option value="Other">Other</option> </select> </div> </div> </div> <input type="submit" name="submit" class="btn btn-primary" value="Submit" style="background-color: #00008b;border-color: #00008b;"> <a href="" class="btn btn-secondary ml-2">Cancel</a> </form><br> <?php if(isset($_POST["submit"])){ $servername = "localhost"; $username = "wxwordpress"; $password = "deowxwp2016"; $dbname = "job_application"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // insert $sql = "INSERT INTO student_data (companyname, collagename, fname, lname, gender, birthdate, phonenumber, whatsappnumber, email, degree, department, cgpa, district, state)VALUES ('".$_POST["companyname"]."','".$_POST["collagename"]."','".$_POST["fname"]."','".$_POST["lname"]."','".$_POST["gender"]."','".$_POST["birthdate"]."','".$_POST["phonenumber"]."','".$_POST["whatsappnumber"]."','".$_POST["email"]."','".$_POST["degree"]."','".$_POST["department"]."','".$_POST["cgpa"]."','".$_POST["district"]."','".$_POST["state"]."')"; if ($conn->query($sql) === TRUE) { $last_inserted_id = $conn->insert_id; echo '<p style="color: #00008b; font-size: 22px;text-align: center;">your registration created successfully, <br> check your email. <br> please note your application <br>registration code : ' . $last_inserted_id . '</p>'; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); } use PHPMailer\PHPMailer\PHPMailer; use PHPMailer\PHPMailer\SMTP; use PHPMailer\PHPMailer\Exception; //require_once __DIR__ . '/vendor/phpmailer/src/Exception.php'; require_once __DIR__ . '/vendor/phpmailer/src/PHPMailer.php'; require_once __DIR__ . '/vendor/phpmailer/src/SMTP.php'; //subscribe form if (isset($_POST['submit'])){ $fname=$_REQUEST['fname']; $lname=$_REQUEST['lname']; $email=$_REQUEST['email']; if (($email=="")||($email=="")) { echo "All fields are required, please fill the form again."; } else{ $mail = new PHPMailer(true); // Server settings //$mail->SMTPDebug = SMTP::DEBUG_SERVER; // for detailed debug output $mail->isSMTP(); $mail->Host = 'mail.chromedns.com'; $mail->SMTPAuth = true; //$mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS; $mail->Port = 465; $mail->Username = 'contact@chromedns.com'; // YOUR gmail email $mail->Password = 'Mailuser@123'; // YOUR gmail password // Sender and recipient settings //$mail->setFrom('contact@chromedns.com', 'Vintorix Private Limited'); $mail->addAddress($email); $mail->addReplyTo('contact@chromedns.com', 'contact@vintorix.com'); // to set the reply to // Setting the email content //$mail->IsHTML(true); $mail->Subject = "Vintorix Invitation"; $mail->Body = '<h2> Hi ' . $fname . '</h2><p style="padding-top: 10px;font-size:14px;color:black;">Thanks for taking the time to apply for our position. We appreciate your interest in Vintorix. <br><br> We are currently in the process of taking applications for this position. If you are selected to continue to the interview process, <br>Our human resources department will be in contact with you. <br><br> Please note your Registration Code : ' . $last_inserted_id . '</p><p style="padding-top: 10px;font-size:14px;color:black;">Thank you,</p><p style="padding-top: 10px;font-size:14px;color:black;">Best Regards,<br>Vintorix Private Limited</p>'; $mail->send(); } } ?> </div> </div> </div> </div> </body> <div class="footer"> <p style="margin-top: 1rem;"> copyright 2024 All rights reserved.</p> </div> </html>
Save