How to fix glitches with SELECT MAX(`id`)?

Question

PHP

There is a code

$servername = "localhost";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT MAX(`id`) FROM `ia`";
$result = $conn->query($sql);
$row = $result->fetch_row();
$firstField = $row[0];
$nextID = $firstField +1 ;

when there is a request from two people at once, we have the first request to the database with id = $nextID data is added then the request of the second person rewrites the information of the first one with the same id , this happens rarely, but still how to do normalino?

Answer 1

I'm not sure if this will help 100%, I haven't tested the logic of this function, but it's worth a try:
In other words:
*I didn't notice right away... But after that with autoincrement it won't be superfluous.