具有PHP和PDO的独特配置文件插件

use ChannaveerSlugSlug;

$string = "john doe";
$slug = Slug::create($string);

$profile_count_stmt = $pdo->prepare("
                    SELECT
                        COUNT(`id`) slug_count
                    FROM
                        `advogados_e_escritorios`
                    WHERE
                        `slug_perfil` LIKE :slug
                ");

$profile_count_stmt->execute([
    ":slug" => "%".$slug."%"
]);

$profile_count = $profile_count_stmt->fetchObject();

if ($profile_count && $profile_count->slug_count > 0) {
    $profile_increment = $profile_count->slug_count + 1;
    $slug = $slug . '-' . $profile_increment;
}

echo 'Your unique slug: '. $slug;
// Your unique slug: john-doe-5

$slug = Slug::create($string);

$slugExists = "DB query to check if the slug exists in your database then you may return the count of rows";

//If the count of rows is more than 0, then add some random string

if($slugExists) {
/** NOTE: you can use primary key - id to append after the slug, but that has to be done after you create the user record. This will help you to achieve the concurrency problem as @YourCommenSense was stating.   */
    $slug = $slug.time(); //time() function will return time in number of seconds
}

//DB query to insert into database