Muutke küpsiste eelistusi

PHP, MySQL & JavaScript All in One, Sams Teach Yourself 6th edition [Pehme köide]

4.50/5 (9 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 704 pages, kõrgus x laius x paksus: 232x177x35 mm, kaal: 1100 g
  • Sari: Sams Teach Yourself
  • Ilmumisaeg: 21-Dec-2017
  • Kirjastus: Sams Publishing
  • ISBN-10: 0672337703
  • ISBN-13: 9780672337703
Teised raamatud teemal:
PHP, MySQL & JavaScript All in One, Sams Teach Yourself 6th editionSuurem pilt
  • Formaat: Paperback / softback, 704 pages, kõrgus x laius x paksus: 232x177x35 mm, kaal: 1100 g
  • Sari: Sams Teach Yourself
  • Ilmumisaeg: 21-Dec-2017
  • Kirjastus: Sams Publishing
  • ISBN-10: 0672337703
  • ISBN-13: 9780672337703
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780672337703.html
Märksõnad:
In just a short time, you can learn how to use PHP, MySQL, and JavaScript together to create dynamic, interactive websites and applications using three leading web development technologies.

 

No previous programming experience is required. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of full-stack web application development from HTML, CSS, and JavaScript on the front end, to PHP scripting and MySQL databases on the server.

 

Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production.

 

Step-by-step instructions carefully walk you through the most common web application development tasks.

 

Practical, hands-on examples show you how to apply what you learn.

 

Quizzes and exercises help you test your knowledge and stretch your skills.

 

Learn how to:

 

 Build web pages with HTML5 and CSS

Use JavaScript to build dynamic, interactive web pages

 Get PHP, MySQL, and JavaScript to work together to create modern, standards-compliant web applications

Enhance interactivity with AJAX

Leverage JavaScript libraries such as jQuery

Work with cookies and user sessions

Get user input with web-based forms

Use basic SQL commands

Interact with the MySQL database using PHP

Write maintainable code and get started with version control

Decide when frameworks such as Bootstrap, Foundation, React, Angular,

and Laravel can be useful

Create a web-based discussion forum or calendar

Add a storefront and shopping cart to your site

 

Contents at a Glance

 

PART I Web Application Basics

1 Understanding How the Web Works

2 Structuring HTML and Using Cascading Style Sheets

3 Understanding the CSS Box Model and Positioning

4 Introducing JavaScript

5 Introducing PHP

 

PART II Getting Started with Dynamic Web Sites

6 Understanding Dynamic Web Sites and HTML5 Applications

7 JavaScript Fundamentals: Variables, Strings, and Arrays

8 JavaScript Fundamentals: Functions, Objects, and Flow Control

9 Understanding JavaScript Event Handling

10 The Basics of Using jQuery

 

PART III Taking Your Web Applications to the Next Level

11 AJAX: Getting Started with Remote Scripting

12 PHP Fundamentals: Variables, Strings, and Arrays

13 PHP Fundamentals: Functions, Objects, and Flow Control

14 Working with Cookies and User Sessions

15 Working with Web-Based Forms

 

PART IV Integrating a Database into Your Applications

16 Understanding the Database Design Process

17 Learning Basic SQL Commands

18 Interacting with MySQL Using PHP

 

PART V Getting Started with Application Development

19 Creating a Simple Discussion Forum

20 Creating an Online Storefront

21 Creating a Simple Calendar

22 Managing Web Applications

 

PART VI Appendixes

A Installation QuickStart with XAMPP

B Installing and Configuring MySQL

C Installing and Configuring Apache





D Installing and Configuring PHP
Introduction 1(4)
Part I: Web Application Basics
Chapter 1 Understanding How the Web Works
5(20)
A Brief History of HTML and the World Wide Web
6(1)
Creating Web Content
7(1)
Understanding Web Content Delivery
7(3)
Selecting a Web Hosting Provider
10(2)
Testing with Multiple Web Browsers
12(1)
Creating a Sample File
13(1)
Using FTP to Transfer Files
14(5)
Understanding Where to Place Files on the Web Server
19(3)
Summary
22(1)
Q&A
22(1)
Workshop
23(2)
Chapter 2 Structuring HTML and Using Cascading Style Sheets
25(50)
Getting Started with a Simple Web Page
26(3)
HTML Tags Every Web Page Must Have
29(2)
Using Hyperlinks in Web Pages
31(2)
Organizing a Page with Paragraphs and Line Breaks
33(3)
Organizing Your Content with Headings
36(3)
Understanding Semantic Elements
39(12)
How CSS Works
51(3)
A Basic Style Sheet
54(5)
A CSS Style Primer
59(5)
Using Style Classes
64(2)
Using Style IDs
66(1)
Internal Style Sheets and Inline Styles
66(3)
Summary
69(2)
Q&A
71(1)
Workshop
72(3)
Chapter 3 Understanding the CSS Box Model and Positioning
75(32)
The CSS Box Model
76(3)
The Whole Scoop on Positioning
79(5)
Controlling the Way Things Stack Up
84(2)
Managing the Flow of Text
86(1)
Understanding Fixed Layouts
87(2)
Understanding Fluid Layouts
89(3)
Creating a Fixed/Fluid Hybrid Layout
92(11)
Considering a Responsive Web Design
103(1)
Summary
104(1)
Q&A
105(1)
Workshop
105(2)
Chapter 4 Introducing JavaScript
107(20)
Learning Web Scripting Basics
108(1)
How JavaScript Fits into a Web Page
109(2)
Exploring JavaScript's Capabilities
111(1)
Basic JavaScript Language Concepts
112(6)
JavaScript Syntax Rules
118(1)
Using Comments
119(1)
Best Practices for JavaScript
120(1)
Understanding JSON
121(1)
Using the JavaScript Console to Debug JavaScript
122(2)
Summary
124(1)
Q&A
124(1)
Workshop
125(2)
Chapter 5 Introducing PHP
127(12)
How PHP Works with a Web Server
127(1)
The Basics of PHP Scripts
128(6)
Code Blocks and Browser Output
134(2)
Summary
136(1)
Q&A
137(1)
Workshop
137(2)
Part II: Getting Started with Dynamic Websites
Chapter 6 Understanding Dynamic Websites and HTML5 Applications
139(36)
Refresher on the Different Types of Scripting
140(1)
Displaying Random Content on the Client Side
140(4)
Understanding the Document Object Model
144(1)
Using window Objects
145(1)
Working with the document Object
146(3)
Accessing Browser History
149(2)
Working with the location Object
151(1)
More About the DOM Structure
152(3)
Working with DOM Nodes
155(2)
Creating Positionable Elements (Layers)
157(5)
Hiding and Showing Objects
162(2)
Modifying Text Within a Page
164(2)
Adding Text to a Page
166(2)
Changing Images Based on User Interaction
168(2)
Thinking Ahead to Developing HTML5 Applications
170(1)
Summary
171(1)
Q&A
172(1)
Workshop
172(3)
Chapter 7 JavaScript Fundamentals: Variables, Strings, and Arrays
175(22)
Using Variables
175(4)
Understanding Expressions and Operators
179(1)
Data Types in JavaScript
180(1)
Converting Between Data Types
181(1)
Using String Objects
182(3)
Working with Substrings
185(3)
Using Numeric Arrays
188(1)
Using String Arrays
189(2)
Sorting a Numeric Array
191(3)
Summary
194(1)
Q&A
195(1)
Workshop
195(2)
Chapter 8 JavaScript Fundamentals: Functions, Objects, and Flow Control
197(42)
Using Functions
198(5)
Introducing Objects
203(2)
Using Objects to Simplify Scripting
205(5)
Extending Built-in Objects
210(2)
Using the Math Object
212(1)
Working with Math Methods
213(3)
Working with Dates
216(3)
The if Statement
219(3)
Using Shorthand Conditional Expressions
222(1)
Testing Multiple Conditions with if and else
223(2)
Using Multiple Conditions with switch
225(2)
Using for Loops
227(2)
Using while Loops
229(1)
Using do...while Loops
230(1)
Working with Loops
231(1)
Looping Through Object Properties
232(4)
Summary
236(1)
Q&A
236(1)
Workshop
237(2)
Chapter 9 Understanding JavaScript Event Handling
239(22)
Understanding Event Handlers
239(5)
Using Mouse Events
244(4)
Using Keyboard Events
248(2)
Using the load and unload Events
250(1)
Using click to Change a <div>'s Appearance
251(7)
Summary
258(1)
Q&A
258(1)
Workshop
258(3)
Chapter 10 The Basics of Using jQuery
261(18)
Using Third-Party JavaScript Libraries
261(2)
jQuery Arrives on the Scene
263(1)
Preparing to Use jQuery
264(1)
Becoming Familiar with the $().ready Handler
265(2)
Selecting DOM and CSS Content
267(1)
Manipulating HTML Content
267(5)
Putting the Pieces Together to Create a jQuery Animation
272(3)
Handling Events with jQuery
275(1)
Summary
276(1)
Q&A
277(1)
Workshop
277(2)
Part III: Taking Your Web Applications to the Next Level
Chapter 11 AJAX: Remote Scripting
279(20)
Introducing AJAX
279(3)
Using XMLHttpRequest
282(1)
Creating a Simple AJAX Library
283(2)
Creating an AJAX Quiz Using the Library
285(5)
Debugging AJAX-Based Applications
290(5)
Using jQuery's Built-in Functions for AJAX
295(1)
Summary
296(1)
Q&A
296(1)
Workshop
296(3)
Chapter 12 PHP Fundamentals: Variables, Strings, and Arrays
299(28)
Variables
299(3)
Data Types
302(5)
Using Expressions and Operators
307(8)
Constants
315(2)
Understanding Arrays
317(1)
Creating Arrays
318(4)
Some Array-Related Constructs and Functions
322(2)
Summary
324(1)
Q&A
324(1)
Workshop
325(2)
Chapter 13 PHP Fundamentals: Functions, Objects, and Flow Control
327(40)
Calling Functions
328(2)
Defining a Function
330(2)
Returning Values from User-Defined Functions
332(1)
Understanding Variable Scope
333(3)
Saving State Between Function Calls with the static Statement
336(2)
More About Arguments
338(3)
Testing for the Existence of a Function
341(2)
Creating an Object
343(5)
Object Inheritance
348(2)
Switching Flow
350(6)
Implementing Loops
356(8)
Summary
364(1)
Q&A
365(1)
Workshop
365(2)
Chapter 14 Working with Cookies and User Sessions
367(18)
Introducing Cookies
367(2)
Setting a Cookie
369(4)
Deleting a Cookie
373(1)
Overview of Server-Side Sessions
373(1)
Working with Session Variables
374(6)
Destroying Sessions and Unsetting Session Variables
380(1)
Using Sessions in an Environment with Registered Users
380(2)
Summary
382(1)
Q&A
382(1)
Workshop
383(2)
Chapter 15 Working with Web-Based Forms
385(40)
How HTML Forms Work
385(1)
Creating a Form
386(4)
Accepting Text Input
390(1)
Naming Each Piece of Form Data
391(1)
Labeling Each Piece of Form Data
392(1)
Grouping Form Elements
393(1)
Exploring Form Input Controls
394(8)
Using HTML5 Form Validation
402(2)
Submitting Form Data
404(2)
Accessing Form Elements with JavaScript
406(2)
Accessing Form Elements with PHP
408(6)
Using Hidden Fields to Save State in Dynamic Forms
414(2)
Sending Mail on Form Submission
416(4)
Summary
420(2)
Q&A
422(1)
Workshop
423(2)
Part IV: Integrating a Database Into Your Applications
Chapter 16 Understanding the Database Design Process
425(12)
The Importance of Good Database Design
425(1)
Types of Table Relationships
426(5)
Understanding Normalization
431(3)
Following the Design Process
434(1)
Summary
435(1)
Q&A
436(1)
Workshop
436(1)
Chapter 17 Learning Basic SQL Commands
437(50)
Learning the MySQL Data Types
437(4)
Learning the Table-Creation Syntax
441(1)
Using the INSERT Statement
442(2)
Using the SELECT Statement
444(3)
Using WHERE in Your Queries
447(2)
Selecting from Multiple Tables
449(6)
Using the UPDATE Statement to Modify Records
455(3)
Using the REPLACE Statement
458(1)
Using the DELETE Statement
459(2)
Frequently Used String Functions in MySQL
461(9)
Using Date and Time Functions in MySQL
470(12)
Summary
482(2)
Q&A
484(1)
Workshop
485(2)
Chapter 18 Interacting with MySQL Using PHP
487(14)
MySQL or MySQLi?
487(1)
Connecting to MySQL with PHP
487(4)
Working with MySQL Data
491(8)
Summary
499(1)
Q&A
499(1)
Workshop
499(2)
Part V: Getting Started with Application Development
Chapter 19 Creating a Simple Discussion Forum
501(22)
Designing the Database Tables
501(1)
Creating an Include File for Common Functions
502(1)
Creating the Input Forms and Scripts
503(4)
Displaying the Topic List
507(3)
Displaying the Posts in a Topic
510(4)
Adding Posts to a Topic
514(4)
Modifying the Forum Display with JavaScript
518(2)
Summary
520(1)
Q&A
520(1)
Workshop
520(3)
Chapter 20 Creating an Online Storefront
523(18)
Planning and Creating the Database Tables
523(4)
Displaying Categories of Items
527(4)
Displaying Items
531(3)
Using JavaScript with an Online Storefront
534(4)
Summary
538(1)
Q&A
538(1)
Workshop
539(2)
Chapter 21 Creating a Simple Calendar
541(26)
Building a Simple Display Calendar
541(17)
Creating the Calendar in JavaScript
558(6)
Summary
564(1)
Q&A
564(1)
Workshop
564(3)
Chapter 22 Managing Web Applications
567(16)
Understanding Some Best Practices in Web Application Development
567(3)
Writing Maintainable Code
570(5)
Implementing Version Control in Your Work
575(1)
Understanding the Value and Use of Code Frameworks
576(5)
Summary
581(1)
Q&A
581(1)
Workshop
582(1)
Appendixes
Appendix A Installation QuickStart Guide with XAMPP
583(14)
Using Third-Party Installation Packages
583(1)
Installing XAMPP on Linux/UNIX
584(2)
Installing XAMPP on Windows
586(3)
Installing XAMPP on Mac OS X
589(5)
Securing XAMPP
594(1)
Troubleshooting
595(2)
Appendix B Installing and Configuring MySQL
597(20)
Current and Future Versions of MySQL
597(1)
How to Get MySQL
598(1)
Installing MySQL on Linux/UNIX
598(3)
Installing MySQL on Mac OS X
601(2)
Installing MySQL on Windows
603(6)
Troubleshooting Your Installation
609(1)
Basic Security Guidelines
610(1)
Introducing the MySQL Privilege System
611(6)
Appendix C Installing and Configuring Apache
617(18)
Current Versions of Apache
617(1)
Choosing the Appropriate Installation Method
618(1)
Installing Apache on Linux/UNIX
619(2)
Installing Apache on Mac OS X
621(1)
Installing Apache on Windows
622(2)
Apache Configuration File Structure
624(5)
Apache Log Files
629(1)
Apache-Related Commands
630(1)
Starting Apache for the First Time
631(2)
Troubleshooting
633(2)
Appendix D Installing and Configuring PHP
635(10)
Current and Future Versions of PHP
635(1)
Building PHP on Linux/UNIX with Apache
636(3)
Installing PHP on Mac OS X
639(1)
Installing PHP on Windows
640(2)
php.ini Basics
642(1)
Testing Your Installation
642(1)
Getting Installation Help
643(2)
Index 645
Julie C. Meloni is a technical consultant who has been developing web-based applications since the Web first saw the light of day. She has authored numerous books and articles on web-based programming and scripting languages and database topics, and you can find translations of her work in 18 different languages.