使用提交按钮通过PHP将条目插入MySQL数据库？

I'm pretty new to PHP, so I'm not quite sure on what to do with this.

我对PHP很新,所以我不太清楚如何处理这个问题。

Basically I'm trying to insert an entry into my MySQL database, through a "submit" button in HTML. I can't seem to get this to work, is it possible?

基本上我是想通过HTML中的“提交”按钮在MySQL数据库中插入一个条目。我似乎无法让这个工作,是否可能?

    <?php
    include('db_connect.php');
    $SQL = "INSERT INTO chosenitems (ID, Name, Price) VALUES ('', '4-6 Days', '£75.00')";

    $result = mysql_query($SQL);
    ?>

The INSERT works perfectly fine on its own, but I want it to be executed when the "submit" button is pressed.

INSERT本身可以很好地工作,但我希望在按下“提交”按钮时执行它。

Any help would be greatly appreciated.

任何帮助将不胜感激。

Thanks

Tobo.

3 个解决方案

#1

Just set the action of the form to the URL of the script that performs the insert.

只需将表单的操作设置为执行插入的脚本的URL即可。

Note that since you are modifying a database, the request is probably non-idempotent and you should use the POST method.

请注意,由于您正在修改数据库,因此请求可能是非幂等的,您应该使用POST方法。

<form action="/path/to/your/script.php" method="post">
    <input type="submit">
</form>

#2

You can check button value is posted and can execute line of code in it.

您可以检查已发布的按钮值,并可以在其中执行代码行。

<?php
    include('db_connect.php');
    if(isset($_REQUEST['SUBMIT_BUTTON_NAME']))
    {
        $SQL = "INSERT INTO chosenitems (ID, Name, Price) VALUES ('', '4-6 Days', '£75.00')";

        $result = mysql_query($SQL);
    }
?>

Hope this will be helpful to you

希望这对你有所帮助

#3

<form method="post">
    <input type="submit" name="submit" value="submt"/>
</form>

PHP

<?php
if(isset($_POST['submit']))
{
     $SQL = "INSERT INTO chosenitems (ID, Name, Price) VALUES ('', '4-6 Days', '£75.00')";
     $result = mysql_query($SQL);
}
?>

#1