Previously I covered the vast majority of both PHP and MySQL in 2 videos. This time I decided to bridge the gap and show how to simply grab data from and edit data in a MySQL database using PHP.
We specifically cover creating users with limited access for security reasons, setting up secure database connections, pulling data from a database, adding data to the database and prepared statements. All of the code follows the video below.
If you like videos like this, it helps to tell Google Plus with a click here [googleplusone]
Code From the Video
mysqli_connect.php
getstudentinfo.php
addstudent.php
studentadded.php
Hi, are you going to continue with PHP/Mysql? It looks like a good start but still there is a lot to talk about 😉 For example PDO… Anyway, big THANKS for your effort 😀
Yes over the coming month I will cover anything everyone requests. I’ll cover web services next
Good idea! Keep up the good work. You know your tutorials are the best, don’t you? 😉
Thank you 🙂 I do my best
I am looking forward to every tutorial you post and enjoy them very much. I have a question: I am developing an application with a central database and several mobile users using MySQL as an exercise. Which site do you suggest for hosting the database during my trials during the development? Thanks.
Thank you 🙂 I’m glad you are enjoying them. I use Go Daddy for everything, but any of the major hosting companies should be fine.
Hi Derek. You are doing a fantastic job. Your tutorials are helpful and easy to understand. Kindly request to cover a Zend framework.Thanking you in advance.
Thank you for the compliment 🙂 I’m working on a learn Zend in 30 minutes video. I use it all of the time so it should be fun
You make 11 hours tutorials in 19 minutes :). You are very talented programmer and a teacher to.
Thank you 🙂 I do my best to make original videos.
Hello derek, thanks for the amazing tutorials!
I have a suggestion for your videos: how about you make tutorial series on a big android app project that( whith users, facebook integration, posts, comments, user interactions, geolocation…….) and go through it step by step from the planning, the wireframming, UI design and development, backend programming with REST php mysql to testing, debugging, submitting…
I kindly ask you to consider this idea since we would all learn how the process of making a complex app really works and how to effectivelly integrate the frontend to the backend ( webservices). I would follow these videos on the project with all the joy in the world. What are your thoughts on this idea?
Thank you again for all your efforts and the videos you make. God bless you! You are a true mentor!
Regards from Brazil
Hello Leonard,
Yes I definitely plan on making a bunch of big apps after I cover all the basics in my new Android tutorial. Thank you for showing your interest in that. May God bless you as well 🙂
Derek, thank you so much for the tutorials you provide. I really appreciate your approach on these programming lessons. I come from a networking and systems analysis (IAM) background and would like to focus on programming. I have started with Java by reading books and watching tutorials like yours online. I have two questions and I apologize if you have covered these before. If I want to get into web development what language would you learn next after Java? What profession would be a little easier to break into, web or application development?
You’re very welcome 🙂 I actively work as a web developer / Android app designer. There is a major difference between the corporate world and the small business world where I work. I basically help businesses set up shopping carts. For that all you need is PHP / JavaScript.
There is a never ending amount of work in this area because the corporations will charge 2 to 3 times more then you need to. When you first start out though you’ll need to prove you know what you are doing. I got a huge portfolio quickly by offering to do the site for free (I owned it) in exchange for a percentage of profits indefinitely.
If you want to get into a big corporation enter coding competitions, network with people that work where you want to work. Find out the needed skills from them. Study up on sales so that you can negotiate your way in for an interview and then into a position.
As per application development, I have mainly only made apps for small business owners that either save them time, provide for portable CSM, provide sales tools, etc.
Hello, Good Day to you. Thanks a lot for all your tutorials, they are very good.
Please I need your help, I was asked by my supervisor to design an Online exam application with PHP and MySQL. to test students on Multiple choice, Short answers(German Objective). I have between now and 20th November to submit, please If you can be of help with the codes and structure(send to my email), you would have saved a soul. I am pretty new to programming.
Thanks
Osahon
Hello Osahon, The first thing you need to do is to take a deep breath. You have plenty of time to do this. Write out on paper everything you need to do as detailed as possible. I don’t know what restrictions you have? To do this, you need to understand the basics of html, php and mysql. I have tutorials on all of them. If you take your time building the system as you learn you’ll do fine. Best of luck 🙂
Great tutorials! At the end you access the php files we just created through what looks like a chrome browser, I tried to follow along but only get “this webpage is not available”. I saved the files to my hosting provider outside of the normal page files like you suggested, any suggestion on how to find the pages?
Thank you 🙂 The provider may be blocking access? You should be able to jump up a directory with ../