Category: Web Programming

Introduction to Databases for the Web

My image
  • Author: Selena Sol
  • Format: online HTML
  • Price: free

This is a free four part course, suitable for webmasters and web developers with little or no database experience. The goal of this tutorial is to introduce database concepts and give you the tools you need to get to work using the databases available to you. The first part introduces the various types of database systems, especially relational databases and the SQL language. Examples are given of creating and manipulating a database and tables within it.

Chapters include:

  • What is a Database
  • Types of Databases
  • Analytic Databases
  • Operational Databases
  • Databases Models
  • Hierarchical Databases
  • Network Databases
  • Relational Databases
  • Client Server Databases
  • Good Database Design
  • Talking to a Database
  • The Basics of the SQL Database
  • Tables
  • The Data Dictionary
  • Basics of an SQL Query
  • Data Types
  • Logging on to the Database
  • A Sample Database
  • Creating Databases
  • Creating Tables
  • Deleting Databases and Dropping Tables
  • Altering a Table
  • Retrieving Data
  • Wildcards
  • Where
  • And, Or, and Not
  • Between
  • In
  • Like
  • Null
  • Order by
  • Performing math
  • Maximums and Minimums
  • Counting Records
  • Distinct
  • Averages
  • Joins
  • Subquerries
  • Adding Data
  • Modifying Data
  • Deleting Data
  • Server Side Database Communication With CGI
  • Chains of Communication
  • Using Perl 5 and the DBI Module to Communicate With Databases
  • The DBI Module
  • The DBI API
  • Getting the Pieces
  • Installing Perl
  • Installing a Web Server : Sambar
  • Running CGI Applications on a Single Station Local Area Network
  • Setting up a Sample Database
  • Putting it all together with a DBI-Aware CGI Script
  • Intro to JDBC
  • JDBC Application Environment Setup
  • Using JDBC to Connect to a Database
  • Using JDBC to Query a Database
  • Using JDBC to Modify a Database
  • More on JDBC
  • JDBC by Example

Introduction to XML for Web Developers

My image
  • Author: Selena Sol
  • Format: online HTML
  • Price: free

In this tutorial, Selena Sol walks you through XML and the sister XSL style sheet language. Using simple, well-explained examples, Sol shows you how to get up to speed with the syntax of XML.

Chapters include:

  • What is a Markup Language
  • What is XML
  • Advantages of XML: Breaking the Tag Monopoly
  • Advantages of XML: Moving Beyond Format
  • Disadvantages of XML
  • History of XML
  • The Basics of XML
  • Well Formed XML
  • XML Document Structure
  • Data Versus Markup
  • The XML Declaration
  • Elements
  • Character Data
  • Tags
  • Comments
  • Processing Instructions
  • Entities
  • General Entities
  • Parameter Entities
  • The DOCTYPE Declarations
  • Entity References
  • Introducing the Valid XML Document and the DTD
  • The Prolog and The Body
  • The Basic DTD
  • Element Type Declarations (ETDs)
  • Defining Elements and their Children
  • Ordering Child Elements
  • Repeated Elements
  • Grouping Elements
  • Either/Or
  • Optional Children
  • Mixed Content
  • Empty Elements
  • Defining Valid Element Attributes
  • Attribute Defaults
  • Attribute Types
  • ID and IDREF
  • Entity Declarations
  • Gathering DTDs from Multiple Sources
  • Public DTDs

The Web Book

My image
  • Author: Robert Schifreen
  • Format: PDF download (click the blue download button)
  • Price: Free for personal use

The Web Book is a complete 330-page book that tells you how to create a Web site from scratch. It covers everything from registering a domain name and renting some hosting space, to creating your first HTML page, to building full online database applications with PHP and MySQL. You can download The Web Book as a PDF file completely free of charge for personal use.

