SitePoint PHPSQLite 3 Beyond the Basics (29.5.2015, 16:00 UTC)

In the introductory post to SQLite 3, we covered some basic commands, database and table creation, and more. In this one, we’ll go into more depth - exploring both familiar features from other databases and features that make SQLite stand out.

It is assumed you went through the introductory post before continuing with this one, or that you are comfortable with the basics of SQLite 3. If you haven’t, please take the time to do so.


SELECT is a standard SQL command and belongs in the Data Query Language (or DQL). It lets you perform queries on a database and fetch required records. The results can be optimized using various clauses provided by SQLite.

Open up the terminal and type: sqlite3 Library.db

This would create a database named Library.db in the current directory.

Continue reading %SQLite 3 Beyond the Basics%

Ben RamseyFun Recruiter Messages (28.5.2015, 22:00 UTC)

Earlier today in the #coderabbi Freenode IRC channel, we were discussing recruiter messages. I thought I’d share one of my favorite gems from over the years.

Would you like to join one of the fastest growing start-ups in Rhode Island? Would you like to be apart [sic] company that makes dreams come true? If you are passionate about Ruby and Opensource technology development than [sic] this is the place for you. Wouldn’t it be nice to come home every day and know you are doing what you love in a company that loves your work? This is not just your average “job”. This is opportunity; this is a blur between dreams and reality; this is the opportunity that is going to slingshot you to happiness & career satisfaction.

Without shaming, ridiculing, or calling out any individuals, what’s your favorite recruiter message?

is a web craftsman, author, and speaker. He builds a platform for professional photographers at ShootProof, organizes user groups, and lives in Nashville, TN with his wife, son, and dog named Echo. Ben blogs at and is @ramsey on Twitter.

“Fun Recruiter Messages” was originally published at and is Copyright © 2015 Ben Ramsey. It is licensed for use under a Creative Commons Attribution-ShareAlike license.

PHP ClassesReview: PHP Beyond the web (28.5.2015, 06:46 UTC)
PHP Beyond the web
Luis Martinez Ulloa
PHP books
Rob Aley
This book is a real guide to developers who want to take advantage of the general purpose capabilities of PHP to make things different besides Web apps.

I recommend this book because I believe it is complete, as its chapters follow solid guidelines to successfully develop non-Web based PHP projects.
SitePoint PHPPagination with jQuery, AJAX and PHP (27.5.2015, 16:00 UTC)

In this article, we’re going to explain how easy it is to paginate your data set using PHP and AJAX via jQuery. We’re also going to use the Silex framework for simplicity.

jQuery Logo

The data source

First off, we need some data to paginate!

id name age
1 Jamie 43
2 Joe 24
3 Fred 23
4 Clive 92
5 Roy 73
6 Geoff 24
7 Ray 12
8 John 9
9 Pete 32
10 Ralph 34

For the purpose of this example we’re going to use MySQL, but of course we can swap this out easily for SQLite or any other RDBMS. We’re going to name our database example and the table will be named people.

The backend

As we’re going to build our application on Silex, we need to install Silex using Composer first. Install it through composer with the command composer require silex/silex.

Next we need set up our index.php file, connect to the data source and select the database. We’re going to use PDO for this as it is easy to change to other database software later, and it also handles escaping user input (thus preventing SQL injection attacks). If you’re still stuck on the mysqli or even worse the mysql extension, see this tutorial. We’re going to put the connection in the $app container so it’s easy to use later in our routes.

Continue reading %Pagination with jQuery, AJAX and PHP%

PHP ClassesCreate a Google Maps alternative with PHP and MySQL using the Leaflet library (27.5.2015, 10:09 UTC)
By Ashraf Gheith
Leaflet is a JavaScript library that became popular for creating mobile friendly Web maps applications. It does not depend on Google, so you do not need to pay fees as you may need to when you use Google Maps.

