Creating Data-Driven Web Sites: An Introduction to HTML, CSS, PHP, and MySQL

✍ Scribed by Bob Terrell

• Publisher: Momentum Press
• Year: 2019
• Tongue: English
• Leaves: 139
• Category: Library

✦ Synopsis

The purpose of this book is to provide an introduction to this set of technologies to teach a new programmer how to get started creating data-driven websites and to provide a jumping-off point for the reader to expand his or her skills.

Today's modern world is heavily dependent on the World Wide Web. It affects the way we communicate, how we shop, and how we learn about the world. Every website, every page, consists of four fundamental elements: the structure, the style, the programming, and the data. These correspond to four different "languages," respectively: HTML, CSS, PHP, and MySQL.

After learning the necessary components, users will have the understanding required to use the above technologies to create a working website. This book is aimed at the programmer or student who understands the basic building blocks of programming such as statements and control structures but lacks knowledge of the syntax and application of the above-mentioned technologies.

✦ Table of Contents

Cover
CREATING DATA-DRIVEN WEBSITES: An Introduction to HTML, CSS,
PHP, and MySQL
Copyright
Abstract
Contents
Acknowledgments
Introduction
CHAPTER 1: HTML
FUNDAMENTALS
TAGS AND ELEMENTS
ATTRIBUTES AND PROPERTIES
BLOCK ELEMENTS
INLINE ELEMENTS
FORM ELEMENTS
ENTITIES
COMMENTS
PROJECT
FURTHER READING
CHAPTER 2: Cascading Style Sheets (CSSSS)
CSS SYNTAX
SELECTORS
THE CASCADE
IMPORTANCE
SPECIFICITY
CODE ORDER
PROPERTIES
COLORS
LENGTH UNITS
PROPERTY LIST
Color Properties
Size Properties
Box Model Properties
Display and Visibility Properties
Positioning Properties
THE BOX MODEL
COMMENTS
WORKING WITH DIFFICULT BROWSERS
PROJECT
FURTHER READING
CHAPTER 3: MySQL
WHY MYSQL?
PHPMYADMIN
THE STRUCTURE OF MYSQL
DATA (FIELD) TYPES
NUMERIC DATA TYPES
STRING DATA TYPES
CHAR
VARCHAR
BINARY and VARBINARY
BLOB and TEXT
ENUM
SET
DATE DATA TYPES
DATE
DATETIME
TIMESTAMP
TIME
THE SPECIAL VALUE NULL
MYSQL STATEMENTS
INSERT
SELECT
UPDATE
DELETE
INDEXES
OPERATORS AND FUNCTIONS
PROJECT
FURTHER READING
CHAPTER 4: PHP
WHY PHP?
GETTING INTO PHP: BASIC SYNTAX
VARIABLES IN PHP
SCALAR
ARRAY
OBJECT
A NOTE ABOUT STRINGS
OPERATORS
ARITHMETIC
STRING
INCREMENT
ASSIGNMENT
COMPARISON
LOGICAL
LANGUAGE CONSTRUCTS
FUNCTIONS
ADD YOUR OWN FUNCTIONS
MY SQLi
MYSQLi
Constructor
Query()
Error
Affected_Rows
MYSQLi_RESULT
$num_rows
fetch_row(), fetch_assoc(), and fetch_array()
SQL INJECTION AND MYSQLi_STMT
MYSQLi_STMT
THE FINAL PIECE: $_POST AND $_GET
AND ONE MORE THING: $_SESSION
PROJECT
FURTHER READING
EXTENDING THE STYLE GUIDE
About the Author
Index
Ad Page
Back Cover