php - 数据未插入数据库

Question

我正在为某个项目制作表格。问题是当用户使用字段输入他们的数据然后提交时，输入不会保留在数据库中。此外，当点击提交时，直接页面显示空白页面，即使连接测试也没有显示。我在其他项目中使用了几乎相似的代码，除此之外它都可以工作。下面是我的代码:

 <?php

    //check connection
    require 'config.php';
    if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    }
    echo "Connected successfully";

   //asas (table name)
       $id = $_POST["Sid"]; $ic = $_POST["Sic"];
       $name = $_POST["Snp"]; $jant = $_POST["J1"];
       $trum = $_POST["Chr"];$tbim = $_POST["Chp"];
       $mel = $_POST["Sem"]; $arum = $_POST["Ar"];
       $asum = $_POST["As"];

  //institusi
       $thp = $_POST["T1"]; $uni = $_POST["Sis"];
       $bid = $_POST["tpe"];$Aint = $_POST["Ai"];

 //industri
      $bip = $_POST["bid"];$bik = $_POST["B1"];
      $tem = $_POST["te"];$mula = $_POST["tm"];
      $tamm = $_POST["tt"]; $res = $_POST["fileToUpload1"];
      $tran = $_POST["fileToUpload2"];$keb = $_POST["fileToUpload3"];


    $link = mysqli_connect($h,$u,$p,$db);

    if('id' != '$Sid'){
    $asas = "insert into asas Values ('$id','$ic','$name','$jant','$trum','$tbim','$mel','$arum','$asum')";
    $inst = "insert into institusi Values ('$thp','$uni','$bid','$Aint')";
    $indr = "insert into industri Values ('$bip','$bik','$tem','$mula','$tamm','$res','$tran','$keb')";

      mysqli_query($link,$asas);
      mysqli_query($link,$inst);
      mysqli_query($link,$indr);
      mysqli_close($link);
     }
      else
     {
     echo "failed"
     }
    ?>
   <b>Register complete</b>

任何人都可以告诉我错误是什么或者一些解决方案。谢谢

Answer 1

我认为您在插入查询时遇到问题，请检查:

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";

写这种。

谢谢