Like everyone said in the comments, keeeping it simple is the best , also there are viewers from other countries who r not native english speakers hence i believe keeping the english as simple as possible is definitely the way to go . Great Vid.
I'm so sorry to hear that Kelly. In my case I'm dealing with psoriasis, so it isn't nearly as serious as yours. I had to cut my hair in order to give the psoriasis a chance to calm down, since it gets worse over the summer heat.
try eating 2 cups of oats with hot water and banana for a week and see what happends. Itworked for me on head skin issues. I hope you all get well soon.
Okay, now this channel is a true real gem for me, it has everything. Maybe it will affect the algorithm a little bit, but that's not all the point of this, the true thing that matters is the lives you have changed with this golden information.
Man, you are fantastic. I am developing a CRM with freelance developers. But things got expensive and quite slow (we are 10 months into the project). To speed things up I decided to learn web programming and create certain portions of the CRM. I did quite well with HTML, CSS and JavaScript, but when i got to the database part I got stuck until I found your videos. Big thank you!
Thank you krossing, you have helped me complete a final year php project with these tutorials. straight foward and easy to learn, I couldn't have asked for more. Be blessed
I've been watching your videos for a few years now and they are easily some of the best out there in terms of explantation and clarity , keep up the great work!
Your videos are absolutely the best! You go above and beyond other instructors. You not only explain things perfectly, but you show us all that we need to know about the code and ways you can implant it into our own. Your series is the golden tutorial for anybody learning PHP and even things most videos don't teach such as PHP security which is a must for anybody learning to make their own website using PHP.
Dani, I've been following your videos and I love them. You present information clearly, your voice is nice to listen to and it's easy to move around/skip parts I may already know. Thank you for offering these videos for free, it means a lot.
Really awesome series, I followed your last one and now I'm following this one and the slight changes to the code are really helping me understand the differences and what impacts what. Looking forward to more
awesome tutorial I have yet to see your other videos but POD caused me quite a headache since I am working with docker containers as my test environment so I had to improvise for the mysqli connection would be great to have that option as video 22.1 with the bells and whistles you have for this video Overall thank you very much
Dani Thank you for your lessons. I learned a lot. I just created my sample form and now I will work on creating the real one. I manage to get the database connection part working and loading the data. So I am quiet happy as to how far I got. Thanks again.
Hi Dani, I have just come across your excellent video whilst searching for a solution to passing data from an ESP32 sensor into an SQL database. I have very limited knowledge of this kind of subject but I am able to follow your instructions very easily but I would like to know if I can use this method to pass the data instead of from a web form but from an ESP32 sensor. I have already tried several solutions but I keep getting stuck at the point of passing the sensor data to the .php file. Again, due to my complete lack of knowledge and understanding of this subject I just seem to be going around in circles. I would really appreciate any pointers you could give me. I will try and follow your PHP full course videos to help me better understand. Thanks in advance.
Nice tutorial. I'm following all classes since the number one. This is the most confusing to me, I think it's due the concept of object in PHP not been explained yet. Even dough, great course. Hope you got your hair back at this point.
please I have a question. I am looking into your tutorials. talking about prepared statement, it is used so that a code will not be injected into the data base. but subsequently, when the same data is grabbed from the code and inserted in the data base, if there is a code there that can destroy the data base, wont it still work? please explain further. Thank you
Your series has been very helpful and informative. Thank you for putting it together. I have had an issue with this last video. No matter where I access the the formhandler.inc.php file whether in the includes folder or the project folder i am getting a "Forbidden You don't have permission to access this resource. Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 Server at localhost Port 80" error. Any ideas?
excellent lesson Dani, sorry to see your hair gone. Oh BTW query in English is said "kwee-ree" when spelt phonetically. Hope you don't mind as your English is way, way better than my Danish.
Thank you, yes the hair is a shame, but at least it has gotten a chance to calm my psoriasis a bit. 🙂 and thanks for the tip on query. The “kwe” is hard for Scandinavians to pronounce, same with “thr” hehe. I’ll practice it and see if I manage to say “query” without tying up my tongue in a knot 😂
Thank your Dani, your teaching is so helpful. I am having an issue with connection failed 1044 Access denied for user ''@'localhost' to database 'mydatabasename' when trying to submit my form into database. Password is correct, privileges are granted. Verrified no password is set, root, local host. Even tried giving it a password and get the same error. I can insert into database directly from phpMyAdmin but not remotely by php from form.
In formholder.in.php i added the location but when i click the submit button i am getting the code of my formholder.inc.php code instead of going back to the previous location....what might be the error here... ??
Help I followed the instructions, but then I clicked the sign in this shows up " Not Found The requested URL was not found on this server. Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4 Server at localhost Port 80 "
Please help me out, Hello. I have a button called register that takes care of inserting the users' input into the database. But when i clicked on the button, it showed me the code I inputted for the phpcode for the connection to my database
Did this and getting request denied. Contacted host and they told me my credentials are right and it's the code. Just so lost right now :/ Edit: I fixed it!
Hi Dani - Your series about using SQL from the website is helping me a lot! However, when I follow along the video to the "Positional parameters Prepared Statement" section, I tried to type-in a new user for sign up so that it can get upload to the database. Instead of that, I keep getting this error and cannot solve it. Do you have any ideas in how to solve that? (I do find out about something that related to 'mySQL default socket' inside the XAMPP folder but all of the fix where mainly the cause from WordPress db sever). "Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)"
Hello Mr Dani, thank you for all your good work. I implemented similar thing but this is the error I am getting, "Insert value list does not match column list: 1136 Column count doesn't match value count at row 1". Can you help?
Ignore my challenge please. I was the one who made an error, after a careful check, I discovered I forgot to put a comma (,) in between 2 placeholder question marks.
Hey dear! How may i save images as well as display images? I dont think pgpmyadmin svars images? I am looking forward to nobody but your help. Thank you!
Hello, I have a question, hope you can answer. How do I open a file index.php in the browser? If I do it the regular way it returns just the code inside the file. Thanks)
I show how in the first two videos in my PHP playlist 🙂 you gotta make sure you open the site, using your local server, and not by just opening the index file directly in the browser.
quick question I keep getting this message after pressing the button "Query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'username' cannot be null" and it won't send the data to my phpmyadmin database. Do you know how to fix this?
Hello Dani please help me sort out this error which state : ***Fatal error: Uncaught Error: Array callback must have exactly two elements in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php on line 2****
Now this ***** Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php:17 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php on line 17***** Anyone with an idea
I need help, I implemented the same code, but once I submitted my first INSERT code the databaase completly crashed and I couldn't even keep it running on the XAMPP
That seems odd… My only guess is that it is a hardware issue, or you somehow looped the query repeatedly until the server crashed. 😅 I don’t see any other explanations…
Both methods are for protecting against SQL injection 🙂 The bindParam() function is just a small part of the overall prepared statement that we create, in order to protect against injection. bindParam() is just used to bind the users data to our statement, using a keyword that we decided using a placeholder like ":username" inside the query. We can do the same when using non-named parameters, which means we don't need to assign the users data to for example a ":username", since we used "?" as placeholders instead. So by using non-named placeholders inside the query using "?" instead, we no longer need to match the placeholder with the data, and can just pass the data directly inside the execute() function as an array. 🙂 Again... It's just two different ways of using placeholders for the parameters. 😊 Both are preventing SQL injection. So choose the one you like more.
I followed this tutorial to the letter but for some reason my database isn’t updating when I use the form. There no error message, so I’m not sure what the problem is. I’ve gone over this video and my code multiple times, I’ve restarted my computer and everything, still doesn’t work. I have no idea why. Help? Love this video series btw.
I need your Help. i do everything and i get this Error. Query failed: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected Can u tell me what else i need to check. Because all files. are good but if i submit i get this message ??? :(
still the same Error Message. Idk if thats important but look at this Code here $dsn = "mysql:host=localhost;dbname = frst_db" the equal before my frst_db i had to put space before and after the equal sign. The only Problem ist when i submit the data. After clicking the button i´ll get this Error. @@Dani_Krossing
@3:22 you mention the ".inc.php" naming convention for files in the "/includes" folder. The explanation was not in the last video but in video "20 | Connect to a Database..." at the 45 second mark. In case anyone is interested: ua-cam.com/video/tHKsZdS8Oug/v-deo.html
the SQL query runs smoothly but why do I get Uncaught Error: Call to undefined function null() when I put the $pdo = null(); $stmt = null(); in the try block?
thank you so much and i have a question what is the deference between this $query = "INSERT INTO users (username, pwd, email) VALUES (?,?,?);"; $stmt->execute([$username, $pwd, $email]); and this $query = "INSERT INTO users (username, pwd, email) VALUES (:username, :pwd, :email);"; $stmt->bindParam(":username", $sername); $stmt->bindParam(":pwd", $pwd); $stmt->bindParam(":email", $email); $stmt->excute(); and which one better or when we use they ?
Each do things slightly different, but it's more from a maintainability point of view. So it's not about "which is safer" or "better". 🙂 The first one is called "positional placeholders", and essentially just match the data you later give it, in the same order as the "?" in the query. So kind of like how arrays work. Where as "named placeholders" allow us to actually label the "?" inside the query, which makes it easier for us as the developer, to know what the "?" are supposed to be. So whether you use one or the other, is more about personal preference, or if your work place demand that you use named parameters, to make it easier to hand off the project to someone else. So basically it's about: "Do you want slightly less code?" or "Do you want the parameters named?" 🙂
@@kylehawks2966 These two videos should help you out. ua-cam.com/video/tHKsZdS8Oug/v-deo.html&ab_channel=DaniKrossing ua-cam.com/video/7ALVC1eWgdI/v-deo.html&ab_channel=DaniKrossing
@@Dani_Krossing I don't mean to be a pest.... but I literally have your code to the letter and using your editor everything I tried the cleaning tables nothing i'll try a pasword
Hi Dani - I keep getting this error and cannot solve it. Any ideas? Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) Warning: Undefined variable $pdo in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php on line 13 Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php:13 Stack trace: #0 {main} thrown in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php on line 13 Thanks!
I’m trying to learn to do his right so its really frustrating to spend a lot of time typing in code and trying to figure out what it is doing only to have you say, but this is not the way we should do it. I don’t care how we shouldn’t do it, only how you should.
@@Dani_Krossing I’m not looking for quick solutions, I’m looking to understand “how to”. I, unlike most, am looking to actually understand what is going on with the software so that I can craft a solution for any situation. I don’t want you to show me your way and then attempt to memorize it as that leaves you with one solution and one solution never fits every problem. I spent most of my life fixing computer hardware. I was very successful at it because I, unlike most, actually knew how the equipment worked. I’m taking that same attitude into learning modern software. The paradigm where we have html, css, javascript on the browser side, http in the middle, with php and sql on the server side is really interesting for me and I enjoy your explanations as I want to know the details. To many sites want you to memorize and copy “their” solution which probably works most of the time. As the software evolves they are left back at the old way because they don’t actually understand what the details are and how they fit. Please don’t take offense, I was just telling how it looks from my side. Regards, Terry
update: brother i am working while studying your course, stuck for this for quite a while now. 3 weeks going strong. still falling in love with your course!
Hi @Dani_Krossing I am truly grateful for your videos. I appreciate your hard work and fantastic explanation. I do face an issue while following along your tutorial, When I submit the form, it states "NOT FOUND: The requested URL was not found on this server." I would truly appreciate it if you can help me. Thank You!
It means that your path inside the "action" of your form, doesn't point to the correct file. 🙂 So either you made a typo in the path, or your files are differently structured than what I do in the video.
Help! I followed the steps outlined. When I click the Submit button I get 404 Not Found Error. What could I've done wrong? The only 3 files I have are the index.php, dbh.inc.php, and formhandler.inc.php. I'm unsure how to fix this. Any help is greatly appreciated. The difference is with the database name, mine is named "ais_db". $dsn="mysql:host=localhost;dbname=ais_db";
Idk why once Iclick submit somehow it puts me in the dbh.inc.php page And The data I sent isn't getting inserted into the database Even tho I eventually copied ur code literally
@@stateofalawites4039 wish i knew what was causing my problem. I enter the form data, hit submit, it goes back to the form index page like it submitted everything. No errors. But nothing in database either. Ugh. I've looked over the code 10 times and its exactly the same.
New look Dan 😂 Thanks for your premium courses Africa is watching
A year ago I was dreaming about making websites and today here I am building one, thank you, your help is much appreciated.
Like everyone said in the comments, keeeping it simple is the best , also there are viewers from other countries who r not native english speakers hence i believe keeping the english as simple as possible is definitely the way to go . Great Vid.
I may have to cut my hair, too. I am dealing with cancer. I pray you are not.
Thank you for your lessons. It's greatly appreciated.
I'm so sorry to hear that Kelly. In my case I'm dealing with psoriasis, so it isn't nearly as serious as yours. I had to cut my hair in order to give the psoriasis a chance to calm down, since it gets worse over the summer heat.
I hope you all get well soon
try eating 2 cups of oats with hot water and banana for a week and see what happends. Itworked for me on head skin issues. I hope you all get well soon.
There is a lot of research now which indicates that you should avoid sugar and carbs to fight against cancer. Also meditate and do yog(a). stay strong
Thanks for simple and clear english, i almost understood everything without subtitle, a lot of loves from Egypt ❤
Okay, now this channel is a true real gem for me, it has everything. Maybe it will affect the algorithm a little bit, but that's not all the point of this, the true thing that matters is the lives you have changed with this golden information.
Great series of videos. I hope everything is okay with your health. Stay strong ❤
You're an amazing tutor. I appreciate your sacrifice of giving us this full packaged php content.
Man, you are fantastic. I am developing a CRM with freelance developers. But things got expensive and quite slow (we are 10 months into the project). To speed things up I decided to learn web programming and create certain portions of the CRM. I did quite well with HTML, CSS and JavaScript, but when i got to the database part I got stuck until I found your videos. Big thank you!
Thank you krossing, you have helped me complete a final year php project with these tutorials. straight foward and easy to learn, I couldn't have asked for more. Be blessed
I've been watching your videos for a few years now and they are easily some of the best out there in terms of explantation and clarity , keep up the great work!
Your videos are absolutely the best! You go above and beyond other instructors. You not only explain things perfectly, but you show us all that we need to know about the code and ways you can implant it into our own. Your series is the golden tutorial for anybody learning PHP and even things most videos don't teach such as PHP security which is a must for anybody learning to make their own website using PHP.
Your channel is the one I have been looking for. You have earned one more loyal subscriber.
You have been so clear in your explanation with every single code that you typed
Dani, I've been following your videos and I love them. You present information clearly, your voice is nice to listen to and it's easy to move around/skip parts I may already know. Thank you for offering these videos for free, it means a lot.
Your the best teacher i'ved ever watched! keep up Sir
Really awesome series, I followed your last one and now I'm following this one and the slight changes to the code are really helping me understand the differences and what impacts what. Looking forward to more
thank you for your efforts , better than uni lectures
Kross, you are really saving life with this tutorial. Thanks.
awesome tutorial I have yet to see your other videos but POD caused me quite a headache since I am working with docker containers as my test environment so I had to improvise for the mysqli connection would be great to have that option as video 22.1 with the bells and whistles you have for this video
Overall thank you very much
1 year down the line and we're still enjoying your videos. Thanks for the work.
i don't have nothing to said thank you 😊😊 your contend is other level
Thanks a lot Dani!Awesome Tutorial series :) Please take care of your health!
Dani Thank you for your lessons. I learned a lot. I just created my sample form and now I will work on creating the real one. I manage to get the database connection part working and loading the data. So I am quiet happy as to how far I got. Thanks again.
Thank you for this tutorial!
Thanks a lot Dani for the great tutorials and sharing your knowledge. ❤
BTW, I love your new haircut 💇♂️
You are so cool bro your lessons are so informative, great foundation
great tutorial. Hope you're good man
Great one Dani, keep it up
You are a genius!!! Thanks much
Hi Dani, I have just come across your excellent video whilst searching for a solution to passing data from an ESP32 sensor into an SQL database. I have very limited knowledge of this kind of subject but I am able to follow your instructions very easily but I would like to know if I can use this method to pass the data instead of from a web form but from an ESP32 sensor. I have already tried several solutions but I keep getting stuck at the point of passing the sensor data to the .php file. Again, due to my complete lack of knowledge and understanding of this subject I just seem to be going around in circles. I would really appreciate any pointers you could give me. I will try and follow your PHP full course videos to help me better understand. Thanks in advance.
Nice tutorial. I'm following all classes since the number one. This is the most confusing to me, I think it's due the concept of object in PHP not been explained yet. Even dough, great course. Hope you got your hair back at this point.
My hair is yet again long and full 😄😉 and yes in a few episodes we get into using it together with your PHP code, which will make it make more sense.
this was a starting point to me coding using PHP. i am not sure if you have courses on Udemy.
so prepared statements enable the code to separate between data inputs and the actual sql code to prevent SQL injunction , thank you
You're my ROLE MODEL, I wish you success in everything!
haircut! but also, great series so far - thanks for all your hard work and clear explanations.
Thank you!
whenever i see an ad in your video i click them because, this way i give you something, nobody have taught me PHP in your way.
You mentioned you cut your hair for health reasons, I hope you are doing well today!
I am thanks 🙂 the hair is fully grown out again
Thank you, very good job
please I have a question. I am looking into your tutorials. talking about prepared statement, it is used so that a code will not be injected into the data base. but subsequently, when the same data is grabbed from the code and inserted in the data base, if there is a code there that can destroy the data base, wont it still work? please explain further. Thank you
Your series has been very helpful and informative. Thank you for putting it together. I have had an issue with this last video. No matter where I access the the formhandler.inc.php file whether in the includes folder or the project folder i am getting a "Forbidden You don't have permission to access this resource. Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 Server at localhost Port 80" error. Any ideas?
Hi Dani how many rows can php display?? And can you make it more than 500?
0:20, Bro please take care of your health, im praying from here.
bindParam vs bindValues what are the diff of these two sir?
I have been a fan of your knowlege. I am dealing with a stoke so excuse me. I am running an issue when I "require_once dataObjects.php". Please Help
Hello teacher, I would like to ask a question, I have seen some websites use 2D website ... What should we do? Thank you very much teacher ...
excellent lesson Dani, sorry to see your hair gone. Oh BTW query in English is said "kwee-ree" when spelt phonetically. Hope you don't mind as your English is way, way better than my Danish.
Thank you, yes the hair is a shame, but at least it has gotten a chance to calm my psoriasis a bit. 🙂 and thanks for the tip on query. The “kwe” is hard for Scandinavians to pronounce, same with “thr” hehe. I’ll practice it and see if I manage to say “query” without tying up my tongue in a knot 😂
get well soon dear
Thank your Dani, your teaching is so helpful. I am having an issue with connection failed 1044 Access denied for user ''@'localhost' to database 'mydatabasename' when trying to submit my form into database. Password is correct, privileges are granted. Verrified no password is set, root, local host. Even tried giving it a password and get the same error. I can insert into database directly from phpMyAdmin but not remotely by php from form.
I keep getting same thing,,,Undefined variable $pdo line 13 Formhandler...same problem can I nest the file some how?
After I submit my document I get a 404 error, my folder and website are located in the correct htdocs folder. What could be the issue?
In formholder.in.php i added the location but when i click the submit button i am getting the code of my formholder.inc.php code instead of going back to the previous location....what might be the error here... ??
u got the fix?
Help I followed the instructions, but then I clicked the sign in this shows up
"
Not Found
The requested URL was not found on this server.
Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4 Server at localhost Port 80
"
u got the fix
If I have my website done in wordpress how can i have a page that communicates with the new database?
I got an error when I click signup button "Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)"
Please help me out, Hello. I have a button called register that takes care of inserting the users' input into the database. But when i clicked on the button, it showed me the code I inputted for the phpcode for the connection to my database
Did this and getting request denied. Contacted host and they told me my credentials are right and it's the code. Just so lost right now :/
Edit: I fixed it!
Hi Dani - Your series about using SQL from the website is helping me a lot! However, when I follow along the video to the "Positional parameters Prepared Statement" section, I tried to type-in a new user for sign up so that it can get upload to the database. Instead of that, I keep getting this error and cannot solve it. Do you have any ideas in how to solve that?
(I do find out about something that related to 'mySQL default socket' inside the XAMPP folder but all of the fix where mainly the cause from WordPress db sever).
"Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)"
It's alright now Dani. I have found out the way to fix the issue! 😄
Waiting for next episode!!
Hello Mr Dani, thank you for all your good work. I implemented similar thing but this is the error I am getting, "Insert value list does not match column list: 1136 Column count doesn't match value count at row 1". Can you help?
Ignore my challenge please. I was the one who made an error, after a careful check, I discovered I forgot to put a comma (,) in between 2 placeholder question marks.
Hey dear! How may i save images as well as display images? I dont think pgpmyadmin svars images? I am looking forward to nobody but your help. Thank you!
You're like the Mr Beast of PHP MySQL tutorials. I'm now rich with knowledge now, thanks.
Hello, I have a question, hope you can answer. How do I open a file index.php in the browser? If I do it the regular way it returns just the code inside the file. Thanks)
I show how in the first two videos in my PHP playlist 🙂 you gotta make sure you open the site, using your local server, and not by just opening the index file directly in the browser.
quick question I keep getting this message after pressing the button "Query failed: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'username' cannot be null" and it won't send the data to my phpmyadmin database. Do you know how to fix this?
Uncaught PDOException: could not find driver
i checked and it said Configuration File (php.ini) Path
how do i fix this isssue?
I tried and I keep getting error on my line 32 that undefined pdo
that new look tho!
i used all your codes but am getting an error [HY000] 2006 , server has gone away , please help
does anyone know why after i do $stmt = $pdo->prepare($query);
the rest of the things turn into html
Hello Dani please help me sort out this error which state : ***Fatal error: Uncaught Error: Array callback must have exactly two elements in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php on line 2****
Now this ***** Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php:17 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Socialhub_Php\Includes\formhandler.inc.php on line 17*****
Anyone with an idea
I need help, I implemented the same code, but once I submitted my first INSERT code the databaase completly crashed and I couldn't even keep it running on the XAMPP
That seems odd… My only guess is that it is a hardware issue, or you somehow looped the query repeatedly until the server crashed. 😅
I don’t see any other explanations…
why you didn't use bindParam method when using question mark?
As I explained in the video, we pass it in using an array instead, inside the execute() method. 🙂
@@Dani_Krossing but as I red it is better to use binParam method everytime after prepare statement to secure and prevent sql injection
Both methods are for protecting against SQL injection 🙂 The bindParam() function is just a small part of the overall prepared statement that we create, in order to protect against injection.
bindParam() is just used to bind the users data to our statement, using a keyword that we decided using a placeholder like ":username" inside the query. We can do the same when using non-named parameters, which means we don't need to assign the users data to for example a ":username", since we used "?" as placeholders instead.
So by using non-named placeholders inside the query using "?" instead, we no longer need to match the placeholder with the data, and can just pass the data directly inside the execute() function as an array. 🙂
Again... It's just two different ways of using placeholders for the parameters. 😊 Both are preventing SQL injection. So choose the one you like more.
I followed this tutorial to the letter but for some reason my database isn’t updating when I use the form. There no error message, so I’m not sure what the problem is. I’ve gone over this video and my code multiple times, I’ve restarted my computer and everything, still doesn’t work. I have no idea why. Help? Love this video series btw.
Paste your PHP code here 🙂
@@Dani_Krossing
@@Dani_Krossing
@@Dani_KrossingI keep trying to share my code but I think youtube may be deleting my comments :(
Yeah it sometimes does that. I can see it now. I’ll check it out once I get back to my PC later 🙂
I need your Help.
i do everything and i get this Error.
Query failed: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected
Can u tell me what else i need to check. Because all files. are good but if i submit i get this message ??? :(
It means you didn't select a database for the query. Maybe you made a typo in the databases name in the dbh file.
still the same Error Message. Idk if thats important but look at this Code here $dsn = "mysql:host=localhost;dbname = frst_db" the equal before my frst_db i had to put space before and after the equal sign. The only Problem ist when i submit the data. After clicking the button i´ll get this Error. @@Dani_Krossing
@3:22 you mention the ".inc.php" naming convention for files in the "/includes" folder. The explanation was not in the last video but in video "20 | Connect to a Database..." at the 45 second mark. In case anyone is interested:
ua-cam.com/video/tHKsZdS8Oug/v-deo.html
the SQL query runs smoothly but why do I get Uncaught Error: Call to undefined function null() when I put the $pdo = null(); $stmt = null(); in the try block?
Remove the () 🙂
@@Dani_Krossing mb already saw it after typing this haha
thank you so much and i have a question
what is the deference between this
$query = "INSERT INTO users (username, pwd, email) VALUES (?,?,?);";
$stmt->execute([$username, $pwd, $email]);
and this
$query = "INSERT INTO users (username, pwd, email) VALUES (:username, :pwd, :email);";
$stmt->bindParam(":username", $sername);
$stmt->bindParam(":pwd", $pwd);
$stmt->bindParam(":email", $email);
$stmt->excute();
and which one better or when we use they ?
Each do things slightly different, but it's more from a maintainability point of view. So it's not about "which is safer" or "better". 🙂
The first one is called "positional placeholders", and essentially just match the data you later give it, in the same order as the "?" in the query.
So kind of like how arrays work.
Where as "named placeholders" allow us to actually label the "?" inside the query, which makes it easier for us as the developer, to know what the "?" are supposed to be.
So whether you use one or the other, is more about personal preference, or if your work place demand that you use named parameters, to make it easier to hand off the project to someone else.
So basically it's about:
"Do you want slightly less code?"
or
"Do you want the parameters named?"
🙂
thank you so much ❤❤❤@@Dani_Krossing
I'm getting a 403 code after I submitt but data is going to table,also not getting pop up for the first page is this something to worry about or ....?
I believe that is caused by a incorrect username or password in your dbh.inc.php file.
@@Dani_Krossing I've looked I don't see 1 $dbusername, $dbpassword?......also $dbpassword = "";
@@kylehawks2966 These two videos should help you out.
ua-cam.com/video/tHKsZdS8Oug/v-deo.html&ab_channel=DaniKrossing
ua-cam.com/video/7ALVC1eWgdI/v-deo.html&ab_channel=DaniKrossing
@@Dani_Krossing I don't mean to be a pest.... but I literally have your code to the letter and using your editor everything I tried the cleaning tables nothing i'll try a pasword
I now can't get into my admin ...yes put password in inc file
Hi Dani - I keep getting this error and cannot solve it. Any ideas?
Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
Warning: Undefined variable $pdo in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php on line 13
Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php:13 Stack trace: #0 {main} thrown in C:\xampp\htdocs\MyWebsite\includes\formhandler.inc.php on line 13
Thanks!
I fixed it!
bro im also facing the same error how to fix it
@@BostonPerry-j1m
??
I believe I had to add "root" to both $dbusername and $dbpassword in the database connection page, or delete both and just put ""@@kunalyadav9727
how din you solve it bro?
You look better with long hair :) after ton of advices you gave to us, perhaps we can give one suggestion to you ? :) hehe GL
For health reasons? Are you okay Dani?
Do you know u/colschrapnel from Reddit?
I’m trying to learn to do his right so its really frustrating to spend a lot of time typing in code and trying to figure out what it is doing only to have you say, but this is not the way we should do it. I don’t care how we shouldn’t do it, only how you should.
I am a teaching channel, not a how to channel. I’m sure there are other channels out there, that only focuses on giving you quick solutions. 🙂
@@Dani_Krossing What’s the difference. Aren’t you teaching how to?
@@Dani_Krossing I’m not looking for quick solutions, I’m looking to understand “how to”. I, unlike most, am looking to actually understand what is going on with the software so that I can craft a solution for any situation. I don’t want you to show me your way and then attempt to memorize it as that leaves you with one solution and one solution never fits every problem. I spent most of my life fixing computer hardware. I was very successful at it because I, unlike most, actually knew how the equipment worked. I’m taking that same attitude into learning modern software. The paradigm where we have html, css, javascript on the browser side, http in the middle, with php and sql on the server side is really interesting for me and I enjoy your explanations as I want to know the details. To many sites want you to memorize and copy “their” solution which probably works most of the time. As the software evolves they are left back at the old way because they don’t actually understand what the details are and how they fit.
Please don’t take offense, I was just telling how it looks from my side.
Regards, Terry
Please do these videos in mysqli
My older PHP course uses MySQLi if you are interested 🙂 it can be found on my channel page
finally, im here where you are bald. been waiting for this. Now look where I am at.
update: brother i am working while studying your course, stuck for this for quite a while now. 3 weeks going strong. still falling in love with your course!
anyone ever tell you that you look like Elon musk a little?
😆😆
BRUH that's the feeling I was getting when it was grown out haha
yeah, i have been thinking about this even right now ,he looks like him and speaks like him.
For health reasons? are you okay? We hope your as healthy as possible at the time.
Yes I am healthy 😊
This is the moment Dani became Heisenberg.
I though who is this new guy? LOL - new hair cut.
Anyone having issues getting this working on Mac?
10:54 "so i'm going to _die~_ "
i miss his hair 😢
where is your hair dani wtf
we like the long hair more
Also your video helped a lot thx
Hi @Dani_Krossing I am truly grateful for your videos. I appreciate your hard work and fantastic explanation. I do face an issue while following along your tutorial, When I submit the form, it states "NOT FOUND: The requested URL was not found on this server." I would truly appreciate it if you can help me. Thank You!
It means that your path inside the "action" of your form, doesn't point to the correct file. 🙂 So either you made a typo in the path, or your files are differently structured than what I do in the video.
@@Dani_Krossing You were right! I had a typo. Thank you for the reply! Greatly appreciate it! You are the best! 🫡
Help! I followed the steps outlined. When I click the Submit button I get 404 Not Found Error. What could I've done wrong? The only 3 files I have are the index.php, dbh.inc.php, and formhandler.inc.php. I'm unsure how to fix this. Any help is greatly appreciated.
The difference is with the database name, mine is named "ais_db".
$dsn="mysql:host=localhost;dbname=ais_db";
404 is a "page not found" error. Meaning that the link in your form inside the 'action' attribute, is incorrect, and doesn't point to a page.
Idk why once Iclick submit somehow it puts me in the dbh.inc.php page
And The data I sent isn't getting inserted into the database
Even tho I eventually copied ur code literally
I can guarantee you with 100%, that there is a typo in your code, based on the description of the error you are giving :)
@@Dani_Krossingoh yeah... I didn't notice I typed post instead of POST in the if condition equality to the request method
Thanks
@@stateofalawites4039 wish i knew what was causing my problem. I enter the form data, hit submit, it goes back to the form index page like it submitted everything. No errors. But nothing in database either. Ugh. I've looked over the code 10 times and its exactly the same.