Pages
Front page
Intro
HTML
Structure
Content
The body
Title
Check
Page 2
Links
Divs
CSS
stylesheet
more
IDs
JavaScript
structure
an event
Conclusion
Optional
Beginner
Concepts
Internet
Web
HTML
CSS
javascript
editors
files
Versions
HTML
Basics
Elements
Indenting
Attributes
Text
Emphasis
Lists
Links
Span
Line breaks
Headings
Media
Images
Video
Sound
Tables
Forms
Structure
Divs
Head
Template
Conclusions
Comments
Reference
Validation
Practical
Page 1
Page 2
Page 3
CSS
Where
In-line
Embedded
External
Colours
Text
Font family
Style
Weight
Size
Decoration
Alignment
Backgrounds
Boxes
Borders
Height/width
Margins/padding
Selectors
Type
ID and Class
Pseudo-classes
Conclusions
Some thoughts
Commenting
Practise
All pages
Page 2
Page 3
JavaScript
Structure
First script
Events
Functions
Data
Variables
Errors
Parameters
Elements
Objects
Styles
getElementById
Attributes
Styles
Text content
Decisions
If
if else
Operators
Arithmetic
Concatenation
Thoughts
Practise
Comments
PHP
Preparation
Words
Server setup
XAMPP
XAMPP portable
PortableApps.com
XAMPP only
Using XAMPP
Linux server
Hosting
FTP
Apology
Basics
Quotes
Variables
Text & variables
Arithmetic
Dates
If
If & else
Nested
Forms
Files
Read
Write
Structure
Arrays & loops
Arrays
For
Foreach
While
Superglobals
Thoughts
Comments
php.net
Errors
Practise
SQL
Terms
Database
SQL
Flavours
PHP
Connecting
Definition
Create DB
Display DBs
Create table
Fields
Close
Template
Syntax
Manipulation
Insert
Code
Form
Display
SELECT
Paragraphs
Lists
WHERE
Sorting
mysqli_num_rows
Delete
Update
Thoughts on SQL
Errors
Practise
Web development
Practice
HTML
Front
Menu
Contact
CSS
JavaScript
PHP & SQL
Intermediate
Concepts
Programming
Structure
Functions
Storage
Data types
Arrays
Loops
Conditions
Servers
Protocols
HTML
Structure
Head
Sections
Files
Forms
Attributes
Autofocus
Value
Disabled
Placeholder
Input
Number
Email
Hidden
Files
Checkbox
Radio
Other
Textarea
Dropdown (select)
Buttons
Tables
Captions
Structure
Colspan
Links
Relative
Absolute
Internal
Keyboard
More
Quotations
Abbreviations
Line breaks
Entities
Pre
Horizontal rule
Conclusions
Web tools
Browsers
Editors
Practise
Index
Products
Staff
Testimonials
Other
CSS
Boxes
Size
Centering
Overflow
Min-height
Max-height
Parts
Positioning
Static
Relative
Absolute
Fixed
Sticky
Float
Box-shadow
Visibility
Opacity
Alpha
Z-index
Visibility
Display
Block & in-line
Units
Size
Colours
Colour Wheel
HSL
Contrast
Good colour
Automation
Selectors
Words
Children
Multiples
Selectors
Shorthand
Universal
Attributes
Element parts
:root
Cascading 4
Text
Shadows
Fonts
Backgrounds
Conclusions
Practise
Navigation
Look
index.html
products.html
staff.html
testimonials.html
JavaScript
Structures
Switch
For
If
Nested
Conditions
Objects
Strings
Searching
Substrings
Replace
Case
Math
Round
Special numbers
Other
Random
Date
Setting
Arithmetic
Variables
Arrays
Scope
Empty
Cookies
Local
DOM
Children
Links
Classes
Attributes
Set
Get
Add
Events
Keyboard
System
Onload
Onscroll
Forms
Time
Touch
Attributes
Keyboard
List
Conclusions
Tidy up
External
addEventListener
Practise
Page 1
Page 2
PHP
Storage
Storing code
Functions
Built-in
User defined
Arguments
Returning
Includes
Scope
Isset
Cookies
Sessions
Variables
Strings
Length
Parts
Joining
Problem
Trim
Split
Escaping
Search
Case
Layout
Forms
One page forms
Form
Process
PHP_SELF
File upload
Decisions
elseif
Switch
Multiple
Get
Conclusions
Security
htmlspecialchars
Consistency
Errors
Logging
Extensions
Sources
Practise
Logging
View log
Log in
Uploads
Security
More info
SQL
PHPMyAdmin
Basics
Create DB
Tables
Edit table
Insert
Relationships
Types
Databases
Indexes
Primary
Integrity
ERD
Display
Tables
Styling
Alternating
Highlighting
Links
Distinct
Select
Where
Operators
Multiple
Join
Outer joins
Summarising
COUNT
GROUP BY
Drop down
Change
Clever
Arithmetic
Dates
Arithmetic
Select
Extract
Format
Conclusions
Security
Backup
Injection
Example
Quotes
Ticks
Encryption
One way
Two way
Salts
Conclusions
Practise
Product info
Products
List
New
Delete
Editing
Logging in
Log in page
Logging out
Logged in?
Page protection
Orders
Improvements
Help
This page
Remember here
Pages under
Operators
Multiple
Admin
Log on
Register
More with SQL WHERE conditions
Operators
Multiple
Now that you have some fairly complicated data you can do more when you query that data.