aixen083 Posted February 18, 2015 Share Posted February 18, 2015 Good Day, Please help me to create a simple organisation management in php so this is the scenario, i have 3 tables (organisation, student, teacher) the simple system works fine But the problem is that adding organisation to my system. ? because before i just type it in my query WHERE org_name = 'COMTECH' to my students query and to my index query after i log in as a student how can i add organisation and create a log in that connects the student on the organisation that he is registered ? So this the example data in my database table Organisation.tbl org_id: 1 org_name: COMTECH org_description: computer fundamentals Student.tbl Teacher.tbl student_id: 1 teacher_id: 1 username: student username: teacher password: demo password: demo firstname: alvin user_type: Admin lastname: biares So right no im having hard time to solve the problem that if the organisation was created and the students are registered to that organisation the student can see only the teachers who are already registered in that organisation. ?please help me.. Quote Link to comment Share on other sites More sharing options...
tryingtolearn Posted February 18, 2015 Share Posted February 18, 2015 Can a teacher be registered to more than one organization? Can a student be registered to more than one organization? Quote Link to comment Share on other sites More sharing options...
Barand Posted February 18, 2015 Share Posted February 18, 2015 This is the same problem you posted in your other thread. Apply the same technique I gave you there. http://forums.phpfreaks.com/topic/294644-how-to-create-query-in-log-in-that-compares-the-id-using-php/?do=findComment&comment=1505910 Or do you want us to write the code for you every time? Quote Link to comment Share on other sites More sharing options...
aixen083 Posted February 19, 2015 Author Share Posted February 19, 2015 Can a teacher be registered to more than one organization? Can a student be registered to more than one organization? No sir, only 1 organization per student and teacher. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.