or here : http://min.us/lbmnlBGogx2aBY
As described in above image how can i do that using scriptcase ? any idea ??
And one more thing, how to use limit in scriptcase ?
When logging in you need to determine his / her role. This role needs to be applied to a global variable which is used in the sql of the according panel. This way you can change the sql statement depending on the role and filter the data. Does this help you?
Well
Doesn’t sound too difficult
You would first have to identify each record
To identify which records be seen by each group
yea that i have planned for after login identification, but the main issue is that what sql query should i run to retrieve different data based on role from database.
eg: my member database has these fields:
table0:
id, username, pass, role
table1:
rollno, student, address, phno, class
table2:
rollno, student, address, phno, marks, rank, subjects, percent, class
Now, in table1: class has 2 variables : fifth and sixth.
the fifth class student data goes to 1st user (say whose role is fifth class admin)
and similarly, sixth class student data goes to 2nd user (say whose role is for sixth class admin)
Then the form they get will contain these fields:
rollno (non-editable), student, address, phno, marks, rank, subjects, percent, class (non-editable).
when he submit / save , the all fields get populated in table 2.
this is all i want to achieve, Also another thing…
i have made the login script of my own in php so can i include that php module in scriptcase project and carry on with it ? or i need to do that all here ? or can i connect this module separately in it ??
what will be best and how ??
Thanks in advance.