javascript - 我正在尝试使用 php 中的 pdo 在 sql server 中插入日期和时间

Question

这个问题已经有答案了:

Error when preparing a multiple insert query (5 个回答)

已关闭 6 年前。

我通过 javascript 函数获取日期并将其发送到 php，但我收到 SQLSTATE[HY093]: 无效的参数号:参数未定义。如何轻松插入日期时间。这是我的代码

<div class="modal fade" id="add_new_event_modal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel1">
<div class="modal-dialog" role="document">
    <div class="modal-content">
        <div class="modal-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
            <h4 class="modal-title" id="myModalLabel1">Add New Event</h4>
        </div>
        <div class="modal-body">
            <div class="form-group">
                <label for="first_name">Event Name</label>
                <input type="text" id="event_name" name="event_name" placeholder="EventName" class="form-control"/>
            </div>
            <div class="form-group">
                <label for="example-datetime-local-input">Date and time</label>
                <div class="input-append date form_datetime" data-date="">
                    <input size="16" type="text" value="" id="wedding_date" name="wedding_date" readonly class="form-control">
                    <span class="add-on"><i class="icon-remove"></i></span>
                    <span class="add-on"><i class="icon-calendar"></i></span>
                    <script type="text/javascript">
                        $(".form_datetime").datetimepicker({
                        format: "dd mm yyyy hh:ii",
                        autoclose: true,
                        todayBtn: true,
                        startDate: "2017-01-14 10:00",
                        minuteStep: 10
                        });
                    </script>            
                </div>
            </div>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
            <button type="button" class="btn model-button" id="AddEvent" OnClick="addEvent()">Save Changes</button>
        </div>

    </div>
</div>
</div>

这里是我的脚本

function addEvent() 
{

    var event_name = $("#event_name").val();
    var wedding_date = $("#wedding_date").val();

    // Add event
    $.post("ajax/addData.php", 
    {
        event_name: event_name,
        wedding_date: wedding_date
    }, 
    function (data, status) 
    {
        //console.log(data);
        // close the popup

        alert("Data: " + data + "\nStatus: " + status);
        $("#add_new_event_modal").modal("hide");

        // read records again
        readEvent();

        // clear fields from the popup
        $("#event_name").val("");
        $("#wedding_date").val("");

    });
}

和我的功能

if (isset($_POST['event_name']) && isset($_POST['wedding_date'])) 
{
    $event_name = $_POST['event_name'];
    $wedding_date = $_POST['wedding_date'];
    //$category_name = $_POST['category_name'];
    $object = new crud();
    $object->addEvent($event_name, $wedding_date);
}

    public function addEvent($event_name, $wedding_date)
    {
        try
        {
            $stmt = $this->DB_conn->prepare("INSERT INTO event1(event_name,  wedding_date)
                                                              VALUES(:event_name, :wedding_date)");
                $stmt->bindparam(":eventname",$event_name);
                $stmt->bindparam(":weddingdate",$wedding_date, PDO::PARAM_STR);
                $stmt->execute(); 
        }   
        catch(PDOException $e)
        {
            echo $e->getMessage();
        }

    }

Answer 1

您有一个拼写错误:

$stmt->bindparam(":eventname",$event_name);
$stmt->bindparam(":weddingdate",$wedding_date, PDO::PARAM_STR);

您的参数是:event_name 和 :wedding_date 所以:

$stmt->bindparam(":event_name",$event_name);
$stmt->bindparam(":wedding_date",$wedding_date, PDO::PARAM_STR);