Get the Code Here : http://goo.gl/Aocylf
PHP Tutorial : https://www.youtube.com/watch?v=7TF00hJI78Y
MySQL Tutorial : https://www.youtube.com/watch?v=yPu6qV5byu4
Support Me on Patreon : https://www.patreon.com/derekbanas
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.
Amazon Auto Links: No products found.
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 !
The scope methodology is different in PHP than in some other languages. It looks like you can access variables even if they are not in the same scope. Is that right ?
EXCELLENT tutorial!!!
I am newbie in php and this tutorial is very good :).. however I tried to used your code in the link you have provided in comment but I have experienced an error which is the reason why I can’t run the code correctly, can tell me why is this not working.
I am using xampp, I created directory for this files and the error that I’ve encountered are this:
Couldn’t issue database query
Table ‘test3.students’ doesn’t exist
thanks!
2:28 – 15:17 (пропустил кусок). No SQL
Hey!
When try to add new student, i fill up the caps i need to, then press send button, and it clears all data i had entered. Then i go to getstudentinfo page, and there is no added student i just tried to add.
Also in file added student, mysqli_stmt_bind_param($stmt, “ssssssisssd”, $f_name, $l_name … ) it only allowe me to give 3 arguments. Can any1 help?
Have you ever considered talking slower? not by much, a pause here and there, just enough so that it doesn’t feel like you are trying to make time but to get the point across.
Hey Derek…Thanks a lot for a great overview.
thanxs:)
is this in wamp or xampp server?
You are awesome, Derek Banas. 🙂
great tutorials
nice tutorial, but can you please create another one for an updated version? thanks!
este video es una mierda
Thanks a lot for your teaching this
interesting video thank you.
Awesome videos !!!! Keep them coming ! 🙂
Does anyone know how to adjust the getstudentinfo.php to only show the last information in the array?
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…
After clicking on Send, i got these warnings
Notice: Undefined variable: dbc in D:XAMMPhtdocsexamplestudentadded.php on line 98
Warning: mysqli_prepare() expects parameter 1 to be mysqli, null given in D:XAMMPhtdocsexamplestudentadded.php on line 98
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, null given in D:XAMMPhtdocsexamplestudentadded.php on line 100
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, null given in D:XAMMPhtdocsexamplestudentadded.php on line 102
Warning: mysqli_stmt_affected_rows() expects parameter 1 to be mysqli_stmt, null given in D:XAMMPhtdocsexamplestudentadded.php on line 104
Error Occureed
Warning: mysqli_error() expects exactly 1 parameter, 0 given in D:XAMMPhtdocsexamplestudentadded.php on line 116
Great Job! Thanks.
Derek, what is the difference between mysql vs mysqli
marvellous
I== !understand.
Hi Derek, any idea how to link database info to 3rd party websites that are not controlled by you? Such that the various fields (e.g. name, age, sex, etc) are automatically filled in at the click of a button (or two). Something like what Fillr does.
Thank You! Derek! real life saver!
can you make a tutorial on mysql security and the best ways to prevent mysql code injections?
I love your style and the fluency is topnotch.
Awesome Tutorial. Giving you credit for a school project!
super tutorial thank you so much Derek!!
what is that text editor you are using?
When I try to open the “getstudentinfo.php” file through localhost, I keep getting the 404 error.. PLEASE HELP! D:
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!
It is very useful for me ,thanks a lot!
If you really wanna be sure of security then use prepared statements, but this works also.
To get this working on my offline laptop only, do I need any software other than note pad ? If yes, which ones ? Thanks a lot !!
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.
hello derek I have all my php files working without any errors but no record shows in mysql table after completing and submitting the form. Ive checked online for possible reasons but to no avail. any suggestions for me?
Derek, You deserve 1,000,000 subs dude!!!!!
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!
Awesome thank you
Nice man! Thanks a lot!
Derek, thank you for your excellent tutorials.
I need an online database – in other words, a
database that ‘lives’ on my website server (instead of my local computer) so that other
people can log in to view, submit, or remove data. Is there a
way to accomplish this?
Thanks!
I get ‘mysqli_stmt’ errors ;(
+10
PLZ One Video in #PHP_For_Wordpress TNK’s
very helpful ,thx man!