PHP and MySQL How to connect
HTML-код
- Опубликовано: 10 сен 2024
- In this video we will learn how to connect HTML login form with PHP and MySQL database for login operation. If email and password match then user will get message login successfully other wise he or she will get message Invalid user name or password.
=============================================
For any Business enquiry contact us
Gmail :- tarique.rkl@gmail.com
WhatsApp :- +917978073704 (for only business query)
=============================================
PHP and MySQL - How to create Login Form using HTML and Bootstrap v4.4 #1
• PHP and MySQL - How to...
To get the form data into the php file we need to specify php file name inside the opening tag of form with action="login.php" login.php is a file name in the same directory where our html code is the next attribute is method="post". we have two method to send data to server get and post. For sending the sensitive information always use post method
For getting the input field value inside the php file we need to specify name of that input using name attribute of HTML
Now inside the login.php file write the following code
$email = $_POST['email'];
here $email is a variable we are getting email using $_POST global variable $_POST['email']; here email is the name of input field
$con = new mysqli("localhost","root","","test");
$con is a variable which hold the $con object
00:01 Learn how to connect a login form with PHP and MySQL database.
00:51 Connect HTML login form to PHP and MySQL using PHP file
01:53 Executing login functionality and establishing database connection in PHP
02:53 Establish a connection to the MySQL database using PHP.
03:48 Prepare a statement with SQL query and bind the value
04:51 Executing SQL query and checking the result
05:53 Fetch data from the result using a fetch method.
06:55 Implementing blank validation in HTML login form
Crafted by Merlin AI.
I did try many more time but failed. But your code is code is working finely.Thanks a lot bro.
Out of all the video tutorials this one helped my code functional! Thank you so much and keep on helping us! God bless you!
Nice video, what about how to build user dashboard after login
Mm
u can create or just download from any other site then link to the login button to that file :)
Sir, Amazing playlist you have here. ( Suggestion - you have performed Create operation on the form in the SQL video, part 2 of that video could have been CRUD operation . And this could have been part 3 ) . Other than this, excellent TO THE POINT explanation. 🙂
tq so so much i m a beginner and it worked without any error.
This video was extremely helpful keep doing the good work :)
Thank you, your video is so amazing
in this video you have explained how to connect form to database but next step is How to Fetch Data From Database in PHP And Display HTML Tables please upload video
thanks a lot sir really
much needed in less time
Why do I always get fatal error on "Call to a member function bind_param() on bool"?
I have same issue
Sir I have one doubt for visual studio and xmapp not connected sir please help me that one sir
Such video have helped me a lot Thank you Sir
hello sir
me apke sabji video regularly check karta hu or bhot kuch sikhne ko mitla he so thnx for you and sir I req u plz online examination project ko online server par kese work uplod karte he vo next video banavo uska source code salary phptiponit pe he hi but kuch quriy raheti ek singup me could not perform quiry and second review que me so plz help me
Please can you send me the XAMP link you used for this. I have never succeeded linking forms. I follow all the processes but not connecting. Thank you
@@scs071-prajapatideepak4 Thank you so much.
This video help me a lot
Thank You
Thank you technical babaji
Thank you I learn more From Your video
After creating login form and I'm filling some info after login button some error shows👉 Undefined array key 'password' ??
Help me
Sir can u plz tell me that which email or password u use when login or which password i use for login??
You help me alot , thanku sir .
What if, after clicking on submit button it shows the php code then what I have to do?
Same problem
After complete coding
Login invalid email password showing
But login successfully not showing
Please help me sir
Thank you so much buddy... This helped me a lot : )
I've tried using your login.php source code and each time there is always an error report with the use of the bind_param() function
I am also come error or no data save in my SQL 😢
Very helpful video Thanku so much
Data input karne par MySQL Mai Kiya save horaha hai apka 😒 Mai to data base name diye phir bhi data nahi save ho raha hai
thank you for your video
@ 1:53 when I click submit it shows all the code on the next page instead of saying "This is a test", please help.
I think you are running your local file not on localhost server, if you are using xampp put your files in xampp\htdocs, then from xampp control panel open apache admin, change the url to localhost/"folder name or filename/ then run it...
Im actually trying to do that since last year. Bt when i click submit button. My php file actually opens up. With all coding part. On the screen. And not only output of php.. if you know what i mean ?
i have the same problem
Bhai kuch solution mila kya iss problem par ?
Am too getting the same problem..did you fix it bro?
@Shadow KinG you are right bro.The folder should be open with localhost/your_folder_name. You must ensure xamp is running with Apache and mysql .
Save your html file and php file in c://......xampp/htdocs/.html
Thank you. It worked
awesome tutorial very useful
Thank you!
dont stop i am following
Thanks bro I like it be blessed.
whatever i type in my php code, its being displayed after i click submit.... when i tested the linking with "echo"
whats wrong with my code?
nice video. thank you
bhiya jab submit per click karte hai to submit hone ki jgh code aaja hai page per kya kare
After login and php output is not displayed instead that the whole code is displaying after clicking on login, why so can you answer
Kya hume database mein pahele se email and password save karna hoga .
Because jab mein koi bhi email ya password enter karta hu invalid email or password hi aata h.
if the query is turned the other way around like Select * from registration where the password=? can it still work the same way ?
Hi, am trying to connect the php part, but I get this displaying on my Screen
Can you advise what I need to do to get it working. Thanks,
Our extension must be .php
2. Save our file in xampp>ht docs then only it excutes
thanx but you should explain deeply waht is->param ? waht is stmnt.. what is ->bind what is prepare why ..?)
When I click on login button message display only invalid email or password,but no print login successful y
Gr at video!
Hi babaj please where can I found the part1 ? Because this is part2
hi, could you help me? my html and i want to connect to php, but it's not working.... where could i contact u?
when i clik on login button it's display me a blank page
Did you get it correctly now because I am getting the same
Same😣
Guys link the login button with button with another html file and make this page like what do you want after an user logged in
Link like this
Link like this
For me the values are nor getting inserted into phpmyadmin what to do please anybody help
HOW TO PRINT DATA OF THE DATABASE TABLE IN PAGE ITSELF?????
Bro your video makes me more helpful . First I get started with php in my college and now i almost forgot it. Now i want to learn more. Did you have full course of php then kindly share that link to me
Hello sir thanks for the tutorial I want to know which screen recorder you are using thanks in advance
Thanku so much Sir
Do you have a video where there is a dashboard where you can see who logged in?
after executing php test code it giving me error that this page is not working..what should i do
sir im only getting invalid email or password as output
plz help anyone
He'll sir. I was making one project using html, css and javascript..on that i was made one page to take user data..but I'm not understand how to store data in Database..using this html language. So how can I connect database in my project to store data.can u help me for that??
You need to learn some server side programming like php nodejs or java etc any one of these. HTML alone isn't sufficient
@@TechnicalBabaji1 ok..u mean to say using HTML language we can't store data in Database..
@@lalitapawar2912 yes
@@TechnicalBabaji1 ok. Thanks
Warning: Undefined array key "password" in C:\xampp\New folder\htdocs\CODING\practice\login.php on line 3
Change file name to localhost/filename.php
My php is not working . please suggest solution.
me too
ruclips.net/video/vb0vQYoeWt0/видео.html
Hope this help.
If the php file will not work what to do?
how did u directly executed that php code in web browser instead of changing the path of php file to local host?
Sir , I tried to bring my card vertical down & follow the same step but didn't get the same output , it does come vertically center.
you prolly dont care but does anybody know a method to get back into an Instagram account??
I was dumb forgot the login password. I appreciate any tips you can give me!
@Kristopher Joaquin Instablaster ;)
@Lewis Benson thanks for your reply. I found the site thru google and im waiting for the hacking stuff now.
I see it takes a while so I will get back to you later with my results.
@Lewis Benson it did the trick and I actually got access to my account again. I am so happy!
Thank you so much you really help me out :D
@Kristopher Joaquin you are welcome xD
Could anyone tell me the name of this software???
Sir when I click login it started to download the login.php file so what I do next ?
U should create local host
I’m stuck and I really need help with connection to my database
How to connect dashboard to this afternoon successful login
how to get response in html page that account is found in database?
how to redirect your visitor to your home page after login. link login to your webpage or main page
what is the software that you are using to type??
In php to connect database you said use while loop plz send that code
Please sign up form should be made
And show data from database
Is learning php worth in 2021
I am getting the php code in my browser what do I do?
Sir inspite of doing everything correct i got call to member function for bind_param. Please help
I also
Bhai info de toh Puri de adhi adhuri mat diya kar
Sir how can i contact you?
Dear subscribers,
We had gone through your comments and lots of requests for promoting your content on our channel. So, we decided to provide you with a great opportunity to promote your own content by collaborating with us. Nothing to worry it's absolutely free of cost! Don't miss this golden chance of collaboration in a channel of 18k subscriber holder! If you're Interested then directly mail here for more details
pravat.behera45@gmail.com
Regards
Technical Babaji
ruclips.net/channel/UCKn7xwxBKZ_H1i6nilMsRQg
what to do i am getting error on going login.php page
*How about using MySQL Workbench?*
source code?
U for real?
Suppose i have mysql instead of xamp
After login how to show next activity
We use session for showing next page after login. Just google to know more about session on php
@@TechnicalBabaji1 what can we make in google like a keyword researh ??
But how do i make a email then?
even i enter correct username and password it shows invalid username and password
same what should i do
Thanks for the video.
Please, how can the successful login be directed (automatically) to homepage i.e. index.html?
I hope you understand my question!
Bro Html par or video bnao
Css؟؟
its not logging in it is showing invalid email or password every time
same here
sir, Can I have the source code of this video?
Charging mobile on sunlight patent -
ruclips.net/video/7Tmgf4KzG_c/видео.html
Coding kisme ki he
Notepad ++ ya notepad 5
Sublime pr
I got a syntax error in line 7
Warning: Array to string conversion in D:\xampp\htdocs\test\login.php on line 12
my error is undefined index email
undefined index password
did you solved it??
i need code
Bro how to make a database?
How can I build user dashboard after login
you have to put the link of source code
stuck on php connecting haha need help
Share source Code please
Bro code link pls
connect nhi ho rha h
Do we need to download and install xaamp ??
Yes