Complex algorithm

Question

I've tried to rack my brain but got stucked.. but i believe this is possible, because there are gurus out there. There is this affiliation websites. If a user is the first to register on the app, he wont be under anyone but the next six users that registered would be under the first user,when it is more than six the seventh user wont be under anyone, any other six users that registered would be under the seventh users, and so on.. I created two tables, the users table and the table to keep track of users under users..

 if(isset($_POST['submit'])) {
    $name = $_POST['name'];
    $email = $_POST['email'];
    $password = $_POST['password'];
    $pre = $db->prepare("SELECT * FROM affi");
     $pre->execute();
    $fetch = $pre->fetchAll();
    // print_r($fetch);die;
    if(count($fetch) < 1) {
        //checking if this is the first user 
        $create_user = $db->prepare("INSERT INTO users (name, email, password )
        VALUES('$name', '$email', '$password')");
        $stmt = $create_user->execute();
        if($stmt)  {
            $refer = $db->prepare("INSERT INTO refer_customer (email)
            VALUES('$email')");
            $stmt = $refer->execute();
            header("Location: Index.php");
        }
    } else if(count($fetch) <= 7) {
        //trying to attach other six users that would register under the first one
        $get_user = $db->prepare("SELECT FIRST(id) from users ");
         $get_user->execute();
         $result = $create_user->fetch(PDO::FETCH_OBJ);
        if($result) {
        $create_user = $db->prepare("INSERT INTO users (name, email, password )
        VALUES('$name', '$email', '$password')");
        $stmt = $create_user->execute();
        if($stmt)  {
            $refer = $db->prepare("INSERT INTO refer_customer (refere_id ,email)
            VALUES('$result->id','$email')");
            $stmt = $refer->execute();
            header("Location: Index.php");
        }
    }  
    
    }
}

Got stucked dont even know how this gonna end because there will be unlimited users if you know what i mean.. Please any help is appreciated

really you should fix the sql injection issues before going any further (ill do later will never happen), see: How can I prevent SQL injection in PHP? also never store passwords as plaintext — Lawrence Cherone
– Lawrence Cherone, Commented Sep 22, 2021 at 23:25

KIKO Software · Accepted Answer · 2021-09-22 23:09:51Z

1

This sounds like quite a simple problem.

You could number your users when they register: user 1, 2, 3, etc. The best way to do this would be with an auto-increment index in your database. Let's call this column userId.
Next is a little trick: You can use the modulo operator in PHP, like this: $position = $userId % 7; This will return a number between 0 and 6. $position == 0 is for the leader of the next 6 users.

And that's it. MySQL also has the modulo operator.

answered Sep 22, 2021 at 23:09

KIKO Software

17.5k3 gold badges33 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Dipo Deen Over a year ago

Thanks for replying, how do i implement this with the code ? the variable userId is coming from where? The auto increment id normally skips a number if a user was deleted. I see awesome reasoning here, but dont know how this helps, any further explanation is appreciated

KIKO Software Over a year ago

I don't know what you explain about the implementation? The ID of an user dictates the position. That's all. There's really not that much to implement. Yes, an auto increment id does not automatically adapt to deleted users. You never mentioned anything about this in your question, so I didn't address it. Did you think about what to do with deleted users? Do they get replaced with other users?

KIKO Software Over a year ago

@DipoDeen If the userId column is not an auto increment column then you can deal with deleted users. Let's rename the column to userNo. You can still use the solution I mentioned in my answer, and when a new user registers you have to look for the lowest available number.

Dipo Deen Over a year ago

Okay, i understand now.. It's a great idea how come i never think like this ? lol. Thanks so much

KIKO Software Over a year ago

@DipoDeen It's simply a question of experience. If you reduce complex things to their simplest form on a daily basis for 30 years you will come up with things like this as well. It's already a big step that you actually understand this, many people wouldn't. So there is hope! 😀

Collectives™ on Stack Overflow

Complex algorithm

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related