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

[@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!🙌🏼

[@kenilgsja3891]

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

[@henryeffiom7610]

I love this so educative

[@shafka9611]

thanks for you help dear brother

[@JunieVM]

Thanks bhai, this is our prelim.

[@TinJ92]

Thank you for sharing your knowledge.

[@markjohntominio9430]

Very helpful, thank you❤

[@Simplaz1234]

Thank you Sir.

[@joganidarshil1314]

this short video tutorial was really helpful. Thank you.

[@justbeing2662]

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

[@Xiaoharuko]

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

[@Gihan10]

Patta machan

[@usermira438]

thank you so much sir

[@jamesmut3117]

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

[@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.

[@heythere_696]

perfect it work 👍👌....

[@HybridThunder]

thank you so much saved my life, liked!

[@cruchcherry_]

This was of great help .Thank you

[@sandeeps8646]

thanks

[@teamnorteth4065]

Thank you very much my friend its work

[@eddiebrempong1143]

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

[@meetamanhar3]

thank your sir this video very helpful 🙏🙏

[@gamingcm8805]

goood

[@user-zi1xk4qv7u]

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

[@samssams1064]

excellent

[@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?

[@darthlinox]

Incrível!!! Professor parabéns!

[@evernjoshua8100]

thank you so muchhhhhh

[@balkan77forum66]

thanks u bro i maked awsome project !!!

[@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 ?

[@dineshdevarapalli6433]

Thank you so much bro❤

[@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

[@mihirrana8070]

bhai helpfullll

[@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

[@molyamolya1617]

Thank you, you’ve been very helpful

[@justbeing2662]

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

[@bishaws6377]

this is really helpful!

[@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.

[@Jenny-no7wi]

Thank you very much! Keep up the great work!

[@palakparmar4720]

Thank you sir

[@baadshahcults8224]

Thank you sooo much🙏🙏

[@user_noway]

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

[@manuelgalvarez5312]

Great job, i like it so much!!

[@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

[@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]

is it the same for android studio app?

[@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.

[@zoldyck9356]

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

[@luqmanqader9251]

Many Thanks

[@makeunlimitedever9278]

Thanks for this 🤗

[@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.

[@govindangovind1013]

Thank you so much Sir

[@nicholastolores861]

Can I ask what tools or software I need for programming

[@RahulKumar-xl3dd]

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

[@WebTechKnowledge]

Yes it will work

[@drmustafamahmod]

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.

[@aniketsingh1976]

Thanks * infinity

[@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?

[@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

[@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!

[@ronnelmacompas1647]

Thank you so much!

[@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?

[@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

[@roycehortaleza272]

Thank you!

[@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

[@killansinyangwe-wg4wv]

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

[@cabusorangelica_ict12-2a4]

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

[@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

[@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.

[@KidaneTeshager]

How we create online exam web with admin and user page

[@jackieBarnesjaylob]

can this be used in vscode instead of sublime?

[@WebTechKnowledge]

Yes. Of course

[@jackieBarnesjaylob]

Thank you

[@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

[@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

[@LindaKeshie-bg9pq]

Can I have this same one done in notepad

[@user-zi1xk4qv7u]

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

[@mysticalstardust]

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

[@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?

[@teamnorteth4065]

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

[@mevoalex7777]

cool.🦔❤️

[@SOUF1YAN]

thank u sm

[@PriyaRani-cy3pu]

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

[@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

[@mahdihossaintanvir350]

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

[@WebTechKnowledge]

Whats the error?

[@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

[@onlinengineer]

I have the same wallpaper bro 👍

[@WebTechKnowledge]

👌

[@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));

[@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

[@jacklythgoe1478]

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

[@yrajasekhar9134]

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

[@arevev]

tyyy

[@Mohammedzahir001]

please someone tell me includ= session_start???

[@manjuthenga4387]

hai, any one can be login as user or admin

[@harisyyyyy]

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

[@hathanehrukhandriv8638]

add hw to select data from database

[@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

[@chelseamissi5331]

Mine is not redirecting to userhome. It says not found

[@WebTechKnowledge]

Check your code properly. Probably there is some spelling mistake

[@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. ❤️

[@franzmclay]

elseif($row["usertype"]=="admin") { $_SESSION["username"]=$username; header("location:adminhome.php"); } PLEASE HELP ME, IM ERROR with that line it gives this warning "Warning: Trying to access array offset on value of type null"