I'm really glad I found this channel, because all of your videos are incredibly easy to understand despite that English isn't my first language and they are always very helpful. Thanks for doing that
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.
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.
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.
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
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.
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
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.
Thank you for the clear and precise step-by-step tutorial on database using php. I'm able to create and host my business database. However, i don't know how to convert the localhost llink to my company website url, do you have a video on that?
i love your videos. i suggest when you're discussing something be direct and avoid inserting things that will not be included in the topic as it makes the subject messy. if you will use a certain method, don't discuss other methods if you will not use it.
@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: ruclips.net/video/tHKsZdS8Oug/видео.html
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.
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 😂
Great video, I do have one issue though. while putting parameters into the parameter for database object ($dbo), I got a "FATAL ERROR" that tells me it expected 4 and got 6. My form has 6 data, so does the pdo only take 4 params?
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... ??
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?
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
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 "
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!
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
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.
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)"
@@deepindark How did you fix this issue? I'm having the exact same problem. I tried to change the password but ended up getting locked completely out of phpmyadmin and had to completely reinstall my server. 😬
@@theCleromancer I'm not using XAMPP anymore so I'm not quite remember how did I fix it. But as long as I can remember, when you take a look at the php.ini file within XAMPP folder (I assume u put it in C drive, which recommended), there should be an option to do with it. Sorry for not helping u to the very last tho 😥
@@deepindark It's all good. I actually figured it out. There was some config file somewhere and the password was not "pass" or "" but rather "mysql". No clue why, but it fixed the problem. 😉Thanks for the incredibly fast response!
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.
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!
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 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.
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?
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’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
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
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!
@@kylehawks2966 These two videos should help you out. ruclips.net/video/tHKsZdS8Oug/видео.html&ab_channel=DaniKrossing ruclips.net/video/7ALVC1eWgdI/видео.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 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…
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
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.
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!
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?" 🙂
I'm really glad I found this channel, because all of your videos are incredibly easy to understand despite that English isn't my first language and they are always very helpful. Thanks for doing that
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.
thank you for your efforts , better than uni lectures
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, the simplicity of this video courses makes them pure joy! Thanks :)
Thanks for simple and clear english, i almost understood everything without subtitle, a lot of loves from Egypt ❤
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
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
You're an amazing tutor. I appreciate your sacrifice of giving us this full packaged php content.
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!
Great series of videos. I hope everything is okay with your health. Stay strong ❤
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.
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.
You have been so clear in your explanation with every single code that you typed
Your the best teacher i'ved ever watched! keep up Sir
i don't have nothing to said thank you 😊😊 your contend is other level
Great one Dani, keep it up
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
1 year down the line and we're still enjoying your videos. Thanks for the work.
Kross, you are really saving life with this tutorial. Thanks.
great tutorial. Hope you're good man
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!
You are so cool bro your lessons are so informative, great foundation
Thanks a lot Dani for the great tutorials and sharing your knowledge. ❤
BTW, I love your new haircut 💇♂️
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
You are a genius!!! Thanks much
haircut! but also, great series so far - thanks for all your hard work and clear explanations.
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.
Thank you!
You're my ROLE MODEL, I wish you success in everything!
so prepared statements enable the code to separate between data inputs and the actual sql code to prevent SQL injunction , thank you
Thank you, very good job
You're like the Mr Beast of PHP MySQL tutorials. I'm now rich with knowledge now, thanks.
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
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.
0:20, Bro please take care of your health, im praying from here.
Waiting for next episode!!
Thank you for the clear and precise step-by-step tutorial on database using php. I'm able to create and host my business database. However, i don't know how to convert the localhost llink to my company website url, do you have a video on that?
that new look tho!
get well soon dear
i love your videos. i suggest when you're discussing something be direct and avoid inserting things that will not be included in the topic as it makes the subject messy. if you will use a certain method, don't discuss other methods if you will not use it.
this was a starting point to me coding using PHP. i am not sure if you have courses on Udemy.
9:00 When creating a form, the user input data, so we should use htmlspecialchars, no?
Yes, among other things 🙂 There is quite a bit of security in PHP, when handling user data. Which is why people learn a framework later on.
@@Dani_Krossing Thx Dani
@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:
ruclips.net/video/tHKsZdS8Oug/видео.html
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.
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 😂
How would that work on an E-Mail form for example?
Great video, I do have one issue though. while putting parameters into the parameter for database object ($dbo), I got a "FATAL ERROR" that tells me it expected 4 and got 6. My form has 6 data, so does the pdo only take 4 params?
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?
I keep getting same thing,,,Undefined variable $pdo line 13 Formhandler...same problem can I nest the file some how?
bindParam vs bindValues what are the diff of these two sir?
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?
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
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
Hi Dani how many rows can php display?? And can you make it more than 500?
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 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 ...
If I have my website done in wordpress how can i have a page that communicates with the new database?
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?
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
This is the moment Dani became Heisenberg.
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
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.
my signe up button is not working
did you find a fix for this?
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! 😄
@@deepindark How did you fix this issue? I'm having the exact same problem. I tried to change the password but ended up getting locked completely out of phpmyadmin and had to completely reinstall my server. 😬
@@theCleromancer I'm not using XAMPP anymore so I'm not quite remember how did I fix it. But as long as I can remember, when you take a look at the php.ini file within XAMPP folder (I assume u put it in C drive, which recommended), there should be an option to do with it. Sorry for not helping u to the very last tho 😥
@@deepindark It's all good. I actually figured it out. There was some config file somewhere and the password was not "pass" or "" but rather "mysql". No clue why, but it fixed the problem. 😉Thanks for the incredibly fast response!
does anyone know why after i do $stmt = $pdo->prepare($query);
the rest of the things turn into html
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.
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!
You look better with long hair :) after ton of advices you gave to us, perhaps we can give one suggestion to you ? :) hehe GL
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 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.
Uncaught PDOException: could not find driver
i checked and it said Configuration File (php.ini) Path
how do i fix this isssue?
I got an error when I click signup button "Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)"
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
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’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
I tried and I keep getting error on my line 32 that undefined pdo
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
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!
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.
ruclips.net/video/tHKsZdS8Oug/видео.html&ab_channel=DaniKrossing
ruclips.net/video/7ALVC1eWgdI/видео.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
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…
i used all your codes but am getting an error [HY000] 2006 , server has gone away , please help
Please do these videos in mysqli
My older PHP course uses MySQLi if you are interested 🙂 it can be found on my channel page
For health reasons? are you okay? We hope your as healthy as possible at the time.
Yes I am healthy 😊
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.
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
For health reasons? Are you okay Dani?
I though who is this new guy? LOL - new hair cut.
Do you know u/colschrapnel from Reddit?
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 🙂
10:54 "so i'm going to _die~_ "
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?
Anyone having issues getting this working on Mac?
i miss his hair 😢
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