We have created a login page of the admin panel, connected with the database, or whose information to log in to the page is already stored in our database.
Step 1: Creating the Database Table
//Table structure for tableloginCREATE TABLElogin(idint(11) NOT NULL,usernamevarchar(255) NOT NULL,passwordvarchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Login page database Structure shows the database.
You insert one record in the database.
Step 2: Creating the Config File
Let’s create a file named “connect.php” and put the following code inside it.
$connection = new mysqli("localhost","User Name","","Database Name");
// Check connection
if ($connection -> connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
exit();
}
Step 3: Creating the login File
Let’s create a file named “login.php” and put the following code inside it.
PHP CODE
<?php
session_start();
require_once('connect.php');
$drp_result = mysqli_query($connection,"SELECT * FROM login WHERE id ='1'");
$row = mysqli_fetch_array($drp_result);
if(isset($_POST) & !empty($_POST)){
$username = $_POST['username'];
$password = md5($_POST['password']);
$sql = "SELECT * FROM `login` WHERE username='$username' AND password='$password'"; $result = mysqli_query($connection, $sql); $count = mysqli_num_rows($result); if($count == 1){ $_SESSION['username'] = $username; }else{ $fmsg = "Invalid Username/Password"; } } if(isset($_SESSION['username'])){ $smsg = "User already logged in"; echo "window.location.href='index.php'; "; exit; } ?>
HTML CODE
<div class="card-body p-0">
<?php if(isset($smsg)){ ?><div class="alert alert-success" role="alert"> <?php echo $smsg; ?> </div><?php } ?>
<?php if(isset($fmsg)){ ?><div class="alert alert-danger" role="alert"> <?php echo $fmsg; ?> </div><?php } ?>
<div class="p-5">
<div class="text-center">
<h1 class="h4 text-gray-900 mb-4">Welcome Back!</h1>
</div>
<form class="user" method="POST">
<div class="form-group">
<input type="text" class="form-control form-control-user" id="username" name="username" aria-describedby="emailHelp" placeholder="User Name">
</div>
<div class="form-group">
<input type="password" class="form-control form-control-user" name="password" id="password" placeholder="Password">
</div>
<div class="form-group form-row mt-3 mb-0">
<button class="btn btn-primary btn-user btn-block" type="submit">Login</button>
</div>
</form>
</div>
</div>Step 4: Creating the index File
Let’s create a file named “index.php” and put the following code inside it.
<h2>Welcome To Admin</h2>The output of the above example (i.e. login form) will look something like this:
After checking out a handful of the blog articles on your site,
I seriously appreciate your technique of writing
a blog. I bookmarked it to my bookmark webpage list and will be checking back soon. Please check out my web site too and let me know how you feel.
Remarkable! Its genuinely awesome post, I have got
much clear idea about from this post.
Hi there, just wanted to say, I loved this blog post. It was inspiring.
Keep on posting!
It’s a shame you don’t have a donate button! I’d definitely donate to this superb blog!
I guess for now i’ll settle for bookmarking and adding your
RSS feed to my Google account. I look forward to new updates and will share this website
with my Facebook group. Chat soon!
Wow, incredible blog layout! How long have you been blogging for?
you make blogging look easy. The overall look of your web site
is magnificent, as well as the content!
Hello, I enjoy reading through your article.
I wanted to write a little comment to support you.
I got this site from my friend who shared with me on the topic of
this web page and at the moment this time I am visiting this website and reading very informative content at
this time.
I’m truly enjoying the design and layout of your site.
It’s a very easy on the eyes which makes it much more pleasant for
me to come here and visit more often. Did you hire out a developer
to create your theme? Great work!
Hello there, You’ve done a great job. I will definitely digg
it and personally recommend to my friends. I’m sure they’ll be
benefited from this web site.
Amazing issues here. I’m very happy to look your post.
Thank you so much and I’m having a look ahead to contact you.
Will you kindly drop me a mail?
Everything is very open with a clear explanation of the challenges.
It was definitely informative. Your site is very helpful.
Thank you for sharing!
Heya i am for the first time here. I found this board and I in finding It truly useful &
it helped me out much. I hope to give one thing
again and help others like you aided me.
I’ve been surfing online more than three hours
today, but I never found any fascinating article like
yours. It is pretty price enough for me. In my opinion,
if all web owners and bloggers made good content material as you probably
did, the net will likely be much more helpful than ever before.
I always used to read article in news papers but now as
I am a user of net thus from now I am using net for content, thanks to web.
Link exchange is nothing else except it is just placing the other person’s website link on your page at suitable place and other person will also do
similar in favor of you.
If you are going for best contents like myself, just visit
this web site everyday as it offers quality contents, thanks
You ought to be a part of a contest for one of the most useful
websites on the net. I am going to highly recommend this blog!
Aw, this was a really nice post. Taking the time and actual effort to produce a very
good article… but what can I say… I hesitate a
lot and never manage to get nearly anything done.
Greetings! I’ve been following your site for some time
now and finally got the courage to go ahead and give you a
shout out from Humble Texas! Just wanted to say keep up the good work!
Hi there, You have done an excellent job.
I will definitely digg it and personally
recommend to my friends. I’m sure they’ll be benefited from this site.
Thank you for sharing your info. I truly appreciate your efforts and
I will be waiting for your next post thanks once again.
It is perfect time to make a few plans for the future and it is time to be happy.
I have learn this post and if I may I wish to counsel you some attention-grabbing issues
or advice. Maybe you can write subsequent articles regarding this article.
I wish to learn more things about it!
First off I would like to say wonderful blog! I had a quick question that I’d like to ask if you do not mind.
I was curious to find out how you center yourself and clear your
mind prior to writing. I have had trouble clearing my thoughts in getting my thoughts out.
I do enjoy writing but it just seems like the first 10 to 15 minutes are usually wasted
just trying to figure out how to begin. Any recommendations or tips?
Thanks!
Hello to every body, it’s my first pay a visit of this website; this blog
consists of remarkable and in fact good information in support of visitors.
Pretty nice post. I just stumbled upon your blog and wanted to
say that I’ve really enjoyed surfing around your blog posts.
After all I will be subscribing to your feed and I hope you write again very soon!
Very shortly this website will be famous among all blogging
people, due to it’s good content
great publish, very informative. I’m wondering why the other specialists of this sector do not
notice this. You should proceed your writing. I’m
confident, you’ve a great readers’ base already!
Awesome! Its actually awesome post, I have got much clear idea on the
topic of from this post.
Thank you for some other informative web site. The place else may I get that kind of information written in such an ideal way?
I have a challenge that I am simply now operating
on, and I have been on the look out for such info.
Hi there to all, the contents existing at
this site are in fact awesome for people knowledge, well, keep up the nice
work fellows.
First off I want to say superb blog! I had a quick question that
I’d like to ask if you don’t mind. I was curious to know how you
center yourself and clear your head before writing.
I have had difficulty clearing my thoughts in getting my ideas
out. I truly do take pleasure in writing however it just seems
like the first 10 to 15 minutes are wasted simply just trying to figure
out how to begin. Any ideas or tips? Kudos!
This website was… how do you say it? Relevant!! Finally
I’ve found something that helped me. Thanks!
This paragraph gives clear idea designed for the new users of blogging, that genuinely how to do running
a blog.
It’s a shame you don’t have a donate button! I’d certainly donate
to this brilliant blog! I guess for now i’ll settle
for bookmarking and adding your RSS feed to my Google account.
I look forward to new updates and will share this site with my Facebook group.
Talk soon!
I truly love your site.. Very nice colors & theme.
Did you build this site yourself? Please reply
back as I’m hoping to create my own personal website
and want to know where you got this from or what the theme is named.
Kudos!
This article gives clear idea in favor of the new users of blogging, that
in fact how to do blogging and site-building.
I always used to read post in news papers but now as I am a
user of internet therefore from now I am using net for content, thanks to
web.
Hi there, I discovered your blog via Google while searching for a comparable subject, your site
came up, it seems to be good. I have bookmarked it in my google bookmarks.
Hello there, simply was alert to your weblog
via Google, and located that it’s really informative. I’m gonna be careful for
brussels. I will appreciate should you proceed this in future.
A lot of other people will be benefited out of your writing.
Cheers!
Hi, I read your blog like every week. Your writing style is
witty, keep doing what you’re doing!
Great article! This is the type of info that are supposed to be shared
around the internet. Shame on Google for now not positioning this submit upper!
Come on over and discuss with my website . Thank you
=)
Way cool! Some very valid points! I appreciate you
penning this article and the rest of the website is also very good.
Wow that was strange. I just wrote an very long comment but after I clicked
submit my comment didn’t appear. Grrrr… well I’m not writing all that
over again. Anyhow, just wanted to say excellent blog!
It’s amazing in favor of me to have a web
page, which is helpful for my knowledge. thanks admin
Wonderful goods from you, man. I have understand your stuff previous to
and you’re just extremely excellent. I really like what you’ve
acquired here, really like what you’re saying and the way in which you say it.
You make it enjoyable and you still take care of to
keep it sensible. I can’t wait to read much more from you.
This is really a wonderful web site.
Good day very cool site!! Guy .. Beautiful ..
Wonderful .. I’ll bookmark your web site and take the feeds
additionally? I’m happy to seek out numerous helpful information right here within the publish,
we need develop extra strategies on this regard, thank you for sharing.
. . . . .
You really make it appear really easy with your presentation but I to find this topic
to be really one thing that I believe I might by no means understand.
It seems too complex and extremely broad for me. I’m looking ahead in your next submit, I will try
to get the grasp of it!
Hi there, I would like to subscribe for this web site to take most
up-to-date updates, therefore where can i do it please help.
This design is spectacular! You certainly know how to keep a reader amused.
Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Great job.
I really enjoyed what you had to say, and more than that,
how you presented it. Too cool!
Thanks a bunch for sharing this with all of us you really
understand what you are talking about! Bookmarked.
Please additionally consult with my web site =).
We could have a hyperlink change agreement among us
Everyone loves what you guys are up too. This type of clever work and reporting!
Keep up the very good works guys I’ve incorporated you guys to our blogroll.
Highly energetic post, I loved that bit. Will there be a part 2?
I’m extremely impressed with your writing skills as
well as with the layout on your blog. Is this a paid theme or did you
modify it yourself? Either way keep up the excellent quality writing, it’s rare to see a nice blog like
this one today.
you are truly a just right webmaster. The site loading speed
is incredible. It sort of feels that you are doing any distinctive trick.
Moreover, The contents are masterwork. you have
performed a magnificent process in this matter!
I quite like reading through an article that will make
men and women think. Also, thank you for allowing
for me to comment!
This is my first time pay a quick visit at here and i am truly happy to read everthing at one place.
Excellent post! We are linking to this particularly great article on our
site. Keep up the good writing.
I loved as much as you’ll receive carried out right here.
The sketch is attractive, your authored material stylish.
nonetheless, you command get got an nervousness over that you wish
be delivering the following. unwell unquestionably come further formerly
again as exactly the same nearly very often inside
case you shield this increase.
Greetings from Florida! I’m bored to death at work so I decided
to check out your site on my iphone during lunch break.
I really like the info you present here and can’t wait to take a look when I get home.
I’m amazed at how quick your blog loaded on my cell phone ..
I’m not even using WIFI, just 3G .. Anyways, very good site!
This is a great tip especially to those new to
the blogosphere. Brief but very accurate information… Appreciate your sharing this one.
A must read article!
My brother recommended I might like this web site.
He was entirely right. This submit actually made
my day. You can not believe just how so much time I had spent for this information! Thank you!
We stumbled over here by a different website and thought I should check things out.
I like what I see so now i am following you. Look
forward to going over your web page yet again.
Very quickly this website will be famous among all blog visitors, due to
it’s fastidious articles or reviews
What i don’t realize is in truth how you’re not really a lot more neatly-liked than you may be now.
You are so intelligent. You understand therefore significantly in the
case of this matter, produced me personally consider it from a lot of numerous angles.
Its like women and men are not fascinated until it is something to do with Girl gaga!
Your own stuffs nice. All the time handle it up!
I need to to thank you for this very good read!! I absolutely loved
every little bit of it. I have got you book marked to
check out new things you post…
Appreciation to my father who shared with me regarding this website, this blog is
actually awesome.
Great article! This is the kind of information that should be shared across the web.
Shame on Google for not positioning this put up upper! Come on over and seek advice from my
web site . Thank you =)
Howdy! Do you know if they make any plugins to help with Search Engine Optimization? 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. Thanks!
Everything is very open with a very clear explanation of the challenges.
It was really informative. Your website is very useful. Thanks
for sharing!
I visited multiple web sites however the audio feature for audio songs existing at
this web page is actually superb.
Awesome issues here. I’m very happy to look your article.
Thank you a lot and I am looking ahead to touch you.
Will you please drop me a mail?
If you wish for to increase your know-how simply keep visiting this site and be updated with the most recent news posted here.
It’s remarkable in support of me to have a web site, which is good in support of
my knowledge. thanks admin
Saved as a favorite, I really like your site!
I’ve been browsing online more than three hours these days, but I never found any
fascinating article like yours. It’s lovely value enough for me.
In my opinion, if all site owners and bloggers made good
content material as you probably did, the internet can be
much more helpful than ever before.
This is really fascinating, You’re an overly
professional blogger. I have joined your feed
and stay up for seeking more of your wonderful post. Additionally, I have shared your site in my
social networks
Excellent items from you, man. I’ve take note your stuff prior to and you’re
simply too fantastic. I actually like what you have got
here, really like what you’re stating and the best way during
which you assert it. You are making it enjoyable and you still take
care of to keep it smart. I can’t wait to learn far more from you.
This is really a great site.
We are a group of volunteers and starting a new scheme in our community.
Your web site offered us with valuable information to
work on. You have done a formidable job and our entire community
will be grateful to you.
Admiring the hard work you put into your website and in depth information you present.
It’s awesome to come across a blog every once in a
while that isn’t the same outdated rehashed material. Fantastic read!
I’ve saved your site and I’m adding your RSS feeds to my Google
account.
Right here is the perfect web site for anybody who really wants to understand this topic.
You understand a whole lot its almost hard to argue with you (not that I actually would want to…HaHa).
You certainly put a new spin on a topic that has been discussed for decades.
Excellent stuff, just excellent!
Thanks for one’s marvelous posting! I truly enjoyed reading
it, you might be a great author. I will make certain to bookmark your blog and will eventually come back later in life.
I want to encourage you continue your great work,
have a nice weekend!
Hi to all, the contents present at this website are truly awesome for people knowledge,
well, keep up the good work fellows.
I really love your site.. Very nice colors & theme.
Did you build this website yourself? Please reply back as I’m wanting to create my
very own site and want to know where you got this from or just what the theme is called.
Appreciate it!
Great post. I was checking continuously this blog and I am impressed!
Very useful information specifically the last part 🙂 I care for such information a lot.
I was seeking this certain information for a very long time.
Thank you and good luck.
Way cool! Some extremely valid points! I appreciate you writing this post plus the rest of the site
is also really good.
Excellent beat ! I wish to apprentice while you amend your web site, how could i
subscribe for a blog website? The account aided me a acceptable deal.
I were a little bit acquainted of this your broadcast offered vivid clear concept
I just like the valuable information you supply for your articles.
I’ll bookmark your blog and take a look at once more right here regularly.
I am somewhat sure I’ll learn many new stuff right right
here! Best of luck for the following!
Wow, awesome blog layout! How long have you been blogging for?
you make blogging look easy. The overall look of your website is wonderful, let alone
the content!