John Cox

Blogs · @wyome

Tagged development · everything

jQuery plugin: Easy List Splitter | Andrea Cima Serniotti

This post introduces Easy List Splitter, a lightweight jQuery plugin that transforms single lists into multi-column layouts by splitting list items across multiple columns and wrapping them in a container div. The plugin generates clean HTML without inline styles, supports both vertical and horizontal item ordering, preserves nested lists, and allows different column configurations for multiple lists on the same page. All styling is handled through CSS classes rather than hardcoded JavaScript, keeping the plugin size minimal at 4KB with no dependencies.

Permalink

Lightbox Print Option? - SitePoint Forums

This post provides a step-by-step guide for adding print functionality to Lightbox image galleries by creating a dedicated print stylesheet, adding a print button to the lightbox interface, and binding a print command to that button. The solution involves hiding all page elements during printing while displaying only the lightboxed image, then triggering the browser's print dialog when the button is clicked.

Permalink

How to Make a Screencast for Your Website | Webdesigner Depot

Screencasts—short, demonstration videos embedded on websites—significantly boost conversion rates for web applications and services. The piece provides a comprehensive how-to guide covering planning, storyboarding, script writing, recording with free or inexpensive screen-capture software, editing in basic video editors, and adding voiceovers and music to create professional two- to three-minute videos that keep visitors engaged. It also reviews hosting providers, discusses optimal placement and sizing of embedded videos, and offers examples of successful implementations across different websites.

Permalink

Writing Your First Twitter Application with OAuth | Snipe.Net

This 2009 tutorial explains how to use Abraham Williams's Twitter OAuth library to build web applications that authenticate users through Twitter without requiring them to share their login credentials. It walks through registering an application with Twitter, obtaining consumer keys, and implementing OAuth authentication flows using PHP code examples for login pages and callback handlers. The piece emphasizes storing Twitter user IDs rather than usernames in databases (since usernames can change and be reassigned) and cautions developers about Twitter's API rate limits and authentication throttling to avoid repeated failed requests.

Permalink

MySQL Triggers: An instruction guide

MySQL triggers are database objects that automatically execute procedural code in response to INSERT, UPDATE, or DELETE events, enabling complex data maintenance across multiple tables without requiring application-layer logic. The article demonstrates this through a practical example where a trigger automatically updates a salesperson's performance statistics whenever a new sale is inserted, showing how triggers can maintain data integrity faster and more portably than equivalent application code written in languages like PHP or Python.

Permalink

Triggers - MySQL Forge Wiki

I can't write a summary of this content—it's a product listing page rather than an article that argues or reports something. These are marketing descriptions of MySQL database products and services. If you saved an actual article *about* MySQL HeatWave, MySQL AI, or one of these products, please share that instead.

Permalink

An Introduction to MySQL Views - Techotopia

MySQL views are virtual tables created from SELECT statements using the CREATE VIEW syntax, allowing you to package and reuse complex queries—particularly those involving joins across multiple tables—without repeatedly writing the same code. The piece explains how to create basic views from single tables and more useful views that combine data from multiple tables via joins, then shows how to query views as if they were regular tables and manage them with commands like SHOW CREATE VIEW and DROP VIEW. Views are most valuable for simplifying the repeated retrieval of joined data that would otherwise require lengthy SELECT statements each time.

Permalink

jLinq

jLinq is a JavaScript library that lets you query arrays of JSON objects using fluent, chainable syntax instead of loops and conditionals, making it easier to filter, sort, and transform data. The library supports complex queries like filtering records by multiple conditions and sorting by multiple fields, with readable method chaining (for example, filtering people whose first names start with 'a', 'b', or 'c', then sorting by last name). It's also extensible, allowing developers to create custom functions that integrate seamlessly into the library's query interface.

Permalink

pChart | a PHP Charting library

pChart is a free, open-source PHP framework for generating anti-aliased charts that can pull data from SQL queries, CSV files, or manual input, with a focus on rendering quality and performance optimization. The library requires PHP with GD support and includes a caching class (pCache) to reduce server load by storing computed charts for reuse across multiple users. Recent versions have added features like scatter plots, customizable axes, transparent text areas, and support for missing data points.

Permalink