Creating Data-Driven Web Sites
An Introduction to HTML, CSS, PHP, and MySQL
Published on 5. March 2019
138 pages
978-1-946646-05-7 (ISBN)
Description
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.
More details
Other editions
Additional editions
Book
03/2019
Momentum Press
€46.20
Shipment within 3-4 weeks
Person
Bob Terrell has completed a Bachelor of Science degree at Wentworth Institute of Technology. While there, he completed a class project to automate the gift drive of a popular nonprofit organization in the Boston area. The website resulting from that project is still in use today and has helped find gifts for over 16,000 children. He was also invited to teach HTML and PHP as a guest teacher to a younger class as part of a database course to help expand the school's community involvement. He currently works as a software developer at a small company north of Boston that creates DOT-compliant truck tracking and fleet management software for trucking and line haul companies, using the technologies outlined in this book. He has 14 years of experience in HTML, CSS, PHP, and MySQL languages.
Content
- 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
