Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

SitePoint PHP Blog:
3 More Joins You Should Be Familiar With
Feb 08, 2016 @ 12:18:36

On the SitePoint PHP blog Zach Wallace shares more database wisdom with his readers introducing three more JOINs you should know in your development work.

There are many ways to JOIN data from two database tables and filter the information you require. Craig Buckler wrote a popular piece on understanding JOINs; namely INNER, LEFT, RIGHT, and FULL OUTER. This article is an extension of that one.

He starts with the data he'll be working with: customers and books, linked by a book_id column. He then quickly reviews some of the joins already discussed in the previous article (LEFT, RIGHT, OUTER, INNER) before getting into the newer, more powerful types:

  • LEFT JOIN with Exclusion
  • RIGHT JOIN with Exclusion
  • OUTER JOIN with Exclusions

He finishes the post with a few other thoughts about using WHERE clauses in JOINs, the CROSS JOIN and how the JOINs relate to each other in MySQL.

tagged: join database three list inner outer left exclusion advanced example tutorial

Link: http://www.sitepoint.com/3-more-joins-you-should-be-familiar-with/

Paul Gregg's Blog:
PHP algorithms: Determining if an IP is within a specific range.
Apr 28, 2009 @ 09:25:39

Paul Gregg has shared a method he's come up with to determine if a given IP is within a selected range.

Unfortunately although people usually understand that an IP address is simply an unsigned 32 bit integer, and is easily determined, usually with $_SERVER['REMOTE_ADDR'], where the real challenge is - is in specifying the range within which they wish to check that IP address. IP ranges are usually specified in three common ways (in increasing complexity): wildcard, start-end range, classless inter-domain routing.

He looks at each method and includes descriptions and code examples as well as a link to the source code and a live demo of it in action.

tagged: algorithms ip address specific range three method wildcard cidr startend

Link:

Zend Developer Zone:
Tim Bray Explains Why Solaris in a Good Choice for PHP Developers
Oct 20, 2006 @ 09:51:56

Over on the Zend Developer Zone, Cal Evans shares part of a mini-interview (one question, really) where Cal asked Tim about Solaris as a hosting and development platform for PHP.

Tim will be at ZendCon this year participating in a panel discussion titled "How Do The Stacks Stack Up?" I talked with Tim by phone because I was curious why PHP developers should consider Solaris as a development and deployment environment. Here's what Tim had to say.

His answer was based around three main points - observability, virtualization "stuff", and the ZFS filesystem all Solaris systems come installed with. And, of course, he explains the thought process behind each (briefly).

tagged: solaris interview timbray developer question three points solaris interview timbray developer question three points

Link:

Zend Developer Zone:
Tim Bray Explains Why Solaris in a Good Choice for PHP Developers
Oct 20, 2006 @ 09:51:56

Over on the Zend Developer Zone, Cal Evans shares part of a mini-interview (one question, really) where Cal asked Tim about Solaris as a hosting and development platform for PHP.

Tim will be at ZendCon this year participating in a panel discussion titled "How Do The Stacks Stack Up?" I talked with Tim by phone because I was curious why PHP developers should consider Solaris as a development and deployment environment. Here's what Tim had to say.

His answer was based around three main points - observability, virtualization "stuff", and the ZFS filesystem all Solaris systems come installed with. And, of course, he explains the thought process behind each (briefly).

tagged: solaris interview timbray developer question three points solaris interview timbray developer question three points

Link:

Jorge Garifuna's Blog:
Build a Complete PHP Application in 3 Clicks
Jun 06, 2006 @ 17:10:02

Sometimes, just the idea of starting off a new project makes developers shy away from an idea. They think about everything they have to set up even before they get to the real work. Thankfully, there are solutions out there to help you get down to the real work real fast. For example, the ATK Code Generator, an application designed to simplify creation of an application to a few clicks. This new tutorial from Jorge Garifuna shows you how.

Developers can spend their time creating robust database schema and feed it to the ATK Code Generator to see instant web applications customized for the schema. Something that used to take months to create, has been cut to minutes and instant results.

