demosthenes.info

I’m Dudley Storey, the author of Pro CSS3 Animation. This is my blog, where I talk about web design and development with , and . To receive more information, including news, updates, and tips, you should follow me on Twitter or add me on Google+.

web developer guide

my books

Book cover of Pro CSS3 AnimationPro CSS3 Animation, Apress, 2013

my other blogs

Massive Head Canon: Intelligent discussion of movies, books, games, and technology.

my projects

A Sass color keyword system for designers. Replaces CSS defaults with improved hues and more memorable, relevant color names.

CSSslidy: an auto-generated #RWD image slider. 3.8K of JS, no JQuery. Drop in images, add a line of CSS. Done.

tipster.ioAutomatically provides local tipping customs and percentages for services anywhere.

Photograph of a man sketching a database design on a piece of glass

Web Developer Reading List: Introduction to MySQL

reading lists / mysql

Estimated reading time: 2 minutes

Databases are one of the major web development solutions to the problem of dealing with large amounts of changing data. Traditional web pages are perfect for presenting static and unchanging information, but as a site grows in scope and complexity creating individual pages for each new product or post rapidly becomes an overwhelming task.

Of all the database formats and languages available, MySQL remains one of the most popular, the “glue” that allows Content Management Systems like WordPress to work. For basic CMS management, a developer might need to know only to know the database name, username and password, but for more ambitious tasks - such as gathering and displaying information in ways never supported by a “stock” CMS install - a deeper understanding is called for.

Handy MySQL Queries: Random Rows, Sequence Gaps, Replace Content & Word Count

mysql

Estimated reading time: 1 minute, 24 seconds

Occasionally you’ll have a need for a query that doesn’t quite fall under the standard range of MySQL statements. A few examples:

Simple INSERT Into A MySQL Database

mysql / introduction

Estimated reading time: 2 minutes, 21 seconds

In previous articles I’ve covered the creation of a MySQL database, and how to select information from it. In this article, I’ll cover insertion of user data into a table.

Insertion of data is usually done via a web form. There are many reasons we might want to do this: the obvious cause is to record input from a user, such as a comment in a blog, or an order for a product. Here, we’ll create a simple version of the former.

First, we’ll create a simple HTML5 on a page:

This site helps millions of visitors while remaining ad-free. For less than the price of a cup of coffee, you can help pay for bandwidth and server costs while encouraging further articles.