User And Admin Login System In PHP MySQL Step By Step | PHP Tutorial For Beginners (2025)

[@WebTechKnowledge]

The source Code : login.php

[@WebTechKnowledge]

Sub ?

[@Hiekejsjsiejn]

Php don't wrk for me yy....😣

[@WebTechKnowledge]

What’s your error?

[@serifarisha2538]

can this coding use in visual studio code ?

[@WebTechKnowledge]

Yes

[@saloni.4443]

spent the entire day looking through countless videos to create a login system to no avail. So glad that I found your video! I was able finish the whole thing from scratch within 30 mins. :)

[@ibunoribunor]

Hi can you teach me too ?

[@darikamukhim3262]

Great tutorial!🙌🏼

[@henryeffiom7610]

I love this so educative

[@shafka9611]

thanks for you help dear brother

[@TinJ92]

Thank you for sharing your knowledge.

[@kenilgsja3891]

sir everything is easy to understand i like this video it is in full detail

[@joganidarshil1314]

this short video tutorial was really helpful. Thank you.

[@JunieVM]

Thanks bhai, this is our prelim.

[@justbeing2662]

You have taught me alot than my teachers😍😍 thank you so much

[@Simplaz1234]

Thank you Sir.

[@Xiaoharuko]

Thank you Sir! Just what i was looking for to work with as a base template in creating my login portal.

[@markjohntominio9430]

Very helpful, thank you❤

[@cruchcherry_]

This was of great help .Thank you

[@jamesmut3117]

This is excellent. I have been looking for something of this kind

[@eddiebrempong1143]

Great job, i like it so much and you made it very simple.

[@heythere_696]

perfect it work 👍👌....

[@usermira438]

thank you so much sir

[@user-zi1xk4qv7u]

Awesome very straight forward and good Thanks so much it was really helpful

[@HybridThunder]

thank you so much saved my life, liked!

[@teamnorteth4065]

Thank you very much my friend its work

[@darthlinox]

Incrível!!! Professor parabéns!

[@sandeeps8646]

thanks

[@samssams1064]

excellent

[@meetamanhar3]

thank your sir this video very helpful 🙏🙏

[@Jenny-no7wi]

Thank you very much! Keep up the great work!

[@molyamolya1617]

Thank you, you’ve been very helpful

[@balkan77forum66]

thanks u bro i maked awsome project !!!

[@gamingcm8805]

goood

[@bishaws6377]

this is really helpful!

[@dineshdevarapalli6433]

Thank you so much bro❤

[@palakparmar4720]

Thank you sir

[@mihirrana8070]

bhai helpfullll

[@manuelgalvarez5312]

Great job, i like it so much!!

[@baadshahcults8224]

Thank you sooo much🙏🙏

[@Gihan10]

Patta machan

[@evernjoshua8100]

thank you so muchhhhhh

[@MrTonyTv]

men it was good tutorial but if i login as a user and i type the admin homepae url i can go in

[@WebTechKnowledge]

Give a if condition, if the usertype is user in admin homepage then send the user to the user homepage location

[@MrTonyTv]

@@WebTechKnowledge Bro can u write quick the code?

[@luqmanqader9251]

Many Thanks

[@makeunlimitedever9278]

Thanks for this 🤗

[@govindangovind1013]

Thank you so much Sir

[@ronnelmacompas1647]

Thank you so much!

[@roycehortaleza272]

Thank you!

[@ismzaxxon]

Great base model for testing. Thank you for your time. I did try the student user first, but some files such as css are missing.

[@EricAstarcom]

Thanks so much. Please do you have crud tutorial on php and mysqli like the laravel tutorial you have already created. It will be appreciated if you could implement the crud tutorial using php. It will get you more subscribers because your tutorial is the best on youtube.

[@WebTechKnowledge]

Ok i will make tutorial on it in 3 days

[@EricAstarcom]

Look forward to crud tutorial in php and mysqli or pdo in the future. Thanks so much for the reply.

[@aniketsingh1976]

Thanks * infinity

[@mysticalstardust]

I really liked how each line was explained thoroughly! Subscribed :)

[@justbeing2662]

If its not too much trouble, please do an online crime reporting system, where the police is the admin

[@SOUF1YAN]

thank u sm

[@mevoalex7777]

cool.🦔❤️

[@SILVER-fy6lx]

hi i want to ask can i change my html file to php file? since i need to connect to my login.php / register.php and can i made other than user and admin to specific admin email and user email ?

[@roshnigaikwad7554]

Once i have login home page with logout option it displays the user name but without logouting the page i went to the admin page there it displays the admin page information without asking to login why and it has same user name which was displayed in home page after login

[@harvey8695]

Since you are only checking to see if the username session variable is set, once you login as a regular user, you can then type the URL for the admin home page and gain access.

[@123210sam]

wats the solution to that vulnerability

[@user_noway]

can this is be a back door for a website for a admin? is this how we create backdoor for a website?

[@zoldyck9356]

is it the same for android studio app?

[@roopa5760]

sir , how to control access for login both user,admin based on time, ex: after 6 user not allowed to login , kindly requesting to provide me solution