Read this tutorial to learn how to use Leaflet library with PHP and MySQL to create an alternative to Google Maps and implement it on your site.
Qafoo - PHPDevelopers Life is a Trade-Off (27.5.2015, 08:58 UTC)
At Qafoo, we train a lot of people on topics like object oriented software design, automated testing and more. It happens quite often that an attendee asks questions like "Which is the best solution for problem class $x?", "What is the optimal tool for task $y" or "There is a new technology $z, is that the future of web development?". Some are disappointed when I reply "It depends" or "That does not exist", but that's the truth.There is no silver bullet and one of the most important skills every developer needs to hone is to assess possibilities and to find the best trade-off for the current challenge.To make that point clear I'm giving three examples from my personal experience, some where it went well and some where it did not.
Michelangelo van DamLittle things can make a difference (26.5.2015, 22:37 UTC)
Source: theleticiabertin on

Wow, I never expected this much involvement when I created an overview of upcoming conferences this fall. I cannot deny I love Markdown to write simple things and I love simplicity. I use IA Writer to have distraction-free editing power on both my phone and laptop.

iA Writer

iA Writer is a minimalist text editor for OS X and iOS developed by Information Architects Incorporated. The idea of iA Writer is "to keep you focused on just writing". iA Writer has been "downloaded 600,000 times by everyone from hobbyist writers to the bestselling author Augusten Burroughs." It is the top selling text editor in the App Store behind Apple's own Pages application.

Truncated by Planet PHP, read more at the original (another 4969 bytes)

Nomad PHPPHP 7 the Big 5 + 1 (26.5.2015, 20:15 UTC)

PHP 7 the Big 5 + 1

Presented By
Cal Evans
DATE 20:00 CDT

The post PHP 7 the Big 5 + 1 appeared first on Nomad PHP.

Nomad PHPDriving Quality with PhpSpec (26.5.2015, 17:00 UTC)

Driving Quality with PhpSpec

Presented By
Ciaran McNulty
August 20, 2015 20:00 CEST

The post Driving Quality with PhpSpec appeared first on Nomad PHP.

Lorna MitchellRecover Bitly Bundle Data (26.5.2015, 14:57 UTC)

For some years I've been creating a bundle of links covering articles I recommend for various topics in the Zend Certified Engineer Exam (if you can here looking for the bundle itself, it's at This was done using bitly's bundles feature, which I thought was a great way to share links. In fact I had 10-15 bundles that I had created from collating all the links in a particular training course or talk, so that people didn't have to try to write down URLs as I went along. Unfortunately they sunset their bundles and then removed them completely, and I missed the announcement (it all happened quite quickly, they'd seen some abuse of the feature, it's free, all totally reasonable) BUT they also didn't respond to my support questions about how to recover the data.

It turns out, it's an undocumented feature on their API, so here is everything I know about recovering your bundle data, including the script I used to rescue my own data.

Bundle Data Via API

The endpoint you want is /v3/user/link_history and the documentation is here: Many MANY thanks to @jehiah for tweeting this information at me, it was a huge help! What they omitted to mention is that you'll also find a "tags" array in the values for each link as well (I assume the documentation will update really soon).

Bitly also has an API browser so you may be able to get your data out through that without needing code. I'm a programmer though so I wrote a script ...

Bitly Bundle Rescue Script

Here's my scratty script to export data. You need to do 3 things to use this:

  1. Add guzzlehttp/guzzle to your composer.json file and install it
  2. Use the instructions in the comment at the top to get your access token (or use the bitly web interface
  3. Look around line 55 and comment/uncomment as appropriate depending on whether you want a CSV export or an HTML output

require "vendor/autoload.php";
 * To request access token:
 * curl -u "username:password" -X POST ""
 * Composer: composer require "guzzlehttp/guzzle": "~5.3"

$access_token = 'GenerateYourOwn';

$client = new GuzzleHttp\Client();
$offset = 0;
$limit = 100;

while(true) {
    $response = $client->get('',
        ["query" => [
            'access_token' => $access_token,
            'limit' => $limit,
            'offset' => $offset,
    if($response->getStatusCode() == 200) {
        $responseData = json_decode($response->getBody(), true);

Truncated by Planet PHP, read more at the original (another 6041 bytes)

LinksRSS 0.92   RDF 1.
Atom Feed   100% Popoon
PHP5 powered   PEAR
ButtonsPlanet PHP   Planet PHP
Planet PHP