php - 作业条目未提交到数据库表

我有一个论坛，用户可以在其中输入他们正在寻找的工作，该工作将被提交到数据库，然后显示在下一页上。只有我无法上传任何数据，我不确定为什么。

我也在努力进行错误检查。有任何想法吗？

// Check for job submission
        if(isset($_POST['submit']))

            //empty error array
            $error = array();

        // check for a things in the field

        if(empty($_POST['job']))
        {
            $error[] = 'Please fill in all required fields';

        }

        // iff there are no errors, insert the job listing into the database.
        // otherwies, display error.
        if(sizeof($error) == 0)
        {
            // insert job listing
            $query = "INSERT INTO job (
                                job_id,
                                user_id,
                                jobtitle,
                                company,
                                location,
                                summary,
                                responsibilities,
                                skills
                                ) VALUES (
                                  null,
                                  '{$_SESSION['user_id']}',
                                   '{$_POST['jobtitle']}',
                                   '{$_POST['company']}',
                                   '{$_POST['location']}',
                                   '{$_POST['summary']}',
                                   '{$_POST['responsibilities']}',
                                   '{$_POST['skills']}',
                                    NOW()
                                    )";

            $result = mysqli_query($dbc, $query) or die('Query failed: ' . mysqli_error($dbc));

            // display a confirmation
            echo "<div class=\"alert alert success\">Your job listing has been added</div>";

        } else {

            // display error message
            foreach($error as $value)
            {
                echo "<div class=\"alert alert-danger\"{$value}</div>";
            }
        }

        ?>

        <!-- Job listing Form -->
        <form method="post" action="listings.php">
            <div class="form-group">
                <label> Job Title </label>
                <input name ="jobtitle" type="text" class="jobform"/>

                <label>Company/Organization</label>
                <input name="company" type="text" class="jobform"/>

                <label> Job Location </label>
                <input name ="location" type="text" class="jobform"/>

                <label> Job Responsibilities </label>
                <textarea name="summary" rows="8" cols="20" class="jobfourm"></textarea>

                <label> Job Responsibilities </label>
                <textarea name="responsibilities" rows="8" cols="20" class="jobfourm"></textarea>

                <label> Job Skills </label>
                <textarea name="skills" rows="8" cols="20" class="jobforum"></textarea>

            </div>

        <div class="form-group">
                    <input name="submit" type="submit" value="Submit" class="btn btn-large btn-primary" />
                </div>

        </form>

     </div>

最佳答案

我的赌注取决于您的查询：

 (
                                job_id,
                                user_id,
                                jobtitle,
                                company,
                                location,
                                summary,
                                responsibilities,
                                skills
                                ) VALUES (
                                  null,
                                  '{$_SESSION['user_id']}',
                                   '{$_POST['jobtitle']}',
                                   '{$_POST['company']}',
                                   '{$_POST['location']}',
                                   '{$_POST['summary']}',
                                   '{$_POST['responsibilities']}',
                                   '{$_POST['skills']}',
                                    NOW()

对于应为job_id的参数，您正在传递null。现在，我假设所有作业都必须具有作业ID，对吗？您实际上需要传递一个有效的ID，因为我要赌钱（或代表），这是表中不可空的字段。此外，您还在未在列名参数中声明的值中添加了一列。