Been on youtube for years, and never felt the need to comment anything.. Just to say how much i'm thankful to you and your work. I love the way you make every coding language basics seem so simple. Great job and thank you again !
Had a job interview with a big company yesterday. One of the technical questions was about retrieving data from a database. Good thing I watched this video the night before, and I got a call this morning from them offering me the job. Thank you so much for these tutorials. You're really awesome.
This video covered more in 19 minutes than my PHP and MySQL class I had for a full semester in my programming class! thank you for this and all of your other videos!!
Finally, someone who has not forgotten what it is like when you are new to aspects of computing. That's another way of saying "Computer Illiterate" or "Stupid, dumb, lacking in IQ, etc." Normally a face to face tutorial involves a lot of nodding, smiling, hoping the ground opens up under you before he asks you a question because despite the fact that when asked, you told him you understood but in reality, you haven't a bloody clue what he is talking about! I highly recommend this tutor. Whilst moving quickly, everything is broken down into easy small steps. It is just a matter of putting them all together. You will understand what can be done and if you are stuck, will quickly be able to go back to the tutorial to remind you that computers have a nasty habit of doing exactly what they are told! You will have the confidence to give it a go and when you successfully work out where you went wrong, will never forget it so your skills will come on in leaps and bounds. I am happy to say that I am in the process of re-opening my business following a long period of illness. In order to get it running, I need to make changes and additions to my web site. While I am a computer programmer, PHP and MYSQL are new to me. On permanent disability, I lack the funds needed to pay a programmer to do this. It would take me an hour if it was in a language I knew. I have tried different tutorials over the last few years and even spent a fortune on books but lost heart. After watching the video before this one, I gave it a go. It took me a few hours but it means that I can employ someone taking them off assistance and also get my dignity back as I can now earn money again paying taxes instead of living off the tax payer. Derek, from Maureen who now has a job and is now not going to lose her home, from the Irish tax payer, from my clients on the business directory who now get a better service, from one of the four charities picked by the client who enjoy 10% of the clients annual fee and especially from me - despite the fact that it is 05:30 and I intended getting an early night but got sucked into your contagious enthusiasm - THANK YOU! Paul :)
+Paul Clarke Thank you for taking the time to write such a nice message. It is very nice to hear that I'm helping people. I wish you all the best in life. I'm happy that I could help :)
Derek, you are every computer engineers' highlight when it comes to stuff like this. Thanks a lot for this PHP-SQL blend, it's just what I was looking for! Cheers!
Another small thing: although it is always good to know how to manually add tables etcetera, I would recommend the MySql Workbench for this as it goes much faster once you get used to it. You also have a direct overview of the data in your tables without having to use SELECT every time.
+Rob Baartwijk The main reason I didn't use the Workbench is because I don't know what it may look like say 2 years from now. If people see even minor changes the normally stop watching the video. I don't expect the terminal to change at all may be even 5 or more years from now.
+Derek Banas Ok, that figures. I have seen screenshots of the Workbench through the years though(while searching for info) and it seems to me that it doesn't really change much. Too many people use it I guess, small changes will probably generate many many complaints.
From a TH-cam search I found your video. I found your information to be clear and to-the-point, very easy to follow along and understand. Great tutorial, I will be watching more, subscribed and thank you.
You are doing a great service to the internet community. This is as great a service as building an open source software from scratch. Keep up your good work!
Great video Derek. In 7:41 the last row should be: $row['birth_date'] . ''; rather than: $row['birth_date'] . ''; There is an extra dangling there with no content, that is not being closed with a relevant
Awesome video. I like how you're showing how to apply the information instead of just spitting out textbook info. It makes it easier to digest. I'll definitely have to come back and view some more of your videos.
Best tutorial i have ever seen on this, been wanting to learn how to do this for years but nobody has made it as clear to follow as you. What i want to know next is how to build dynamic queries. With the birth_date field for example i know on SQL how to make it show only records where the date is greater than a date i specify. How would i do that in PHP so there is a date picker and when you then click submit only records where the date is greater than what you selected would show.
David Lawton Thank you :) Probably the easiest way to do that is through JQuery using Ajax techniques. Here is a tutorial on that th-cam.com/video/O8C86NHhFZg/w-d-xo.html
Derek, Just wanted to say thank you for all of your hard work. These tutorials have helped me with personal, academic and professional projects. I can tell you put a lot of thought and time into each one. Your method of instruction leads to high retention, conceptual and otherwise in an incredibly short time frame. In short they are the best I've come across in a long time. Thanks again man. ps: have you considered making any udemy.com courses I feel like they would sell extremely well. I've seen/bought courses that sell in the 5 figures volume wise that aren't close to your quality.
+Rdella Thank you for the very nice compliments :) I greatly appreciate them. Thank you for noticing that a lot more work goes into structuring these videos then it may seem. I spend a lot of time studying the psychological side of teaching. I like the idea of keeping the videos free. I just want to make enough money to pay for the equipment and books I need to make the videos. If I do that and help people I'm very happy.
Hello, I am just figuring out how to put everything together (front-end/back-end) now. Just started using AMPPS and Sequel Pro. Just learning PHP. Already have some background with HTML, CSS, and SQL. Still need to become more familiar with JavaScript. At any rate, this tutorial is super helpful for comprehending how to connect the front-end to the back-end. Thank you for laying out such a thorough example and putting out the code to be copy/pasted as well! Cheers! Rick
Looking at the web-stack in an meta cognitive way you can think of the web-stack "trinary" as (x = html, y = css, z = javascript) but where z can equal "php" or "javascript" or others. To choose, just look at the situation and balance your trade-offs for the task.
Dude, this is a really fucking huge piece of information to swallow. 20 minutes of coding with explanation alongside it doesn't help learning this. I got to 15 minutes when i realised; "I'm just looking on screen and repeating this, I'm not learning anything at all, let alone seeing what each bit of the code is doing."
"Okay, let's watch some of this tutorial to determine whether it's good or not before I give it a like" 50 seconds in, a Twin Peaks database appears. "Fine.... here's your like!"
Derek Banas Hey Derek Since You are familiar with php I just wanted to ask. I was told by my teacher to learn Laravel to Do a PHP application. But to what I can see using Core PHP is far easier for making an php application as Laravel Has it's own Syntax and Functions. Keeping in mind I learnt php a few days ago Laravel seems to be the longer road when developing a php application. So why would people use it for any reason other than security. Also are you planning on doing a Laravel Tutorial any time soon?
Derek you are awesome. I love your tutorials. Very well explained and easy to follow. I am currently learning SQL and using MySQL and your tutorials have been really helpful. I am going to learn PHP next so that I can make a front-end for my database and this video is just awesome and really gives you a good idea how to go about it. Keep up the great tutorials. Greetings from the UK.
Thank you so much!! Derek your videos are so helpful, you made the boring books contents into some interactive videos which makes me learn languages in no time. Stay blessed and keep up the good work...
Well, Hello Derek Banas! Previously I watched a big giant tutorial on PHP and CSS, now I'm back for more. I've got a lot to do, so lets get started! Theres are 2 very important keywords you can add to your search that will help you find the right tutorial for MANY developer tools and languages out there >> and those two words are: DEREK and BANAS I just realized I've been here before... mySQL is something I just can't seem to enjoy learning... but anyways .. Here Goes!
Thank you for the compliment :) Yes MySQL requires some time to get used to. Try playing around with data that interests you and that will make it more fun. There are numerous databases available for download. I enjoy playing around with this baseball database www.seanlahman.com/baseball-archive/statistics/
Well Hop Skip AND Jump. Hot- Diggity dog. Love it. Absolutely love it. As a "dusted off" developer coming back to relearn a lot of this stuff, your crash courses are absolutely awesome when it comes to needing to cram as much info into a short amount of time, USEFUL when weekend study accidentally turns into weekend STUDDING. Chip Chop Cheerio!
Man... thanks... for real haha, can't bealive how fast I've learn PHP and Mysql haha, great tutorials for ppl looking to migrate to another lenguaje. keep it up!
Hey Derek, Great Tutorial as always. You won't believe this but I practically learn more programming from your youtube channel rarher than from the collge.One quick request can you post a quick video on "Image processing in Android Using OpenCv(Or any Other you think is better").That would be of great help to all of us.
Prashant Patel Thank you :) I'm very lucky to be able to help. I have added your request. Stanford used to have a very nice tutorial, but I can't find it right now. I'll get back into Android after my next video on web services
Another awesome tutorial i finally understand how database works with PHP+MYSQL thanks a lot. hope you do similar tutorials on Andoird using database how to save info on phone similar to a note taking apps
Please, correct me if I am wrong. Just to clarify something I hadn't understand. There are 3 ways to connect * MySQLi (object-oriented) -Ex. $conn = new mysqli($servername, $username, $password); * MySQLi (procedural) - Ex. $conn = mysqli_connect($servername, $username, $password); * PDO - Ex. $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password); Derek used the MySQLi (procedural) and added @ to suppresses error messages. $conn = @mysqli_connect($servername, $username, $password);
The problem: I want some foreign keys of a few tables to be avaliable in one form as selectable options to input into another table. i.e. I want doctor_id, patient_id, and ward_id to be available to select when setting up an appointment. They’re set up as foreign keys and they work when I test them in SequelPro so I think it’s just a PHP and HTML thing to do.
Being a novice to PHP Derek, why did you use constants (3:54) with your database info instead of just putting them in variables? There must be some advantage to this, otherwise I doubt you'd do it this way. . . Great tutorials as always, Derek!
+Matthew NotReal LOL, i'm also trying here, but i got this error: Parse error: syntax error, unexpected 'Integers' (T_STRING) in /home/website/public_html/studentadded.php on line 155
Hey Derek Banas I keep getting errors, these are the errors: Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given Warning: mysqli_stmt_affected_rows() expects parameter 1 to be mysqli_stmt, boolean given Warning: mysqli_error() expects exactly 1 parameter, 0 given
This comment is very old, but for posterity,.. I had this problem because I forgot a closing parenthesis to the end of my $query statement, just before the closing quote.
Question for ya. When i go to host this online, what do i set the db_host to? And what other things do I have to set to make it live. Thanks derek!! Btw bout 3 or 4 hrs of watching your video, and trying stuff on my own. And much trial and error. I have a login and registration page, and adding stuff into mysql!!
Thanks , very fluently explained, only what needs for the purpose just given. I really appreciate your help. I don’t want to miss your other video therefore just subscribe your channel👍.
Is there any way to connect the php page to Microsoft Access database or Libre Office Base database?? Coz security isn't my priority but lightweight multifunctional software are. Once again thanks for your tutorial. Can wait to try it out. Can't imagine youtube without you.
Hey man i love your videos! I am gonna do an android app and i will follow your tutorials, but i really want to ask you something... I'm gonna have to choose my path in life and so i'm thinking of something connected to technology... What did you study? What jobs can you fit in with your knowledge? And btw, i heard you have an eye infection and i wish you get better soon ;)
Alexandre Pinto Thank you :) When I started out programming was an unknown profession. I have been doing this for 30 years. I basically bounced around working for software, finance and even marketing companies. It wasn't until the last 10 years that I started making shopping carts and now Android apps. I always wanted to help regular small companies and that is what I have been doing for the last decade. I have basically been learning new things for the last 30 years. My core languages are JavaScript, PHP, C++ and Java. I can do pretty much anything with them. I think adding sales skills has dramatically helped me more then anything. I learned how to get my way and become a better leader by increasing my ability to negotiate. I hope that helps. Hopefully the eye gets better soon so I can make more videos.
Derek Banas well ty very much for replying, that makes me really happy... Hehehe but i think you should rest your eye ;) Hope you get better soon ;) Btw, is there a list of apps created with your videos' help? I would love to see what i can do with your tutorials hehehe Cuz i am really looking forward to make an app ;) (with the help of your tutorials, of course ;) ) Stay awesome ;)
Maybe I missed something but what exactly is the PHP command to establishes the connection between PHP and MySQL? In Minute 4:30 you define variable 'dbc ' and you use the 'mysqli_connect' function. Is that a native PHP function that establishes connections to any DB? What if my DB is not MySQL but something else, will this still work? Thank you!
Good afternoon sir, Define ('DB_user', 'Studentweb'), my question are, what are DB_user stands for? and the student web stand for? is it the database that you created?
Been on youtube for years, and never felt the need to comment anything..
Just to say how much i'm thankful to you and your work.
I love the way you make every coding language basics seem so simple.
Great job and thank you again !
Thank you for the nice compliment :) I appreciate it!
Had a job interview with a big company yesterday. One of the technical questions was about retrieving data from a database. Good thing I watched this video the night before, and I got a call this morning from them offering me the job. Thank you so much for these tutorials. You're really awesome.
Yuuri Evanov That is very cool! I'm very happy I could help :) Congratulations on the new job!!!
Been doing PHP for over a month,never seen anything this concise and clear.
Thank you :) I'm glad you liked it
New to PHP (I do embedded systems and OS development, so it's a bit out of my league) but your tutorials have been really helpful thanks so much!
Thank you :) I'm glad they have helped
This video covered more in 19 minutes than my PHP and MySQL class I had for a full semester in my programming class! thank you for this and all of your other videos!!
LordTPrime2100 Thank you very much :) I did my best to cover most things you'd need.
"I know this should be done in CSS, but I'm... I'm not doing that." Words to live and breathe by. Love it.
That's funny :)
Finally, someone who has not forgotten what it is like when you are new to aspects of computing. That's another way of saying "Computer Illiterate" or "Stupid, dumb, lacking in IQ, etc." Normally a face to face tutorial involves a lot of nodding, smiling, hoping the ground opens up under you before he asks you a question because despite the fact that when asked, you told him you understood but in reality, you haven't a bloody clue what he is talking about!
I highly recommend this tutor. Whilst moving quickly, everything is broken down into easy small steps. It is just a matter of putting them all together. You will understand what can be done and if you are stuck, will quickly be able to go back to the tutorial to remind you that computers have a nasty habit of doing exactly what they are told! You will have the confidence to give it a go and when you successfully work out where you went wrong, will never forget it so your skills will come on in leaps and bounds.
I am happy to say that I am in the process of re-opening my business following a long period of illness. In order to get it running, I need to make changes and additions to my web site. While I am a computer programmer, PHP and MYSQL are new to me. On permanent disability, I lack the funds needed to pay a programmer to do this. It would take me an hour if it was in a language I knew. I have tried different tutorials over the last few years and even spent a fortune on books but lost heart. After watching the video before this one, I gave it a go. It took me a few hours but it means that I can employ someone taking them off assistance and also get my dignity back as I can now earn money again paying taxes instead of living off the tax payer.
Derek, from Maureen who now has a job and is now not going to lose her home, from the Irish tax payer, from my clients on the business directory who now get a better service, from one of the four charities picked by the client who enjoy 10% of the clients annual fee and especially from me - despite the fact that it is 05:30 and I intended getting an early night but got sucked into your contagious enthusiasm - THANK YOU!
Paul :)
+Paul Clarke Thank you for taking the time to write such a nice message. It is very nice to hear that I'm helping people. I wish you all the best in life. I'm happy that I could help :)
Derek, you are every computer engineers' highlight when it comes to stuff like this. Thanks a lot for this PHP-SQL blend, it's just what I was looking for!
Cheers!
Filip Boev Thank you :) I'm glad I could help
Oh man, came here just to learn php. Now ive learned HTML, and php, now imma go learn mysql and come back. Man you got it all!!!
Thank you :) I try to cover everything
This guy is a good instructor
michaelguy Thank you :) I do my best.
Derek Banas You videos are awesome. But sometimes you don't explain some data types/functions fully. Android tutorial 1. :(
Another small thing: although it is always good to know how to manually add tables etcetera, I would recommend the MySql Workbench for this as it goes much faster once you get used to it. You also have a direct overview of the data in your tables without having to use SELECT every time.
+Rob Baartwijk The main reason I didn't use the Workbench is because I don't know what it may look like say 2 years from now. If people see even minor changes the normally stop watching the video. I don't expect the terminal to change at all may be even 5 or more years from now.
+Derek Banas Ok, that figures. I have seen screenshots of the Workbench through the years though(while searching for info) and it seems to me that it doesn't really change much. Too many people use it I guess, small changes will probably generate many many complaints.
From a TH-cam search I found your video. I found your information to be clear and to-the-point, very easy to follow along and understand. Great tutorial, I will be watching more, subscribed and thank you.
ppmservers Thank you :) I'm glad you liked it.
You Derek teach smoothly with ease. You are a very good teacher.
Nebih Erzorlu Thank you for the compliment :)
You are doing a great service to the internet community. This is as great a service as building an open source software from scratch. Keep up your good work!
kumropotashify Thank you for the nice compliment :) I'm doing my best
You are a lifesaver!!!
I'm very happy that it helped :)
Great video Derek.
In 7:41 the last row should be:
$row['birth_date'] . '';
rather than:
$row['birth_date'] . '';
There is an extra dangling there with no content, that is not being closed with a relevant
Ronnie R. Winter Whoops sorry about that
Awesome video. I like how you're showing how to apply the information instead of just spitting out textbook info. It makes it easier to digest. I'll definitely have to come back and view some more of your videos.
Brandon Jones Thank you :) I do my best to keep the videos interesting.
Best tutorial i have ever seen on this, been wanting to learn how to do this for years but nobody has made it as clear to follow as you. What i want to know next is how to build dynamic queries. With the birth_date field for example i know on SQL how to make it show only records where the date is greater than a date i specify. How would i do that in PHP so there is a date picker and when you then click submit only records where the date is greater than what you selected would show.
David Lawton Thank you :) Probably the easiest way to do that is through JQuery using Ajax techniques. Here is a tutorial on that th-cam.com/video/O8C86NHhFZg/w-d-xo.html
Derek,
Just wanted to say thank you for all of your hard work. These tutorials have helped me with personal, academic and professional projects. I can tell you put a lot of thought and time into each one. Your method of instruction leads to high retention, conceptual and otherwise in an incredibly short time frame.
In short they are the best I've come across in a long time.
Thanks again man.
ps: have you considered making any udemy.com courses I feel like they would sell extremely well. I've seen/bought courses that sell in the 5 figures volume wise that aren't close to your quality.
+Rdella Thank you for the very nice compliments :) I greatly appreciate them. Thank you for noticing that a lot more work goes into structuring these videos then it may seem. I spend a lot of time studying the psychological side of teaching. I like the idea of keeping the videos free. I just want to make enough money to pay for the equipment and books I need to make the videos. If I do that and help people I'm very happy.
Hello,
I am just figuring out how to put everything together (front-end/back-end) now. Just started using AMPPS and Sequel Pro. Just learning PHP. Already have some background with HTML, CSS, and SQL. Still need to become more familiar with JavaScript.
At any rate, this tutorial is super helpful for comprehending how to connect the front-end to the back-end. Thank you for laying out such a thorough example and putting out the code to be copy/pasted as well!
Cheers!
Rick
***** You're very welcome :) My goal is to teach everything you need.
Thanks Derek !
Your latest 3 videos for PHP and MySQL are so perfect . Very well explained.
Parker John Thank you for the nice compliment :) I'm glad you liked them
Looking at the web-stack in an meta cognitive way you can think of the web-stack "trinary" as
(x = html, y = css, z = javascript)
but where z can equal "php" or "javascript" or others.
To choose, just look at the situation and balance your trade-offs for the task.
If you really wanna be sure of security then use prepared statements, but this works also.
Dude, this is a really fucking huge piece of information to swallow. 20 minutes of coding with explanation alongside it doesn't help learning this. I got to 15 minutes when i realised; "I'm just looking on screen and repeating this, I'm not learning anything at all, let alone seeing what each bit of the code is doing."
"Okay, let's watch some of this tutorial to determine whether it's good or not before I give it a like"
50 seconds in, a Twin Peaks database appears.
"Fine.... here's your like!"
That's funny :) Thank you
I love the videos for quick emerson into a topic that I'm looking to get into. They're also short enough to get a quick refresher on something.
(table header) tags do bold and cenered aligned automatically btw for HTML. amazing tutorial! just thought i'd share if you or anyone was curious
I Simply cannot thank you enough. Your tutorials are the best on youtube
Thank you for the nice compliment :)
Derek Banas Hey Derek Since You are familiar with php I just wanted to ask. I was told by my teacher to learn Laravel to Do a PHP application. But to what I can see using Core PHP is far easier for making an php application as Laravel Has it's own Syntax and Functions. Keeping in mind I learnt php a few days ago Laravel seems to be the longer road when developing a php application. So why would people use it for any reason other than security. Also are you planning on doing a Laravel Tutorial any time soon?
Derek you are awesome. I love your tutorials. Very well explained and easy to follow. I am currently learning SQL and using MySQL and your tutorials have been really helpful. I am going to learn PHP next so that I can make a front-end for my database and this video is just awesome and really gives you a good idea how to go about it. Keep up the great tutorials. Greetings from the UK.
DLiberator78 Thank you for the compliment :) I'm very happy that I could help.
Thank you so much!! Derek your videos are so helpful, you made the boring books contents into some interactive videos which makes me learn languages in no time.
Stay blessed and keep up the good work...
Thank you :) I'm very happy that you like the videos. Many more are coming
I have a test about this tomorrow, thank you a lot is sure helped me.
Ur awesome!
Luc Mulders Thank you :) Best of luck on your test.
How’d it go?
Well, Hello Derek Banas! Previously I watched a big giant tutorial on PHP and CSS, now I'm back for more. I've got a lot to do, so lets get started!
Theres are 2 very important keywords you can add to your search that will help you find the right tutorial for MANY developer tools and languages out there >> and those two words are: DEREK and BANAS
I just realized I've been here before... mySQL is something I just can't seem to enjoy learning... but anyways .. Here Goes!
Thank you for the compliment :) Yes MySQL requires some time to get used to. Try playing around with data that interests you and that will make it more fun. There are numerous databases available for download. I enjoy playing around with this baseball database www.seanlahman.com/baseball-archive/statistics/
Well Hop Skip AND Jump. Hot- Diggity dog.
Love it. Absolutely love it.
As a "dusted off" developer coming back to relearn a lot of this stuff, your crash courses are absolutely awesome when it comes to needing to cram as much info into a short amount of time, USEFUL when weekend study accidentally turns into weekend STUDDING.
Chip Chop Cheerio!
+Sid P That's funny :) I'm very happy that you find them useful.
Man... thanks... for real haha, can't bealive how fast I've learn PHP and Mysql haha, great tutorials for ppl looking to migrate to another lenguaje. keep it up!
Thank you very much :)
Derek, You deserve 1,000,000 subs dude!!!!!
Thank you :) Maybe I'll get there some day
can you make a tutorial on mysql security and the best ways to prevent mysql code injections?
I'll see what I can do
thanks.
SQL Injection is fairly easy to defend against.
buddyroach mysqli real escape string look it up
I've only skimmed this for the moment but I believe this will be really helpful for what I need when I get round to watching it properly :)
I hope it helps :)
I love your style and the fluency is topnotch.
Thank you very much :)
Great tutorials! Keep them coming, I really appreciate you putting in the time. THANKS!!!
Just something one:
BIG HUGE THANKS FOR THIS
I'm very happy that you liked it :)
GREAT refresher course on a prepared statement, thank you!
Isaac Wrate Thank you :) You're very welcome
It is very useful for me ,thanks a lot!
Hey Derek,
Great Tutorial as always. You won't believe this but I practically learn more programming from your youtube channel rarher than from the collge.One quick request can you post a quick video on "Image processing in Android Using OpenCv(Or any Other you think is better").That would be of great help to all of us.
Prashant Patel Thank you :) I'm very lucky to be able to help. I have added your request. Stanford used to have a very nice tutorial, but I can't find it right now. I'll get back into Android after my next video on web services
Derek Banas Thank You Derek. Waiting for your other development videos.
Prashant Patel You're very welcome :) I hope to have another up this weekend
Another awesome tutorial i finally understand how database works with PHP+MYSQL thanks a lot. hope you do similar tutorials on Andoird using database how to save info on phone similar to a note taking apps
Sonu JATT Thank you :) Yes I'm doing this so I can make web services which I will then use with Android. That is coming next
Awesome Tutorial. Giving you credit for a school project!
Thank you very much :)
Please, correct me if I am wrong.
Just to clarify something I hadn't understand. There are 3 ways to connect
* MySQLi (object-oriented) -Ex. $conn = new mysqli($servername, $username, $password);
* MySQLi (procedural) - Ex. $conn = mysqli_connect($servername, $username, $password);
* PDO - Ex. $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
Derek used the MySQLi (procedural) and added @ to suppresses error messages.
$conn = @mysqli_connect($servername, $username, $password);
You are the only channel that I give like Before watching the video, Thank you very much, and keep making such fantastic tutorials.
Mahmoud Elsousy Thank you very much :) Many more videos are coming. I'm glad you like them.
Basically you are a lifesaver, I subbed
!!
Thank you :) I'm happy I could help
Wonderful tutorials. Its amazing. Nice explanation. Thanks.
Thank you very much :)
Would be cool if you did something with Searching for certain types of data. Anything on that you already have done Derek Banas
Excellent tutorial. Thank you.
Thank you :)
super tutorial thank you so much Derek!!
Thank you :)
wow! very useful and helped me lot. thanks.
Thank you :)
The problem: I want some foreign keys of a few tables to be avaliable in one form as selectable options to input into another table. i.e. I want doctor_id, patient_id, and ward_id to be available to select when setting up an appointment. They’re set up as foreign keys and they work when I test them in SequelPro so I think it’s just a PHP and HTML thing to do.
Maestro superb presentation👏👏👏
Thank you very much :)
Thank you very much it helped me a lot!!
Marco Pierre Fernandez Burgos You're very welcome :)
Which software are you are using, & can you explain same thing in windows?.
Thank you for sharing this video with us, very helpful.
Thank you for checking out my video :)
Hey Derek...Thanks a lot for a great overview.
Thank you very much :)
Excellent. Much appreciated.
+Ajay Anand Thank you :)
Thank You! Derek! real life saver!
Thank you :) I'm glad I could help
Thank you Sir.
Excellent tutorial.
khalid Qweder You're very welcome :) Thank you
If I haven't told you already, you're one from my most favourite youtubers :) Thanks for putting the code up online too!
thaqalain10 Thank you for taking the time to tell me :) Yes feel free to do anything you need with the code. It is completely free.
Derek Banas Thanks, I really appreciate it! :)
I forgot to mention, when I've used
thaqalain10 Sure if they are in the same directory that will work
Awesome, thanks once again!
You are the best!
Love from INDIA
Love back to India :) Thank you
Thanks for all the content of this channel! You're amazing!!!
Thank you very much :)
Great tutorial! Exactly what I wanted to know
+Iamgercornholio Thank you :) I'm glad it helped.
Man your tutorials are great, Thanks.
Suggestion for next video: laravel
+Angga Kharisma Putra Thank you very much :) laravel is on the list
Awesome. I just needed that.
Thanks Derek. :)
Anil Kurmi You're very welcome :)
Being a novice to PHP Derek, why did you use constants (3:54) with your database info instead of just putting them in variables? There must be some advantage to this, otherwise I doubt you'd do it this way. . .
Great tutorials as always, Derek!
Chris Kavanagh Thank you :) I set them that way so that they can't be changed to access another users info
Derek Banas
I see. Security precaution.
You are awesome, Derek Banas. :)
Thank you very much :) I do my best
this is exactly for which i have search for
Hi Derek,
Awesome tutorial, just one quick question, how is making scripts in different folders improves the security for the website?
As usual great stuff thank you for posting this and thank you for making it to the point.
Thank you :) I try to do my best
@@derekbanas you should know I got my bachelors in computer science because of you videos. You exlained the concepts better than my professors
nice video! learnt a lot from this
+TheBaliCompany Thank you :)
Just spent the last 3 hours and finally got something in the database.
+Matthew NotReal Keep at it and it will get easier.
+Matthew NotReal LOL, i'm also trying here, but i got this error:
Parse error: syntax error, unexpected 'Integers' (T_STRING) in /home/website/public_html/studentadded.php on line 155
+Mateus Pimentel are you passing the wrong data type / have an extra parameter?
Great video, thank you very much for making it.
Theodore Quentin Evelyn- Rahr Thank you :) You're very welcome
Hey Derek Banas I keep getting errors, these are the errors:
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given
Warning: mysqli_stmt_affected_rows() expects parameter 1 to be mysqli_stmt, boolean given
Warning: mysqli_error() expects exactly 1 parameter, 0 given
This comment is very old, but for posterity,.. I had this problem because I forgot a closing parenthesis to the end of my $query statement, just before the closing quote.
I've heard that there are much better alternatives to PHP that are easier to use, more efficient, and more modern. What's your opinion on this?
Hi Derek can you please cover a video on PHP5 and mysqli connection and concepts?
I'll see what I can do
Thanks Derek :)
+alhadidi1 Your welcome :)
Awesome tutorial, good job!
Andrej Batarilo Thank you :)
Question for ya. When i go to host this online, what do i set the db_host to? And what other things do I have to set to make it live. Thanks derek!! Btw bout 3 or 4 hrs of watching your video, and trying stuff on my own. And much trial and error. I have a login and registration page, and adding stuff into mysql!!
Good lesson. Thanks!
Your very welcome
Thanks , very fluently explained, only what needs for the purpose just given. I really appreciate your help. I don’t want to miss your other video therefore just subscribe your channel👍.
nice tutorial, but can you please create another one for an updated version? thanks!
Great job! Thanks.
+guscles25 Thank you :)
thankx derek for ur help.
is a great tutorial
Hakim BEN You're very welcome :) Thank you
Very Useful, Thanks :)
Abdel Ouery Thank you :)
very helpful ,thx man!
Thank you :)
BEST TUTORIAL...
Thank you :)
Is there any way to connect the php page to Microsoft Access database or Libre Office Base database??
Coz security isn't my priority but lightweight multifunctional software are.
Once again thanks for your tutorial. Can wait to try it out. Can't imagine youtube without you.
I don't know why some developers write code like this:
if($affected_rows == 1){
echo 'Student Entered.';
mysqli_stmt_close($stmt);
mysqli_close($dbc);
} else {
echo 'Error Occurred. ';
mysqli_error($dbc);
mysqli_stmt_close($stmt);
mysqli_close($dbc);
}
instead of this:
if($affected_rows == 1){
echo 'Student Entered.';
} else {
echo 'Error Occurred. ';
mysqli_error($dbc);
}
mysqli_stmt_close($stmt);
mysqli_close($dbc);
I thought of the same thing !
Yeah! You'r Right
defnitley DRYer
well when you try to explain something minimizing code is not a priority .
It is easy I'll explain it to you with an example
If ($mark>=10){
a=1;
}
if($a == 1){
echo 'Congratulation';
}
Nice man! Thanks a lot!
Thank you :)
Thank you so much, want more on mysql
Masum Khulna You're very welcome :) I'll be getting more into MySQL with my Rails and NodeJS tutorials.
Derek Banas really really looking forward to NodeJS. waiting for them from you!
Hey man i love your videos! I am gonna do an android app and i will follow your tutorials, but i really want to ask you something...
I'm gonna have to choose my path in life and so i'm thinking of something connected to technology...
What did you study?
What jobs can you fit in with your knowledge?
And btw, i heard you have an eye infection and i wish you get better soon ;)
Alexandre Pinto Thank you :) When I started out programming was an unknown profession. I have been doing this for 30 years. I basically bounced around working for software, finance and even marketing companies. It wasn't until the last 10 years that I started making shopping carts and now Android apps. I always wanted to help regular small companies and that is what I have been doing for the last decade.
I have basically been learning new things for the last 30 years. My core languages are JavaScript, PHP, C++ and Java. I can do pretty much anything with them. I think adding sales skills has dramatically helped me more then anything. I learned how to get my way and become a better leader by increasing my ability to negotiate. I hope that helps. Hopefully the eye gets better soon so I can make more videos.
Derek Banas well ty very much for replying, that makes me really happy... Hehehe but i think you should rest your eye ;)
Hope you get better soon ;)
Btw, is there a list of apps created with your videos' help? I would love to see what i can do with your tutorials hehehe
Cuz i am really looking forward to make an app ;) (with the help of your tutorials, of course ;) )
Stay awesome ;)
Aloha Derek! Love your Red Bull-paced tutorials. Do you have your code available on Github, etc.?
Aloha :) Thank you. I have links in the descriptions for all of my videos. I have it on my website, but everything is 100% free.
Do you have any tutorials on these extra security measures you mention?
Maybe I missed something but what exactly is the PHP command to establishes the connection between PHP and MySQL? In Minute 4:30 you define variable 'dbc ' and you use the 'mysqli_connect' function. Is that a native PHP function that establishes connections to any DB? What if my DB is not MySQL but something else, will this still work? Thank you!
Good afternoon sir, Define ('DB_user', 'Studentweb'),
my question are, what are DB_user stands for? and the student web stand for?
is it the database that you created?
handoko werento DB_user is the userid you want to use to connect to the database
ah okay,
thanks sir, thanks for uploading this video.
keep up the good work!
Awesome videos !!!! Keep them coming ! :)
+Daniel K thank you😃