$_POST not inserting values in the database

Question

I have a form. When the user submits, the values should insert in the database. Only the value of one $_POST is not inserted in the database, but the other $_POST's are inserting properly.

How to fix this?

HTML:

<input type="text" name="position" value="<?php echo $_POST['jobTitle']; ?>" id="position" required/>

PHP snippet:

$firstName = $middleName = $lastName = $email = $mobile = $resume = $position = $message = $attachment_id = $locations = "";

if(isset($_POST['submit'])){
    $firstName = isset($_POST['firstName']) ? $_POST['firstName'] : '';
    $middleName = isset($_POST['middleName']) ? $_POST['middleName'] : '';
    $lastName = isset($_POST['lastName']) ? $_POST['lastName'] : '';
    $email = isset($_POST['email']) ? $_POST['email'] : '';
    $mobile = isset($_POST['mobile']) ? $_POST['mobile'] : '';
    $locations = isset($_POST['locations_list']) ? $_POST['locations_list'] : '';
    $position = isset($_POST['jobTitle']) ? $_POST['jobTitle'] : '';
    $message = isset($_POST['message']) ? $_POST['message'] : '';
        if( ! empty($_FILES)){
            $file=$_FILES['resumeFile'];
            $attachment_id = upload_user_file($file);
        }

    $sql=$wpdb->query("INSERT INTO resume_databank(submit_time,last_name,first_name,middle_name,mobile_number,email,location,position,message,process_resume,attachment_resume_id) VALUES (now(),'$lastName','$firstName','$middleName','$mobile','$email','$locations','$position','$message','No','$attachment_id')");
}

exit();

you can debug it: just echo this- "INSERT INTO resume_databank(submit_time,last_name,first_name,middle_name,mobile_number,email,location,position,message,process_resume,attachment_resume_id) VALUES (now(),'$lastName','$firstName','$middleName','$mobile','$email','$locations','$position','$message','No','$attachment_id')". — Murad Hasan
– Murad Hasan, Commented May 25, 2016 at 3:45
WARNING: You've created a dangerous SQL injection bug by putting $_POST data directly in your query. NEVER do this. Instead, use the WordPress prepared statements feature to properly escape all data parameters. — tadman
– tadman, Commented May 25, 2016 at 3:56

Boby · Accepted Answer · 2016-05-25 03:49:26Z

4

Change this part

$position = isset($_POST['jobTitle']) ? $_POST['jobTitle'] : '';

to

$position = isset($_POST['position']) ? $_POST['position'] : '';

because in your form. your field name is position and $_POST['jobTitle']; is just a value

answered May 25, 2016 at 3:49

Boby

1,2084 gold badges26 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

$_POST not inserting values in the database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related