Login Page in PHP with Database Source Code
Login Page in PHP with Database Source Code is the main focus of this course based on our previous tutorial called “How to Create a Secure Login page using PHP/MySQL“. But this time we will simply modify some of our codes to convert MySQL to MySQLi in Object-Oriented approach. If you don’t have any idea about MySQLi, you can visit and start your basic understanding here for more examples and demonstrations.
Let’s Start Coding the Projects
To do this, open the root folder called “logintuts” and using any text editor open the file named “connect.php”. Then replace all the codes by the following code:
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "studentdb";
// Create connection
$conn = new mysqli($server, $username, $password, $database);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
Continuation Coding the “processlogin.php” file
Next, we will modify the “processlogin.php” file and here’s the modified code:
<?php
require('connect.php');
require('session.php');
if (isset($_POST['btnlogin'])) {
$email = trim($_POST['email']);
$upass = trim($_POST['password']);
$h_upass = sha1($upass);
if ($upass == ''){
?> <script type="text/javascript">
alert("Password is missing!");
window.location = "login.php";
</script>
<?php
}else{
//create some sql statement
$sql = "SELECT * FROM `tblmember` WHERE `email` = '" . $email . "' AND `password` = '" . $h_upass . "'";
$result = $conn->query($sql);
if ($result){
//get the number of results based n the sql statement
//check the number of result, if equal to one
//IF theres a result
if ( $result->num_rows > 0) {
//store the result to a array and passed to variable found_user
$found_user = mysqli_fetch_array($result);
//fill the result to session variable
$_SESSION['MEMBER_ID'] = $found_user['id'];
$_SESSION['FIRST_NAME'] = $found_user['fName'];
$_SESSION['LAST_NAME'] = $found_user['lName'];
?> <script type="text/javascript">
//then it will be redirected to index.php
window.location = "index.php";
</script>
<?php
} else {
//IF theres no result
?> <script type="text/javascript">
alert("Username or Password Not Registered! Contact Your administrator.");
window.location = "index.php";
</script>
<?php
}
} else {
# code...
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
}
$conn->close();
?>
After modifying these PHP files, you can now test it on your browser.
Related Topics:
- How to Create a Registration Page Using a Twitter Bootstrap Framework
- Saving Data from Registration Form into MySQL Database using PHP/MySQL
-
MySQL Insert, Multiple Insert, and Last Inserted Query in PHP
Login Page in PHP with Database Source Code Download here: +|====>>logintutsmyqli01
If you have any questions or suggestions about this material on how to create a login page like facebook. please feel free to contact us or simply leave a comment below.
Readers might read also:
It’s really a great and helpful piece of info. I’m glad that you just shared this helpful info with us. Please keep us up to date like this. Thanks for sharing.
Very shortly this site will be famous among all blog visitors, due to it’s fastidious posts
Hi, its good article about media print, we all be aware of media is a wonderful source of data.
I savor, lead to I found just what I was having a look for. You’ve ended my 4 day lengthy hunt! God Bless you man. Have a great day. Bye
We are a bunch of volunteers and opening a new scheme in our community. Your site provided us with valuable information to work on. You’ve done a formidable task and our whole community will likely be thankful to you.
With havin so much written content do you ever run into any problems of plagorism or copyright violation? My blog has a lot of exclusive content I’ve either written myself or outsourced but it looks like a lot of it is popping it up all over the internet without my agreement. Do you know any methods to help reduce content from being ripped off? I’d certainly appreciate it.
I was recommended this blog by my cousin. I am no longer sure whether or not this submit is written by way of him as no one else recognize such special approximately my difficulty. You’re wonderful! Thanks!
Aw, this was an extremely nice post. Spending some time and actual effort to produce a very good article… but what can I say… I put things off a lot and don’t manage to get nearly anything done.
I’m really enjoying the theme/design of your website. Do you ever run into any internet browser compatibility issues? A number of my blog audience have complained about my site not working correctly in Explorer but looks great in Firefox. Do you have any suggestions to help fix this problem?
I’ll right away grasp your rss feed as I can’t to find your email subscription link or newsletter service. Do you’ve any? Kindly let me know in order that I may just subscribe. Thanks.
You could certainly see your skills in the work you write. The world hopes for more passionate writers like you who are not afraid to say how they believe. At all times follow your heart.
Genuinely when someone doesn’t understand afterward its up to other visitors that they will assist, so here it happens.
This web site truly has all of the information and facts I needed about this subject and didn’t know who to ask.
Thank you a bunch for sharing this with all of us you really understand what you’re speaking about! Bookmarked. Kindly also talk over with my site =). We will have a hyperlink alternate arrangement between us
This is a great tip especially to those fresh to the blogosphere. Short but very accurate information… Thanks for sharing this one. A must read article!
My brother recommended I might like this website. He was totally right. This post actually made my day. You cann’t imagine just how much time I had spent for this info! Thanks!
Why viewers still use to read news papers when in this technological world all is available on web?
Hmm it looks like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog writer but I’m still new to the whole thing. Do you have any points for newbie blog writers? I’d certainly appreciate it.
Thank you a bunch for sharing this with all folks you really know what you are talking approximately! Bookmarked. Kindly additionally visit my website =). We may have a link trade contract among us
I was able to find good information from your blog articles.
I like the helpful info you provide in your articles. I will bookmark your weblog and check again here frequently. I am quite sure I will learn many new stuff right here! Best of luck for the next!
Hello to every one, the contents present at this web page are truly remarkable for people experience, well, keep up the nice work fellows.
When someone writes an piece of writing he/she maintains the image of a user in his/her brain that how a user can understand it. Thus that’s why this paragraph is amazing. Thanks!
This is very interesting, You’re a very skilled blogger. I’ve joined your rss feed and look forward to seeking more of your great post. Also, I have shared your site in my social networks!
Your style is really unique compared to other folks I’ve read stuff from. Thanks for posting when you have the opportunity, Guess I will just book mark this web site.
If some one needs expert view regarding blogging afterward i propose him/her to pay a quick visit this web site, Keep up the nice work.
I was suggested this blog by my cousin. I’m not sure whether this post is written by him as no one else know such detailed about my trouble. You are incredible! Thanks!
It’s very simple to find out any matter on web as compared to textbooks, as I found this post at this web page.
Thanks on your marvelous posting! I certainly enjoyed reading it, you will be a great author. I will make certain to bookmark your blog and will often come back sometime soon. I want to encourage that you continue your great work, have a nice weekend!
This article is truly a fastidious one it assists new internet users, who are wishing in favor of blogging.
Hi there! I could have sworn I’ve visited your blog before but after going through a few of the articles I realized it’s new to me. Anyways, I’m definitely happy I stumbled upon it and I’ll be book-marking it and checking back frequently!
I could not refrain from commenting. Well written!
I could not resist commenting. Well written!
Oh my goodness! Incredible article dude! Thank you so much, However I am experiencing issues with your RSS. I don’t understand the reason why I am unable to join it. Is there anybody getting identical RSS problems? Anyone that knows the solution will you kindly respond? Thanks!!
Your style is so unique compared to other folks I’ve read stuff from. Thanks for posting when you have the opportunity, Guess I will just bookmark this site.
Wow, awesome blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is magnificent, let alone the content!
This is a very good tip particularly to those new to the blogosphere. Short but very accurate information… Appreciate your sharing this one. A must read post!
I got this website from my pal who informed me regarding this web site and now this time I am browsing this site and reading very informative content here.
Great beat ! I wish to apprentice while you amend your website, how could i subscribe for a weblog web site? The account aided me a appropriate deal. I had been a little bit familiar of this your broadcast offered vivid transparent concept
My family members all the time say that I am killing my time here at net, except I know I am getting know-how everyday by reading thes fastidious articles.
Aw, this was an incredibly good post. Spending some time and actual effort to produce a great article… but what can I say… I procrastinate a lot and don’t seem to get anything done.
Magnificent beat ! I wish to apprentice while you amend your site, how can i subscribe for a blog site? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright clear idea
I am truly pleased to glance at this blog posts which includes lots of useful facts, thanks for providing these kinds of information.
Admiring the time and effort you put into your site and detailed information you present. It’s great to come across a blog every once in a while that isn’t the same unwanted rehashed material. Wonderful read! I’ve saved your site and I’m including your RSS feeds to my Google account.
I am regular reader, how are you everybody? This post posted at this site is really nice.
If some one desires expert view regarding running a blog afterward i suggest him/her to visit this web site, Keep up the nice work.
Very nice article, just what I needed.
Hello there! I could have sworn I’ve been to this site before but after reading through some of the post I realized it’s new to me. Anyhow, I’m definitely glad I found it and I’ll be bookmarking and checking back frequently!
I have been surfing online more than 3 hours as of late, but I by no means discovered any attention-grabbing article like yours. It is lovely worth enough for me. Personally, if all website owners and bloggers made just right content material as you probably did, the web might be much more useful than ever before.
At this time it seems like WordPress is the preferred blogging platform out there right now. (from what I’ve read) Is that what you are using on your blog?
Hello i am kavin, its my first occasion to commenting anyplace, when i read this paragraph i thought i could also make comment due to this good post.
Hey! Would you mind if I share your blog with my zynga group? There’s a lot of people that I think would really appreciate your content. Please let me know. Thank you
sure no problem.
Excellent way of describing, and fastidious article to get facts concerning my presentation focus, which i am going to present in institution of higher education.
Very nice post. I simply stumbled upon your blog and wanted to mention that I’ve really enjoyed surfing around your blog posts. After all I will be subscribing for your rss feed and I am hoping you write again soon!
You can definitely see your expertise in the work you write. The sector hopes for even more passionate writers such as you who aren’t afraid to mention how they believe. At all times follow your heart.
I take pleasure in, cause I found exactly what I used to be looking for. You’ve ended my four day long hunt! God Bless you man. Have a nice day. Bye
I don’t even know how I stopped up here, but I assumed this submit was great. I don’t understand who you might be however certainly you are going to a famous blogger should you aren’t already. Cheers!
If some one desires to be updated with newest technologies then he must be visit this site and be up to date every day.
Greetings from Colorado! I’m bored to tears at work so I decided to check out your site on my iphone during lunch break. I really like the info you provide here and can’t wait to take a look when I get home. I’m amazed at how fast your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyways, wonderful site!
That is very interesting, You’re an excessively professional blogger. I’ve joined your rss feed and look forward to in search of more of your magnificent post. Also, I’ve shared your site in my social networks
Thanks! Please keep in touch!
What i don’t realize is in truth how you’re now not actually a lot more smartly-liked than you might be right now. You’re so intelligent. You realize thus considerably with regards to this matter, made me personally consider it from a lot of various angles. Its like men and women are not interested unless it is something to do with Woman gaga! Your personal stuffs great. All the time handle it up!
Excellent way of explaining, and nice post to take data regarding my presentation subject, which i am going to convey in school.
Hello There. I discovered your weblog the usage of msn. This is a very well written article. I will make sure to bookmark it and come back to learn extra of your helpful information. Thanks for the post. I’ll certainly comeback.
Can I just say what a relief to discover somebody who really knows what they’re talking about online. You definitely understand how to bring an issue to light and make it important. More people ought to check this out and understand this side of your story. I can’t believe you are not more popular because you surely have the gift.
Attractive element of content. I simply stumbled upon your blog and in accession capital to say that I acquire in fact enjoyed account your weblog posts. Any way I will be subscribing for your augment and even I fulfillment you get entry to consistently fast.
Hi Dear, are you genuinely visiting this website regularly, if so then you will absolutely obtain pleasant know-how.
I like this website. it is very very helpful. Thanks for sharing.
wonderful points altogether, you just gained a new reader. What may you recommend in regards to your submit that you just made a few days ago? Any sure?
Thanks for finally talking about >How to Create a Secure Login Page using PHP/MySQL <Loved it!
If you are going for finest contents like me, just go to see this web page daily since it presents feature contents, thanks
Attractive component of content. I just stumbled upon your site and in accession capital to claim that I acquire in fact loved account your blog posts. Any way I will be subscribing on your feeds or even I fulfillment you get right of entry to constantly rapidly.
Everyone loves what you guys are up too. This sort of clever work and reporting! Keep up the good works guys I’ve incorporated you guys to blogroll.
Hi, yup this article is in fact nice and I have learned lot of things from it concerning blogging. thanks.
I was recommended this website by way of my cousin. I’m now not certain whether or not this post is written by means of him as no one else recognize such targeted approximately my difficulty. You’re wonderful! Thank you!
Generally I don’t read article on blogs, however I wish to say that this write-up very forced me to take a look at and do it! Your writing taste has been surprised me. Thank you, very nice article.
Wonderful article! We are linking to this particularly great article on our site. Keep up the good writing.
Oh my goodness! Incredible article dude! Thanks, However I am having troubles with your RSS. I don’t know why I am unable to subscribe to it. Is there anybody having similar RSS problems? Anyone that knows the answer will you kindly respond? Thanks!!
Hello, I think your website might be having browser compatibility issues. When I look at your website in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog!
Good day! I could have sworn I’ve visited your blog before but after going through a few of the articles I realized it’s new to me. Anyhow, I’m definitely pleased I discovered it and I’ll be book-marking it and checking back regularly!
Hello, i believe that i saw you visited my web site so i came to go back the choose?.I’m trying to in finding things to improve my web site!I suppose its adequate to make use of some of your ideas!!
Link exchange is nothing else except it is just placing the other person’s blog link on your page at appropriate place and other person will also do similar for you.
I am really enjoying the theme/design of your site. Do you ever run into any browser compatibility problems? A couple of my blog visitors have complained about my blog not operating correctly in Explorer but looks great in Opera. Do you have any recommendations to help fix this issue?
Unquestionably consider that that you stated. Your favorite reason seemed to be at the web the simplest factor to have in mind of. I say to you, I definitely get annoyed even as folks consider worries that they plainly don’t recognise about. You controlled to hit the nail upon the highest as well as outlined out the entire thing with no need side effect , folks can take a signal. Will probably be again to get more. Thank you
Thanks for the marvelous posting! I genuinely enjoyed reading it, you might be a great author.I will be sure to bookmark your blog and may come back later on. I want to encourage continue your great writing, have a nice holiday weekend!
I do trust all of the ideas you’ve offered to your post. They’re really convincing and will certainly work. Still, the posts are too short for beginners. May you please lengthen them a bit from next time? Thank you for the post.
Thanks for some other great article. The place else could anyone get that type of information in such a perfect means of writing? I’ve a presentation subsequent week, and I’m at the look for such info.
Thanks for another magnificent post. Where else may just anybody get that type of info in such a perfect way of writing? I have a presentation subsequent week, and I’m at the look for such information.
If you are going for best contents like myself, just visit this website every day because it presents feature contents, thanks
Excellent, what a web site it is! This webpage gives valuable facts to us, keep it up.
Thank you, I’ve recently been looking for info about this subject for a long time and yours is the greatest I’ve came upon till now. But, what about the bottom line? Are you certain concerning the source?
Thanks , I’ve just been looking for information approximately this subject for a long time and yours is the greatest I have discovered so far. But, what concerning the bottom line? Are you positive in regards to the supply?
Article writing is also a excitement, if you be familiar with afterward you can write or else it is complicated to write.
This paragraph provides clear idea in support of the new visitors of blogging, that in fact how to do blogging.
I think the admin of this web site is truly working hard in support of his web page, because here every material is quality based material.
Fantastic web site. Lots of useful info here. I’m sending it to a few pals ans also sharing in delicious. And naturally, thank you in your effort!
Hurrah! Finally I got a weblog from where I can truly get useful facts concerning my study and knowledge.
I’ll immediately clutch your rss feed as I can’t find your email subscription hyperlink or e-newsletter service. Do you’ve any? Please let me realize in order that I may subscribe. Thanks.
Hello, its nice paragraph about media print, we all understand media is a enormous source of facts.
What’s up friends, its fantastic article on the topic of teachingand completely explained, keep it up all the time.
This excellent website definitely has all of the information and facts I wanted concerning this subject and didn’t know who to ask.
Attractive element of content. I just stumbled upon your web site and in accession capital to say that I acquire in fact loved account your weblog posts. Any way I will be subscribing in your feeds and even I achievement you get right of entry to consistently quickly.
At this time I am going to do my breakfast, when having my breakfast coming over again to read other news.
When I initially left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and now each time a comment is added I get 4 emails with the exact same comment. Is there a way you are able to remove me from that service? Many thanks!
great points altogether, you simply gained a new reader. What may you suggest in regards to your submit that you made a few days in the past? Any sure?
I am actually grateful to the owner of this website who has shared this great article at at this time.
Asking questions are actually pleasant thing if you are not understanding anything entirely, however this paragraph offers pleasant understanding yet.
Greate article. Keep writing such kind of information on your blog. Im really impressed by your blog.
Hey there, You have performed an excellent job. I’ll certainly digg it and in my view recommend to my friends. I’m sure they will be benefited from this site.
What’s up to every one, for the reason that I am truly keen of reading this webpage’s post to be updated regularly. It includes pleasant stuff.
Heya i’m for the first time here. I came across this board and I to find It really useful & it helped me out much. I hope to present one thing back and help others such as you aided me.
Remarkable! Its actually amazing paragraph, I have got much clear idea regarding from this piece of writing.
Thanks for finally writing about >How to Create a login page using PHP/MySQLi(Object-Oriented) <Liked it!
This post will assist the internet visitors for creating new website or even a weblog from start to end.
For most recent news you have to go to see world wide web and on web I found this website as a most excellent site for most recent updates.
After looking into a number of the articles on your blog, I honestly like your technique of blogging. I saved it to my bookmark website list and will be checking back soon. Take a look at my website as well and tell me your opinion.
It’s really a cool and useful piece of information. I’m happy that you simply shared this helpful info with us. Please keep us informed like this. Thanks for sharing.
Los medicos trataban a las mujeres con este genero de enfermedades a traves del estimulo manual mas el proceso resultaba agotador, sin embargo, con la aparicion de las maquinas complejas a lo largo de la revolucion industrial, la innovacion llego a todas y cada una de las disciplinas incluyendo la salud sexual.
Excellent beat ! I wish to apprentice at the same time as you amend your web site, how can i subscribe for a weblog web site? The account helped me a applicable deal. I were tiny bit familiar of this your broadcast provided vibrant clear idea
I’ve been exploring for a bit for any high-quality articles or weblog posts in this kind of house . Exploring in Yahoo I finally stumbled upon this site. Reading this information So i’m happy to show that I have an incredibly just right uncanny feeling I discovered exactly what I needed. I most indubitably will make sure to don?t disregard this web site and give it a look regularly.
No matter if some one searches for his required thing, so he/she desires to be available that in detail, so that thing is maintained over here.
Belen E. compartia plano con J. J. V. para imitar a la mujer de Jesulin de Ubrique.
Los vibradores electricos tuvieron mucho apogeo hace años, debido a sus prestaciones, pero hoy dia se han visto igualados en calidad a los de bateria.
Generar tu energia ya es una realidad como sacada de la ciencia ficcion y es posible con un tanto de esfuerzo.
Hi there! Do you know if they make any plugins to help with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thank you!
Hi there to all, the contents present at this web page are actually amazing for people knowledge, well, keep up the nice work fellows.
Por otro lado, en la ribera, encontramos diferentes casas señoriales de principios del siglo veinte, la visita de las cuales nos conduce enseguida cara el puente de M. Cristina, que es el mas monumental de los que cruzan el rio.
En funcion de la fuerza, posicionamiento y salud” de cada dominio, asi como la pericia y conocimiento de tu webmaster.
Cuenta la historia de leyenda que el oro de St Katharinen fue parte del botin del pirata Klaus Stortebecker.
A fin de que sus pececillos se sientan mimados, por 35 euros vas a tener un regalo original para sus mascotitas.
Good, solid content. I just now sent this on 5/23/2019 to a colleague who’s been doing a little research of their own on the topic. To show their appreciation, he just bought me a drink! So, I should probably say: Cheers for the drink!
To reach the number of users who visit our site every day looking for information on digital marketing, digitalizedpedia provided text authors with a section where they could click “write for us marketing”.
Thanks for sharing helpful information…
We’re looking for writers who are passionate about CBD and eager to share their knowledge with others.