Book Image

PHP 7 Programming Cookbook

By : Doug Bierer
Book Image

PHP 7 Programming Cookbook

By: Doug Bierer

Overview of this book

PHP 7 comes with a myriad of new features and great tools to optimize your code and make your code perform faster than in previous versions. Most importantly, it allows you to maintain high traffic on your websites with low-cost hardware and servers through a multithreading web server. This book demonstrates intermediate to advanced PHP techniques with a focus on PHP 7. Each recipe is designed to solve practical, real-world problems faced by PHP developers like yourself every day. We also cover new ways of writing PHP code made possible only in version 7. In addition, we discuss backward-compatibility breaks and give you plenty of guidance on when and where PHP 5 code needs to be changed to produce the correct results when running under PHP 7. This book also incorporates the latest PHP 7.x features. By the end of the book, you will be equipped with the tools and skills required to deliver efficient applications for your websites and enterprises.
Table of Contents (22 chapters)
PHP 7 Programming Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Building an OOP SQL query builder


PHP 7 implements something called a context sensitive lexer. What this means is that words that are normally reserved can be used if the context allows. Thus, when building an object-oriented SQL builder, we can get away with using methods named and, or, not, and so on.

How to do it...

  1. We define a Application\Database\Finder class. In the class, we define methods that match our favorite SQL operations:

    namespace Application\Database;
    class Finder
    {
      public static $sql      = '';
      public static $instance = NULL;
      public static $prefix   = '';
      public static $where    = array();
      public static $control  = ['', ''];
      
        // $a == name of table
        // $cols = column names
        public static function select($a, $cols = NULL)
        {
          self::$instance  = new Finder();
          if ($cols) {
               self::$prefix = 'SELECT ' . $cols . ' FROM ' . $a;
          } else {
            self::$prefix = 'SELECT * FROM ' . $a;
          }
          return self::$instance;
        }
      ...