The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$archive_pages - Line: 2 - File: printthread.php(287) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/printthread.php(287) : eval()'d code 2 errorHandler->error
/printthread.php 287 eval
/printthread.php 117 printthread_multipage



UserSpice
Fetch data from DB - Printable Version

+- 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)

Pages: 1 2 3 4

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-in


Fetch 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! Tongue

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 Tongue Just kidding ;-)