解析错误:语法错误，第59行C:\xampp\htdocs\tempahperalatan\Page2.php中的意外T_IF

Question

嗨，我是一个学习php和sql的学生，我试图用一个数量从复选框中插入一个数据，但是我不确定我的编码，有人能帮我吗？第59行有一个错误。

这是我的php代码：

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "tempahperalatan";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

if(isset($_POST['submit']))
{

    $catatan = $_POST['catatan'];

    $microphones=$row[microphones];

        if ($laptop=='1')
          { $vlaptop="ON";}
        else
          { $vlaptop="OFF";}

    $amplifiers=$row[amplifiers];
        if ($amplifiers=='1')
          {
            $vamplifiers="ON";
          }
          else
          {
          $vamplifiers="OFF";
          }

    $loudspeakers=$row[loudspeakers];
        if ($loudspeakers=='1')
          {
            $vloudspeakers="ON";
          }
          else
          {
          $vloudspeakers="OFF";
          }

    $mixers=$row[mixers];
        if ($mixers=='1')
          {
            $vmixers="ON";
          }
          else
          {
          $vmixers="OFF";
          }       

 $sql= "INSER INTO pasystems (catatan) INTO '$catatan'"


if (mysqli_query($conn, $sql)) { //this is line 59
    echo "<script type='text/javascript'>alert('submitted successfully!')</script>";
} else {
    echo "<script type='text/javascript'>alert('failed!')</script>" . $sql . "<br>" . mysqli_error($conn);
}


}


mysqli_close($conn);
?>

这是我的表格：

<form action="page2.php" method="POST">


        <div class="form-group row text-left">
          <label for="example-date-input" class="col-2 col-form-label">Nama Peralatan: </label>
          <div class="col-10">

            <div class="form-group">
              <div class="form-row">
                <div class="col-md-2">
                        <div class="form-check text-left">
                            <label class="form-check-label">
                                <input class="form-check-input" name="Microphones" type="checkbox" 
                                <?      if ($row[microphones]==1)
                { ?> checked="checked" <?    }              
        ?> >
                                Microphones
                            </label>
                        </div>
                </div>
                <div class="">
                    <input class="form-control" type="number" value="1" id="example-number-input">                              
                </div>                                  
              </div>
            </div>

            <div class="form-group">
              <div class="form-row">
                <div class="col-md-2">
                        <div class="form-check text-left">
                            <label class="form-check-label">
                                <input class="form-check-input" name="Amplifiers" type="checkbox" 
                                <?      if ($row[lamplifiers]==1)
                { ?> checked="checked" <?    }              
        ?> >
                                Amplifiers
                            </label>
                        </div>
                </div>
                <div class="">
                    <input class="form-control" type="number" value="1" id="example-number-input">  
                </div>
              </div>
            </div>

            <div class="form-group">
              <div class="form-row">
                <div class="col-md-2">
                        <div class="form-check text-left">
                            <label class="form-check-label">
                                <input class="form-check-input" name="Loudspeakers" type="checkbox" 
                                <?      if ($row[loudspeakers]==1)
                { ?> checked="checked" <?    }              
        ?> >
                                Loudspeakers
                            </label>
                        </div>
                </div>
                <div class="">
                    <input class="form-control" type="number" value="1" id="example-number-input">  
                </div>
              </div>
            </div>  

            <div class="form-group">
              <div class="form-row">
                <div class="col-md-2">
                        <div class="form-check text-left">
                            <label class="form-check-label">
                                <input class="form-check-input" name="Mixers]" type="checkbox" 
                                <?      if ($row[mixers]==1)
                { ?> checked="checked" <?    }              
        ?> >
                                Mixers
                            </label>
                        </div>
                </div>
                <div class="">
                    <input class="form-control" type="number" value="1" id="example-number-input">  
                </div>
              </div>
            </div>                          

          </div>
        </div>  

        <div class="form-group row text-left">
        <label for="exampleTextarea" class="col-2 col-form-label">Catatan: </label>
            <div class="col-10">
            <textarea class="form-control" name="catatan" id="exampleTextarea" rows="3"></textarea>
            </div>
        </div>                      
    <center><button type="submit" name="submit" class="btn btn-info">Submit</button></center>   

</form>

我不知道我的编码有什么问题。提前谢谢你的帮助是非常需要的。

Answer 1

这里的错误是您在语法中插入错误。您缺少了VALUES关键字，您拼错了INSERT和一个缺失的分号，下面应该会修复它。

$sql= "INSERT INTO pasystems (catatan) VALUES('$catatan')";

另外，上面的代码也不安全。您需要开始使用准备好的语句，因为您正在使用支持它的api

Answer 2

写插入代替inser @58

希望这能帮到你

谢谢