[srcsameer]

i am trying to create a registration form and i have a column where i want to insert multiple values in that single column(catagory) through check Box. is there a possible way to do that? have a look at my php files.

Thank You,

This is my Dboperation.php

PHP Code


<?php 
public function createEmpl($name, $surname, $username, $user_pass, $address, $pin, $mail, $phone, $catagory){
            if($this->isUserExist($username,$mail,$phone)){
                    return 0;
            }else{
                $password = md5($user_pass);
                $stmt = $this->con->prepare("INSERT INTO `employee_data` (`name`, `surname`, `username`, `password`, `address`, `pin`, `mail`, `phone`, `catagory`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?);");
                $stmt->bind_Param("sssssssss",$name,$surname,$username,$password,$address,$pin,$mail,$phone,$catagory);

                if($stmt->execute()){
                    return 1;
                }else{
                    return 2;
                }
            }
        } 


And this is my main registration.php file

PHP Code


<?php 
if(
        isset($_POST['reg_name']) and isset($_POST['reg_surname']) and isset($_POST['reg_username']) and isset($_POST['reg_password']) and isset($_POST['reg_address']) and isset($_POST['reg_pin']) and isset($_POST['reg_mail']) and isset($_POST['reg_phone']) and isset($_POST['reg_catagory'])
        ){
        //operate the data further

        $db = new DbOperations();

        $result = $db->createEmpl(    $_POST['reg_name'],
                                    $_POST['reg_surname'],
                                    $_POST['reg_username'],
                                    $_POST['reg_password'],
                                    $_POST['reg_address'],
                                    $_POST['reg_pin'],
                                    $_POST['reg_mail'],
                                    $_POST['reg_phone'],
                                    $_POST['reg_catagory']
                                );
        if($result == 1){
            $response['error'] = false;
            $response['message'] = "User register successfully"; 


Any help will be appreciated.

[ShadowCloudGH]

Why not have a one to many table saving the categories? While you could save this in one column, I would suggest creating a new table called Employee_Category and saving an EmployeeId against a CategoryId. You could then have multiple records for the same employee in this table?

This will save you a lot of time manipulating strings later on...

[srcsameer]

Why not have a one to many table saving the categories? While you could save this in one column, I would suggest creating a new table called Employee_Category and saving an EmployeeId against a CategoryId. You could then have multiple records for the same employee in this table?

This will save you a lot of time manipulating strings later on...

Bro... i Didn't get you... i can't change my table or columns i just want is:

while registering one can check checkbox item/s and then selected keywords will be inserted to category column also i want to retrieve that user's id using that keyword. like if i will post checkbox1 then user's who has checkbox1 in their category column their names will be shown. did you get it?

[ShadowCloudGH]

Bro... i Didn't get you... i can't change my table or columns i just want is:

while registering one can check checkbox item/s and then selected keywords will be inserted to category column also i want to retrieve that user's id using that keyword. like if i will post checkbox1 then user's who has checkbox1 in their category column their names will be shown. did you get it?

Yes, but you clearly didn't get me :)

If you save this in one column, potentially delimited by something like a comma, or heaven forbid a pipe (|) or something even more sinisiter like a combination of chars (#split#) then you end up with the following in the record:

UsrID1>> cat1#split#cat2#split#cat5
UsrID2>> cat1#split#cat3
UsrID3>> cat5
UsrID4>> cat3
UsrID5>> cat1#split#cat3
UsrID6>> cat4#split#cat7

The problem with this is, now if you want all users with cat5 selected in registration, you have no way of getting info without going through all the records in the table.

This is concerned an anti-pattern

[srcsameer]

Yes, but you clearly didn't get me :)

If you save this in one column, potentially delimited by something like a comma, or heaven forbid a pipe (|) or something even more sinisiter like a combination of chars (#split#) then you end up with the following in the record:

UsrID1>> cat1#split#cat2#split#cat5
UsrID2>> cat1#split#cat3
UsrID3>> cat5
UsrID4>> cat3
UsrID5>> cat1#split#cat3
UsrID6>> cat4#split#cat7

The problem with this is, now if you want all users with cat5 selected in registration, you have no way of getting info without going through all the records in the table.

This is concerned an anti-pattern

Can you just show me by editing my php file Dboperation and registration... i am a learner bro.

---

Yes, but you clearly didn't get me :)

If you save this in one column, potentially delimited by something like a comma, or heaven forbid a pipe (|) or something even more sinisiter like a combination of chars (#split#) then you end up with the following in the record:

UsrID1>> cat1#split#cat2#split#cat5
UsrID2>> cat1#split#cat3
UsrID3>> cat5
UsrID4>> cat3
UsrID5>> cat1#split#cat3
UsrID6>> cat4#split#cat7

The problem with this is, now if you want all users with cat5 selected in registration, you have no way of getting info without going through all the records in the table.

This is concerned an anti-pattern

Hi! bro please reply... can you show me how to o it? it's really important for me.