while循环用于检查标题并添加一个数字（如果它已经存在）

Question

I want to get the title out of a form and write it to the database. But if the title already exists I want to add number 1 to the title. I can fix that on my own but the problem is how can I (after the 1 is added) check again and if title +1 already exists make it title +2 and so on... Any ideas how I have to construct a while loop that does that?

$title = $_POST["title"]; 
$sql = "SELECT * FROM [my_table] WHERE title='$title'";
$result = mysqli_query($con, $sql);
if(mysqli_num_rows($result) > 0) {
  $title = mysql_real_escape_string($_POST["title"]);
  //$title + add 1 to the title

} else {
  $title = mysql_real_escape_string($_POST["title"]); 
}

Answer 1

One possible solution is to get the count of how many registers with the same title you have. For example:

$sql = "SELECT COUNT(*) AS count FROM [my_table] WHERE title='$title'";
$result = mysqli_query($con,$sql);
$row = mysqli_fetch_assoc( $result);
$count = $row['count'];

Then:

if($count > 0) {
  $title = mysql_real_escape_string($_POST["title"]);
  $title .= $count;

} else {
  $title = mysql_real_escape_string($_POST["title"]); 
}