php - 如何使用 GET 方法将数据存储在 mysql 中？

Question

我正在尝试使用 GET 方法将数据从 php 存储到 mysql，

   <?php 
    $user = "root";
    $password = "";
    $host = "localhost";

    $connection = mysql_connect($host,$user,$password);
    $select = mysql_select_db('dam',$connection);

    if($connection)
    {
        echo "connection succesfull";
    }
    else {
        echo "Error";
    }
 ?>

这是数据库连接代码 connection.php，它还在 localhos(浏览器)中显示连接成功，我正在尝试使用 GET 方法将一些数据添加到数据库

    <?php 
    include("connect.php");

    $sensor1 = $_GET['sensor1'];
    $sensor2 = $_GET['sensor2'];
    $sensor3 = $_GET['sensor3'];



    $sql_insert = "insert into tablearduino (sensor1,sensor2,sensor3) values ('$sensor1,$sensor2,$sensor3')";

    mysql_query($sql_insert);

    if($sql_insert)
    {
        echo "Saving succeed";
    }
    else{
        echo "Error occured";
    }
 ?>

当我这样输入网址时

http://localhost/EPPF/index.php?sensor1=5.0&sensor2=3.0&sensor3=4.0

数据没有存储在mysql数据库中

问题是什么，我该如何解决？

Answer 1

将您的查询更改为

$sql_insert = "insert into tablearduino (sensor1,sensor2,sensor3) values ('$sensor1','$sensor2','$sensor3')";