title: unable to insert data into database from html
body: <p>I am trying to  insert  data from a html file into my database "customers"</p>
  
  <p>I am however able to connect to database but unable to insert data from a <a href="https://i.stack.imgur.com/8DS5r.png" rel="nofollow noreferrer">html</a> file to my database</p>
  
  <p>screenshot of <a href="https://i.stack.imgur.com/TZvLF.png" rel="nofollow noreferrer">error</a><br>
      <a href="https://i.stack.imgur.com/TZvLF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TZvLF.png" alt="enter image description here"></a>
  Notes:</p>
  
  <ol>
  <li>I have not set password for phpmyadmin just the username as "root"</li>
  <li>all files are stored in same folder (C:\wamp64\www) </li>
  </ol>
  
  <p><strong>customers.html</strong></p>
  
  <pre><code>&lt;!DOCTYPE html&gt;
  &lt;html&gt;
  &lt;head&gt;
          &lt;title&gt;customers&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
  
    &lt;center&gt;&lt;form action="SignUp.php" method="POST"&gt;
          &lt;input type="text" name="id" placeholder="customer id"&gt;&lt;br&gt;
          &lt;input type="text" name="firstname" placeholder="firstname"&gt;&lt;br&gt;
          &lt;input type="text" name="orderno" placeholder="order no"&gt; &lt;br&gt;
          &lt;input type="text" name="city" placeholder="city"&gt;&lt;br&gt;
          &lt;input type="text" name="price" placeholder="product price"&gt;&lt;br&gt;
          &lt;button type="submit"&gt;order&lt;/button&gt;
       &lt;/form&gt;
  &lt;/center&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p><strong>SignUp.php</strong></p>
  
  <pre><code>&lt;?php
  
  include 'db.php';
  
  $sql= "INSERT INTO customers (id,firstname,orderno,city,price)
  VALUES ('345','username','979','city','4465')";
  
   if($result=mysql_query($sql)==true)
          echo "data inserted successfully";
   else
          echo "failed to insert data";
  ?&gt;
  </code></pre>
  
  <p><strong>db.php</strong></p>
  
  <pre><code>&lt;?php
  
  $conn=mysqli_connect("localhost","root","","customers");
  if(!$conn){
          die("connection failed : " .mysqli_connect_error());
  }
  else{
          echo "connection created successfully"."&lt;br&gt;";
  }
  
  ?&gt;
  </code></pre>