Great vid mate it’s exactly what I’ve been trying to find this whole week! I have a few tips for people looking to use this on their websites, make sure you use some form of encryption for passwords
Hey @dharmemdrarathore4424, Dil se shukriya! 🙏 I'm thrilled to hear that you found the video helpful in mastering these essential PHP concepts. Your kind words mean a lot! If you have any more questions or if there's anything specific you'd like to learn next, feel free to let me know. Happy coding, and thanks for being a part of our learning community! ❤️🚀
Thank you for your awesome feedback! I really appreciate your kind words and I'm glad you found the tutorial clear and helpful. Welcome to the channel - I'm excited to have you as a subscriber! If you ever need more assistance or have questions about future content, don't hesitate to ask. Keep up the great work with your login and registration form project using PHP and MySQL! 🙌🎉
Thank you for your positive feedback! We're glad to hear that you found the video helpful and appreciate your comment. Our goal is always to provide clear and concise information to help viewers understand the topic efficiently, without wasting their time. If you have any further questions or suggestions, please feel free to let us know.
Perfect tutorial you know coding with music like this not oy makes coding fun but takes the coder through a world of nostalgia due to the music I felt like i was back in 2016
You're welcome! I'm glad to hear that you found the video useful. If you have any further questions or if there's anything else I can assist you with, please don't hesitate to let me know.
Hi @ajiedelacruz5836, Thank you so much for your kind words! I'm thrilled to hear that you found the video helpful and that you've learned a lot. If you have any more questions or if there's anything specific you'd like to explore further, feel free to let me know. Your success in learning and implementing is my priority! Happy coding, and keep up the awesome work! 💻🚀
Hey @jay-shree-ram9 , Bahut shukriya! I'm glad to hear that you found the tutorial helpful and appreciate the time efficiency. My goal is to make the learning process smooth for everyone. If you have any questions or need further clarification, feel free to ask. Happy coding! 😊🚀
Thank you so much for your kind words! I'm thrilled to hear that you found the method amazing. If you have any further questions or need assistance with anything else, please don't hesitate to reach out. Keep up the great work with your login and registration form project using PHP and MySQL! 🌟
@@DavidGTech I hope you'll reach more audience and subscribers soon. Because your video has a lot of point for peoples who want learn about programming. You deserve it. Can't you make video like this but with an explanation, don't fast motion the video. Just originally.. I'll be enjoy the explanation. 🙂🙂🙂
Can i ask, so sessions are the way you store id for a user throughout a website for example im making a social netwoek so i wanna be able to use user id through many pages
You're very welcome! I'm glad to hear that my video was helpful for your project. Regarding your question about adding a hashed password function, you can use a hash function like "password_hash()" in PHP to securely hash passwords. Here's an example: $password = 'myPassword123'; $hashed_password = password_hash($password, PASSWORD_DEFAULT); I hope that helps! Let me know if you have any further questions or if there's anything else I can help you with.
I appreciate the humor in your comment! 😄 Developing a login and registration system with PHP and MySQL can indeed feel like diving into a deep pool of code, especially if you're new to it. It's like a crash course in web development, right? But don't worry; it gets easier with practice. The world of coding can be vast, and it's normal to feel overwhelmed at times. The important thing is that you're taking the initiative to learn and explore these concepts. If you have any specific questions or if there's a particular part of the code that's giving you trouble, feel free to ask. I'm here to help and break down the complexities of PHP into more digestible bits. Remember, every coder has been through this phase, and it's all part of the learning journey. Keep coding, and you'll be amazed at how much you can accomplish! 💻🚀
Hello, I have a error, when I try to register, I get directed to a white window with nothing written and no changes on the database, could you help me please ? I would really appreciate it.
Files downloaded and reglog imported, registration successful but not showing up on localhost, is there something I missed or failed to configure in wamp?
Sorry,my English is not good I just copied from your source code,but I can't registered a new user on website After I registered it wrote Registration Successful, but there is no new data in my database I have tried to add it directly to the database, it can work How to fix it?
Bang di gua kok pas registrasi berhasil tetapi data nya kga Bisa masuk di Database padahal sama seperti di video dari awal ampe akhir ... Ada solusi kah 🙏??
Kayanya ada kode yang ketinggalan sedikit, kalau kodenya full sama seperti yang di video pasti harusnya berhasil sih. Coba aja copas source codenya yang ada di deskripsi video. Thank you for watching
@@DavidGTech Thx Saran nya Bang Kelupaan Saiya Ternyata Yang salah Di bagian Database nya bang ... Tipe data yang saya buat semuanya Pada Integer ga ada yang tipe Varchar buat nama, email, dan passwordnya ....awkwkw Thx bro... ilmunya... Dah. Bisa..
Bang mau nanya pas isi datanya di localhost dah berhasil tp pas di cek di databasenya nama gak sesuai yang tadi saya input nama jadi nama username jadi username gtu itu kira2 kenapa ya?
Hi @user-xq1yu8rh4h, Great question! Securing PHP authentication is crucial for protecting user data. Here are a few key tips: - Use Prepared Statements: When interacting with the database, use prepared statements to prevent SQL injection attacks. - Hash Passwords: Always hash passwords using a secure hashing algorithm (e.g., bcrypt). Never store plain text passwords in your database. - Session Security: Ensure that your sessions are secure. Use secure session handling, regenerate session IDs, and set appropriate session timeout values. - Cross-Site Scripting (XSS) Prevention: Sanitize user input and output to prevent XSS attacks. Use functions like htmlspecialchars() when echoing user data. - SSL/TLS: Implement SSL/TLS to encrypt data during transmission, especially when handling login credentials. - Brute Force Protection: Implement measures to prevent brute force attacks, such as account lockout mechanisms or CAPTCHAs. - Validate User Input: Validate and sanitize all user input to prevent various types of attacks. Remember, security is a multi-layered approach, and staying informed about the latest security practices is essential. If you have specific questions or need more detailed guidance, feel free to ask! Happy coding, and stay secure! 🔒🚀
Halo kak, saya sudah import database dengan nama database yang sama, codenya langsung coba tanpa diubah ubah tapi tetep ga nambah di database tb_user setelah registrasi kak
Coba pakai source codenya dah, kayanya ada yang salah kodenya. Kalau kodenya lengkap dan databasenya sama persis pasti bisa sama seperti yang ada di video. Thank you udah nonton
@RoniKarmakar-sk9vm Hi there! Good question. The reason for leaving a blank in the first place is to handle the AUTO_INCREMENT feature in MySQL. Typically, this blank corresponds to the id column, which is set to auto-increment. When you use an AUTO_INCREMENT column, you don't need to specify a value for it in your INSERT statement; MySQL will automatically generate a unique value for it.
@Richboss04 Hi there! If you want to separate your HTML and PHP code, you can start by creating separate files for each. For example, you can have a file named form.html for your HTML code and another file named process.php for your PHP code. In form.html, you can include a form with the necessary HTML structure, and in process.php, you can handle form submission and interact with your database using PHP. Remember to use appropriate form actions and method attributes to ensure the form data is sent to the correct PHP file for processing.
Hi @srkajolfan6341, If your database connection is correct but the data isn't enrolling, check for any SQL errors and ensure your form data is being correctly sent to your PHP script. Double-check your query and make sure you're using the correct table and field names. Let me know if you need more help! 👍
Hi @user-sq5ho3ri5s, I appreciate you reaching out, and I'm sorry to hear that you're experiencing trouble with the header redirect. There could be a few reasons why it's not working as expected. Here are some things to check: - Errors or Output: Make sure there are no PHP errors or output before the header function is called. Even a single space or newline before the header function can prevent it from working. - Session Start: Ensure that you have session_start() at the beginning of your PHP files, especially before using session variables or attempting to redirect. If the issue persists, consider checking your server logs for any error messages. Additionally, you may want to share the relevant section of your code for a more detailed analysis. I hope this helps! Feel free to ask if you have further questions or need additional assistance.
I'm sorry to hear that you're experiencing issues with the alerts in your code. Please review your codes and ensure there are no syntax errors or typos that might be causing the alerts to malfunction. Double-check the syntax and placement of your alert code.
Heyy!! pls help to fix my error even after copying the same login code my form is not validating even for wrong password it is navigated to the nxt page. Help me to fix this issue
Hi @meghanam.d7494, I'm sorry to hear you're experiencing issues. Let's troubleshoot this together. A few things to check: - Form Validation: Ensure that your form validation logic is correctly implemented. Double-check that the password validation is working as expected. You may want to review the validation conditions and make sure they align with your requirements. - Redirection: Verify the redirection code after the login attempt. Ensure that it redirects only when the validation is successful. If the wrong password is entered, it should not navigate to the next page. If you can share snippets of your code related to form validation and redirection, I'd be happy to take a look and provide more specific assistance. Also, make sure that there are no typos or syntax errors in your code. Feel free to provide more details or code snippets, and I'll do my best to help you fix the issue!
Is the data base important? I use MariaDB and it doesn‘t work. I copied everything. The connections works but my registration is not in the data base that‘s why I can‘t log in
Thank you for your comment and bringing up the issue you encountered while following the tutorial on creating a login and registration form with PHP and MySQL. It can be frustrating when the registration process shows a success message but the data is not visible in the database. Here are a few possible explanations for this issue: - Database Configuration: Double-check your database configuration details such as the database name, username, password, and hostname. Ensure that you have provided the correct information in your PHP code to establish a connection with the database. - Table Name and Structure: Verify that the table name used in your PHP code matches the actual table name in your database. Additionally, confirm that the table structure (columns and their data types) is set up correctly to accommodate the registration data. - Submit Validation: Check if there is any validation logic in your PHP code that might prevent the registration data from being saved to the database. Ensure that the validation rules are correctly implemented and allow valid data to be stored. I hope this helps you troubleshoot the issue with the missing registration data. If you have any further questions or require additional assistance, please let me know.
Hi @cr4zy4scy, I understand you're having trouble with the header redirection after login. A couple of things you might want to check: - Redirect Location: Ensure that your header redirection is set to the correct location. After a successful login, it should redirect to the index page. Double-check the URL and path specified in the header('Location: ...') function. - Session Status: Confirm that your login session is being properly set. If the login session isn't established, the script might redirect to the login page. Check your session initialization and make sure it's set upon successful login. I hope this helps! Let me know if you have more details or if there's anything specific you'd like assistance with.
In phpMyAdmin, it is not normal for the password to default to 0. The default password value depends on the configuration of your database table. It's possible that you have a default value set as 0 for the password column in your table, which may be causing the issue.
Hi @Artbyrishi1019, If MySQL is not accepting data, check for any SQL errors and ensure your database connection is working correctly. Verify that your table structure matches the data you're trying to insert. If you share more details about the error, I'd be happy to help troubleshoot! 👍
Warning:mysqli_num_rows()expects parameter 1 to be mysqli_result, boolean ... How can solve it You already said in tha comment but i don't understand what you have said
Hi @OneAndOnlyQueen22! The warning means that mysqli_num_rows is expecting a mysqli_result but received a boolean. This usually happens when there's an error in your SQL query. Check your query for any syntax errors and ensure it's returning a result set. If you need further clarification, let me know!
Thanks for your comment! The login and registration form demonstrated in this video is specifically designed for this tutorial and focuses on PHP and MySQL authentication. While the code can be a great starting point for building login systems for other projects, it might require some modifications to suit different scenarios or additional features. If you have a specific use case or need guidance on adapting this code for a different login system, I'd be more than happy to help! Please let me know more about what you're trying to achieve, and I'll do my best to assist you.
this error keep showing Warning: Trying to access array offset on value of type int in C:\xampp\htdocs\Project\homepage\login.php on line 9.... How to fix this?
Hi @jovelynfabie7089, It looks like you're encountering a PHP error related to array offsets in your login.php file. The warning indicates that you are trying to access an array offset on a value of type int at line 9. To help you fix this issue, I'd need to see the relevant code snippet around line 9 in your login.php file. However, based on the error message, it seems like you might be trying to treat an integer as an array. Make sure that the variable you're trying to access at line 9 is actually an array before attempting to use array offsets. You may want to check the variable's type using functions like is_array() or ensure that it is initialized properly. If you can share the code snippet around line 9, I'd be happy to provide more specific guidance. Additionally, double-check the data types you're working with and ensure that they align with your expectations. Hope this helps! Let me know if you have further questions.
- Check if there are any errors in your code that might prevent the data from being inserted into the database. You could try debugging your code and checking for any syntax errors, typos or incorrect variable names. - Verify that the connection between your PHP code and the database is established successfully. Make sure that you are using the correct database credentials and that the database server is running.
Thank you for pointing that out. You are correct. In the video, XAMPP is being used as the server software, which includes MySQL as one of its components.
Please help I have downloaded your source code but it is not storing data from registration file. Everything else is ok. If I insert data in phpmyadmin manually then login works with those data but when I go for registration it says registration successful but It does not store any data in the table, then If I go for login with that data it says User Not Registered. Can you please check if everything ok with the source code...or please say what is my fault
I'm glad to hear that you successfully created the login and registration form! For adding a referral URL feature to your complete website, I'll consider making a video tutorial soon. Stay tuned!
Hi @hufaizenbesitzer, For security reasons, it's important not to store or expose user login credentials. Instead, use proper authentication methods and securely hash passwords. Let me know if you need help with secure login implementation! 👍
Hi @bangrajee9215, I'm sorry to hear that you're facing issues with the script. Let's work together to figure this out. A few things you might want to check: - JavaScript Console: Open your browser's console (usually by pressing F12 or right-clicking and selecting 'Inspect,' then going to the 'Console' tab) and see if there are any error messages. This can give you insights into what might be going wrong. - Script Inclusion: Confirm that your JavaScript file is correctly included in your HTML file. Check for any typos or errors in the file path. - Correct Element Targeting: Double-check that you're targeting the correct HTML elements in your script. Typos in element IDs or classes can lead to issues. - Check for Syntax Errors: Make sure there are no syntax errors in your JavaScript code. Even a small mistake can prevent the script from running. If you're still having trouble, feel free to share relevant parts of your HTML and JavaScript code (without any sensitive information), and I'll do my best to help you debug. Happy coding, and we'll get this sorted out together! 🛠️😊
If you're experiencing an issue where XAMPP is inserting the username data into the password field, you may want to check your SQL query or the data being passed into the query to see if there are any errors or mistakes. Make sure that the values you're passing into the SQL query match the correct fields in the database, and that the syntax of the query is correct. Additionally, you may want to check the code that's responsible for handling the data and passing it to the database, to ensure that it's correctly assigning the data to the appropriate variables. If you're still having trouble, please provide more details about your issue and the code you're using, so I can provide more specific guidance.
Hello, thank you for pointing out the warning you encountered in the code. I'm here to help you resolve it! The warning you're seeing, 'mysqli_num_rows() expects parameter 1 to be mysqli_result bool given,' usually occurs when the mysqli_query() function does not return a valid result. It could be due to an issue with the SQL query or a problem with the database connection. To fix this warning, let's do some steps you can follow: - First, double-check your database connection code at the beginning of 'registration.php' to ensure it's set up correctly. Confirm that your database credentials (username, password, host, and database name) are accurate. - Next, check the SQL query on line 13. Ensure that the query is valid and properly formatted. It should be a SELECT query that retrieves data from the database. Verify that the table name and column names are correct. - After running the SQL query, you need to fetch the result using mysqli_query() and store it in a variable. Then, you can use mysqli_num_rows() on that result to get the number of rows returned by the query. If you still encounter issues after following these steps, please let me know, and I'll be glad to assist you further. Understanding and resolving errors is an integral part of the learning process, and together, we can tackle this!
Great vid mate it’s exactly what I’ve been trying to find this whole week!
I have a few tips for people looking to use this on their websites, make sure you use some form of encryption for passwords
I couldn't agree more with you! Thank you for your awesome tips.
Best video on TH-cam ji me php ke in 3 concept ko achhe se perform kar ke bataya gya ho . ❤
Hey @dharmemdrarathore4424,
Dil se shukriya! 🙏 I'm thrilled to hear that you found the video helpful in mastering these essential PHP concepts. Your kind words mean a lot! If you have any more questions or if there's anything specific you'd like to learn next, feel free to let me know. Happy coding, and thanks for being a part of our learning community! ❤️🚀
Legend right here! Very clear, straight to the point!
Subbed!!!!!!
Thank you for your awesome feedback! I really appreciate your kind words and I'm glad you found the tutorial clear and helpful. Welcome to the channel - I'm excited to have you as a subscriber! If you ever need more assistance or have questions about future content, don't hesitate to ask. Keep up the great work with your login and registration form project using PHP and MySQL! 🙌🎉
This kind words from you make me want to learn more about coding! Other channels completely ignored questions. Thank you! @@DavidGTech
You're much welcome!!!
No time waste , to the point ❤
Thank you for your positive feedback! We're glad to hear that you found the video helpful and appreciate your comment. Our goal is always to provide clear and concise information to help viewers understand the topic efficiently, without wasting their time. If you have any further questions or suggestions, please feel free to let us know.
@@DavidGTech thanks ❤️ already, will let you know when a new idea comes to my mind
Thank you so much!!!
Perfect explained with saying anything 🙌
Thank you for your suggestion!!!
Works perfectly!
Awesome! Glad to hear it. Thank you for watching.
Perfect tutorial you know coding with music like this not oy makes coding fun but takes the coder through a world of nostalgia due to the music I felt like i was back in 2016
I appreciate your feedback! It's great to know that the music helped create a fun and nostalgic atmosphere while coding.
Thanks mate for the help. I was stuck here at creating and destroying sessions👍
Glad I could help
Thanks for your coding it's really working
Thank you for watching!
omg perfect simple outline of html ... css I will add
it :)
Thanks for watching!
thank you sir , your vedio is very helpfull to me and all the best for more vedios.
You're welcome, thanks for watching!
It's very usefull for me bro very thanks for user video🙏🙏🙏
You're welcome! I'm glad to hear that you found the video useful. If you have any further questions or if there's anything else I can assist you with, please don't hesitate to let me know.
awesome....I learned a lot
Hi @ajiedelacruz5836,
Thank you so much for your kind words! I'm thrilled to hear that you found the video helpful and that you've learned a lot. If you have any more questions or if there's anything specific you'd like to explore further, feel free to let me know. Your success in learning and implementing is my priority!
Happy coding, and keep up the awesome work! 💻🚀
Thanks dude, you're my savior
Thanks for your kind words! I'm happy to hear that my content is useful to you
Thankyou sir at the end I got it ..
Hi @itsmasters6759,
Glad to hear you got it! 😊 Thank you for watching!
man gye gurur apne kam time me itna cche se btaya kayi log to time weste kerte he
Hey @jay-shree-ram9 ,
Bahut shukriya! I'm glad to hear that you found the tutorial helpful and appreciate the time efficiency. My goal is to make the learning process smooth for everyone. If you have any questions or need further clarification, feel free to ask. Happy coding! 😊🚀
Woowww so helpful
Thank you buddy 😅
You're most welcome buddy!!! Thanks a lot for watching!!!
Very good toturial
Thank you...
Thanks for your tutorial it's really working
You're welcome
You're the savior
Thank you for watching bro...
thanks a lot among the best content everr
You're welcome! Thanks for watching
Ossum gurujii 🎉,, very clearify and simple
Great video it very helpful to my project good job bri
amazing content!
👌
Password type
Thank you so much!
You're welcome, buddy
oh my god, W for this guy
Thank you!!!
Amazing method
Thank you so much for your kind words! I'm thrilled to hear that you found the method amazing. If you have any further questions or need assistance with anything else, please don't hesitate to reach out. Keep up the great work with your login and registration form project using PHP and MySQL! 🌟
@@DavidGTech I hope you'll reach more audience and subscribers soon. Because your video has a lot of point for peoples who want learn about programming. You deserve it. Can't you make video like this but with an explanation, don't fast motion the video. Just originally.. I'll be enjoy the explanation. 🙂🙂🙂
thank you my friend very helpful video keep it up !!
You're welcome!!! Thanks for watching
terima kasih banyak bang, saya jadi semangat untuk belajar Mysql
semangat teruss... sudah saya subscribe dan support
Iya, masama... Thank you juga udah nonton dan subscribe...
THANKYOU VERY MUCH
You're very welcome @MUSIC-fg6ip
its really helpful sir, thank you sir
You're welcome!!! Thank you for watching...
thx a lotttt david
You're welcome!!! Thanks for watching...
Working properly, thanks po for new learnings and ideas
Glad to hear that! You're welcome, thanks for watching!
Tysm bro!
You're very welcome @alucardthamuz5238!!!
Super ❤
Thanks 🔥
what is text editor you are using? can use vs code?
I was using Atom then, but now I am using vs code, and sure you can use vs code!
thanks alot bro
Hi @ronanhruti! You're welcome! Glad I could help. If you have any more questions, feel free to ask!
thank's dude
You're welcome! Thanks for watching
Thanks
You're very welcome!!! Thanks for watching!!!
Good
Thank you!!!
love u bro
Thank you!!!
Can i ask, so sessions are the way you store id for a user throughout a website for example im making a social netwoek so i wanna be able to use user id through many pages
Yes
Thank you so much David G Tech, this video really helped me with my project.
How can one add hashed password function.
You're very welcome! I'm glad to hear that my video was helpful for your project.
Regarding your question about adding a hashed password function, you can use a hash function like "password_hash()" in PHP to securely hash passwords. Here's an example:
$password = 'myPassword123';
$hashed_password = password_hash($password, PASSWORD_DEFAULT);
I hope that helps! Let me know if you have any further questions or if there's anything else I can help you with.
@@DavidGTech You are most welcome.
thank you very much
You're welcome! Thank you for watching...
The amount of php here is more than my entire 4 years university, dark comedy 😢😐
I appreciate the humor in your comment! 😄 Developing a login and registration system with PHP and MySQL can indeed feel like diving into a deep pool of code, especially if you're new to it. It's like a crash course in web development, right?
But don't worry; it gets easier with practice. The world of coding can be vast, and it's normal to feel overwhelmed at times. The important thing is that you're taking the initiative to learn and explore these concepts.
If you have any specific questions or if there's a particular part of the code that's giving you trouble, feel free to ask. I'm here to help and break down the complexities of PHP into more digestible bits. Remember, every coder has been through this phase, and it's all part of the learning journey. Keep coding, and you'll be amazed at how much you can accomplish! 💻🚀
@@DavidGTechits not humor 🥲
good job
Thank bro
You're welcome!!! Thank you for watching...
hello how are you? thank you very much for this class it saved me a lot, you could do it with image sending
You're very welcome! Thanks for watching...
@@DavidGTech thanks you thank you your channel teaches well
Good
Thanks!
Hello, I have a error, when I try to register, I get directed to a white window with nothing written and no changes on the database, could you help me please ? I would really appreciate it.
There must be something wrong with your code. If you want the full source code, contact my gmail. Thank you for watching.
@@DavidGTech Hello David, I sent you an email, thank you.
Okay
Hello. Can i ask for a code of this😊
great video thanks
Glad you enjoyed it! You're welcome!!!
Files downloaded and reglog imported, registration successful but not showing up on localhost, is there something I missed or failed to configure in wamp?
If you put the downloaded files in htdocs folder, then it must be showing up on localhost
@@DavidGTech I did the registration and it returned successfully but the added record doesn't show up in the table.
Make sure that your database and table name are right like in the video
Sorry,my English is not good
I just copied from your source code,but I can't registered a new user on website
After I registered it wrote Registration Successful, but there is no new data in my database
I have tried to add it directly to the database, it can work
How to fix it?
never mind,i fixed it
Thank you for your video
Nice!!! You're welcome! Thanks for watching.
how did you fix it
👌
Thank you for watching!
Thanks
You're welcome!!! Thanks for watching...
Bang di gua kok pas registrasi berhasil tetapi data nya kga Bisa masuk di Database padahal sama seperti di video dari awal ampe akhir ... Ada solusi kah 🙏??
Kayanya ada kode yang ketinggalan sedikit, kalau kodenya full sama seperti yang di video pasti harusnya berhasil sih. Coba aja copas source codenya yang ada di deskripsi video. Thank you for watching
@@DavidGTech
Thx Saran nya Bang Kelupaan Saiya Ternyata Yang salah Di bagian Database nya bang ...
Tipe data yang saya buat semuanya Pada Integer ga ada yang tipe Varchar buat nama, email, dan passwordnya ....awkwkw
Thx bro... ilmunya... Dah. Bisa..
Wkwkwk sip, masama.
what is the app that hes using?
I'm using Atom as a text editor
Bang mau nanya pas isi datanya di localhost dah berhasil tp pas di cek di databasenya nama gak sesuai yang tadi saya input nama jadi nama username jadi username gtu itu kira2 kenapa ya?
Coba cek lagi bang kodenya, kalau kodenya semuanya bener pasti berjalan dengan baik. Source code ada di deksripsi (gratis) yah. Thank you udah nonton.
@@DavidGTech udah bang udah work mksih videonya bang
Wkwkw ok sip, makasih udah nonton.
Secure PHP Authentication ?
Hi @user-xq1yu8rh4h,
Great question! Securing PHP authentication is crucial for protecting user data. Here are a few key tips:
- Use Prepared Statements: When interacting with the database, use prepared statements to prevent SQL injection attacks.
- Hash Passwords: Always hash passwords using a secure hashing algorithm (e.g., bcrypt). Never store plain text passwords in your database.
- Session Security: Ensure that your sessions are secure. Use secure session handling, regenerate session IDs, and set appropriate session timeout values.
- Cross-Site Scripting (XSS) Prevention: Sanitize user input and output to prevent XSS attacks. Use functions like htmlspecialchars() when echoing user data.
- SSL/TLS: Implement SSL/TLS to encrypt data during transmission, especially when handling login credentials.
- Brute Force Protection: Implement measures to prevent brute force attacks, such as account lockout mechanisms or CAPTCHAs.
- Validate User Input: Validate and sanitize all user input to prevent various types of attacks.
Remember, security is a multi-layered approach, and staying informed about the latest security practices is essential. If you have specific questions or need more detailed guidance, feel free to ask!
Happy coding, and stay secure! 🔒🚀
Bro why you are using require config.php pls tell me ...
Because the connection to MySQL database is in config.php
Halo kak, saya sudah import database dengan nama database yang sama, codenya langsung coba tanpa diubah ubah tapi tetep ga nambah di database tb_user setelah registrasi kak
Coba pakai source codenya dah, kayanya ada yang salah kodenya. Kalau kodenya lengkap dan databasenya sama persis pasti bisa sama seperti yang ada di video. Thank you udah nonton
why did you take a blank in ther first place here? please explain
$query = "INSERT INTO user VALUES ( ' ' ,'$name','$username','$email','$password')";
@RoniKarmakar-sk9vm Hi there! Good question. The reason for leaving a blank in the first place is to handle the AUTO_INCREMENT feature in MySQL. Typically, this blank corresponds to the id column, which is set to auto-increment.
When you use an AUTO_INCREMENT column, you don't need to specify a value for it in your INSERT statement; MySQL will automatically generate a unique value for it.
What changes would be made if I want the html and php coding separate (like the form class line, I’m unsure) ?
@Richboss04
Hi there! If you want to separate your HTML and PHP code, you can start by creating separate files for each. For example, you can have a file named form.html for your HTML code and another file named process.php for your PHP code. In form.html, you can include a form with the necessary HTML structure, and in process.php, you can handle form submission and interact with your database using PHP. Remember to use appropriate form actions and method attributes to ensure the form data is sent to the correct PHP file for processing.
Actually my database connection with php has been done correctly but my data does not enrolled into database plz help me ...
Hi @srkajolfan6341,
If your database connection is correct but the data isn't enrolling, check for any SQL errors and ensure your form data is being correctly sent to your PHP script. Double-check your query and make sure you're using the correct table and field names. Let me know if you need more help! 👍
thanks bhaiyaaa
Sad the header redirect not working:
Hi @user-sq5ho3ri5s,
I appreciate you reaching out, and I'm sorry to hear that you're experiencing trouble with the header redirect. There could be a few reasons why it's not working as expected. Here are some things to check:
- Errors or Output: Make sure there are no PHP errors or output before the header function is called. Even a single space or newline before the header function can prevent it from working.
- Session Start: Ensure that you have session_start() at the beginning of your PHP files, especially before using session variables or attempting to redirect.
If the issue persists, consider checking your server logs for any error messages. Additionally, you may want to share the relevant section of your code for a more detailed analysis.
I hope this helps! Feel free to ask if you have further questions or need additional assistance.
Some of the alerts are not popping while others are working fine. Could you please help? Used the same code as yours.
I'm sorry to hear that you're experiencing issues with the alerts in your code. Please review your codes and ensure there are no syntax errors or typos that might be causing the alerts to malfunction. Double-check the syntax and placement of your alert code.
Heyy!! pls help to fix my error even after copying the same login code my form is not validating even for wrong password it is navigated to the nxt page. Help me to fix this issue
Hi @meghanam.d7494,
I'm sorry to hear you're experiencing issues. Let's troubleshoot this together. A few things to check:
- Form Validation:
Ensure that your form validation logic is correctly implemented. Double-check that the password validation is working as expected. You may want to review the validation conditions and make sure they align with your requirements.
- Redirection:
Verify the redirection code after the login attempt. Ensure that it redirects only when the validation is successful. If the wrong password is entered, it should not navigate to the next page.
If you can share snippets of your code related to form validation and redirection, I'd be happy to take a look and provide more specific assistance. Also, make sure that there are no typos or syntax errors in your code.
Feel free to provide more details or code snippets, and I'll do my best to help you fix the issue!
Is the data base important? I use MariaDB and it doesn‘t work. I copied everything. The connections works but my registration is not in the data base that‘s why I can‘t log in
The database is very important. You should use MySQL not MariaDB
It shows me *Registration successful* but I don't see it in my database
Thank you for your comment and bringing up the issue you encountered while following the tutorial on creating a login and registration form with PHP and MySQL. It can be frustrating when the registration process shows a success message but the data is not visible in the database. Here are a few possible explanations for this issue:
- Database Configuration: Double-check your database configuration details such as the database name, username, password, and hostname. Ensure that you have provided the correct information in your PHP code to establish a connection with the database.
- Table Name and Structure: Verify that the table name used in your PHP code matches the actual table name in your database. Additionally, confirm that the table structure (columns and their data types) is set up correctly to accommodate the registration data.
- Submit Validation: Check if there is any validation logic in your PHP code that might prevent the registration data from being saved to the database. Ensure that the validation rules are correctly implemented and allow valid data to be stored.
I hope this helps you troubleshoot the issue with the missing registration data. If you have any further questions or require additional assistance, please let me know.
you saved my ass
Glad to hear that, thanks for watching!!!
Terimakasih banyak 🙏
Sama-sama
bang, session saya kok gk tersimpan ya? udah pas padahal kode nya. bisa bagi source code nya bang?
Sbb, bisa, email saya aja yah langsung davidgarciasaragih7@gmail.com
@@DavidGTech sorry bang sudah solved, saya ada salah ketika query nya , $row['id'] . ternyata id user saya $row['user_id']😁
Wkkwkwk sip mantap 👍🏿👍🏿
what php studio didyou use?
I use Atom as my text editor
The header is not redirecting to the index page, it redirects to the login page after login
Hi @cr4zy4scy,
I understand you're having trouble with the header redirection after login. A couple of things you might want to check:
- Redirect Location:
Ensure that your header redirection is set to the correct location. After a successful login, it should redirect to the index page. Double-check the URL and path specified in the header('Location: ...') function.
- Session Status:
Confirm that your login session is being properly set. If the login session isn't established, the script might redirect to the login page. Check your session initialization and make sure it's set upon successful login.
I hope this helps! Let me know if you have more details or if there's anything specific you'd like assistance with.
Is it normal that in phpadmin, the password default as 0 and it kept show up wrong password eventually, how can I do so?
In phpMyAdmin, it is not normal for the password to default to 0. The default password value depends on the configuration of your database table. It's possible that you have a default value set as 0 for the password column in your table, which may be causing the issue.
MySQL is not accepting data what to do?
Hi @Artbyrishi1019,
If MySQL is not accepting data, check for any SQL errors and ensure your database connection is working correctly. Verify that your table structure matches the data you're trying to insert. If you share more details about the error, I'd be happy to help troubleshoot! 👍
Make the action = php server self , I have also faced that problem
Warning:mysqli_num_rows()expects parameter 1 to be mysqli_result, boolean
... How can solve it
You already said in tha comment but i don't understand what you have said
Hi @OneAndOnlyQueen22! The warning means that mysqli_num_rows is expecting a mysqli_result but received a boolean. This usually happens when there's an error in your SQL query. Check your query for any syntax errors and ensure it's returning a result set. If you need further clarification, let me know!
1:04 what app is that?
Atom (text editor)
this can do other login
Thanks for your comment! The login and registration form demonstrated in this video is specifically designed for this tutorial and focuses on PHP and MySQL authentication. While the code can be a great starting point for building login systems for other projects, it might require some modifications to suit different scenarios or additional features.
If you have a specific use case or need guidance on adapting this code for a different login system, I'd be more than happy to help! Please let me know more about what you're trying to achieve, and I'll do my best to assist you.
@@DavidGTechi swear you are best 😢❤❤❤❤
this error keep showing
Warning: Trying to access array offset on value of type int in C:\xampp\htdocs\Project\homepage\login.php on line 9.... How to fix this?
Hi @jovelynfabie7089,
It looks like you're encountering a PHP error related to array offsets in your login.php file. The warning indicates that you are trying to access an array offset on a value of type int at line 9.
To help you fix this issue, I'd need to see the relevant code snippet around line 9 in your login.php file. However, based on the error message, it seems like you might be trying to treat an integer as an array.
Make sure that the variable you're trying to access at line 9 is actually an array before attempting to use array offsets. You may want to check the variable's type using functions like is_array() or ensure that it is initialized properly.
If you can share the code snippet around line 9, I'd be happy to provide more specific guidance. Additionally, double-check the data types you're working with and ensure that they align with your expectations.
Hope this helps! Let me know if you have further questions.
i already copy the source code but still error how can fix this can I get the whole codes?
The source code is the whole codes, please make sure that your database is correct too like in the video
Unchaught error call to undefined mulu di line isset, apa harus downgrad xampp y?
Enggak, itu biasanya ada kesalahan di kodingannya :)
@@DavidGTech gw udah cek sama persis gak bisa, akhirnya ganti kodingan koneksi baru bisa. Btw thanks bg, video lain pada gk work cuma ini yg work
Oke, mantap 👌, makasih banyak udah nonton
After i successfully register. It cannot stored in my database. What should I do?
- Check if there are any errors in your code that might prevent the data from being inserted into the database. You could try debugging your code and checking for any syntax errors, typos or incorrect variable names.
- Verify that the connection between your PHP code and the database is established successfully. Make sure that you are using the correct database credentials and that the database server is running.
After filling and submitting the registration form it says this page is not working
Local host is currently unable to handle this request
Download the source code .php and .sql (link in the description)
Or maybe something wrong with your localhost server
It is xamp server instead of mysql software
Thank you for pointing that out. You are correct. In the video, XAMPP is being used as the server software, which includes MySQL as one of its components.
Sir mere login krne pr intenal server error bta rha please btaye m kya kru
Speak English please...
Please help
I have downloaded your source code but it is not storing data from registration file.
Everything else is ok.
If I insert data in phpmyadmin manually then login works with those data but when I go for registration it says registration successful but It does not store any data in the table, then If I go for login with that data it says User Not Registered.
Can you please check if everything ok with the source code...or please say what is my fault
It says registration is successful but it is not saving any data in the database...registration is not working..Please check and inform
Okay, I will check the source code first. Please, wait ;)
Thanks for the response!
Was I making mistake or Was the source code ok?
The source code is OK.
My advice is to follow the video carefully... Because based on people experience, they have succeeded.
hi i create this it ok, i need create refarral url lik with complete web site place i need video.
I'm glad to hear that you successfully created the login and registration form! For adding a referral URL feature to your complete website, I'll consider making a video tutorial soon. Stay tuned!
GOAT
can i somehow see the login credentials of users?
Hi @hufaizenbesitzer,
For security reasons, it's important not to store or expose user login credentials. Instead, use proper authentication methods and securely hash passwords. Let me know if you need help with secure login implementation! 👍
How about with hash password?
why does my script doesnt work? it doesnt appear the alert text
Hi @bangrajee9215,
I'm sorry to hear that you're facing issues with the script. Let's work together to figure this out. A few things you might want to check:
- JavaScript Console: Open your browser's console (usually by pressing F12 or right-clicking and selecting 'Inspect,' then going to the 'Console' tab) and see if there are any error messages. This can give you insights into what might be going wrong.
- Script Inclusion: Confirm that your JavaScript file is correctly included in your HTML file. Check for any typos or errors in the file path.
- Correct Element Targeting: Double-check that you're targeting the correct HTML elements in your script. Typos in element IDs or classes can lead to issues.
- Check for Syntax Errors: Make sure there are no syntax errors in your JavaScript code. Even a small mistake can prevent the script from running.
If you're still having trouble, feel free to share relevant parts of your HTML and JavaScript code (without any sensitive information), and I'll do my best to help you debug.
Happy coding, and we'll get this sorted out together! 🛠️😊
sorry, i have a problem with $conn undefined variable
Make sure that you have included config.php file
Hello, how do you do this with JUST a username and password, and without password check?
I do this with a password check for users who want to login
How should I fix xammp it is inserting data of username into password ?
If you're experiencing an issue where XAMPP is inserting the username data into the password field, you may want to check your SQL query or the data being passed into the query to see if there are any errors or mistakes.
Make sure that the values you're passing into the SQL query match the correct fields in the database, and that the syntax of the query is correct. Additionally, you may want to check the code that's responsible for handling the data and passing it to the database, to ensure that it's correctly assigning the data to the appropriate variables.
If you're still having trouble, please provide more details about your issue and the code you're using, so I can provide more specific guidance.
Please help
Undefined variable $row
There must be something wrong with your code. If you want the full source code, contact my gmail. Thank you for watching.
warning mysqli_num_rows() expects parameter 1 to be mysqli_result bool given ...
how ti fix that on line 13 in registration. php
Hello, thank you for pointing out the warning you encountered in the code. I'm here to help you resolve it!
The warning you're seeing, 'mysqli_num_rows() expects parameter 1 to be mysqli_result bool given,' usually occurs when the mysqli_query() function does not return a valid result. It could be due to an issue with the SQL query or a problem with the database connection.
To fix this warning, let's do some steps you can follow:
- First, double-check your database connection code at the beginning of 'registration.php' to ensure it's set up correctly. Confirm that your database credentials (username, password, host, and database name) are accurate.
- Next, check the SQL query on line 13. Ensure that the query is valid and properly formatted. It should be a SELECT query that retrieves data from the database. Verify that the table name and column names are correct.
- After running the SQL query, you need to fetch the result using mysqli_query() and store it in a variable. Then, you can use mysqli_num_rows() on that result to get the number of rows returned by the query.
If you still encounter issues after following these steps, please let me know, and I'll be glad to assist you further. Understanding and resolving errors is an integral part of the learning process, and together, we can tackle this!
Paspasa pud ui
Hi @user-bt6xz8ti4e,
Could you please provide more details about the issue you're facing? I'll do my best to help you out! 😊