Fetch data from DB

[brian]

In most cases a column named "id" is the primary key or unique identifier/selector for a row of data. So when you perform a SELECT id WHERE user_id=? that returns the unique identifier 'id' which in these cases are 100 or 101 or whatever, which matched your query WHERE condition of user_id. So every table in the row can be described the same way: a row with id=X, has user_id=Y and permission_id=Z. Again in this example the id column simply acts as a unique identifier for the useful information which demonstrates the permission_id's which have been assigned to a user_id.

In this case user_id 1 belongs to permission_id 1 and 2 so it has two entries. The actual value of id in this case is meaningless except for providing a unique identifier.

[jjmmrg]

Thanks for the explanation @brian

[jjmmrg]

@brian , i have a query since it is very long for formatting over here i posted in external site which link is below . can you look at that and either help me with a reply over here or there .

Code:

http://stackoverflow.com/questions/36032007/php-redirect-user-if-logged-in

[brian]

I'll need to defer to @mudmin since this is more in his domain and he wrote the redirect classes (or is now managing them at least). With any luck he will chime in soon.

[astropos]

Hey @jjmmrg did you definitely set the url for your site in your settings?

What version of UserSpice are you using?

[mudmin]

I have internet now, but not my workstation that I built userspice on. I'm still in transition but making progress. I'll pop over to stack exchange and give it a shot. Looking at the question, it's a 4.x version.

[brian]

This tardiness will get you fired!

[jjmmrg]

@brian Thanks for looping @mudmin

[jjmmrg]

@astropos , yes i did everything . However now everything is solved with the help of @mudmin mate

[jjmmrg]

@brian , even being tardiness , he took time to help me . so its been forgiven Just kidding ;-)