mysql - 无法将数据推送到mysql

Question

我似乎无法将数据从表单推送到数据库，我检查了 error_log 并且没有错误。请检查我下面的代码，谢谢!

<?php 
   $con=mysqli_connect("localhost","admineventus","J7!ren;3") or Die ("Cannot connect");
    mysqli_select_db($con,"eventus");


if(isset($_POST['submitpublish']))
   {
  mysqli_query($con,"insert into events values('$_POST[Category]','$_POST[Name]','$_POST[Location]','$_POST[Sdate]','$_POST[Edate]','$_POST[Etime]','$_POST[Fee]','$_POST[Free]','$_POST[About]')");
     }
                 ?>

Answer 1

试试这个

if(isset($_POST['submitpublish']))
 {
 $sql = "INSERT INTO events (col1, col1, .. , colx)
VALUES ('".$_POST["Category"]."','".$_POST["Name"]."','".$_POST["Location"]."','".$_POST["Sdate"]."','".$_POST["Sdate"]."','".$_POST["Edate"]."','".$_POST["Etime"]."','".$_POST["Fee"]."','".$_POST["Free"]."','".$_POST["About"]."')";

 $result = mysqli_query($conn,$sql);
 }

确保您的代码进入 IF 语句