User And Admin Login System In PHP MySQL Step By Step | PHP Tutorial For Beginners (2023)
HTML-код
- Опубликовано: 28 апр 2021
- #php #multiuserloginphp
How To Make Admin And User LOGIN System In PHP Mysql Step By Step | PHP Tutorial For Beginners
Support This Channel :
Join this channel to get access to perks:
/ @webtechknowledge
Your support will be really appreciated.
#webtechknowledge
You can connect with me with the given links below:
Please Subscribe to this channel: / @webtechknowledge
Follow me on :
Facebook Link: / yaminshakil07
Instagram Link: / yamin_shakil
Twitter Link: / yaheashakil
The source Code :
login.php
Sub ?
Php don't wrk for me yy....😣
What’s your error?
can this coding use in visual studio code ?
Yes
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. :)
Hi can you teach me too ?
Thank you Sir!
Just what i was looking for to work with as a base template in creating my login portal.
Great tutorial!🙌🏼
Incrível!!! Professor parabéns!
Great job, i like it so much and you made it very simple.
sir everything is easy to understand i like this video it is in full detail
You have taught me alot than my teachers😍😍 thank you so much
Awesome very straight forward and good
Thanks so much it was really helpful
Thank you very much! Keep up the great work!
This was of great help .Thank you
This is excellent. I have been looking for something of this kind
Great job, i like it so much!!
this short video tutorial was really helpful. Thank you.
Thank you for sharing your knowledge.
thank you so much saved my life, liked!
Thank you, you’ve been very helpful
thanks for you help dear brother
Thanks bhai, this is our prelim.
Thanks a lot. You have really saved me
this is really helpful!
perfect it work 👍👌....
I really liked how each line was explained thoroughly! Subscribed :)
Thank you very much my friend its work
Thanks for this 🤗
thanks u bro i maked awsome project !!!
Thank you so much!
Patta machan
thank you so much sir
Thank you so much Sir
excellent
cool.🦔❤️
thank your sir this video very helpful 🙏🙏
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.
Thank you so much bro❤
thank you so muchhhhhh
bhai helpfullll
Thank you sooo much🙏🙏
Thank you!
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.
Ok i will make tutorial on it in 3 days
Look forward to crud tutorial in php and mysqli or pdo in the future. Thanks so much for the reply.
If its not too much trouble, please do an online crime reporting system, where the police is the admin
goood
thank u sm
Many Thanks
Thanks * infinity
tyyy
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 ?
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!
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
can you teach us how to make attendance app for student plsss🙏🙏
Can i request sir ...can you please make an municipal library system sir thank you and godbless
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
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.
wats the solution to that vulnerability
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.
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.
can this is be a back door for a website for a admin? is this how we create backdoor for a website?
Can I ask what tools or software I need for programming
I have the same wallpaper bro 👍
👌
Can u tell me how can i change the name of the user_type bcs i have done it but the error keeps coming
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?
You can use validation. Just search it on youtube. You will get it
can we use the same php code and relate it with android studio app please help
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
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 ?
Oh my! It's true , I just checked my it out ...... please is there a fix for this issue ???
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.
Please kindly help on how i can login to admin password from a database
How i correct 'Trying to access array offset on value of type null in ...'??????pls give me solution......
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.
Did you create the table in the database?
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")
Same with me, did you tried to access it?
@@badonggamingtv1810 u need to change $db (in login.php) name same as u database name
Hi sir, may I know, if i have 3 or more roles to add, what shall i do?
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
men it was good tutorial but if i login as a user and i type the admin homepae url i can go in
Give a if condition, if the usertype is user in admin homepage then send the user to the user homepage location
@@WebTechKnowledge Bro can u write quick the code?
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
Im having the same issue, have u managed to solve it?
Hello, if you have managed to solve this, can u tell us? TIA
is it the same for android studio app?
It passes an error if you input wrong username and password instead of it to return or echo wrong username or password
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
Checkout this tutorial. Then your issue will be solved. Here i make it a little detailed. Check around at the end.
ruclips.net/video/2-h0Pqyd3Io/видео.html
How we create online exam web with admin and user page
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
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.
If we use html , javascript and css for front end then will it work ???
Yes it will work
Can I have this same one done in notepad
An error in this...... That was... Trying to access array offset on value of type null... Plz give solution
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
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.
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?
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));
when I try with wrong name or password, the code runs well but it shows me two error also...
Whats the error?
Parse error: syntax error, unexpected '$password' (T_VARIABLE), expecting ')' in C:\xampp\htdocs\Project\login.php on line 9
add hw to select data from database
My page is not redirecting to userhome and no error as be seen ..can you resolve it soon!
I have given the source code in the 1st comment. Try that out
can this be used in vscode instead of sublime?
Yes. Of course
Thank you
oke
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.
same problem, have u solve the issue?
Undefined index error in POST Method
$username=$_POST["username"];
$password=$_POST["password"];
how resolve this ???
Hi, I get this erro:
Uncaught TypeError: mysqli_error(): Argument #1 ($mysql) must be of type mysqli
Probably there is some spelling or syntax mistake.. Check your code
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
Hello, how do I get my xammp port to work, it says port 3306 has been occupied
You need to change the xampp port number
@@WebTechKnowledge do you know how?
getting this error Uncaught TypeError: mysqli_num_rows(): Argument #1
please someone tell me includ= session_start???
hai, any one can be login as user or admin
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
Mine is not redirecting to userhome. It says not found
Check your code properly. Probably there is some spelling mistake
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"
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.
Did you create the user table in the database?
@@WebTechKnowledge Yes po
i followed your steps
@@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");
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. ❤️
SIR SHARE CODING
Source Code Link Please
Ok
I added the source code in the first comment
@@WebTechKnowledge thank you
how to fix?
Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\project\login.php on line 31
Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\project\login.php on line 39
waste of time the code is running in your system but not working others system