Table Of ContentEBOOKS Creating Data-Driven Web Sites T
E
R
FOR THE R COMPUTER SCIENCE COLLECTION
An Introduction to HTML, CSS, PHP,
E
ENGINEERING and MySQL LL
Lisa MacLean, Editor
LIBRARY
Bob Terrell
Create your own
Today’s modern world is heavily dependent on the World
Customized Content
Wide Web. It affects the way we communicate, how we shop,
Bundle—the more
and how we learn about the world. Every website, every
books you buy,
page, consists of four fundamental elements: the structure,
the greater your
the style, the programming, and the data. These correspond
discount!
to four different “languages,” respectively: HTML, CSS, PHP,
and MySQL.
Creating
THE CONTENT
This book provides an introduction to this set of technol-
• Manufacturing ogies to teach a new programmer how to get started creat-
Engineering ing data-driven websites and to provide a jumping-off point C
R
• Mechanical for the reader to expand his or her skills. After learning the E Data-Driven
& Chemical necessary components, users will have the understanding A
T
Engineering required to use the above technologies to create a working IN
• Materials Science website. This book is aimed at the programmer or student G
Web Sites
& Engineering who understands the basic building blocks of programming D
A
• Civil & such as statements and control structures but lacks know-
T
A
Environmental ledge of the syntax and application of the above-mentioned
-
D
Engineering technologies.
R An Introduction to
• Advanced Energy IV
Technologies Bob Terrell has completed a Bachelor of Science degree E
N
at Wentworth Institute of Technology. While there, he com- HTML, CSS, PHP,
pleted a class project to automate the gift drive of a popular W
THE TERMS
E
nonprofi t organization in the Boston area. The website re-
• Perpetual access for B and MySQL
sulting from that project is still in use today and has helped S
a one time fee I
fi nd gifts for over 16,000 children. He was also invited to T
• No subscriptions or E
teach HTML and PHP as a guest teacher to a younger class S
access fees
as part of a database course to help expand the school’s
• Unlimited
community involvement.
concurrent usage
He currently works as a software developer at a small
• Downloadable PDFs
company north of Boston that creates DOT-compliant truck
• Free MARC records
tracking and fl eet management software for trucking and
line haul companies, using the technologies outlined in this
For further information, book. He has 14 years of experience in HTML, CSS, PHP, and Bob Terrell
a free trial, or to order,
MySQL languages.
contact:
[email protected]
CREATING
DATA-DRIVEN
WEBSITES
CREATING
DATA-DRIVEN
WEBSITES
A I HtML, cSS,
n ntroductIon to
PHP, M SQL
And y
BOB TERRELL
Creating Data-Driven Websites: An Introduction to HTML, CSS, PHP,
and MySQL
Copyright © Momentum Press®, LLC, 2019.
All rights reserved. No part of this publication may be reproduced, stored
in a retrieval system, or transmitted in any form or by any means—
electronic, mechanical, photocopy, recording, or any other—except for
brief quotations, not to exceed 250 words, without the prior permission
of the publisher.
First published by Momentum Press®, LLC
222 East 46th Street, New York, NY 10017
www.momentumpress.net
ISBN-13: 978-1-94664-604-0 (print)
ISBN-13: 978-1-94664-605-7 (e-book)
Momentum Press Computer Science Collection
Cover and interior design by S4Carlisle Publishing Services Private Ltd.,
Chennai, India
10 9 8 7 6 5 4 3 2 1
Printed in the United States of America
A
bStrAct
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.
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. 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 state-
ments and control structures but lacks knowledge of the syntax and appli-
cation of the above-mentioned technologies.
KEYWORDS
HTML; PHP; website; MAMP; LAMP; databases; CSS; structured query
language; SQL; MySQL
c
ontentS
Acknowledgments ix
IntroductIon xi
chApter 1 html 1
Fundamentals 3
Tags and Elements 4
Attributes and Properties 5
Block Elements 6
Inline Elements 7
Form Elements 8
Entities 9
Comments 11
Project 11
Further Reading 14
chApter 2 cAscAdIng style sheets (css) 15
CSS Syntax 17
Selectors 17
The Cascade 21
Importance 21
Specificity 22
Code Order 23
Properties 23
Colors 23
Length Units 25
Property List 25
The Box Model 34
Comments 37
Working with Difficult Browsers 37
Project 38
Further Reading 47
chApter 3 mysQl 49
Why MySQL? 49
phpMyAdmin 50
The Structure of MySQL 50
viii • CONTENTS
Data (Field) Types 52
Numeric Data Types 52
String Data Types 54
Date Data Types 56
The Special Value NULL 57
MySQL Statements 58
Indexes 67
Operators and Functions 69
Project 72
Further Reading 75
chApter 4 php 77
Why PHP? 77
Getting into PHP: Basic Syntax 78
Variables in PHP 78
A Note about Strings 81
Operators 81
Language Constructs 84
Functions 86
Add Your Own Functions 87
MySQLi 89
mysqli 89
mysqli_result 90
SQL Injection and mysqli_stmt 91
The Final Piece: $_POST and $_GET 93
And One More Thing: $_SESSION 95
Project 95
Further Reading 115
extendIng the style guIde 117
About the Author 119
Index 121
A
cknowLedgMentS
I would like to thank my wife for her patience and understanding and for
occupying the time of three children long enough to write this book; Lisa
MacLean, for being my favorite professor; my parents, for always seeing
the potential in me and wanting the best for me; and fate, for life has
given me many blessings and opportunities arising from circumstances
that reach far beyond my own actions.
