Learning PHP, MySQL, JavaScript, CSS & HTML5. A Step-by-Step Guide to Creating Dynamic Websites. 3rd Edition - Helion
ISBN: 978-14-919-4945-0
stron: 730, Format: ebook
Data wydania: 2014-05-20
Księgarnia: Helion
Cena książki: 152,15 zł (poprzednio: 176,92 zł)
Oszczędzasz: 14% (-24,77 zł)
Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you only have basic HTML knowledge. With this popular hands-on guide, you’ll tackle dynamic web programming with the help of today’s core technologies: PHP, MySQL, JavaScript, CSS, and HTML5.
Explore each technology separately and learn how to use them together—and pick up valuable web programming practices along the way. At the end of the book, you’ll put everything together to build a fully functional social networking site.
- Learn PHP essentials and the basics of object-oriented programming
- Discover MySQL, from database structure to complex queries
- Create dynamic PHP web pages that integrate forms and other HTML features
- Manage cookies and sessions, and maintain a high level of security
- Work with JavaScript fundamentals, from functions and event handling to accessing the Document Object Model
- Use Ajax calls to turn your website into a highly dynamic environment
- Pick up CSS basics for formatting and styling your pages
- Learn HTML5 features, including geolocation, audio, video, and canvas
- Get up to speed on all of today's main web development technologies
Osoby które kupowały "Learning PHP, MySQL, JavaScript, CSS & HTML5. A Step-by-Step Guide to Creating Dynamic Websites. 3rd Edition", wybierały także:
- Zosta 148,98 zł, (59,59 zł -60%)
- LESS. Kurs video. Poziom pierwszy. Jak usprawnić pracę z CSS 89,00 zł, (35,60 zł -60%)
- CSS i SASS. Kurs video. Praktyczny projekt nowoczesnego dashboardu 99,00 zł, (44,55 zł -55%)
- CSS3. Kurs video. Poziom pierwszy. Nowoczesne i stylowe strony WWW 59,00 zł, (26,55 zł -55%)
- Sass od podstaw. Kurs video. Budowa kompleksowej strony w oparciu o metodologię BEM 47,93 zł, (22,05 zł -54%)
Spis treści
Learning PHP, MySQL, JavaScript, CSS & HTML5. A Step-by-Step Guide to Creating Dynamic Websites. 3rd Edition eBook -- spis treści
- Learning PHP, MySQL, JavaScript, CSS & HTML5
- Dedication
- Preface
- Audience
- Assumptions This Book Makes
- Organization of This Book
- Supporting Books
- Conventions Used in This Book
- Using Code Examples
- Wed Like to Hear from You
- Safari Books Online
- Acknowledgments
- 1. Introduction to Dynamic Web Content
- HTTP and HTML: Berners-Lees Basics
- The Request/Response Procedure
- The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5
- Using PHP
- Using MySQL
- Using JavaScript
- Using CSS
- And Then Theres HTML5
- The Apache Web Server
- About Open Source
- Bringing It All Together
- Questions
- 2. Setting Up a Development Server
- What Is a WAMP, MAMP, or LAMP?
- Installing a WAMP on Windows
- Testing the Installation
- Alternative WAMPs
- Installing a MAMP on Mac OS X
- Configuring MySQL
- Ensuring MySQL Starts on Booting
- Testing the Installation
- Installing a LAMP on Linux
- Working Remotely
- Logging In
- Using FTP
- Using a Program Editor
- Using an IDE
- Questions
- 3. Introduction to PHP
- Incorporating PHP Within HTML
- This Books Examples
- The Structure of PHP
- Using Comments
- Basic Syntax
- Semicolons
- The $ symbol
- Variables
- String variables
- Numeric variables
- Arrays
- Two-dimensional arrays
- Variable naming rules
- Operators
- Arithmetic operators
- Assignment operators
- Comparison operators
- Logical operators
- Variable Assignment
- Variable incrementing and decrementing
- String concatenation
- String types
- Escaping characters
- Multiple-Line Commands
- Variable Typing
- Constants
- Predefined Constants
- The Difference Between the echo and print Commands
- Functions
- Variable Scope
- Local variables
- Global variables
- Static variables
- Superglobal variables
- Superglobals and security
- Questions
- 4. Expressions and Control Flow in PHP
- Expressions
- TRUE or FALSE?
- Literals and Variables
- Operators
- Operator Precedence
- Associativity
- Relational Operators
- Equality
- Comparison operators
- Logical operators
- Conditionals
- The if Statement
- The else Statement
- The elseif Statement
- The switch Statement
- Breaking out
- Default action
- Alternative syntax
- The ? Operator
- Looping
- while Loops
- do ... while Loops
- for Loops
- Breaking Out of a Loop
- The continue Statement
- Implicit and Explicit Casting
- PHP Dynamic Linking
- Dynamic Linking in Action
- Questions
- Expressions
- 5. PHP Functions and Objects
- PHP Functions
- Defining a Function
- Returning a Value
- Returning an Array
- Passing by Reference
- Returning Global Variables
- Recap of Variable Scope
- Including and Requiring Files
- The include Statement
- Using include_once
- Using require and require_once
- PHP Version Compatibility
- PHP Objects
- Terminology
- Declaring a Class
- Creating an Object
- Accessing Objects
- Cloning Objects
- Constructors
- PHP 5 Destructors
- Writing Methods
- Static Methods in PHP 5
- Declaring Properties
- Declaring Constants
- Property and Method Scope in PHP 5
- Static Properties and Methods
- Inheritance
- The parent operator
- Subclass constructors
- Final methods
- Questions
- PHP Functions
- 6. PHP Arrays
- Basic Access
- Numerically Indexed Arrays
- Associative Arrays
- Assignment Using the array Keyword
- The foreach ... as Loop
- Multidimensional Arrays
- Using Array Functions
- is_array
- count
- sort
- shuffle
- explode
- extract
- compact
- reset
- end
- Questions
- Basic Access
- 7. Practical PHP
- Using printf
- Precision Setting
- String Padding
- Using sprintf
- Date and Time Functions
- Date Constants
- Using checkdate
- File Handling
- Checking Whether a File Exists
- Creating a File
- Reading from Files
- Copying Files
- Moving a File
- Deleting a File
- Updating Files
- Locking Files for Multiple Accesses
- Reading an Entire File
- Uploading Files
- Using $_FILES
- Validation
- System Calls
- XHTML or HTML5?
- Questions
- Using printf
- 8. Introduction to MySQL
- MySQL Basics
- Summary of Database Terms
- Accessing MySQL via the Command Line
- Starting the Command-Line Interface
- Windows users
- OS X users
- Linux users
- MySQL on a remote server
- Using the Command-Line Interface
- The semicolon
- Canceling a command
- MySQL Commands
- Creating a database
- Creating users
- Creating a table
- Data Types
- The CHAR data type
- The BINARY data type
- The TEXT and VARCHAR data types
- The BLOB data type
- Numeric data types
- DATE and TIME
- The AUTO_INCREMENT data type
- Adding data to a table
- Renaming a table
- Changing the data type of a column
- Adding a new column
- Renaming a column
- Removing a column
- Deleting a table
- Starting the Command-Line Interface
- Indexes
- Creating an Index
- Using CREATE INDEX
- Adding indexes when creating tables
- Primary keys
- Creating a FULLTEXT index
- Querying a MySQL Database
- SELECT
- SELECT COUNT
- SELECT DISTINCT
- DELETE
- WHERE
- LIMIT
- MATCH ... AGAINST
- MATCH ... AGAINST ... IN BOOLEAN MODE
- UPDATE ... SET
- ORDER BY
- GROUP BY
- Joining Tables Together
- NATURAL JOIN
- JOIN...ON
- Using AS
- Using Logical Operators
- Creating an Index
- MySQL Functions
- Accessing MySQL via phpMyAdmin
- Using phpMyAdmin
- Questions
- 9. Mastering MySQL
- Database Design
- Primary Keys: The Keys to Relational Databases
- Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- When Not to Use Normalization
- Relationships
- One-to-One
- One-to-Many
- Many-to-Many
- Databases and Anonymity
- Transactions
- Transaction Storage Engines
- Using BEGIN
- Using COMMIT
- Using ROLLBACK
- Using EXPLAIN
- Backing Up and Restoring
- Using mysqldump
- Creating a Backup File
- Backing up a single table
- Backing up all tables
- Restoring from a Backup File
- Dumping Data in CSV Format
- Planning Your Backups
- Questions
- 10. Accessing MySQL Using PHP
- Querying a MySQL Database with PHP
- The Process
- Creating a Login File
- Connecting to MySQL
- Selecting a database
- Building and executing a query
- Fetching a result
- Fetching a row
- Closing a connection
- A Practical Example
- The $_POST Array
- Deleting a Record
- Displaying the Form
- Querying the Database
- Running the Program
- Practical MySQL
- Creating a Table
- Describing a Table
- Dropping a Table
- Adding Data
- Retrieving Data
- Updating Data
- Deleting Data
- Using AUTO_INCREMENT
- Using insert IDs
- Using locks
- Performing Additional Queries
- Preventing SQL Injection
- Using Placeholders
- Preventing HTML Injection
- Questions
- Querying a MySQL Database with PHP
- 11. Using the mysqli Extension
- Querying a MySQL Database with mysqli
- Creating a Login File
- Connecting to MySQL
- Building and executing a query
- Fetching a result
- Fetching a row
- Closing a connection
- A Practical Example
- Using mysqli Procedurally
- Questions
- Querying a MySQL Database with mysqli
- 12. Form Handling
- Building Forms
- Retrieving Submitted Data
- register_globals: An Old Solution Hangs On
- Default Values
- Input Types
- Text boxes
- Text areas
- Checkboxes
- Radio buttons
- Hidden fields
- <select>
- Labels
- The submit button
- Sanitizing Input
- An Example Program
- Whats New in HTML5?
- The autocomplete Attribute
- The autofocus Attribute
- The placeholder Attribute
- The required Attribute
- Override Attributes
- The width and height Attributes
- Features Awaiting Full Implementation
- The form Attribute
- The list Attribute
- The min and max Attributes
- The step Attribute
- The color Input Type
- The number and range Input Types
- Date and time Pickers
- Questions
- 13. Cookies, Sessions, and Authentication
- Using Cookies in PHP
- Setting a Cookie
- Accessing a Cookie
- Destroying a Cookie
- HTTP Authentication
- Storing Usernames and Passwords
- Salting
- Using Sessions
- Starting a Session
- Ending a Session
- Setting a Timeout
- Session Security
- Preventing session hijacking
- Preventing session fixation
- Forcing cookie-only sessions
- Using a shared server
- Questions
- Using Cookies in PHP
- 14. Exploring JavaScript
- JavaScript and HTML Text
- Using Scripts Within a Document Head
- Older and Nonstandard Browsers
- Including JavaScript Files
- Debugging JavaScript Errors
- Using Comments
- Semicolons
- Variables
- String Variables
- Numeric Variables
- Arrays
- Operators
- Arithmetic Operators
- Assignment Operators
- Comparison Operators
- Logical Operators
- Variable Incrementing and Decrementing
- String Concatenation
- Escaping Characters
- Variable Typing
- Functions
- Global Variables
- Local Variables
- The Document Object Model
- But Its Not That Simple
- Another Use for the $ Symbol
- Using the DOM
- Questions
- JavaScript and HTML Text
- 15. Expressions and Control Flow in JavaScript
- Expressions
- Literals and Variables
- Operators
- Operator Precedence
- Associativity
- Relational Operators
- Equality operators
- Comparison operators
- Logical operators
- The with Statement
- Using onerror
- Using try ... catch
- Conditionals
- The if Statement
- The else Statement
- The switch statement
- Breaking out
- Default action
- The ? Operator
- Looping
- while Loops
- do ... while Loops
- for Loops
- Breaking Out of a Loop
- The continue Statement
- Explicit Casting
- Questions
- 16. JavaScript Functions, Objects, and Arrays
- JavaScript Functions
- Defining a Function
- The arguments Array
- Returning a Value
- Returning an Array
- JavaScript Objects
- Declaring a Class
- Creating an Object
- Accessing Objects
- The prototype Keyword
- Static methods and properties
- Extending JavaScript objects
- JavaScript Arrays
- Numeric Arrays
- Assigning element values
- Assignment using the array keyword
- Associative Arrays
- Multidimensional Arrays
- Using Array Methods
- concat
- forEach (for non-IE browsers)
- forEach (a cross-browser solution)
- join
- push and pop
- Using reverse
- sort
- Numeric Arrays
- Questions
- JavaScript Functions
- 17. JavaScript and PHP Validation and Error Handling
- Validating User Input with JavaScript
- The validate.html Document (Part One)
- The validate.html Document (Part Two)
- Validating the forename
- Validating the surname
- Validating the username
- Validating the password
- Validating the age
- Validating the email
- Using a separate JavaScript file
- Regular Expressions
- Matching through metacharacters
- Fuzzy character matching
- Grouping through parentheses
- Character classes
- Indicating a range
- Negation
- Some more complicated examples
- Summary of metacharacters
- General modifiers
- Using Regular Expressions in JavaScript
- Using Regular Expressions in PHP
- Redisplaying a Form After PHP Validation
- Questions
- Validating User Input with JavaScript
- 18. Using Ajax
- What Is Ajax?
- Using XMLHttpRequest
- Your First Ajax Program
- The readyState property
- The server half of the Ajax process
- Using GET Instead of POST
- Sending XML Requests
- About XML
- Why use XML?
- Using Frameworks for Ajax
- Your First Ajax Program
- Questions
- 19. Introduction to CSS
- Importing a Style Sheet
- Importing CSS from Within HTML
- Embedded Style Settings
- Using IDs
- Using Classes
- Using Semicolons
- CSS Rules
- Multiple Assignments
- Using Comments
- Style Types
- Default Styles
- User Styles
- External Style Sheets
- Internal Styles
- Inline Styles
- CSS Selectors
- The Type Selector
- The Descendant Selector
- The Child Selector
- The ID Selector
- The Class Selector
- The Attribute Selector
- The Universal Selector
- Selecting by Group
- The CSS Cascade
- Style Sheet Creators
- Style Sheet Methods
- Style Sheet Selectors
- Calculating Specificity
- Using a different number base
- Some rules are more equal than others
- The Difference Between Div and Span Elements
- Measurements
- Fonts and Typography
- font-family
- font-style
- font-size
- font-weight
- Managing Text Styles
- Decoration
- Spacing
- Alignment
- Transformation
- Indenting
- CSS Colors
- Short Color Strings
- Gradients
- Positioning Elements
- Absolute Positioning
- Relative Positioning
- Fixed Positioning
- Pseudo-Classes
- Shorthand Rules
- The Box Model and Layout
- Setting Margins
- Applying Borders
- Adjusting Padding
- Object Contents
- Questions
- Importing a Style Sheet
- 20. Advanced CSS with CSS3
- Attribute Selectors
- The ^ Operator
- The $ Operator
- The * Operator
- The box-sizing Property
- CSS3 Backgrounds
- The background-clip Property
- The background-origin Property
- The background-size Property
- Multiple Backgrounds
- CSS3 Borders
- The border-color Property
- The border-radius Property
- Box Shadows
- Element Overflow
- Multicolumn Layout
- Colors and Opacity
- HSL Colors
- HSLA Colors
- RGB Colors
- RGBA Colors
- The opacity Property
- Text Effects
- The text-shadow Property
- The text-overflow Property
- The word-wrap Property
- Web Fonts
- Google Web Fonts
- Transformations
- 3D Transformations
- Transitions
- Properties to Transition
- Transition Duration
- Transition Delay
- Transition Timing
- Shorthand Syntax
- Questions
- Attribute Selectors
- 21. Accessing CSS from JavaScript
- Revisiting the getElementById Function
- The O function
- The S Function
- The C Function
- Including the Functions
- Accessing CSS Properties from JavaScript
- Some Common Properties
- Other Properties
- Inline JavaScript
- The this Keyword
- Attaching Events to Objects in a Script
- Attaching to Other Events
- Adding New Elements
- Removing Elements
- Alternatives to Adding and Removing Elements
- Using Interrupts
- Using setTimeout
- Passing a string
- Repeating timeouts
- Canceling a Timeout
- Using setInterval
- Using the function
- Canceling an interval
- Using Interrupts for Animation
- Using setTimeout
- Questions
- Revisiting the getElementById Function
- 22. Introduction to HTML5
- The Canvas
- Geolocation
- Audio and Video
- Forms
- Local Storage
- Web Workers
- Web Applications
- Microdata
- Summary
- Questions
- 23. The HTML5 Canvas
- Creating and Accessing a Canvas
- The toDataURL Function
- Specifying an Image Type
- The fillRect Method
- The clearRect Method
- The strokeRect Method
- Combining These Commands
- The createLinearGradient Method
- The addColorStop Method in Detail
- The createRadialGradient Method
- Using Patterns for Fills
- Writing Text to the Canvas
- The strokeText Method
- The textBaseLine Property
- The font Property
- The textAlign Property
- The fillText Method
- The measureText Method
- Drawing Lines
- The lineWidth Property
- The lineCap and lineJoin Properties
- The miterLimit Property
- Using Paths
- The moveTo and LineTo Methods
- The stroke Method
- The rect Method
- Filling Areas
- The clip Method
- The isPointInPath Method
- Working with Curves
- The arc Method
- The arcTo Method
- The quadraticCurveTo Method
- The bezierCurveTo Method
- Manipulating Images
- The drawImage Method
- Resizing an Image
- Selecting an Image Area
- Copying from a Canvas
- Adding Shadows
- Editing at the Pixel Level
- The getImageData Method
- The data Array
- The putImageData Method
- The createImageData Method
- Advanced Graphical Effects
- The globalCompositeOperation Property
- The globalAlpha Property
- Transformations
- The scale Method
- The save and restore Methods
- The rotate Method
- The translate Method
- The transform Method
- The setTransform Method
- Summary
- Questions
- Creating and Accessing a Canvas
- 24. HTML5 Audio and Video
- About Codecs
- The <audio> Element
- Supporting Non-HTML5 Browsers
- The <video> Element
- The Video Codecs
- Supporting Older Browsers
- Summary
- Questions
- 25. Other HTML5 Features
- Geolocation and the GPS Service
- Other Location Methods
- Geolocation and HTML5
- Local Storage
- Using Local Storage
- The localStorage Object
- Web Workers
- Offline Web Applications
- Drag and Drop
- Cross Document Messaging
- Microdata
- Other HTML5 Tags
- Summary
- Questions
- 26. Bringing It All Together
- Designing a Social Networking Site
- On the Website
- functions.php
- The Functions
- header.php
- setup.php
- index.php
- signup.php
- Checking for Username Availability
- Logging In
- checkuser.php
- login.php
- profile.php
- Adding the About Me Text
- Adding a Profile Image
- Processing the Image
- Displaying the Current Profile
- members.php
- Viewing a Users Profile
- Adding and Dropping Friends
- Listing All Members
- friends.php
- messages.php
- logout.php
- styles.css
- javascript.js
- A. Solutions to the Chapter Questions
- Chapter 1 Answers
- Chapter 2 Answers
- Chapter 3 Answers
- Chapter 4 Answers
- Chapter 5 Answers
- Chapter 6 Answers
- Chapter 7 Answers
- Chapter 8 Answers
- Chapter 9 Answers
- Chapter 10 Answers
- Chapter 11 Answers
- Chapter 12 Answers
- Chapter 13 Answers
- Chapter 14 Answers
- Chapter 15 Answers
- Chapter 16 Answers
- Chapter 17 Answers
- Chapter 18 Answers
- Chapter 19 Answers
- Chapter 20 Answers
- Chapter 21 Answers
- Chapter 22 Answers
- Chapter 23 Answers
- Chapter 24 Answers
- Chapter 25 Answers
- B. Online Resources
- PHP Resource Sites
- MySQL Resource Sites
- JavaScript Resource Sites
- CSS Resource Sites
- HTML5 Resource Sites
- AJAX Resource Sites
- Miscellaneous Resource Sites
- OReilly Resource Sites
- C. MySQLs FULLTEXT Stopwords
- D. MySQL Functions
- String Functions
- Date Functions
- Time Functions
- Index
- Colophon
- Copyright