[@nicholastolores861]

Can I ask what tools or software I need for programming

[@richardrodgers7406]

I found a serious issue with his tutorial. Regular users can access the admin area using the url. How can we restrict that area to admin users only ?

[@bamideleadedamola4309]

Oh my! It's true , I just checked my it out ...... please is there a fix for this issue ???

[@WebTechKnowledge]

Yes there is.. Send the usertype using session just like you send the name. Like this - $_SESSION['usertype']="user"; Then in the userhome write a else if condition Like this - elseif($_SESSION['usertype']="admin") { header("location:login.php"); } You have to do the same for adminhome Hope you are clear.

[@AdaNnenna-es1bz]

Thank you for this but please, when I login in, I don't see the username displayed And when I add the Access denied code for non logged in users, even a registered account is redirected to the login page

[@zoldyck9356]

can we use the same php code and relate it with android studio app please help

[@athirah__471]

Can u tell me how can i change the name of the user_type bcs i have done it but the error keeps coming

[@mecyber6316]

is it okay to make a new table for admins only? or have to be with users to specify the role? thank you for the video.

[@WebTechKnowledge]

Its fine to create different table for user and admin..but why you want to create a separate table for admin. Probably you will have a few admin data . so creating a different table is unnecessary. It's better to keep the number of table as minimum as possible. So it depends on your decision.

[@cabusorangelica_ict12-2a4]

can you teach us how to make attendance app for student plsss🙏🙏

[@arevev]

tyyy

[@bamideleadedamola4309]

Please is there a way I can write a select all query based on the user type Something like " select * from table where usertype = admin " Thanks!

[@jackieBarnesjaylob]

can this be used in vscode instead of sublime?

[@WebTechKnowledge]

Yes. Of course

[@jackieBarnesjaylob]

Thank you

[@gohxuanyou5381]

Hi sir, may I know, if i have 3 or more roles to add, what shall i do?

[@WebTechKnowledge]

Same process. In this tutorial we use 0 for user 1 for admin Let's say you have another user_type which is manager then consider, 2 for manager

[@LindaKeshie-bg9pq]

Can I have this same one done in notepad

[@onlinengineer]

I have the same wallpaper bro 👍

[@WebTechKnowledge]

👌

[@RahulKumar-xl3dd]

If we use html , javascript and css for front end then will it work ???

[@WebTechKnowledge]

Yes it will work

[@KidaneTeshager]

How we create online exam web with admin and user page

[@discere5811]

I encounter a problem around the 21:42, I keep getting the error Warning: Trying to access array offset on value of type null I have tried every solution I see on the internet but nothing worked, I hope you can reply even though the video is 1 year old, and to anyone who encountered this error and were able to solve it, can you kindly reply what solution you have done? Thank you in advance.

[@shiellamay6862]

same problem, have u solve the issue?

[@killansinyangwe-wg4wv]

Please kindly help on how i can login to admin password from a database

[@edwinteoh3342]

I found this error : "Notice: Trying to access array offset on value of type null" The line is if($row["Usertype"]=="User") & if($row["Usertype"]=="Admin")

[@badonggamingtv1810]

Same with me, did you tried to access it?

[@hijaujahat7500]

@@badonggamingtv1810 u need to change $db (in login.php) name same as u database name

[@user-zi1xk4qv7u]

It passes an error if you input wrong username and password instead of it to return or echo wrong username or password

[@charllotegracesarzuelo2015]

Thank that so helpful. But there is one problem I encounter why is it after logging in I couldn't enter to homepage, is it because of my database? Thank you.

[@WebTechKnowledge]

Did you create the table in the database?

[@teamnorteth4065]

Can i request sir ...can you please make an municipal library system sir thank you and godbless

[@Erp-what]

hello how i can change user to be an admin from backend ?? i know i must make a register page and all data go to database can i know how i make some user be admin not from change his statues from phpmyadmin

[@WebTechKnowledge]

For adding admin you need to store usertype as 1 from the code. What you can do is that you need to make form in admin dashboard for user table. While inserting data to the table you need to insert usertype as 1 by default in controller.

[@sathishkumarvaradharajan7110]

when user logged in it goes to specific landing php page..but when user change the url to admin.php its opening ..who to authencate the page with usertype before loading

[@WebTechKnowledge]

Checkout this tutorial. Then your issue will be solved. Here i make it a little detailed. Check around at the end. kzbin.info/www/bejne/aF7LYYOnrslmf9E

[@PriyaRani-cy3pu]

An error in this...... That was... Trying to access array offset on value of type null... Plz give solution

[@mecyber6316]

I got this warning "Warning: Trying to access array offset on value of type null" with admin account only, what happening? and what should i do? thank you

[@mecyber6316]

I figured it out this morning, this is because the admin password is encrypted in the database. I decrypted it and all codes worked fine.

[@andrewilson3722]

When I was testing the error message for username or password incorrect. I'm getting: Warning: Trying to access array offset on value of type null in D:\secure\project\index.php on line 20 Warning: Trying to access array offset on value of type null in D:\secure\project\index.php on line 23 Username or password incorrect. How do I fixed this without showing the warning

