• 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

MySQL

By Jeff Cohan, September 13, 2015

Custom Web Form: Contract Generator in PHP & MySQL

Custom Web Form

Forms are the engine that drive user interactivity on the Web. We see them everywhere — they are the meat of eCommerce Web sites and online surveys, and simple versions of forms are common on “Contact Us” pages. Some forms are easy to make, using basic HTML, online form builders, or plugins for platforms like WordPress. But there are other applications for Web forms — including some applications for which you might not initially think a form is the answer — that require a custom solution with custom programming. This article describes a project in which we created a form-based system for generating contracts for a private school’s Independent Study Program. This system, housed within the existing password-protected Intranet/Administrative area of the school’s Web site, automates and streamlines the process of generating contracts, minimizing the need for manual calculations and eliminating most, if not all, of the opportunities for user error.

Read more…

Written by Jeff Cohan · Categorized: Case Studies · Tagged: MySQL, php, Web forms

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, July 26, 2013

Case Study: Emergency Notice Banner for Hybrid Web site

In December of 2012, in anticipation of school closings, late openings, or early dismissals due to extreme weather, the head of Eaton Academy asked me to implement an emergency announcement banner that would appear on all pages of Eaton’s Web site. The challenge was that the Web site is a hybrid: the main section of the site was custom built, while the blog section was built on WordPress. This case study describes the approach we took to solve the problem. I think this project is a good example of how easily WordPress can be hooked into.

Read more…

Written by Jeff Cohan · Categorized: Case Studies · Tagged: MySQL, php, WordPress

By Jeff Cohan, December 14, 2012

How to create 323 unique landing pages with Pretty URLs – from just one page

The Challenge nSiteful Client Jay Maurice operates a music instruction business called Lessons In Your Home. At this writing, the business has over 200 active music teachers in eight major U.S. markets. Jay wanted to optimize his email marketing and pay-per-click advertising campaigns by having a customized landing page for each market and each instrument […]

Written by Jeff Cohan · Categorized: Case Studies · Tagged: GD Lib, Landing Pages, mod_rewrite, MySQL, php

By Jeff Cohan, March 28, 2012

PHP OOP Virtual Study Group?

Any takers? Lemme explain. I’m trying to dive into OOP in PHP. If you are, too – or if you happen to enjoy teaching others what you already know – maybe this is for you.

Written by Jeff Cohan · Categorized: General · Tagged: MySQL, OOP, php, Programming

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

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

  • 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
  • Make your Web Site the Heart & Hub of your Online Marketing Strategy March 24, 2022

Filter By Category/Tag

Categories

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

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

×