title: PHP Insert Into Error
body: <p>I am started to learn coding start with HTML, CSS, and php. I created a basic form to test my skill. However, I got stuck with this. Can you help me on that? </p>
  
  <p>I know that it is open to SQL injections, I am just trying to improve myself in coding and will use prepared statements and parameterized queries in real life. </p>
  
  <pre><code>&lt;?php
  
  if ($_SERVER["REQUEST_METHOD"] == "POST") {
  
      $mysql_host = "";
      $mysql_username = "";
      $mysql_password = "";
      $mysql_database = "";
  
      $conn = new mysqli ($mysql_host, $mysql_username, $mysql_password, $mysql_database);
  
      $c_name = $_POST["club_name"]; 
      $c_league = $_POST["league"];
      $c_rank = $_POST["ranking"];
      $c_prank = $_POST["previous_rank"];
  
      $sql = "INSERT INTO `club_data` (`club_name`, `league`, `ranking`, `previous_rank`)
      VALUES ('$c_name', '$c_league, $c_rank, $c_prank);";
      mysqli_query($conn, $sql); 
  
      if ($conn-&gt;query($sql) === TRUE) {
          echo "kayit islendi";
      }
      else {
          echo "Error". $sql ."&lt;br&gt;". $conn-&gt;error;
      }
      $conn-&gt;close();
  }
  ?&gt;
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/EMvXd.png" alt="List Names"></p>
  
  <p>Everytime I used the form I got this error. </p>
  
  <p>ErrorINSERT INTO... etc.</p>