在数据库表中使用mysqli插入数据不起作用？连接工作正常

Question

• It should say new record and then I should be able to see new data in items table

• connection to database file contains:

      $server="localhost";
      $login="root";
      $pass="";
      $database="floweritem";
  
      $con=mysqli_connect($server,$login,$pass,$database);
      if(mysqli_connect_errno()){
      echo "Failed connect to MYSQL".mysqli_connect_error();
      }
  

• form action

• PHP

      <?php
      if(isset($_POST['submit'])){
      $Name=mysqli_real_escape_string($con,$_POST['Name']);
      $Desc=mysqli_real_escape_string($con,$_POST['Desc']);
      $Size=mysqli_real_escape_string($con,$_POST['Size']);
      $Price=mysqli_real_escape_string($con,$_POST['Price']);
  
  
      //no problwm with connection to table or database
      $sql="INSERT INTO `items`(`Name`,`Description`,`Size`,`Price`) 
      VALUES($Name,$Desc,$Size,$Price)";
      echo $Desc;
  
  
      if(mysqli_query($con,$sql)){ 
      echo "new record";
      }
      //always get wrong
      //can't find problem
      else{echo"Wrong";}
      mysqli_close($con);
      }
      ?>
  

• shows $Desc But Not successful to insert data in items table

Answer 1

You need to add single quotes against values.

Corrected Code:

 //no problwm with connection to table or database
    $sql="INSERT INTO `items`(`Name`,`Description`,`Size`,`Price`) 
    VALUES('$Name','$Desc','$Size','$Price')";
    echo $Desc;

Otherwise, MySQL will consider user entered values as MySQL keywords, hence creating Syntax errors.