Contents include:

  • About The Web Book
  • Our Choice of Web Host
  • Licensing The Web Book
  • A Custom Edition For Your Company
  • Who’s Written This Book?  And Why?
  • Why We’re Here
  • From Word Processor to Web Site
  • How long should all this take?
  • What Is a Web Site Anyway?
  • How the Web Works
  • Domain Names
  • The Simple Option
  • The Flexible Option
  • About Web Content
  • Do you need a development server?
  • Getting Everything Together
  • Our Domain Name and Hosting
  • It’s Not Rude to Point
  • Our HTML Editor and FTP Client
  • Amaya
  • Make A Web Work Folder
  • Filezilla
  • Creating Your First Web Page
  • Now step away from the computer!
  • Keep On Reading
  • WWW – What, Why, Who?
  • Importing Existing Content
  • Writing For The Web
  • Fonts and Colours
  • Hyperlinks
  • Linking to Other Sites
  • Mailto: Links
  • Understanding The Basics of HTML
  • Meta tags
  • HTML and Privacy
  • Validating your HTML
  • A Bit More about Accessibility
  • Cascading Style Sheets
  • About DOCTYPEs
  • Getting Started with CSS
  • A Word About Fonts
  • Classes
  • Making Styles Work For You
  • HTML Tags Names
  • A Better CSS Editor
  • ID-based Styles
  • Extreme CSS
  • Page Layouts and Div Tags
  • The CSS Box Model
  • Pictures On Pages
  • About Image Sizes
  • Pictures As Links
  • Finding Images to Use on Your Site
  • A Browser Icon for your Site
  • The Short Cut to Great Web Pages
  • Using an Open Source Design
  • Tweaking the Text
  • Changing the Pictures
  • Changing the CSS Styles
  • Which Style Is This?
  • Adding Pages and Navigation
  • Uploading the Finished Files
  • Rules, Tables and Image Maps
  • Rules
  • Tables
  • Image Maps
  • Password-Protecting your Web Pages
  • The .htaccess File
  • The .htpasswd File
  • Protecting Multiple Folders
  • CMSes and Other Software
  • CMSes and Templates
  • Automatic Installers
  • Try Before You Install
  • A Word about Patching
  • Setting Up A Database
  • General Installation Procedures
  • Uninstalling
  • Joomla
  • Uploading the Files
  • Configuring Joomla
  • Your New Joomla Site
  • WordPress
  • Downloading the Software
  • Make a Database
  • Configure WordPress
  • Upload The Software
  • Final Configuration
  • phpBB
  • File Permissions
  • Plogger
  • Getting Started
  • The Installation Process
  • Uploading Your Pictures
  • Avoiding Data Overload
  • Installing the PSPad Editor
  • Javascript
  • Choose Your Side
  • Javascript and Semicolons
  • Email Address Obfuscation
  • Why Upload?
  • Security and Cookies
  • Morning All!
  • Getting the Screen Size
  • Javascript Toolkits and Frameworks
  • Finding Out More
  • MySQL and Web Databases
  • Databases, Tables, Fields, Rows and Columns
  • Normalization
  • Referential Integrity
  • Creating A Database
  • Using phpMyAdmin
  • Creating The Customers Table
  • Inserting Some Data
  • Querying the Customers Table
  • Introducing PHP
  • Don’t Panic
  • Your First PHP Program
  • Some More PHP
  • Random Numbers
  • Sending Email with PHP
  • Passing Information to PHP
  • Don’t Forget to Sanitize
  • Loop the Loop
  • Arrays
  • User-Defined Functions
  • HTML Forms
  • Creating a Form with Amaya
  • Naming the Form Objects
  • Handling Form Data in PHP
  • Testing The Form
  • Other Types of Form Data
  • Checkbox Arrays
  • Feedback Forms
  • Hidden Fields
  • Accessing MySQL Databases with PHP
  • Counting Rows
  • Reading Data
  • Searching A Table
  • About SQL Injection Attacks
  • Adding Data to a Table
  • Editing a Data Record
  • Deleting Data
  • Putting it All Together
  • Debugging and Global Variables
  • Syntax Errors
  • Coding Errors
  • The $_SERVER Variables
  • The Structure of a PHP Application
  • Web Servers and the Real World
  • Putting the App Together
  • Saving State
  • How to Back Up your Web Site
  • Don’t Forget the Database
  • Restoring Lost Information
  • Finance and Marketing Issues
  • Promoting Your Site
  • Making Money
  • Accepting Online Payments
  • Managing your Marketing
  • Search Engine Optimisation
  • SEO Tips
  • Keeping the Crawlers Away
  • If at First you Don’t Succeed, Pay
  • The End.  So, What Now
  • Appendix A – Building a Test Server
  • Our Goal
  • First Install the OS
  • Some Useful Commands
  • Get Updated
  • Test Your Web Server
  • Install the Telnet Server
  • An ftp server
  • Webmin
  • Webalizer
  • PHP and MySQL