He mentions specifically a three-step method to create an "application" around a database table. The user views the tables in the software, customizes the options for it, and clicks to have the ATK Code Generator build it out for them.

Also included in the post are links to the project's homepage, some documentation, and screenshots of the application at work.

tagged: complete application three clicks atk generator complete application three clicks atk generator

Link:

Jorge Garifuna's Blog:
Build a Complete PHP Application in 3 Clicks
Jun 06, 2006 @ 17:10:02

Sometimes, just the idea of starting off a new project makes developers shy away from an idea. They think about everything they have to set up even before they get to the real work. Thankfully, there are solutions out there to help you get down to the real work real fast. For example, the ATK Code Generator, an application designed to simplify creation of an application to a few clicks. This new tutorial from Jorge Garifuna shows you how.

Developers can spend their time creating robust database schema and feed it to the ATK Code Generator to see instant web applications customized for the schema. Something that used to take months to create, has been cut to minutes and instant results.

He mentions specifically a three-step method to create an "application" around a database table. The user views the tables in the software, customizes the options for it, and clicks to have the ATK Code Generator build it out for them.

Also included in the post are links to the project's homepage, some documentation, and screenshots of the application at work.

tagged: complete application three clicks atk generator complete application three clicks atk generator

Link:

Jan Schneider's Blog:
3 projects at Google's Summer of Code
May 25, 2006 @ 05:33:19

Jan Schneider has a new blog post today concerning the acceptance of three projects (based on the Horde Project) into the Google "Summer of Code" program for this year.

3 student applications for projects in the Horde Project have been accepted by Google's Summer of Code 2006 program: an LDAP browser/manager, a Live CD, and "Wandering Books".

Here's some of the details:

  • Jonathan Burchfield's LDAP module for the Horde Application Framework to include full read/write functionality when completed
  • Soumyadip Modak's development of a Horde bootable Live CD with a complete install of all Groupware modules Horde.
  • Luciano Ramalho's "Wandering Books" application to allow anyone to turn their own library into a lending library quickly and easily.

tagged: three projects google summerofcode horde ldap livecd library three projects google summerofcode horde ldap livecd library

Link:

Jan Schneider's Blog:
3 projects at Google's Summer of Code
May 25, 2006 @ 05:33:19

Jan Schneider has a new blog post today concerning the acceptance of three projects (based on the Horde Project) into the Google "Summer of Code" program for this year.

3 student applications for projects in the Horde Project have been accepted by Google's Summer of Code 2006 program: an LDAP browser/manager, a Live CD, and "Wandering Books".

Here's some of the details:

  • Jonathan Burchfield's LDAP module for the Horde Application Framework to include full read/write functionality when completed
  • Soumyadip Modak's development of a Horde bootable Live CD with a complete install of all Groupware modules Horde.
  • Luciano Ramalho's "Wandering Books" application to allow anyone to turn their own library into a lending library quickly and easily.

tagged: three projects google summerofcode horde ldap livecd library three projects google summerofcode horde ldap livecd library

Link:

Davey Shafik's Blog:
php|tek Day 3
May 01, 2006 @ 07:02:15

Davey Shafik has posted his third and final day's summary for the php|tek conference put on by php|architect.

He recounts the talks he attended, including Hartmuts talk on Clustering MySQL, the Keynote from another of the php|architect staff, and a vote that was taken on the suggested location for next year's php|architect spring conference.

Davey has also posted quite a few pictures over on the php|tek photostream on Flickr for a bit of the experience for those not able to attend.

tagged: phptek conference day three keynote mysql phptek conference day three keynote mysql

Link:

Davey Shafik's Blog:
php|tek Day 3
May 01, 2006 @ 07:02:15

Davey Shafik has posted his third and final day's summary for the php|tek conference put on by php|architect.

He recounts the talks he attended, including Hartmuts talk on Clustering MySQL, the Keynote from another of the php|architect staff, and a vote that was taken on the suggested location for next year's php|architect spring conference.

Davey has also posted quite a few pictures over on the php|tek photostream on Flickr for a bit of the experience for those not able to attend.

tagged: phptek conference day three keynote mysql phptek conference day three keynote mysql

Link: