Jump to content

r1nk

Members
 View Profile  See their activity

  • Posts

    26

  • Joined

  • Last visited

 Content Type 

Everything posted by r1nk

  1. r1nk
    EDIT: about no 3, the user table i show you is the old one.. i do updated the table to match my coding in the view_users.php about no 5 and no 7, yes, i would like the teacher to be assigned with his/her own courses and subjects so that when he/she want to take attendance, he/she need to click the course and subject 1st..
  2. r1nk
    Thanx, i will think of your points.. Hmm regarding my current error about undefined index.. How to fix it? I think i need to declare something 1st about the user_id right.. but i dont know how..
  3. r1nk
    ok i updated my view_users.php and my edit.php.. view_users.php <?php session_start(); require_once('function.php'); //Set this to what ever page you include that holds all your functions so that we can use the checkUserStatus() checkUserStatus('admin'); ?> <html> <head> <title> View Users </title> </head> <body> <h2 align='right'><a href='admin.php'>Home</a></h2> <center><h2>Users Information</h2><center> <table width='800' align='center' border='5'> <tr bgcolor='yellow'> <th>No.</th> <th>Full Name</th> <th>Matrix No.</th> <th>Username</th> <th>Password</th> <th>User Type</th> <th>Edit User</th> <th>Delete User</th> </tr> <?php mysql_connect("localhost","root",""); mysql_select_db("class_attendance"); $query = "select * from user"; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $id = $row[0]; $full_name = $row[1]; $matrix_no = $row[2]; $username = $row[3]; $pass = $row[4]; $type = $row[5]; ?> <tr align='center'> <td><?php echo $id; ?></td> <td><?php echo $full_name; ?></td> <td><?php echo $matrix_no; ?></td> <td><?php echo $username; ?></td> <td><?php echo $pass; ?></td> <td><?php echo $type; ?></td> <a href="edit.php?user_id=<?= $id ?>">Edit</a> <td><a href='delete.php?del=<?php echo $id;?>'>Delete</a></td> </tr> <?php } ?> </table> </body> </html> edit.php <?php session_start(); require_once('function.php'); //Set this to what ever page you include that holds all your functions so that we can use the checkUserStatus() checkUserStatus('admin'); ?> <html> <head> <title> Student/Lecturer Course Form </title> </head> <body> <h2 align='right'><a href='admin.php'>Home</a></h2> <?php mysql_connect("localhost","root",""); mysql_select_db("class_attendance"); $courses = $subjects = array(); $sql = "SELECT * FROM course"; $res = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_assoc($res)) { $courses[] = $row; } $sql = "SELECT * FROM subject"; $res = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_assoc($res)) { $subjects[] = $row; } ?> <form method='post' action='edit.php'> <table width='400' border='5' align='center'> <tr> <td align='center' colspan='5'><h1>Student/Lecturer Course Form</h1></td> </tr> <tr> <td> <select name="course"> <?php foreach($courses as $course) : ?> <option value="<?= $course['course_id'] ?>"> <?= $course['name'] ?> </option> <?php endforeach ?> </select> </td> </tr> <tr> <td> <select name="subject"> <?php foreach($subjects as $subject) : ?> <option value="<?= $subject['subject_id'] ?>"> <?= $subject['name'] ?> </option> <?php endforeach ?> </select> </td> </tr> <input type="hidden" name="user_id" value="<?= $_GET['user_id'] ?>"> <tr> <td colspan='5' align='center'><input type='submit' name='submit' value='Submit' /></td> </tr> </table> </form> </body> </html> <?php mysql_connect("localhost","root",""); mysql_select_db("class_attendance"); if (isset($_POST['submit'])) { print_r( $_POST ); // check all submitted data & make sure we get course_id, subject_id and user_id } ?> and this is my error..
  4. r1nk
    Ok i tried to sketch the coding a little bit.. and this is what i got so far.. <?php session_start(); require_once('function.php'); //Set this to what ever page you include that holds all your functions so that we can use the checkUserStatus() checkUserStatus('admin'); ?> <html> <head> <title> Student/Lecturer Course Form </title> </head> <body> <h2 align='right'><a href='admin.php'>Home</a></h2> <form method='post' action='edit.php'> <table width='400' border='5' align='center'> <tr> <td align='center' colspan='5'><h1>Student/Lecturer Course Form</h1></td> </tr> <tr> <td align='center'> <select name="course_id" id="course_id"> <option value="0 selected="selected">Select course</option> <option value=""></option> <option value=""></option> </select></td> </tr> <tr> <td colspan='5' align='center'><input type='submit' name='submit' value='Submit' /></td> </tr> </table> </form> </body> </html> <?php mysql_connect("localhost","root",""); mysql_select_db("class_attendance"); if(isset($_POST['submit'])){ $course_id= $_POST['course_id']; if($course_id==''){ echo "<script>alert('The Course Name is empty!')</script>"; exit(); } $check_name= "select * from user_course where course_id='$course_id'"; $run = mysql_query($check_name); if(mysql_num_rows($run)>0){ echo "<script>alert('The Course Name $course_id already been filled! Please fill another one.')</script>"; exit(); } $query = "insert into user_course (course_id) values ('$course_id')"; if(mysql_query($query)){ echo"<script>alert('Registration successful!')</script>"; } } ?> As you can see, i dont know how to view the clicked user_id to the edit.php and fill the dropdown options with courses that have been added in the course table..
  5. r1nk
    Thanx for replying.. Yeah, i already updated my user table to one and this new thread is my new problem.. http://forums.phpfreaks.com/topic/282348-view-name-based-on-user-id-and-stored-coursesubject-option-to-respective-tables/
  6. r1nk
    Right now these are my tables.. i have create a page that list all the users and there is an edit button.. My question is when i click the edit button, how to view the name of the user and a select box option where the options are my course and subject that been stored? Then, when i fill the course and subject from the select box, it will stored to user_subject and user_course table.. <?php session_start(); require_once('function.php'); //Set this to what ever page you include that holds all your functions so that we can use the checkUserStatus() checkUserStatus('admin'); ?> <html> <head> <title> View Users </title> </head> <body> <h2 align='right'><a href='admin.php'>Home</a></h2> <center><h2>Users Information</h2><center> <table width='800' align='center' border='5'> <tr bgcolor='yellow'> <th>No.</th> <th>Full Name</th> <th>Matrix No.</th> <th>Username</th> <th>Password</th> <th>User Type</th> <th>Edit User</th> <th>Delete User</th> </tr> <?php mysql_connect("localhost","root",""); mysql_select_db("class_attendance"); $query = "select * from user"; $run = mysql_query($query); while ($row=mysql_fetch_array($run)){ $id = $row[0]; $full_name = $row[1]; $matrix_no = $row[2]; $username = $row[3]; $pass = $row[4]; $type = $row[5]; ?> <tr align='center'> <td><?php echo $id; ?></td> <td><?php echo $full_name; ?></td> <td><?php echo $matrix_no; ?></td> <td><?php echo $username; ?></td> <td><?php echo $pass; ?></td> <td><?php echo $type; ?></td> <td><a href='edit.php?del=<?php echo $id;?>'>Edit</a></td> <td><a href='delete.php?del=<?php echo $id;?>'>Delete</a></td> </tr> <?php } ?> </table> </body> </html>
  7. r1nk
    hmmm.. bump.
  8. r1nk
    Im now making a simple project called student attendance.. I've just managed the register/login part.. Right now, these are the tables that i created so far.. http://i272.photobucket.com/albums/jj178/r1nk_2008/1_zpsf1765f1c.png http://i272.photobucket.com/albums/jj178/r1nk_2008/2_zpsa1a1310a.png http://i272.photobucket.com/albums/jj178/r1nk_2008/3_zps092b7ff1.png http://i272.photobucket.com/albums/jj178/r1nk_2008/4_zps1fffbc49.png What i need right now is some advice on how :- The lecturer can select the course_id that have been assigned and then list of subject he/she teach will appear.. Based on what subject he/she clicked, an attendance table appear with list of students in that class and week 1- week XX (checkbox for attendance).. Do i need to assign some primary and foreign key in my tables or adding some more necessary tables?
  9. r1nk
    haha no problem.. thanx it works.. =) Finally can move on to the next part.. but one thing that have been bugging me right now.. so i have a table called users (id, name, username, pass, type) right.. lets say in the student page, he/she can view his/her birthday, own cgpa and email.. so i must create another table right.. Now my question is, is it possible when the admin register a student in the database and the username and pass of the students will be add both in the users table and the new created table..?
  10. r1nk
    owh ok the <?php ?> was missing in the function.php .. i already fixed that and when i tried to login, its just going back to the login page instead of the admin page.. why?
  11. r1nk
    thanx for replying.. already fixed my login.php.. and now i got this error.. http://i272.photobucket.com/albums/jj178/r1nk_2008/newerror_zpsce7fad20.png
  12. r1nk
    sorry for late replying.. Got busy with tests.. Ok for the 1st part, i dun get what this means.. header('Location: '.$page); //You may need to edit the path to suit your folder structure. and also for the third part i dont know where to put it in.. So right now these are what i got so far.. function.php function checkUserType($type) { switch($type) { case 'admin': $page = 'admin_page.php'; break; case 'student': $page = 'student.php'; break; case 'lecturer': $page = 'lecturer.php'; break; case 'parents': $page = 'parents.php'; break; } header('Location: '.$page); //You may need to edit the path to suit your folder structure. } function checkUserStatus($actual_page) { //First check to make sure the $_SESSION['type'] is set, if it's not then they haven't logged in so redirect back to login screen if(!isset($_SESSION['type'])) { header('Location: login.php'); } else { if($actual_page == $_SESSION['type']){} else{ checkUserType($_SESSION['type']); } } } login.php <html> <head> <title> Login Form </title> </head> <body> <div style="width: 200px; margin: 200px auto 0 auto;"> <form method='post' action='login.php'> <table width='400' border='5' align='center'> <tr> <td align='center' colspan='5'><h1>Member Login</h1></td> </tr> <tr> <td align='center'>Username:</td> <td><input type='text' name='username' /></td> </tr> <tr> <td align='center'>Password:</td> <td><input type='password' name='pass' /></td> </tr> <tr> <td colspan='5' align='center'><input type='submit' name='login' value='Log In' /></td> </tr> </table> </form> </body> </html> <?php mysql_connect("localhost","root",""); mysql_select_db("student_attendance"); if(isset($_POST['login'])){ $username = $_POST['username']; $password = $_POST['pass']; $check_user = "select * from users where username='$username' AND pass='$password'"; $run = mysql_query($check_user); if(mysql_num_rows($run)>0){ echo "<script>window.open('function.php;','_self')</script>"; } else { echo "<script>alert('Username or password is incorrect!')</script>"; } } ?> admin_page.php <?php session_start(); require_once('function.php'); //Set this to what ever page you include that holds all your functions so that we can use the checkUserStatus() checkUserStatus('admin'); ?> <!DOCTYPE html> <html> <head> <title> Admin Page </title> </head> <body> <h2 align='right'><a href='logout.php'>Logout</a></h2> <h2 align='right'><a href='registration.php'>Register User</a></h2> <h2 align='right'><a href='view_users.php'>Delete User</a></h2> </body> </html>
  13. r1nk
    =,=... help me to view the page..
  14. r1nk
    Hey, anyone can run this script perfectly.. I tried to run it using wampp but failed. http://code.google.com/p/student-council-attendance/
  15. r1nk
    owh, ok.. thanx i got the concept.. but how to redirect the next page based on the user_type..? "At the top of your admin, student, etc pages you put a if() to check if the user_type is correct for that page and redirect if not." I dun get what u mean by this..
  16. r1nk
    Well, i dun think a student could login to the admin page as in the users table, the user_type already been set to "student".. He/she will get an error when login although the username and pass is correct but the user type is wrong. Right now im developing a student attendance project and im planning to make that when the admin log in, the next page that comes out is special for admin only where he can add/delete other users.. that goes the same with parents where the page is to view his/her children attendance.. Hmmmm.. help me if u got other easy solution..
  17. r1nk
    so what are you suggesting? i want to make that when a user login, he/she will be redirected to a page based on the user type..
  18. r1nk
    Guys, need some help.. Right now i have a login page with select box option.. I have create several other page (admin_page.php, student_page.php, parents_page.php) to link with the option in the select box.. So what im asking now is how to link the selected option to their page respectively with the username and pass correct? Here is the login page looks like.. http://i272.photobucket.com/albums/jj178/r1nk_2008/lol_zpsa54db359.png <html> <head> <title> Login Form </title> </head> <body> <div style="width: 200px; margin: 200px auto 0 auto;"> <form method='post' action='login.php'> <table width='400' border='5' align='center'> <tr> <td align='center' colspan='5'><h1>Member Login</h1></td> </tr> <tr> <td align='center'>Username:</td> <td><input type='text' name='username' /></td> </tr> <tr> <td align='center'>Password:</td> <td><input type='password' name='pass' /></td> </tr> <tr> <td></td> <td align='left'> <select name="type" id="type"> <option value="0" selected="selected">Select user type</option> <option value="admin">Admin</option> <option value="student">Student</option> <option value="lecturer">Lecturer</option> <option value="parents">Parents</option> </select> </td> </tr> <tr> <td colspan='5' align='center'><input type='submit' name='login' value='Log In' /></td> </tr> </table> </form> </body> </html> <?php mysql_connect("localhost","root",""); mysql_select_db("student_attendance"); if(isset($_POST['login'])){ $username = $_POST['username']; $password = $_POST['pass']; $type = $_POST['type']; $check_user = "select * from users where username='$username' AND pass='$password' AND type='$type'"; $run = mysql_query($check_user); if(mysql_num_rows($run)>0){ echo "<script>window.open('admin_page.php','_self')</script>"; } else { echo "<script>alert('Username, password or user type is incorrect!')</script>"; } } ?>
  19. r1nk
    Thanks.. Appreciate your help..
  20. r1nk
    Thanx.. i changed to "AND" and it works.. But i dun use the 2nd command.. Mine explaining me what its function for? And one more thing, how to make the select box option to the right side, below the password form ?
  21. r1nk
    thanx.. fixed that already.. now only 1 error left.. Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\wamp\www\student_attendance\login.php on line 57
  22. r1nk
    Hey, i got another question. Ok so far i have a table called users (id, name, username, pass, type) and here is my coding so far.. <html> <head> <title> Login Form </title> </head> <body> <form method='post' action='login.php'> <table width='400' border='5' align='center'> <tr> <td align='center' colspan='5'><h1>Login Form</h1></td> </tr> <tr> <td align='center'>Username:</td> <td><input type='text' name='username' /></td> </tr> <tr> <td align='center'>Password:</td> <td><input type='password' name='pass' /></td> </tr> <tr> <td align='center'> <select name="type" id="type"> <option value="0 selected="selected">Select user type</option> <option value="admin">Admin</option> <option value="student">Student</option> </select> </tr> <tr> <td colspan='5' align='center'><input type='submit' name='login' value='Log In' /></td> </tr> </table> </form> </body> </html> <?php mysql_connect("localhost","root",""); mysql_select_db("student_attendance"); if(isset($_POST['login'])){ $username = $_POST['username']; $password = $_POST['pass']; $type = $_POST['type']; $check_user = "select * from users where username='$username', pass='$password' AND type='$type'"; $run = mysql_query($check_user); if(mysql_num_rows($run)>0){ echo "<script>alert('You are logged in')</script>"; } else { echo "<script>alert('username,password or user type is incorrect!')</script>"; } } ?> And when i viewed it looks like this.. http://i272.photobucket.com/albums/jj178/r1nk_2008/prob_zpsd907ed84.png So my questions are :- -how to make the select box option to the right side, below the password form ? -how to fix the error so that when i enter correct username, pass and type it says "you are login" ?
  23. r1nk
    yupp.. that's what im planning.. only the admin can register for other type of user including register the course id.. but of course other users can change their password after they logged in.
  24. r1nk
    ok, just to make sure no problem will arise later bcoz of the tables. So, right now these are my initial tables. http://i272.photobucket.com/albums/jj178/r1nk_2008/1_zpsf1765f1c.png http://i272.photobucket.com/albums/jj178/r1nk_2008/2_zpsa1a1310a.png http://i272.photobucket.com/albums/jj178/r1nk_2008/3_zps092b7ff1.png http://i272.photobucket.com/albums/jj178/r1nk_2008/4_zps1fffbc49.png If i delete those 4 users table and create a new one called users ( id, name, username, password, type_of_user), then wouldn't it be a problem later when : - - the admin wanna asign course_id for the added lecturer - the lecturer enter his/her course_id and the whole students in that course can be viewed
  25. r1nk
    owhh so i need to add one more new table with a column of user type.. ok thanks.. now im searching for the coding to add a dropdown user type option in login page.. gonna ask u if i cant find..hehe
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.