# MySQL user authentication question

**URL:** https://forum.kirupa.com/t/mysql-user-authentication-question/232944
**Category:** programming
**Created:** [July 18, 2007, 9:46pm UTC](https://forum.kirupa.com/t/mysql-user-authentication-question/232944 "2007-07-18T21:46:51Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Lolit](https://avatars.discourse-cdn.com/v4/letter/l/8edcca/32.png) [@Lolit](https://forum.kirupa.com/u/Lolit)
#### Post date: [July 18, 2007, 9:46pm UTC](https://forum.kirupa.com/t/mysql-user-authentication-question/232944/1 "2007-07-18T21:46:51Z")

</div>

Hello guys,  
I don’t have a lot of experience with PHP and MYSQL. I need some help with my school project. Can you just give me a hint how should i start it!  
I have the following task. I have to create a sample university website, where the students should be able to register and log in and then access the campus information and bulletin after they log in, which shouldn’t be visible before student authentication.  
It has to be done with PHP and MySQL. So, my idea is to create a table in my database Campus  
user\_id, username, password, first\_name, last\_name, registration\_date, active (to activate account after confirmation)  
And then my problem is how to allocate the bulletin file and the campus information only for the logged in users? How do i place these files in my site directories or at the database, so that they will be visible only after the user logs in? Do i have to create another table for the campus\_info.html and bulletin.html?  
Any help will be deeply appreciated!  
Thanks!