php - 插入表格没有发生

Question

我有一个表单并尝试将表单插入到 mysql 中。表单返回 bool(false) 并出现致命错误

致命错误：未捕获的错误：调用 C:\xampp\htdocs\xxx\jobs.php:444 中布尔值的成员函数 bind_param() 堆栈跟踪：#0 {main} 在 C:\xampp\htdocs\xxx\ 中抛出jobs.php 在第 444 行。

我该如何解决这个问题。

工作.php

<?php
                         include ('admin/config.php');

                     if(isset($_POST['template-jobform-apply'])) {

                        $sql = "INSERT INTO apply_job (template-jobform-fname,template-jobform-email,template-jobform-phone,template-jobform-application) VALUES ('?,?,?,?')";
                        $stmt = mysqli_prepare($db,$sql);
                        var_dump($stmt);
                        $stmt->bind_param("ssss", $_POST['template-jobform-fname'], $_POST['template-jobform-email'], $_POST['template-jobform-phone'], $_POST['template-jobform-application']);

                        $stmt->execute();

                        echo "<p style='text-align: center'>Job Applied Succesfully</p>";


                      }
                    ?>

<form class="" id="template-jobform" name="template-jobform" method="post" action="" role="form">

                    <div class="form-group">

                        <div class="cols-sm-10">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-user fa" aria-hidden="true"></i></span>
                                <input type="text" class="form-control" name="template-jobform-fname" id="name"  placeholder="Enter your Name"/>
                            </div>
                        </div>
                    </div>

                    <div class="form-group">

                        <div class="cols-sm-10">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-envelope fa" aria-hidden="true"></i></span>
                                <input type="text" class="form-control" name="template-jobform-email" id="email" placeholder="Enter your Email"/>
                            </div>
                        </div>
                    </div>

                    <div class="form-group">
                        <div class="cols-sm-10">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-phone fa" aria-hidden="true"></i></span>
                                <input type="phone" class="form-control" name="template-jobform-phone" id="mobile" placeholder="Mobile Number"/>
                            </div>
                        </div>
                    </div>

                    <div class="form-group">

                        <div class="cols-sm-10">
                            <div class="input-group">

                                <input type="file" 
                                   class="filepond"
                                   name="template-jobform-application"
                                   multiple
                                   data-max-file-size="3MB"
                                   data-max-files="3" />
                            </div>
                        </div>
                    </div>

                    <div class="form-group ">
                        <button target="_blank" type="submit" name="template-jobform-apply" class="btn btn-primary btn-lg btn-block login-button">Apply</button>
                    </div>

                </form>

标签： phpmysql