PHP is almost synonymous with databases, and has been since the early versions. Yet creating SQL queries can still be a challenging task. What's the right tool to use? ORMs often feel like overkill. And creating queries by hand can be unmaintainable. In this session, I'll show you how to use the Zend\Db library to generate SQL queries; from simple selects, through to more complex unions, filtered deletions, and updates. You'll learn how to use the library to create flexible, secure, maintainable, and reusable queries quickly, and efficiently, saving you time and effort in the long term.
Matthew Setter settermjd
|DROP TABLE IF EXISTS `departments`;|
|CREATE TABLE `departments` (|
|`dept_no` char(4) NOT NULL,|
|`dept_name` varchar(40) NOT NULL,|
|PRIMARY KEY (`dept_no`),|
|UNIQUE KEY `dept_name` (`dept_name`),|
|KEY `idx_deptno` (`dept_no`) USING BTREE|
|) ENGINE=InnoDB DEFAULT CHARSET=latin1;|
|DROP TABLE IF EXISTS `dept_emp`;|
Do you have an awesome WordPress plugin, Drupal module, Zend Framework module, or PHP library, one that you want people to use, to be truly successful, perhaps one people even rave about? Often, most of the effort expended on a project goes in to development, with documentation and promotion considered after-thoughts. But these two steps are essential to a project's success. In this session, I'll show you key ways to document and promote your project, so it's easier to find out about, to start using, to maintain, and to grow its reputation, using examples of real world successes.
Ever dreamed of being your own boss? We often think that building a business involves a lot of money and time (and it does). There are also innumerable software applications to handle countless day-to-day processes; whether that's accounting, project management, time tracking, and so on.
In reality however, its not that difficult to spin up infrastructure to support routine business tasks. Whether you're starting out as a freelancer, or building a fully-fledged business, replete with employees and payroll, there are services and apps to help.
In this session, I'll show you the key applications you need to start and build a successful business, on a virtual shoestring. Along the way, I'll share what I've learned building my own programming and writing business, when it comes to working with clients, getting paid, and managing projects and tasks.
This gist is about:
functioncannot (should not) be used when side-effects occur