connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if (isset($_POST['submit'])) {
$fname = $_POST['fname'];
$email = $_POST['email'];
$file = $_FILES['file'];
// Check if the phone number already exists in the database
$check_query = "SELECT * FROM `resumes` WHERE `email` = '$email'";
$check_result = $conn->query($check_query);
if ($check_result->num_rows == 0) {
// Phone number does not exist, proceed with insertion
$filename = $file['name'];
$filepath = $file['tmp_name'];
$fileerror = $file['error'];
if ($fileerror == 0) { // 0 means successfully uploaded
$destfile = 'ssibhotanewtem2/' . $filename;
move_uploaded_file($filepath, $destfile);
$sql = "INSERT INTO `resumes`(`fname`, `email`, `file`) VALUES ('$fname', '$email', '$destfile')";
$result = $conn->query($sql);
if ($result == TRUE) {
echo "New record created successfully.";
} else {
echo "Error: " . $sql . "
" . $conn->error; } } } else { echo ""; } } $conn->close(); ?>
" . $conn->error; } } } else { echo ""; } } $conn->close(); ?>