无法从php脚本插入数据库，我正在使用WAMP - Cannot insert into database from php script I am using WAMP

Cannot insert into database from php script I am using WAMP

本文关键字：WAMP 数据库 php 脚本插入 | 更新日期: 2023-09-27

我正试图从php脚本将数据插入MySQL数据库。我正在使用WAMP。当通过phpmyadmin插入数据时，一切都很好，数据也可以显示在网页上，但当试图通过php脚本手动插入数据时什么也没发生（我这样做是为了测试，我的目标是将数据加载到服务器frOm Arduino中）。BElow是代码：

<?php
    $link=mysqli_connect("localhost", "root", "", "database");
    if (mysqli_connect_errno()) {
     printf("Connect failed: %s'n", mysqli_connect_error());
    exit();
    }
    $temp="";
    $hum="";
    if(isset($_POST["temp1"])){ $temp = $_POST["temp1"];}
    if(isset($_POST["hum1"])){ $hum = $_POST["hum1"];}
    $safetemp1= mysqli_real_escape_string($link, $temp);
    $safehum1= mysqli_real_escape_string($link, $hum); 
    $query = "INSERT INTO tempLog (temperature, humidity) 
     VALUES (10, 10)";
    $result = mysqli_query($link,$query);
    if (!$result) {
       die("Nothing was inserted, something went wrong.");
    }
    mysqli_close($link);
    header("Location: indexx.php")

试试这个，看看是否有错误，也许是拼错了行或表名。

echo("Error description: " . mysqli_error($link));

$link=mysqli_connect("localhost", "root", "", "database");
if (mysqli_connect_errno()) {
 printf("Connect failed: %s'n", mysqli_connect_error());
exit();
}
$temp="";
$hum="";
if(isset($_POST["temp1"])){ $temp = $_POST["temp1"];}
if(isset($_POST["hum1"])){ $hum = $_POST["hum1"];}
$safetemp1= mysqli_real_escape_string($link, $temp);
$safehum1= mysqli_real_escape_string($link, $hum); 
$query = "INSERT INTO tempLog (temperature, humidity) 
 VALUES (10, 10)";
$result = mysqli_query($link,$query);
if (!$result) {
   echo("Error description: " . mysqli_error($link));
   die("Nothing was inserted, something went wrong.");
}
mysqli_close($link);
header("Location: indexx.php")