• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

nSiteful Web Builders

Building a Better Web - One Site at a Time.

  • Home
  • About
    • Testimonials
    • Resources
  • Web Sites
  • Online Marketing
  • WordPress Support
    • Customized WordPress Training
    • 60-for-60 Sessions
  • Web Applications
  • Blog
    • Archive Listing Minimalistic
    • Blog Articles Grouped by Category
    • Case Studies
    • General
    • Portfolio
    • Reviews
    • Snippets
    • Techniques
  • Contact Jeff
    • Purchase Retainer Consulting Hours
    • About Retainer Consulting Hours

Snippets

Code snippets I want to have handy. You might, too.

By Jeff Cohan, February 26, 2014

Update MySQL table using subquery, Excel data

If you’re a developer like me who builds custom database-driven Web sites and Web applications, you don’t necessarily create a user-maintainable content management system (CMS) for absolutely everything you build. In this article, I’m going to show you a simple and practical low-tech solution for adding content from your clients for database-driven content for which you did not build a CMS. The only tools you need for this solution are Microsoft Excel and SQL (in my case, the MySQL flavor).

Read more…

Written by Jeff Cohan · Categorized: Snippets · Tagged: Excel, MySQL, SQL

By Jeff Cohan, September 30, 2013

Custom extensible PHP shortcode function for non-WordPress Web sites

In this article, I’ll share a custom PHP shortcode function I use for my non-WordPress Web sites to improve their maintainability. This function mimics the WordPress shortcode feature.

Read more…

Written by Jeff Cohan · Categorized: Snippets · Tagged: php, WordPress

By Jeff Cohan, June 17, 2013

Fun with CSS3 Multiple Backgrounds

CSS3 supports multiple backgrounds for an element. There are lots of resources on the Web that tell you how to do it. It’s actually remarkably easy and intuitive. And most modern browsers support multiple CSS backgrounds.

What I want to do here is show you why and when you might want to try this.

Read more…

Written by Jeff Cohan · Categorized: Snippets · Tagged: Background Images, CSS

By Jeff Cohan, May 1, 2012

How to embed a YouTube Video in WordPress

Here are the basic tried-and-true steps for embedding a YouTube video into a WordPress Blog post or page, as of this writing. It also applies to embedding videos from several other video servers. Method #1: The Original Way: Embed Code Prior to version 2.9 of WordPress, this was how you had to do it. This […]

Written by Jeff Cohan · Categorized: Snippets · Tagged: Embedding, WordPress, YouTube

By Jeff Cohan, March 22, 2012

Get From Foreigner (utility function)

In your PHP/MySQL applications, have you ever had to get values from a table based on the value of a foreign key in another table? Of course you have! Let me put it this way: Let’s suppose… Suppose you have a database of students and their families. Further suppose each student in the “students” table […]

Written by Jeff Cohan · Categorized: Snippets · Tagged: MySQL, php

By Jeff Cohan, February 9, 2012

NextGen Gallery Compact Album Mods

This article describes how to customize aspects of the NextGen Gallery plugin by modifying an NGG template and making corresponding CSS modifications. You gotta love the NextGen Gallery plugin for WordPress. It is to image galleries in WordPress what Irfanview is to desktop image management. But not everything about NGG is wonderful.

Written by Jeff Cohan · Categorized: Snippets · Tagged: NextGen Gallery, Photo Gallery, Plugins, WordPress

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2

Primary Sidebar

mailchimp signup

Subscribe to get notified when new articles are published. Unsubscribe any time. No spam. I promise. Check out my newsletter archives.

social

Twitter Facebook LinkedIn

Recent Articles

  • Use Case for Custom Post Type: “In The News” March 10, 2023
  • Create a Custom Shortcode to Display a MemberPress Membership Price ANYWHERE on Your Website February 5, 2023
  • Avoid Direct Styling; Use CSS Instead September 21, 2022
  • Blog Tags: What They Are (and What They’re Not) August 5, 2022
  • How to Create a Simple Custom Events Plugin May 24, 2022

Filter By Category/Tag

Categories

  • Case Studies (7)
  • General (61)
  • Portfolio (5)
  • Reviews (12)
  • Snippets (16)
  • Techniques (38)

Popular Tags

Advanced Custom Fields Blogging Child Themes Content Marketing CSS CSS Grid Customer Service Custom Fields Custom Post Types Diagnostics Facebook FooGallery Genesis Gutenberg HTML Images iPhone Libra Live Chat Marketing Media MemberPress MemberPress Courses mu-plugins MySQL Photo Gallery php Pinterest Plugins Post Formats Pricing Project Management Security SEO Seth Godin Shortcodes Social Networking Surveys Taxonomies Trello Twitter Video Web design Web forms WordPress

siteground wp hosting

Web Hosting

wp101

EasyWordPresstutorialvideosforbeginners.
MemberPress CTA

Footer

Background

Web Sites | WordPress Support | Web Applications.

Formally trained in liberal arts and education (I have a B.A. in Government from Harvard and studied Secondary Education at Rutgers Graduate School), I have honed my skills in the communication arts and sciences as a teacher, trainer, instructional designer, writer, photographer, calligrapher, helpdesk manager, database programmer, and multimedia developer.

(I've also been a group counselor, waiter, bartender, bicycle messenger boy, computer salesman, carpenter's helper, financial analyst, and school board president.)

Tech

Systems since 1983.
Web sites since 1994.
PHP since 2001.
WordPress since 2007.

Contact

770-772-5134
Email Jeff
Send Money
All Ways

Copyright 2023, nSiteful Web Builders, Inc.

 

Subscribe

Pardon the interruption. I know popups can be annoying. But I’d love to have you as a subscriber.

Sign up to be notified when new articles are published. Unsubscribe any time.

* indicates required

Powered by MailChimp

×