Muutke küpsiste eelistusi

E-raamat: PHP and MySQL Web Development: A Beginner's Guide

  • Formaat: 624 pages
  • Sari: Beginner's Guide
  • Ilmumisaeg: 05-Jan-2015
  • Kirjastus: McGraw-Hill Professional
  • Keel: eng
  • ISBN-13: 9780071837316
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 49,61 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Formaat: 624 pages
  • Sari: Beginner's Guide
  • Ilmumisaeg: 05-Jan-2015
  • Kirjastus: McGraw-Hill Professional
  • Keel: eng
  • ISBN-13: 9780071837316
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

"This step-by-step tutorial shows you how to use PHP and MySQL to power websites with dynamic content. PHP and MySQL Web Development: A Beginner's Guide takes you from building static pages to ones with PHP and MySQL dynamic elements. Hands-on projects get you started using new skills right away!This solutions-oriented book is organized around real-world web scenarios that demonstrate the use of PHP and MySQL. These scenarios can be directly used to build web pages with dynamic content. Security topics such as validation, authentication, and encryption are addressed throughout. Each chapter teaches practical techniques that can be immediately applied Covers the basics of what drives many of today's most popular sites Ready-to-use code examples from the book available for download "--

Essential Skills—Made Easy!

PHP and MySQL Web Development: A Beginner's Guide takes you from building static web pages to creating comprehensive database-driven web applications. The book reviews HTML, CSS, and JavaScript and then explores PHP--its structure, control statements, arrays, functions, use with forms, and file handling capabilities. Next, the book examines MySQL, including SQL, the MySQL command set, and how to use it with PHP to create a relational database and build secure, databasedriven web applications. This practical resource features complete,step-by-step examples with code that you can use as templates for your own projects.

Designed for Easy Learning

  • Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter
  • Try This--Hands-on exercises that show you how to apply your skills
  • Notes--Extra information related to the topic being covered
  • Tips--Helpful reminders or alternate ways of doing things
  • Cautions--Errors and pitfalls to avoid
  • Self Tests--End-of-chapter quizzes to reinforce your skills
  • Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

Ready-to-use code at www.mhprofessional.com