[@mahdihossaintanvir350]

when I try with wrong name or password, the code runs well but it shows me two error also...

[@WebTechKnowledge]

Whats the error?

[@jonasbauer4807]

Ok thank you now it is working. But when I enter the passwort incorrect . This warning appears: Trying to access array offset on value of type null in C:\xampp\htdocs\login1\authenticate.php on line 40 i think because the array is empty. How can I catch the error that it only shows username or passwort incorrect?

[@WebTechKnowledge]

You can use validation. Just search it on youtube. You will get it

[@patilkomal5638]

My page is not redirecting to userhome and no error as be seen ..can you resolve it soon!

[@WebTechKnowledge]

I have given the source code in the 1st comment. Try that out

[@kenyanmemes767]

Hello, how do I get my xammp port to work, it says port 3306 has been occupied

[@WebTechKnowledge]

You need to change the xampp port number

[@kenyanmemes767]

@@WebTechKnowledge do you know how?

[@tiangong4712]

Hi, your tutotial is very helpful, but i don't know why my page when i click login, is show me(Fatal error: Uncaught TypeError: mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, bool given in D:\Xampp\Xampp\htdocs\Delivery(final)\login\login.php:29 Stack trace: #0 D:\Xampp\Xampp\htdocs\Delivery(final)\login\login.php(29): mysqli_fetch_array(false) #1 {main} thrown in D:\Xampp\Xampp\htdocs\Delivery(final)\login\login.php on line 29), can you help to solve this?

[@Carlos-jp2eh]

where you are running mysqli_query , add 'or die( mysqli_error($db)' e.g $sql = "SELECT * FROM users"; $result = mysqli_query($db, $sql) or die( mysqli_error($db));

[@duke6477]

This helps me so much sir, but I'm having a problem on the "else" wherein if you input a wrong password or user it should state that it's incorrect but mine says error but it still output the incorrect Warning: Trying to access array offset on value of type null in D:\xampp\htdocs\login\account.php on line 31 username or password incorrect

[@zhennan1591]

Im having the same issue, have u managed to solve it?

[@laughingkettle]

Hello, if you have managed to solve this, can u tell us? TIA

[@hathanehrukhandriv8638]

add hw to select data from database

[@jacklythgoe1478]

Parse error: syntax error, unexpected '$password' (T_VARIABLE), expecting ')' in C:\xampp\htdocs\Project\login.php on line 9

[@Runetherune]

I got this error: Fatal error: Uncaught mysqli_sql_exception: The server requested authentication method unknown to the client [auth_gssapi_client] in C:\xampp\htdocs\project\login.php:8 Stack trace: #0 C:\xampp\htdocs\project\login.php(8): mysqli_connect('localhost', 'root', Object(SensitiveParameterValue), 'user') #1 {main} thrown in C:\xampp\htdocs\project\login.php on line 8

[@Mohammedzahir001]

please someone tell me includ= session_start???

[@yrajasekhar9134]

getting this error Uncaught TypeError: mysqli_num_rows(): Argument #1

[@manjuthenga4387]

hai, any one can be login as user or admin

[@eroyu]

oke

[@chelseamissi5331]

Mine is not redirecting to userhome. It says not found

[@WebTechKnowledge]

Check your code properly. Probably there is some spelling mistake

[@jonasbauer4807]

Hi, I get this erro: Uncaught TypeError: mysqli_error(): Argument #1 ($mysql) must be of type mysqli

[@WebTechKnowledge]

Probably there is some spelling or syntax mistake.. Check your code

[@WebTechKnowledge]

Here is a link which you can also check stackoverflow.com/questions/66837160/i-keep-having-uncaught-typeerror-mysqli-error-argument-1-mysql-must-be-o

[@harisyyyyy]

Undefined index error in POST Method $username=$_POST["username"]; $password=$_POST["password"]; how resolve this ???

[@o.k.S...65]

Why i got this error ?? Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\SIP23PROJECT\User.php on line 25 Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\SIP23PROJECT\User.php on line 30 username or password incorrect

[@bautistadalisaymilenem.4722]

Warning: mysqli_connect(): (HY000/1049): Unknown database 'user' in C:\xampp\htdocs\login\login.php on line 11 connection error how to fix? The code was correct but still it looks like that.

[@WebTechKnowledge]

Did you create the user table in the database?

[@bautistadalisaymilenem.4722]

@@WebTechKnowledge Yes po

[@bautistadalisaymilenem.4722]

i followed your steps

[@WebTechKnowledge]

@@bautistadalisaymilenem.4722 1st solution : Check if the database name is exactly like in your code . 2nd solution : Check my.ini file of mysql and verify port number. Im most of the cases it runs on 3306 however if it is running on 3308 then edit your connection file: $conn = mysqli_connect($server_name, $mysql_username, $mysql_password, $db_name, "3308");

[@bautistadalisaymilenem.4722]

I just read your reply. I already fixed it yesterday. Thank you so much for the response. Also, with your video, it helps me a lot. ❤️