40: What are Prepared Statements and how to use them | PHP tutorial | Learn PHP programming

Channel:
Denmark Dani Krossing
Subscribers:
497,000
Published on ● Video Link: https://www.youtube.com/watch?v=I4JYwRIjX6c


Category:
Tutorial
Duration: 18:12
214,015 views
2,936

What are Prepared Statements and how to use them. Today we will learn how to connect to our database using Prepared Statements, which is also a better method of preventing SQL injection. The basic idea behind Prepared Statements, is to create placeholders in our SQL statements when we send them to our database. Then later we fill in the placeholders with parameters that the user send from a form.

➤ GET ACCESS TO MY LESSON MATERIAL HERE!

First of all, thank you for all the support you have given me!

I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!

I am now using Patreon to share improved and updated lesson material, and for a small fee you can access all the material. I have worked hard, and done my best to help you understand what I teach.

I hope you will find it helpful :)

Material for this lesson: https://www.patreon.com/posts/lesson-material-42361704



Other Videos By Dani Krossing


2017-10-2411: How to Create Sub Pages in HTML | Learn HTML and CSS | Full Course For Beginners
2017-10-2210: How to Import New Fonts | Basics of CSS | Learn HTML and CSS | Learn HTML & CSS For Beginners
2017-09-149: CSS Text Styling Tutorial | Basics of CSS | Learn HTML and CSS | Learn HTML & CSS Full Course
2017-08-308: Introduction to Classes and IDs in HTML | Learn HTML and CSS | Learn HTML & CSS Full Course
2017-08-147: How To Create HTML and CSS Comments | Learn HTML and CSS | Learn HTML & CSS Full Course
2017-08-116: How Do We Include CSS In Our HTML | Learn HTML and CSS | Learn HTML & CSS Full Course
2017-08-085: We Use Boxes in Websites | Learn HTML and CSS | HTML Tutorial | Learn HTML & CSS Full Course
2017-07-30How to Create Website Layouts Using CSS Grid | Learn HTML and CSS | HTML Tutorial
2017-07-27CSS grids will change how we create website layouts | Learn HTML and CSS | HTML tutorial
2017-07-2443: Hashing and de-hashing data using PHP | PHP tutorial | Learn PHP programming
2017-07-2040: What are Prepared Statements and how to use them | PHP tutorial | Learn PHP programming
2017-07-2039: Protect your database against SQL injection using MySQLi | PHP tutorial | Learn PHP programming
2017-07-2038: Insert data from a website into a database using MySQLi | PHP tutorial | Learn PHP programming
2017-07-1637: How to show database data on a website using MySQLi | PHP tutorial | Learn PHP programming
2017-07-1336: How to connect to a database in PHP | PHP tutorial | Learn PHP programming
2017-07-044: Create Titles and Text Using HTML | Learn HTML and CSS | Learn HTML & CSS Full Course
2017-07-043: Learn About HTML Elements and Attributes | Learn HTML and CSS | Learn HTML & CSS Full Course
2017-06-272: Let's Create Our First HTML Project | Learn HTML and CSS | Learn HTML & CSS Full Course
2017-06-2611: Get and set DOM using jQuery | jQuery Tutorial | Learn jQuery | jQuery Library
2017-06-221: Get Started With HTML & CSS | HTML Tutorial for Beginners | Learn HTML & CSS Full Course
2017-06-21NEW UPLOAD SCHEDULE + LAST UPLOAD EXPLAINED


Tags:
php prepared statements
prepared statements
prepared statements mysqli
sql injection
how to prevent sql injection
prevent sql injection using php
php
php tutorial
Learn to protect your database against SQL injection
mysqli placeholders
sql using placeholders
how to use prepared statements in php
how to interact with your database using prepared statements
how to use prepared statements together with mysqli
what are prepared statements and how to use them