title: How to store integer numbers to MySQL database using php?
body: <p>I am doing a website for some reporting purpose, so I need to store data to MySQL using php. everything is good but I can't store integers/numbers to the database. I guess there's something wrong with my code. Please help me out.</p>
  
  <p>html code: </p>
  
  <pre><code> &lt;div id = "forms"&gt;
     &lt;form enctype="multipart/form-data" form action="add_data.php" method="post" &gt;
  
    &lt;li&gt; &lt;label for = "Injured_D" &gt; No. of Injured Driver: &lt;/label&gt;
    &lt;input "type = "text" name = "Injured_D" id = "Injured_D" /&gt;  
    &lt;/li&gt;
  
  &lt;div id = "submit"&gt;&lt;button type="submit" &gt;Submit&lt;/button&gt; &lt;/div&gt;&lt;br&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>php code:</p>
  
  <pre><code>// escape variables for security
  $injured_D = mysqli_real_escape_string($con, $_POST['injured_D']);
  $sql="INSERT INTO abc (injured_D) VALUES ('$injured_D')";
  </code></pre>
  
  <p>MySQL Settings:</p>
  
  <p>Type: int(30)</p>
  
  <p>Collation: none</p>