Talk in English - US at Northeast PHP 2017
Short URL: https://joind.in/talk/ad37a (QR-Code (opens in new window))
Database are persistent stores of information but often the syntax of PHP combines with oddities of database to confuse the heck out of novice developers. This presentation will take novice PHP developers through the steps need to store and retrieve data into a database. MySQL will be used for examples but the core knowledge will apply to other databases. Then this foundation will be used to cover efficient use of a database, avoiding the N+1 problem, and how to avoid SQL injection.
Comments are closed.
Slides are at https://www.slideshare.net/davidmstokes/php-database-programming-basics-northeast-php and for those looking for something Intermediate to advanced, please see my 'What Your Database Query is Really Doing'.
Great talk, got some good insights to take home and I never realized limits weren't actually speeding up my query. It does actually speed up my return times sometime.
David is a great speaker and super knowledable.