如何通过php在mysql(wamp)数据库中插入数据 - how to insert data in mysql( wamp) database through php?

how to insert data in mysql( wamp) database through php?

我已经尝试了很多次，连接成功，但是我无法插入数据，请帮助我。

下面是我的代码，我刚刚添加了一个if检查，看看查询是否没有向数据库添加任何数据，那么它应该给出某种指示，所以它说无法发布。当我从wamp数据库中看到数据库表中没有插入或添加数据时，请帮助我，将不胜感激。谢谢。

    <?php
    if(isset($_POST['id']) && isset($_POST['name']) && isset($_POST['semester']) && isset($_POST['section'])):
    $post_id = $_POST['id'];
    $post_name = $_POST['name'];
    $post_semester = $_POST['semester'];
    $post_section = $_POST['section'];
    $link = new mysqli('localhost','root','','registration');
    if($link->connect_error)
        die('connection error: '.$link->connect_error);
    $sql = "INSERT INTO student_info(student_id, student_name, semester, section) VALUES('".$post_id."', '".$post_name."', '".$post_semester."', '".$post_section."',)";
    //echo $sql;    
    $result = $link->query($sql); 
    if($result > 0):
        echo 'Successfully posted';
    else:
        echo 'Unable to post';
    endif;
    $link->close();
    die();
    endif; 
    ?>
    <!DOCTYPE html>
    <html>
     <head>
     </head>
     <body>
      <h1>Student Registration</h1>
      <form action="add.php" method="post">
        Student ID : <input type="text" name="id"/><br><br>
        Student Name : <input type="text" name="name"/><br><br>
        Semester : <input type="text" name="semester"/><br><br>
        Section : <input type="text" name="section"/><br><br>
        <input type="submit" value="create"/>
      </form>
     </body>
    </html>

在SQL语句的末尾有一个额外的逗号(，)。正确的是-

$sql = "INSERT INTO student_info(student_id, student_name, semester, section) VALUES('".$post_id."', '".$post_name."', '".$post_semester."', '".$post_section."')";

我也能够看到错误'无法张贴'与您当前的代码，所以这是正常工作。

Try;

<?php
if(isset($_POST['id']) && isset($_POST['name']) && isset($_POST['semester']) && isset($_POST['section'])){
$post_id = $_POST['id'];
$post_name = $_POST['name'];
$post_semester = $_POST['semester'];
$post_section = $_POST['section'];
$link = new mysqli('localhost','root','','registration');
if($link->connect_error)
    die('connection error: '.$link->connect_error);
$sql = "INSERT INTO student_info(student_id, student_name, semester, section) VALUES('$post_id', '$post_name', '$post_semester', '$post_section')";
//echo $sql;    
$result = $link->query($sql); 
if($result){
    echo 'Successfully posted';
}else{
    echo 'Unable to post';
}
$link->close();
die();
}
?>