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.
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 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!
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.
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.
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!
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
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?
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.
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.
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
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 😂
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... ??
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.
@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: th-cam.com/video/tHKsZdS8Oug/w-d-xo.html
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!
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)"
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 "
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.
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
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.
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!
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.
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!
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?" 🙂
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?
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
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?
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…
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.
@@kylehawks2966 These two videos should help you out. th-cam.com/video/tHKsZdS8Oug/w-d-xo.html&ab_channel=DaniKrossing th-cam.com/video/7ALVC1eWgdI/w-d-xo.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 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
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!
A year ago I was dreaming about making websites and today here I am building one, thank you, your help is much appreciated.
New look Dan 😂 Thanks for your premium courses Africa is watching
Man, the simplicity of this video courses makes them pure joy! Thanks :)
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.
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 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
thank you for your efforts , better than uni lectures
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!
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
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.
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!
You're an amazing tutor. I appreciate your sacrifice of giving us this full packaged php content.
You have been so clear in your explanation with every single code that you typed
Great series of videos. I hope everything is okay with your health. Stay strong ❤
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.
Kross, you are really saving life with this tutorial. Thanks.
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
1 year down the line and we're still enjoying your videos. Thanks for the work.
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.
great tutorial. Hope you're good man
Great one Dani, keep it up
i don't have nothing to said thank you 😊😊 your contend is other level
Thank you for this tutorial!
Thanks a lot Dani!Awesome Tutorial series :) Please take care of your health!
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 so cool bro your lessons are so informative, great foundation
You're my ROLE MODEL, I wish you success in everything!
You are a genius!!! Thanks much
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
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.
so prepared statements enable the code to separate between data inputs and the actual sql code to prevent SQL injunction , thank you
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?
haircut! but also, great series so far - thanks for all your hard work and clear explanations.
Thank you!
Thank you, very good job
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.
this was a starting point to me coding using PHP. i am not sure if you have courses on Udemy.
0:20, Bro please take care of your health, im praying from here.
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.
Waiting for next episode!!
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.
get well soon dear
that new look tho!
bindParam vs bindValues what are the diff of these two sir?
You're like the Mr Beast of PHP MySQL tutorials. I'm now rich with knowledge now, thanks.
my signe up button is not working
did you find a fix for this?
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 ...
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
How would that work on an E-Mail form for example?
Hi Dani how many rows can php display?? And can you make it more than 500?
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 😂
I keep getting same thing,,,Undefined variable $pdo line 13 Formhandler...same problem can I nest the file some how?
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
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?
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.
@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:
th-cam.com/video/tHKsZdS8Oug/w-d-xo.html
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!
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! 😄
If I have my website done in wordpress how can i have a page that communicates with the new database?
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
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.
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
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.
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 got an error when I click signup button "Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)"
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.
This is the moment Dani became Heisenberg.
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!
Uncaught PDOException: could not find driver
i checked and it said Configuration File (php.ini) Path
how do i fix this isssue?
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
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?
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
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.
does anyone know why after i do $stmt = $pdo->prepare($query);
the rest of the things turn into html
For health reasons? are you okay? We hope your as healthy as possible at the time.
Yes I am healthy 😊
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
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…
For health reasons? Are you okay Dani?
I tried and I keep getting error on my line 32 that undefined pdo
Please do these videos in mysqli
My older PHP course uses MySQLi if you are interested 🙂 it can be found on my channel page
i used all your codes but am getting an error [HY000] 2006 , server has gone away , please help
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'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.
th-cam.com/video/tHKsZdS8Oug/w-d-xo.html&ab_channel=DaniKrossing
th-cam.com/video/7ALVC1eWgdI/w-d-xo.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 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
I though who is this new guy? LOL - new hair cut.
You look better with long hair :) after ton of advices you gave to us, perhaps we can give one suggestion to you ? :) hehe GL
Do you know u/colschrapnel from Reddit?
Anyone having issues getting this working on Mac?
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?
i miss his hair 😢
10:54 "so i'm going to _die~_ "
where is your hair dani wtf
Your hair, noo
we like the long hair more
Also your video helped a lot thx