Get the book: The Web Book

Active Server Pages

My image
  • Author: Wikibooks, the open-content textbooks collection
  • Format: HTML
  • Price: free

This book is organized into modules. Each module should take you about one hour to complete. Later modules build upon earlier modules, so you are encouraged to read them in sequence.

The book is a work in progress, and there may be incomplete or missing chapters.

Chapters include:

  • Prerequisites
  • Differences between ASP 3.0 and ASP.NET
  • Your first page
  • Basic ASP Syntax
  • Variable Types
  • Expressions
  • Conditionals and Looping
  • Functions and Subroutines
  • Database Access Using ADO
  • Server-Side Includes
  • Appendix A: Language Reference
  • Protecting against user-input (XSS attacks)

Perl Programming

My image
  • Author: Wikibooks, the open-content textbooks collection
  • Format: HTML
  • Price: free

Perl is a programming language designed by Larry Wall, known today for its strong community and module archive CPAN. It was originally developed to process text and produce reports. As a result, a backronym has been formed from its name: Practical Extraction and Report Language. It makes extensive use of significant punctuation, and highly chaotic-looking code has been written in it. This has resulted in a less complimentary backronym (which is still embraced by Perl users): Pathologically Eclectic Rubbish Lister (said to be a quote from the language designer himself).

Perl is Free Software, available under the Artistic License and the GPL. It was developed on Unix, and its Unix roots are pervasive. Perl is available for most operating systems but is particularly prevalent on Unix and Unix-like systems, and is growing in popularity on Microsoft Windows systems. However, it has been ported to a multitude of environments (some say as many as Java). It’s a popular systems administration tool in Windows. Most of the things done in Perl transfer well from one operating system to another (provided suggested conventions are followed).

The book is a work in progress, and there may be incomplete or missing chapters.

Chapters include:

  • Editors and IDEs
  • First Program
  • Basic Variables
  • Strings
  • Numbers
  • Making choices: if and else
  • Doing things over and over: while and for loops
  • Operators
  • Variables
  • Data Types
  • Scalar Variables
  • Array Variables
  • Hash Variables
  • User I/O
  • Advanced Output
  • Filehandles
  • Statement modifiers
  • Functions
  • Perl 5.10 Additions
  • Exercises
  • Programming Structure and style
  • References and Data Structures
  • Regular Expressions
  • Regular Expression Operators
  • Regular Expressions Reference
  • Code reuse (modules)
  • Perl Objects
  • GUI and desktop programming
  • CPAN
  • DBI – Perl Database Interface
  • CGI
  • FastCGI
  • mod_perl
  • HTML::Mason
  • Perl 6
  • Humour
  • First example code to get you started
  • Second example code to get you started
  • Function Reference
  • Concept Index
  • Useful Modules
  • Quick-reference cards
  • Websites

PHP 5 Power Programming

PHP 5 Power Programming
  • Author: Andi Gutmans, Stig Sæther Bakken, and Derick Rethans
  • Format: online PDF
  • Price: free

