PHP Prepared Statements and MySQL Table Design

Ed Barnard

Tuesday 24 October 2017 from 10:15 to 11:15

Talk in English - US at ZendCon 2017
View Slides: https://www.dropbox.com/s/kdu066k6etefkyi/Prepared-V06.pdf?dl=0
Checkout the code: https://github.com/ewbarnard/PreparedStatements
Short URL: https://joind.in/talk/9cd27 (QR-Code (opens in new window))

Avg. Rating

When using a PHP framework, standard practice is to use an Object-Relational Model (ORM) for database access. However, with high-volume logging and statistics-gathering, it pays to go "old school" with PHP prepared statements. Meanwhile, when MySQL tables quickly grow by millions of rows, table storage space becomes an issue. Our table design must focus on keeping these tables more compact and efficient. Here too, prepared statements simplify both coding and table design. This session will use CakePHP 3's excellent support for PHP prepared statements, but all concepts are native to PHP and apply to any project striking this use case.

Comments

Comments are closed.

Kirt Jeppson at 11:29 on 24 Oct 2017

Thanks for this. I can see my self using this a lot in my permission as a some what custodian of the code.

Ferrett Steinmetz at 11:48 on 24 Oct 2017

Solid introductory talk on normalization and prepared statements.

Tim Ledlie at 09:55 on 27 Oct 2017

Clear introduction

Elli at 10:49 on 27 Oct 2017

Learned a lot and will be implementing this at work!

Amanda Findley at 15:40 on 27 Oct 2017

Although a lot of this information was basic and things I already knew, the presentation was done in an engaging manner. I learned a few things, not as new concepts, but as correct terms for practices I already imply. There was one slide I wanted to screen cap and show my coworker. "See, this is why we normalize our tables!" Thanks for the great talk.