title: only one record inserted at a time when try to save from two different client
body: <p>I have tried to save agency information from two different clients at the same time but the problem is only one row inserted in the database but not shown any error to other client. <br>
  <br>Let me explain in another way, I have a web app which is running on two different machines but same server, I tried to save two differents information at the same time from both machine but only one record saved. Should I have to use any Deadlock prevention algorithm? Thank for your response in advance.</p>
  
  <p>Here is my simple insertion code </p>
  
  <pre><code>$sql = "insert into  agency(agcode,agcname,proprietor,address,contact,email,gst)values('".$agcode."','".$agcname."','".$proprietor."','".$address."','".$cont."','".$email."','".$gst."')";
  $result = mysqli_query($con,$sql);
  </code></pre>