Acknowledgments xv
Introduction xvii
PART I Getting Ready
1 Setting Up Your Workstation
5(30)
Picking a Development Tool
6(15)
Full-Featured Development Packages
7(1)
Powerful Alternatives
8(13)
Choosing a Testing Server
21(8)
Testing Environment
29(6)
Using Testing Browsers
30(1)
Considering Other Factors
31(4)
2 Building Web Pages with HTML
35(40)
HTML5
37(33)
Using HTML5
38(1)
Setting Up Aptana
39(4)
Reviewing HTML
43(1)
Using Basic Tags
44(1)
Using Global Attributes
44(1)
Setting Paragraph Styles
44(5)
Applying Character Styles
49(2)
Displaying Special Characters
51(2)
Working with Images and Image Maps
53(1)
Adding Hyperlinks and Bookmarks
54(2)
Defining Forms
56(4)
Creating Tables
60(2)
Using New HTML5 Tags
62(7)
Understanding Deprecated HTML Tags
69(1)
HTML Authoring Resources
70(5)
3 Styling with CSS
75(46)
Creating CSS
77(8)
Attaching CSS
77(3)
Understanding CSS Rules
80(1)
Selecting What to Format
81(4)
CSS Properties and Values
85(36)
Applying CSS Concepts
85(7)
Using Text Properties
92(4)
Implementing Page Properties
96(4)
Laying Out with CSS
100(21)
4 Adding Dynamic Elements with JavaScript
121(66)
Introducing JavaScript
123(2)
Characteristics of JavaScript
123(2)
JavaScript Introduction
125(6)
Using JavaScript with HTML Pages
125(1)
JavaScript Basics
126(3)
Writing and Testing JavaScript
129(2)
Parts of JavaScript
131(13)
Variables and Constants
131(3)
Operators
134(4)
Statements and Expressions
138(1)
Functions
138(3)
Objects
141(3)
Control Structures
144(8)
If/Else Statements
145(2)
While and Do-While Statements
147(1)
For Statement
148(1)
Switch Statements
149(3)
Introducing Event Handlers
152(1)
Placing Event Handlers in Your Code
152(1)
Understanding Event Handler Syntax and Usage
153(1)
Working with the Window Event Handlers
153(5)
Displaying Messages When a Page Opens/Closes
153(2)
Placing and Removing Focus
155(1)
Resizing a Window
156(2)
Using the Mouse and Keyboard Event Handlers
158(7)
Working with onclick, ondblclick, and Arrays
158(3)
Moving the Mouse Pointer to Trigger Events
161(1)
Using the Keyboard Event Handlers
162(3)
Reviewing Forms
165(4)
Understanding Forms
165(2)
Creating Forms Using HTML
167(2)
Using JavaScript in Forms
169(10)
Naming Forms on a Web Page
170(1)
Form Properties and Methods
171(4)
Working with Form Element Properties and Methods
175(4)
Validating a Form
179(8)
Understanding Validation
179(1)
Using Validation with Passwords
179(8)
PART II Exercising the Server with PHP
5 Fundamentals of PHP
187(40)
About PHP
188(1)
Tools Needed for PHP
189(8)
Preparing a PHP Workstation
190(7)
PHP Introduction
197(10)
Integrating PHP with HTML
198(2)
Writing and Testing PHP
200(3)
PHP Basics
203(4)
Parts of PHP
207(20)
Types of Information
207(2)
Variables and Constants
209(1)
Operators
210(4)
Statements and Expressions
214(1)
Functions
214(13)
6 PHP Control and File Handling
227(30)
Control Structures
229(9)
If/Else Statements
229(3)
While and do-while Statements
232(2)
For and foreach Statements
234(2)
Switch Statements
236(2)
PHP File and Directory Management
238(8)
Basic File Functions
238(4)
Additional File Functions
242(4)
Cookies and Session and Server Variables
246(11)
Session Variables
247(2)
Cookies
249(3)
Server Variables
252(5)
7 PHP Arrays and Forms
257(36)
Using Arrays
258(21)
Creating Arrays
259(1)
Working with Arrays
260(1)
Looping Through Arrays
261(4)
Sorting Arrays
265(3)
Navigating in Arrays
268(1)
Converting Arrays To and From Strings
269(2)
Joining and Splitting Arrays
271(4)
Comparing Arrays
275(3)
Handling Multidimensional Arrays
278(1)
Building and Handling Forms
279(14)
Create a Form in HTML
280(2)
Add JavaScript to a Form
282(3)
Accepting and Filing Form Data in PHP
285(8)
8 Putting PHP to Use
293(16)
User Authentication
294(15)
Create an Index Script
296(1)
Add Registration Scripts
297(4)
Insert Sign-In Scripts
301(3)
Attach a Site Page
304(5)
PART III Creating and Using Relational Databases with MySQL
9 Introduction to Relational Databases
309(24)
Databases and Relational Databases
310(2)
Understanding Databases
310(2)
Understanding a Relational Database
312(1)
Using phpMyAdmin
312(21)
Get and Install phpMyAdmin
312(4)
Opening and Exploring phpMy Admin
316(4)
Create and Use a Database in phpMy Admin
320(13)
10 Fundamentals of MySQL and SQL
333(36)
About MySQL
334(14)
Installing and Using MySQL Workbench
335(4)
Understanding SQL
339(3)
Using MySQL
342(6)
Exploring the MySQL Language
348(21)
Reviewing MySQL Word Usage
349(2)
Using MySQL Operators
351(3)
Exploring MySQL Functions
354(15)
11 Implementing MySQL Command Statements
369(36)
MySQL Commands
370(4)
Understanding the MySQL Command Structure
371(2)
Preparing the MySQL Workbench
373(1)
Create Databases and Tables
374(5)
Creating and Using a Database
374(1)
Creating a Table and Its Columns
374(4)
Reviewing MySQL Data Types
378(1)
Insert Data into Tables
379(2)
Inserting Data
379(2)
Select, Replace, Update, and Delete Data in Tables
381(11)
Selecting Data
382(3)
Replacing Data
385(3)
Updating Data
388(2)
Deleting Data
390(2)
Alter, Rename, and Drop Tables and Databases
392(4)
Altering Tables and Databases
393(2)
Renaming Tables
395(1)
Dropping Tables and Databases
395(1)
Create and Use Events, Views, and Triggers
396(9)
Using Events
396(3)
Using Views
399(1)
Using Triggers
400(5)
PART IV Powering Databases with MySQL and PHP
12 Using a MySQL Database with PHP
405(20)
Bringing PHP and MySQL Together
406(11)
Database Manipulation
407(5)
Database Information
412(2)
Database Administration
414(1)
Combining PHP MySQL Functions
415(2)
Working with Forms and Databases
417(8)
Expanding PHP Form Handling
417(1)
Facilitating User Interaction
418(1)
Interacting with a Database
419(1)
Improving Security
419(6)
13 Registering and Responding to Users
425(74)
Application Design
427(17)
Design Template and CSS
428(11)
Database Design
439(5)
Creating the Scripts
444(55)
Administrator Authentication
444(14)
Database Entry and Maintenance
458(41)
14 Handling Online Purchases
499(52)
Application Design
502(10)
Design Template and CSS
502(6)
Database Design
508(4)
Creating the Book List and Customer Sales Scripts
512(26)
Book List and Selection
513(3)
Customer Sign-in and Verification
516(17)
Sales and Confirmation
533(5)
Invoicing
538(13)
Building an Invoice
538(6)
Deleting Sales
544(1)
Writing an Invoice Record
545(6)
Index 551
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide