Announcement

Collapse
No announcement yet.

How to do this using scriptcase ? any help will be wonderful.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to do this using scriptcase ? any help will be wonderful.

    545.jpg

    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 ?
    Last edited by rasttech990; 04-17-2013, 08:45 AM.

  • #2
    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?
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Well
      Doesn't sound too difficult

      You would first have to identify each record
      To identify which records be seen by each group

      Comment


      • #4
        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.

        Comment

        Working...
        X