MySQL数据库插入错误

Question

Okay, so this allows me to create projects and add them to the database, but for some reason, it's not adding anything, I know there's a typo or something in the code, but I can't find it for the life of me. It's been racking my brain for a while.

if(isset($_POST['project_name'])&&isset($_POST['project_lead'])&&isset($_POST['project_type'])&&isset($_POST['project_start'])&&isset($_POST['project_due'])&&isset($_POST['project_link'])&&isset($_POST['project_desc'])) {

    $project_name = $_POST['project_name'];
    $project_lead = $_POST['project_lead'];
    $project_type = $_POST['project_type'];
    $project_start = $_POST['project_start'];
    $project_due = $_POST['project_due'];
    $project_link = $_POST['project_link'];
    $project_desc = $_POST['project_desc'];

    $esc_project_link = mysql_real_escape_string($project_link);
    $esc_project_desc = mysql_real_escape_string($project_desc);

    if(!empty($project_lead)&&!empty($project_name)&&!empty($project_type)&&!empty($project_start)&&!empty($project_due)&&!empty($project_link)&&!empty($project_desc)) {

        $insert_new_project = "INSERT INTO projects VALUES ('','$project_name','$project_lead','$project_type','$project_start','$project_due','$esc_project_link','$esc_project_desc')";

        if($insert_success = mysql_query($insert_new_project)) {
            header('Location: projects.php?new=true');
        } else {
            header('Location: projects.php?new=fail');
        }
    }
}

Thanks in advance!

Answer 1

You should declare your columns which are you inserting your data:

$insert = "INSERT INTO table_name 
           (column1, column2, column3,...)
           VALUES (value1, value2, value3,...) 
           WHERE value1 = 'yourvalue'";

This is a insert with correct syntax from w3schools.com .

For more information check out w3schools.com