Snooble Posted January 29, 2007 Share Posted January 29, 2007 Hello, I'm a beginner with all web coding. My task is to create a log in system. This is my assumption.use db connect to connect to mysql database. have an if statement at the start of each page. (If user logged in then allow to see page, else login.php)select "views etc." from "table" where "username" "password"Sorry, but this is just a few things i've gathered from looking at this forum. Would this be the way to go. When i say views etc. i assume they'll be set variables.My main question is:How do i save a variable, e.g. Credits. To a DB and then echo that out per individual user. Would it involve select credits from table where "username" "password"Also, in the register file how would i take the username and password variable and place it into the database. I know how to carry a variable from page to page to page in hidden fields. But i'd like to get a login system sorted.Sorry if this is hard to understand. But it's my dotted mind at the moment.Snooble Quote Link to comment https://forums.phpfreaks.com/topic/36119-solved-login-query/ Share on other sites More sharing options...
pocobueno1388 Posted January 29, 2007 Share Posted January 29, 2007 <a href="http://www.tutorialized.com/tutorial/PHP-Simple-login-script/9963">Tutorial.</a> Quote Link to comment https://forums.phpfreaks.com/topic/36119-solved-login-query/#findComment-171510 Share on other sites More sharing options...
Snooble Posted January 29, 2007 Author Share Posted January 29, 2007 thank you. i did look before. Also, how would i view the mysql table. Would it be possible? Could i see how many points each user had?Snooble Quote Link to comment https://forums.phpfreaks.com/topic/36119-solved-login-query/#findComment-171512 Share on other sites More sharing options...
pocobueno1388 Posted January 29, 2007 Share Posted January 29, 2007 You use phpmyadmin (in most cases) to view your tables and the information in them. You need to go to your hosts control panel and they will usually have a link to get to it from there. Quote Link to comment https://forums.phpfreaks.com/topic/36119-solved-login-query/#findComment-171514 Share on other sites More sharing options...
Snooble Posted January 29, 2007 Author Share Posted January 29, 2007 yeah i've used phpmyadmin before. Thanks, Snooble Quote Link to comment https://forums.phpfreaks.com/topic/36119-solved-login-query/#findComment-171522 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.