dongying3830 2013-03-08 13:43
浏览 44


I am trying to create a function that will create a unique username for each user stored in the database.

My plan was to create a username by concatenating the first and last name then check if this username was taken. If it wasn't just store it in the database and if it was then add a number on the end of it.

For example if ConnorAtherton was taken the function would next check ConnorAtherton1, ConnorAtherton2 until it found a unique username.

Here is the function (I have added some echo statements for debugging)

    function createUserName($username, $counter){

        global $fname, $lname;

        echo "\t\t\tUsername at Start - " . $username . "

        // connect to database
        require($_SERVER['DOCUMENT_ROOT'] . "/inc/db.connect.php");

        $stmt = $conn->prepare('SELECT * FROM users WHERE username = ?');
        $stmt->bind_param('s', $username); 

        echo "\t\t\tUsername before loop - " . $username . "

            if( $stmt->num_rows > 0){

                //construct original name and try again
                $username = ucfirst($fname) . ucfirst($lname) . $counter;
                createUserName($username, $counter);


            echo "\t\t\tUsername after loop - " . $username . "


            return $username;

Here is what it returns to the console

    Username at Start - ConnorAtherton
    Username before loop - ConnorAtherton
    Username at Start - ConnorAtherton1
    Username before loop - ConnorAtherton1
    Username at Start - ConnorAtherton2
    Username before loop - ConnorAtherton2
    Username after loop - ConnorAtherton2

    Username after loop - ConnorAtherton1

It returns the correct value after the loop (ConnorAtherton2) to begin with but I don't know why there would be a second value after the loop.

It returns ConnorAtherton1 and I need it to return ConnorAtherton2.

Any help is greatly appreciated.

  • 写回答

2条回答 默认 最新

  • doutian3269 2013-03-08 13:47

    The code executes as expected. What you are seeing is just the stack unwinding from the recursive calls.

    You should modify your function to exit after the recursive call, by returning the result from the recursive call

        return createUserName($username, $counter);
     //... Rest of fn omitted
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥15 用matlab写代码
  • ¥30 motoradmin系统的多对多配置
  • ¥15 求组态王串口自定义通信配置方法或代码?
  • ¥15 实验 :UML2.0 结构建模
  • ¥20 用vivado写数字逻辑实验报告撰写,FPGA实验
  • ¥15 为什么shp文件会有这种小方块?
  • ¥15 ecplise在连接数据库时显示加载驱动成功但是数据库连接失败
  • ¥15 visionmaster启动失败,提示为“机器不满足授权而被禁用”
  • ¥15 IDEA中圈复杂度如何具体设置
  • ¥50 labview采集不了数据