This book is an introduction to the advanced features new to PHP 5. It is written for PHP programmers who are making the move to PHP 5. Although Chapter 2, “PHP 5 Basic Language,” contains an introduction to PHP 5 syntax, it is meant as a refresher for PHP programmers and not as a tutorial for new programmers. However, web developers with experience programming other high-level languages may indeed find that this tutorial is all they need in order to begin working effectively with PHP 5.
Chapters include:

  • What Is New in PHP 5?
  • PHP 5 Basic Language
  • PHP 5 OO Language
  • PHP 5 Advanced OOP and Design Patterns
  • How to Write a Web Application with PHP
  • Databases with PHP 5
  • Error Handling
  • XML with PHP 5
  • Mainstream Extensions
  • Using PEAR
  • Important PEAR Packages
  • Building PEAR Components
  • Making the Move
  • Performance
  • An Introduction to Writing PHP Extensions
  • PHP Shell Scripting
  • PEAR and PECL Package Index
  • phpDocumentor Format Reference
  • Zend Studio Quick Start

Getting Real: The smarter, faster, easier way to build a successful web application

My image
  • Author: 37signals
  • Format: online HTML
  • Price: free

Getting Real details the business, design, programming, and marketing principles of 37signals. The book is packed with keep-it-simple insights, contrarian points of view, and unconventional approaches to software design.

This is not a technical book or a design tutorial, it’s a book of ideas. Anyone working on a web app — including entrepreneurs, designers, programmers, executives, or marketers — will find value and inspiration in this book.

37signals used the Getting Real process to launch five successful web-based applications (Basecamp, Campfire, Backpack, Writeboard, Ta-da List), and Ruby on Rails, an open-source web application framework, in just two years with no outside funding, no debt, and only 7 people (distributed across 7 time zones).

Over 500,000 people around the world use these applications to get things done. Now you can find out how they did it and how you can do it too. It’s not as hard as you think if you Get Real.

Chapters include:

  • Introduction
  • The Starting Line
  • Stay Lean
  • Priorities
  • Feature Selection
  • Process
  • The Organization
  • Staffing
  • Interface Design
  • Code
  • Words
  • Pricing and Signup
  • Promotion
  • Support
  • Post-Launch
  • Conclusion

Philip and Alex’s Guide to Web Publishing

My image
  • Author: Philip Greenspun
  • Format: online HTML
  • Price: free

This book is a catalog of the mistakes that I’ve made while building more than 100 Web sites in the last five years. I wrote it in the hopes that others won’t have to repeat those mistakes.

In a society that increasingly rewards specialists and narrowness, Web publishing is one of the few fields left where the generalist is valuable. To make a great site, you need to know a little bit about writing, photography, publishing, Unix system administration, relational database management systems (RDBMS), user interface design, and computer programming. I have thus assumed no specific technical background among my readers and have tried to make the text self-contained.

Chapters include:

  • Envisioning a site that won’t be featured in
  • So you want to join the world’s grubbiest club: Internet entrepreneurs
  • Scalable systems for on-line communities
  • Static site development
  • Learn to program HTML in 21 minutes
  • Adding images to your site
  • Publicizing your site
  • So you want to run your own server
  • User tracking
  • Sites that are really programs
  • Sites that are really databases
  • Database management systems
  • Interfacing a relational database to the Web
  • ecommerce
  • Case studies
  • Better living through chemistry
  • A future so bright you’ll need to wear sunglasses

Software Engineering for Internet Applications

  • Author: Eve Andersson, Philip Greenspun, Andrew Grumet
  • Format: online HTML
  • Price: free

This book requires some previous programming experience. It is not language specific. It will take you through the process of building multi-user internet applications, with the end results of being able to write large scale applications, similar to the ones used on most large interactive websites. Originally written for an MIT course, it is suitable for classroom use, as a textbook.

Chapters include:

  • Introduction
  • Basics
  • Planning
  • Software Structure
  • User Registration and Management
  • Content Management
  • Software Modularity
  • Discussion
  • Adding Mobile Users To Your Community
  • Voice (VoiceXML)
  • Scaling Gracefully
  • Search
  • Planning Redux
  • Distributed Computing with HTTP, XML, SOAP, and
  • WSDL
  • Metadata (programs that write programs)
  • User Activity Analysis
  • Writeup

Reference Chapters:

  • HTML
  • Engagement Management by Cesar Brea
  • Grading Standards (mostly for MIT students)



Buy Print Edition (paid link)

As an Amazon Associate I earn from qualifying purchases made through Amazon links appearing on this website.