+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: Fetch data from DB (/showthread.php?tid=100)
Fetch data from DB - brian - 03-15-2016
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.
Fetch data from DB - jjmmrg - 03-16-2016
Thanks for the explanation @brian
Fetch data from DB - jjmmrg - 03-16-2016
@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-inFetch data from DB - brian - 03-16-2016
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.
Fetch data from DB - astropos - 03-16-2016
Hey @jjmmrg did you definitely set the url for your site in your settings?
What version of UserSpice are you using?
Fetch data from DB - mudmin - 03-17-2016
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.
Fetch data from DB - brian - 03-17-2016
This tardiness will get you fired!
Fetch data from DB - jjmmrg - 03-18-2016
@brian Thanks for looping @mudmin
Fetch data from DB - jjmmrg - 03-18-2016
@astropos , yes i did everything . However now everything is solved with the help of @mudmin mate
Fetch data from DB - jjmmrg - 03-18-2016
@brian , even being tardiness , he took time to help me . so its been forgiven
Just kidding ;-)