<?php
$servername = "localhost";
$username = "xxxxxxxx_user";
$password = "xxxxxxxxxxxx_pw";
$database = "xxxxxxxx_db";
// Create connection
$con = new mysqli($servername, $username, $password, $database);
// Check connection
if (isset($_POST["submit"])){
$student="school";
$fname = addslashes($_POST['first_name']);
$lname = addslashes($_POST['last_name']);
$gender = addslashes($_POST['gender']);
$age = addslashes($_POST['age']);
$phone = addslashes($_POST['phone']);
$aadhar = addslashes($_POST['aadhar']);
$email = addslashes($_POST['email']);
$addr_street = addslashes($_POST['addr_street']);
$addr_city = addslashes($_POST['addr_city']);
$addr_state = addslashes($_POST['addr_state']);
$addr_pincode = addslashes($_POST['addr_pincode']);
$duration = addslashes($_POST['duration']);
$internship = addslashes($_POST['internship']);
$file_name_aadhar = $_FILES['aadhar_file']['name'];
$file_name_aadhar_loc = $_FILES['aadhar_file']['tmp_name'];
$file_store_aadhar = "aadhar/".$file_name_aadhar;
$file_upload_aadhar = false;
if(move_uploaded_file($file_name_aadhar_loc, $file_store_aadhar))
{
$file_upload_aadhar = true;
}
else
{
$file_upload_aadhar = false;
}
if ($file_upload_aadhar)
{
$checkQuery = "INSERT into sip(student,firstname,lastname,gender,age,phone,aadhar,email,eduinsti,addr_street,addr_city,addr_state,addr_pincode,subjects,batch,internship,duration,aadharimg,idimg) VALUES('".$student."','".$fname."','".$lname."','".$gender."','".$age."','".$phone."','".$aadhar."','".$email."','Life Student',".$addr_street."','".$addr_city."','".$addr_state."','".$addr_pincode."','Life Student','Life Student','".$internship."'.'".$duration."','".$file_name_aadhar."','Life Student')";
if (mysqli_query($con, $checkQuery)) {
echo "<script>window.alert('Added')</script>";
}
else{
echo "<script>window.alert('PHP error');</script>";
}
}
else{
echo "<script>window.alert('ID');</script>";
}
}
?>
internship select:
<div class="form-group">
<label for="internship">Area of Internship</label>
<div class="select-list">
<select name="internship" id="city" required>
<option name=internship value="Architecture">Architecture</option>
<option name=internship value="Art and Culture">Art and Culture</option>
<option name=internship value="Biology & Life Sciences">Biology & Life Sciences</option>
<option name=internship value="Biotechnology & Bioinformatics">Biotechnology & Bioinformatics</option>
<option name=internship value="Business & Management">Business & Management</option>
<option name=internship value="Chemistry">Chemistry</option>
<option name=internship value="Communication">Communication</option>
<option name=internship value="Comics/ Manga/ Stories">Comics/ Manga/ Stories</option>
<option name=internship value="Computer Science">Computer Science</option>
<option name=internship value="Content Creation/ Memes">Content Creation/ Memes</option>
<option name=internship value="Data Analysis & Statistics">Data Analysis & Statistics</option>
<option name=internship value="Design">Design</option>
<option name=internship value="Economics & Finance">Economics & Finance</option>
<option name=internship value="Education">Education</option>
<option name=internship value="Electronics">Electronics</option>
<option name=internship value="Energy & Earth Sciences">Energy & Earth Sciences</option>
<option name=internship value="Engineering">Engineering</option>
<option name=internship value="Environmental Studies">Environmental Studies</option>
<option name=internship value="Ethics">Ethics</option>
<option name=internship value="Food and Nutrition">Food and Nutrition</option>
<option name=internship value="Film & Web/Tv series">Film & Web/Tv series</option>
<option name=internship value="Health and Safety">Health and Safety</option>
<option name=internship value="History">History</option>
<option name=internship value="Humanities">Humanities</option>
<option name=internship value="Human Resources">Human Resources</option>
<option name=internship value="Journalism And Mass Communication">Journalism And Mass Communication</option>
<option name=internship value="Language">Language</option>
<option name=internship value="Law">Law</option>
<option name=internship value="Literature">Literature</option>
<option name=internship value="Maths">Maths</option>
<option name=internship value="Microbiology">Microbiology</option>
<option name=internship value="Medicine">Medicine</option>
<option name=internship value="Music">Music</option>
<option name=internship value="Philanthropy">Philanthropy</option>
<option name=internship value="Public Relations">Public Relations</option>
<option name=internship value="Philosophy & Ethics">Philosophy & Ethics</option>
<option name=internship value="Physics">Physics</option>
<option name=internship value="Psychology">Psychology</option>
<option name=internship value="Science">Science</option>
<option name=internship value="Social Science">Social Science</option>
<option name=internship value="Youtube/ Social Media">Youtube/ Social Media</option>
</select>
</div>
</div>
duration select:
<div class="form-group">
<label for="duration">Duration of daily working hours in Internship</label>
<div class="select-list">
<select name="duration" id="duration" required>
<option value=one>One Hour</option>
<option value="two">Two Hours</option>
<option value="four">Four Hours</option>
<option value="six">Six Hours</option>
<option value="eight">Eight Hours</option>
</select>
</div>
</div>
addr_state select:
<div class="form-group">
<label for="states">State</label>
<div class="select-list">
<select name="addr_state" id="states" required>
<option name="addr_state" value="Andhra Pradesh">Andhra Pradesh</option>
<option name="addr_state" value="Andaman and Nicobar Islands">Andaman and Nicobar Islands</option>
<option name="addr_state" value="Arunachal Pradesh">Arunachal Pradesh</option>
<option name="addr_state" value="Assam">Assam</option>
<option name="addr_state" value="Bihar">Bihar</option>
<option name="addr_state" value="Chandigarh">Chandigarh</option>
<option name="addr_state" value="Chhattisgarh">Chhattisgarh</option>
<option name="addr_state" value="Dadar and Nagar Haveli">Dadar and Nagar Haveli</option>
<option name="addr_state" value="Daman and Diu">Daman and Diu</option>
<option name="addr_state" value="Delhi">Delhi</option>
<option name="addr_state" value="Lakshadweep">Lakshadweep</option>
<option name="addr_state" value="Puducherry">Puducherry</option>
<option value="Goa" name="addr_state" >Goa</option>
<option name="addr_state" value="Gujarat">Gujarat</option>
<option name="addr_state" value="Haryana">Haryana</option>
<option name="addr_state" value="Himachal Pradesh">Himachal Pradesh</option>
<option name="addr_state" value="Jammu and Kashmir">Jammu and Kashmir</option>
<option name="addr_state" value="Jharkhand">Jharkhand</option>
<option name="addr_state" value="Karnataka">Karnataka</option>
<option name="addr_state" value="Kerala">Kerala</option>
<option name="addr_state" value="Madhya Pradesh">Madhya Pradesh</option>
<option name="addr_state" value="Maharashtra">Maharashtra</option>
<option name="addr_state" value="Manipur">Manipur</option>
<option name="addr_state" value="Meghalaya">Meghalaya</option>
<option name="addr_state" value="Mizoram">Mizoram</option>
<option name="addr_state" value="Nagaland">Nagaland</option>
<option name="addr_state" value="Odisha">Odisha</option>
<option name="addr_state" value="Punjab">Punjab</option>
<option name="addr_state" value="Rajasthan">Rajasthan</option>
<option name="addr_state" value="Sikkim">Sikkim</option>
<option name="addr_state" value="Tamil Nadu">Tamil Nadu</option>
<option name="addr_state" value="Telangana">Telangana</option>
<option name="addr_state" value="Tripura">Tripura</option>
<option name="addr_state" value="Uttar Pradesh">Uttar Pradesh</option>
<option name="addr_state" v