Writing PREPARED QUERIES in PHP - Secure SQL Tutorial: INSERT, UPDATE, SELECT, DELETE

49 Views
45ghesgd1
0
Published on 14 Oct 2018 / In PHP

You NEED to know HOW TO WRITE PREPARED QUERIES in PHP if you want a secure website, protected from SQL injection. Prepared Queries take it an extra step, and are much more simple to write than complicated & constantly-changing mysqli_/msqyl_ functions. With this FREE tutorial, you can learn how to write prepared queries with PHP and manage a database for your app, website, or other projects!

Sorry about the mic quality - I am fixing my actual camera right now, and figured I will wait til that is back to go and buy a new rode studio mic that can perhaps be dual-use for PC and my camera... so we'll see! In the meantime, if you want to talk just message me on YT or comment on the video - you can also find me at...
http://nerdi.org

https://twitter.com/NerdiOrg
~ If you are on Twitter, make sure you participate in the #100DaysOfCode challenge to prove your determination (to learn new skills), or stop by and encourage other developers!

https://stackoverflow.com/users/9588466/nerdi-org

To learn more about the prepared SELECT query for PHP, check out the QueryPro tool page below:
http://wbr.bz/QueryPro/index.p....hp?query_type=prepar

Or, if you want help setting up an SQL INSERT query, use this page for prepared queries!
http://wbr.bz/QueryPro/index.p....hp?query_type=prepar

This tutorial covers INSERT INTO, UPDATE, SELECT, and DELETE FROM. It also covers simple WHERE statements, database table management / creation and the following functions:
prepare()
bind_param()
execute()
affected_rows
num_rows
store_result()
bind_result()
fetch()
close()

Simply follow along in the video, or use the free QueryPro tool to write your prepared queries for secure SQL now, and in any of your future projects :) Thanks for watching!

Show more
0 Comments sort Sort by

Up next