PHP and MySQL web development:
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Hoboken, NJ ; Boston ; Indianapolis ; San Francisco ; New York ; Toronto ; Montreal ; London ; Munich ; Paris ; Madrid ; Cape Town ; Sydney ; Tokyo ; Singapore ; Mexico City
Addison-Wesley
[2017]
|
| Ausgabe: | Fifth edition |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | xxvi, 652 Seiten Illustrationen |
| ISBN: | 9780321833891 0321833899 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV043563925 | ||
| 003 | DE-604 | ||
| 005 | 20170908 | ||
| 007 | t | ||
| 008 | 160520s2017 a||| |||| 00||| eng d | ||
| 015 | |a GBB2A9066 |2 dnb | ||
| 020 | |a 9780321833891 |c pbk. |9 978-0-321-83389-1 | ||
| 020 | |a 0321833899 |c pbk. |9 0-321-83389-9 | ||
| 035 | |a (OCoLC)967869884 | ||
| 035 | |a (DE-599)BVBBV043563925 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-91G |a DE-11 |a DE-1050 |a DE-739 |a DE-B768 | ||
| 084 | |a ST 250 |0 (DE-625)143626: |2 rvk | ||
| 084 | |a DAT 663f |2 stub | ||
| 084 | |a DAT 675f |2 stub | ||
| 084 | |a DAT 366f |2 stub | ||
| 100 | 1 | |a Welling, Luke |d 1972- |e Verfasser |0 (DE-588)129184942 |4 aut | |
| 245 | 1 | 0 | |a PHP and MySQL web development |c Luke Welling, Laura Thomson |
| 250 | |a Fifth edition | ||
| 264 | 1 | |a Hoboken, NJ ; Boston ; Indianapolis ; San Francisco ; New York ; Toronto ; Montreal ; London ; Munich ; Paris ; Madrid ; Cape Town ; Sydney ; Tokyo ; Singapore ; Mexico City |b Addison-Wesley |c [2017] | |
| 264 | 4 | |c © 2017 | |
| 300 | |a xxvi, 652 Seiten |b Illustrationen | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a PHP (Computer program language) | |
| 650 | 4 | |a Web site development | |
| 650 | 7 | |a PHP (Computer program language) |2 fast | |
| 650 | 7 | |a Web site development |2 fast | |
| 650 | 0 | 7 | |a PHP 5.3 |0 (DE-588)7638375-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a PHP 7.0 |0 (DE-588)1082352969 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a PHP |0 (DE-588)4546126-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a MySQL |0 (DE-588)4559381-4 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a MySQL 5.0 |0 (DE-588)4792791-4 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a PHP 4.0 |0 (DE-588)4584299-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a PHP 5.0 |0 (DE-588)4763174-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a MySQL 5.1 |0 (DE-588)7574874-5 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a MySQL |0 (DE-588)4559381-4 |D s |
| 689 | 0 | 1 | |a PHP 7.0 |0 (DE-588)1082352969 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a PHP 4.0 |0 (DE-588)4584299-1 |D s |
| 689 | 1 | 1 | |a MySQL |0 (DE-588)4559381-4 |D s |
| 689 | 1 | |8 1\p |5 DE-604 | |
| 689 | 2 | 0 | |a PHP 5.0 |0 (DE-588)4763174-0 |D s |
| 689 | 2 | |8 2\p |5 DE-604 | |
| 689 | 3 | 0 | |a MySQL 5.0 |0 (DE-588)4792791-4 |D s |
| 689 | 3 | |8 3\p |5 DE-604 | |
| 689 | 4 | 0 | |a PHP 5.3 |0 (DE-588)7638375-1 |D s |
| 689 | 4 | |8 4\p |5 DE-604 | |
| 689 | 5 | 0 | |a MySQL 5.1 |0 (DE-588)7574874-5 |D s |
| 689 | 5 | |8 5\p |5 DE-604 | |
| 689 | 6 | 0 | |a PHP |0 (DE-588)4546126-0 |D s |
| 689 | 6 | |8 6\p |5 DE-604 | |
| 700 | 1 | |a Thomson, Laura |d 1972- |e Verfasser |0 (DE-588)139272186 |4 aut | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028978954&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028978954 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 2\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 3\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 4\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 5\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 6\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Datensatz im Suchindex
| _version_ | 1804176235589271552 |
|---|---|
| adam_text | Titel: PHP and MySQL web development
Autor: Welling, Luke
Jahr: 2017
Table of Contents
Introduction 1
I: Using PHP
1 PHP Crash Course 11
Before You Begin: Accessing PHP 12
Creating a Sample Application: Bob s Auto Parts
Creating the Order Form 12
Processing the Form 14
Embedding PHP in HTML 14
PHP Tags 16
PHP Statements 16
Whitespace 17
Comments 17
Adding Dynamic Content 18
Calling Functions 19
Using the date ( ) Function 19
Accessing Form Variables 20
Form Variables 20
String Concatenation 22
Variables and Literals 23
Understanding Identifiers 23
Examining Variable Types 24
PHP s Data Types 24
Type Strength 25
Type Casting 25
Variable Variables 25
Declaring and Using Constants 26
Understanding Variable Scope 27
Using Operators 28
Arithmetic Operators 28
String Operators 29
Assignment Operators 29
Comparison Operators 31
Logical Operators 32
X
Contents
Bitwise Operators 33
Other Operators 33
Working Out the Form Totals 36
Understanding Precedence and Associativity 37
Using Variable Handling Functions 39
Testing and Setting Variable Types 39
Testing Variable Status 40
Reinterpreting Variables 41
Making Decisions with Conditionals 41
if Statements 41
Code Blocks 42
else Statements 42
elseif Statements 43
switch Statements 44
Comparing the Different Conditionals 45
Repeating Actions Through Iteration 46
while Loops 47
for and foreach Loops 49
do. . .while Loops 50
Breaking Out of a Control Structure or Script 50
Employing Alternative Control Structure Syntax 51
Using declare 51
Next 52
2 Storing and Retrieving Data 53
Saving Data for Later 53
Storing and Retrieving Bob s Orders 54
Processing Files 55
Opening a File 55
Choosing File Modes 55
Using f open ( ) to Open a File 56
Opening Files Through FTP or HTTP 58
Addressing Problems Opening Files 58
Writing to a File 61
Parameters for fwrite ( ) 62
File Formats 62
Closing a File 63
Contents x¡
Reading from a File 65
Opening a File for Reading: f open ( ) 66
Knowing When to Stop: f eof ( ) 66
Reading a Line at a Time: fgets (), fgetss (),
andfgetcsv() 67
Reading the Whole File: readf ile ( ) , fpassthru ( ) ,
file(), and file_get_contents() 68
Reading a Character: fgetc ( ) 69
Reading an Arbitrary Length: f read ( ) 69
Using Other File Functions 69
Checking Whether a File Is There: f ile_exists () 70
Determining How Big a File Is: filesize ( ) 70
Deleting a File: unlink ( ) 70
Navigating Inside a File: rewind ( ), f seek ( ), and f tell ( ) 70
Locking Files 71
A Better Way: Databases 73
Problems with Using Flat Files 73
How RDBMSs Solve These Problems 74
Further Reading 74
Next 74
3 Using Arrays 75
What Is an Array? 75
Numerically Indexed Arrays 76
Initializing Numerically Indexed Arrays 76
Accessing Array Contents 77
Using Loops to Access the Array 78
Arrays with Different Indices 79
Initializing an Array 79
Accessing the Array Elements 79
Using Loops 79
Array Operators 81
Multidimensional Arrays 82
Sorting Arrays 85
Using sort () 85
Using asort ( ) and ksort ( ) to Sort Arrays 86
Sorting in Reverse 87
xii Contents
Sorting Multidimensional Arrays 87
Using the array_multisort ( ) function 87
User-Defined Sorts 88
Reverse User Sorts 89
Reordering Arrays 90
Using shuffle ( ) 90
Reversing an Array 92
Loading Arrays from Files 92
Performing Other Array Manipulations 96
Navigating Within an Array: each (}, current ( ), reset ( ),
end ( ), next ( ), pos ( ), and prev ( ) 96
Applying Any Function to Each Element in an Array:
array_walk() 97
Counting Elements in an Array: count (), sizeof (),
and array_count_values ( ) 98
Converting Arrays to Scalar Variables: extract ( ) 99
Further Reading 100
Next 100
4 String Manipulation and Regular Expressions 101
Creating a Sample Application: Smart Form Mail 101
Formatting Strings 104
Trimming Strings: chop ( ), ltrim ( ), and trim ( ) 104
Formatting Strings for Output 105
Joining and Splitting Strings with String Functions 112
Using explode ( ), implode ( ), and j oin ( ) 112
Using strtok ( ) 113
Using substr ( ) 114
Comparing Strings 115
Performing String Ordering: strcmp ( ), strcasecmp ( ),
and strnatcmp() 115
Testing String Length with strlen ( ) 115
Matching and Replacing Substrings with String Functions 116
Finding Strings in Strings: strstr ( ), strchr ( ), strrchr ( ),
andstristrO 116
Finding the Position of a Substring: strpos ( )
and strrpos ( ) 117
Replacing Substrings: str_replace ( )
and substr_replace() 118
Contents xiii
Introducing Regular Expressions 119
The Basics 120
Delimiters 120
Character Classes and Types 120
Repetition 122
Subexpressions 122
Counted Subexpressions 123
Anchoring to the Beginning or End of a String 123
Branching 123
Matching Literal Special Characters 123
Reviewing Meta Characters 124
Escape Sequences 125
Backreferences 126
Assertions 126
Putting it All Together for the Smart Form 127
Finding Substrings with Regular Expressions 128
Replacing Substrings with Regular Expressions 129
Splitting Strings with Regular Expressions 129
Further Reading 130
Next 130
5 Reusing Code and Writing Functions 131
The Advantages of Reusing Code 131
Cost 132
Reliability 132
Consistency 132
Using require ( ) and include () 132
Using require ( ) to Include Code 133
Using require ( ) for Website Templates 134
Using auto_prepend_f ile and auto_append_file 139
Using Functions in PHP 140
Calling Functions 141
Calling an Undefined Function 142
Understanding Case and Function Names 143
Defining Your Own Functions 144
Examining Basic Function Structure 144
Naming Your Function 145
Using Parameters 146
xiv Contents
Understanding Scope 148
Passing by Reference Versus Passing by Value 150
Using the return Keyword 152
Returning Values from Functions 153
Implementing Recursion 154
Implementing Anonymous Functions (or Closures) 155
Further Reading 157
Next 157
6 Object-Oriented PHP 159
Understanding Object-Oriented Concepts 160
Classes and Objects 160
Polymorphism 161
Inheritance 161
Creating Classes, Attributes, and Operations in PHP 162
Structure of a Class 162
Constructors 163
Destructors 163
Instantiating Classes 163
Using Class Attributes 164
Calling Class Operations 165
Controlling Access with private and public 166
Writing Accessor Functions 166
Implementing Inheritance in PHP 168
Controlling Visibility Through Inheritance with private
and protected 169
Overriding 170
Preventing Inheritance and Overriding with final 172
Understanding Multiple Inheritance 172
Implementing Interfaces 173
Using Traits 174
Designing Classes 176
Writing the Code for Your Class 177
Understanding Advanced Object-Oriented Functionality in PHP 185
Using Per-Class Constants 185
Implementing Static Methods 185
Checking Class Type and Type Hinting 185
Contents xv
Late Static Bindings 186
Cloning Objects 187
Using Abstract Classes 188
Overloading Methods with_call ( ) 188
Using_autoload ( ) 189
Implementing Iterators and Iteration 190
Generators 192
Converting Your Classes to Strings 194
Using the Reflection API 194
Namespaces 195
Using Subnamespaces 197
Understanding the Global Namespace 197
Importing and Aliasing Namespaces 198
Next 198
7 Error and Exception Handling 199
Exception Handling Concepts 199
The Exception Class 201
User-Defined Exceptions 202
Exceptions in Bob s Auto Parts 204
Exceptions and PHP s Other Error Handling Mechanisms 208
Further Reading 208
Next 208
II: Using MySQL
8 Designing Your Web Database 209
Relational Database Concepts 210
Tables 210
Columns 211
Rows 211
Values 211
Keys 211
Schemas 212
Relationships 213
Designing Your Web Database 213
Think About the Real-World Objects You Are Modeling 213
Avoid Storing Redundant Data 214
xvi Contents
Use Atomic Column Values 216
Choose Sensible Keys 217
Think About What You Want to Ask the Database 217
Avoid Designs with Many Empty Attributes 217
Summary of Table Types 218
Web Database Architecture 218
Further Reading 220
Next 220
9 Creating Your Web Database 221
Using the MySQL Monitor 222
Logging In to MySQL 223
Creating Databases and Users 224
Setting Up Users and Privileges 225
Introducing MySQL s Privilege System 225
Principle of Least Privilege 225
User Setup: The CREATE USER and GRANT Commands 225
Types and Levels of Privileges 227
The REVOKE Command 230
Examples Using GRANT and REVOKE 230
Setting Up a User for the Web 231
Using the Right Database 232
Creating Database Tables 232
Understanding What the Other Keywords Mean 234
Understanding the Column Types 235
Looking at the Database with show and DESCRIBE 237
Creating Indexes 238
Understanding MySQL Identifiers 239
Choosing Column Data Types 240
Numeric Types 241
Date and Time Types 243
String Types 244
Further Reading 246
Next 246
10 Working with Your MySQL Database 247
What Is SQL? 247
Inserting Data into the Database 248
Contents xvii
Retrieving Data from the Database 250
Retrieving Data with Specific Criteria 251
Retrieving Data from Multiple Tables 253
Retrieving Data in a Particular Order 259
Grouping and Aggregating Data 259
Choosing Which Rows to Return 261
Using Subqueries 262
Updating Records in the Database 265
Altering Tables After Creation 265
Deleting Records from the Database 268
Dropping Tables 268
Dropping a Whole Database 268
Further Reading 269
Next 269
11 Accessing Your MySQL Database from the Web with PHP 271
How Web Database Architectures Work 272
Querying a Database from the Web 275
Checking and Filtering Input Data 276
Setting Up a Connection 277
Choosing a Database to Use 278
Querying the Database 278
Using Prepared Statements 279
Retrieving the Query Results 280
Disconnecting from the Database 281
Putting New Information in the Database 282
Using Other PHP-Database Interfaces 286
Using a Generic Database Interface: PDO 286
Further Reading 289
Next 289
12 Advanced MySQL Administration 291
Understanding the Privilege System in Detail 291
The user Table 293
The db Table 295
The tables_priv, columns_priv, and procs
Access Control: How MySQL Uses the Grant Tables
Updating Privileges: When Do Changes Take Effect?
priv Tables 296
298
299
xviii Contents
Making Your MySQL Database Secure 299
MySQL from the Operating System s Point of View 299
Passwords 300
User Privileges 300
Web Issues 301
Getting More Information About Databases 301
Getting Information with SHOW 302
Getting Information About Columns with DESCRIBE 304
Understanding How Queries Work with EXPLAIN 304
Optimizing Your Database 309
Design Optimization 309
Permissions 309
Table Optimization 310
Using Indexes 310
Using Default Values 310
Other Tips 310
Backing Up Your MySQL Database 310
Restoring Your MySQL Database 311
Implementing Replication 311
Setting Up the Master 312
Performing the Initial Data Transfer 313
Setting Up the Slave or Slaves 313
Further Reading 314
Next 314
13 Advanced MySQL Programming 315
The LOAD DATA INFILE Statement 315
Storage Engines 316
Transactions 317
Understanding Transaction Definitions 317
Using Transactions with InnoDB 318
Foreign Keys 319
Stored Procedures 320
Basic Example 320
Local Variables 323
Cursors and Control Structures 323
Triggers 327
Further Reading 329
Next 329
III: Web Application Security
14 Web Application Security Risks 331
Identifying the Threats We Face 331
Access to Sensitive Data 331
Modification of Data 334
Loss or Destruction of Data 334
Denial of Service 335
Malicious Code Injection 337
Compromised Server 338
Repudiation 338
Understanding Who We re Dealing With 339
Attackers and Crackers 339
Unwitting Users of Infected Machines 339
Disgruntled Employees 339
Flardware Thieves 340
Ourselves 340
Next 340
15 Building a Secure Web Application 341
Strategies for Dealing with Security 341
Start with the Right Mindset 342
Balancing Security and Usability 342
Monitoring Security 342
Our Basic Approach 343
Securing Your Code 343
Filtering User Input 343
Escaping Output 348
Code Organization 350
What Goes in Your Code 351
File System Considerations 352
Code Stability and Bugs 352
Executing Commands 353
XX Contents
Securing Your Web Server and PHP 354
Keep Software Up-to-Date 354
Browse the php. ini file 355
Web Server Configuration 356
Shared Hosting of Web Applications 356
Database Server Security 357
Users and the Permissions System 358
Sending Data to the Server 358
Connecting to the Server 359
Running the Server 359
Protecting the Network 360
Firewalls 360
Use a DMZ 360
Prepare for DoS and DDoS Attacks 361
Computer and Operating System Security 361
Keep the Operating System Up to Date 361
Run Only What Is Necessary 362
Physically Secure the Server 362
Disaster Planning 362
Next 364
16 Implementing Authentication Methods with PHP 365
Identifying Visitors 365
Implementing Access Control 366
Storing Passwords 369
Securing Passwords 369
Protecting Multiple Pages 371
Using Basic Authentication 372
Using Basic Authentication in PHP 372
Using Basic Authentication with Apache s .htaccess Files 374
Creating Your Own Custom Authentication 377
Further Reading 377
Next 377
IV: Advanced PHP Techniques
17 Interacting with the File System and the Server 379
Uploading Files 379
HTML for File Upload 381
Contents xx¡
Writing the PHP to Deal with the File 382
Session Upload Progress 387
Avoiding Common Upload Problems 389
Using Directory Functions 390
Reading from Directories 390
Getting Information About the Current Directory 394
Creating and Deleting Directories 394
Interacting with the File System 395
Getting File Information 395
Changing File Properties 397
Creating, Deleting, and Moving Files 398
Using Program Execution Functions 398
Interacting with the Environment: getenv ( ) and putenv ( ) 401
Further Reading 402
Next 402
18 Using Network and Protocol Functions 403
Examining Available Protocols 403
Sending and Reading Email 404
Using Data from Other Websites 404
Using Network Lookup Functions 408
Backing Up or Mirroring a File 412
Using FTP to Back Up or Mirror a File 412
Uploading Files 420
Avoiding Timeouts 420
Using Other FTP Functions 420
Further Reading 421
Next 421
19 Managing the Date and Time 423
Getting the Date and Time from PHP 423
Understanding Timezones 423
Using the date () Function 424
Dealing with Unix Timestamps 426
Using the getdate ( ) Function 427
Validating Dates with checkdate ( ) 428
Formatting Timestamps 429
Converting Between PHP and MySQL Date Formats 431
xxii Contents
Calculating Dates in PHP 433
Calculating Dates in MySQL 434
Using Microseconds 435
Using the Calendar Functions 436
Further Reading 436
Next 436
20 Internationalization and Localization 437
Localization Is More than Translation 437
Understanding Character Sets 438
Security Implications of Character Sets 439
Using Multibyte String Functions in PHP 440
Creating a Basic Localizable Page Structure 440
Using gettext ( ) in an Internationalized Application 444
Configuring Your System to Use gettext ( ) 444
Creating Translation Files 445
Implementing Localized Content in PHP Using gettext ( ) 447
Further Reading 448
Next 448
21 Generating Images 449
Setting Up Image Support in PHP 449
Understanding Image Formats 450
JPEG 450
PNG 450
GIF 451
Creating Images 451
Creating a Canvas Image 452
Drawing or Printing Text on the Image 453
Outputting the Final Graphic 455
Cleaning Up 455
Using Automatically Generated Images in Other Pages 456
Using Text and Fonts to Create Images 457
Setting Up the Base Canvas 460
Fitting the Text onto the Button 461
Positioning the Text 464
Writing the Text onto the Button 464
Finishing Up 465
Drawing Figures and Graphing Data 465
Using Other Image Functions 474
Next 474
22 Using Session Control in PHP 475
What Is Session Control? 475
Understanding Basic Session Functionality 476
What Is a Cookie? 476
Setting Cookies from PHP 476
Using Cookies with Sessions 477
Storing the Session ID 477
Implementing Simple Sessions 478
Starting a Session 478
Registering Session Variables 478
Using Session Variables 479
Unsetting Variables and Destroying the Session 479
Creating a Simple Session Example 480
Configuring Session Control 482
Implementing Authentication with Session Control 483
Next 491
23 Integrating JavaScript and PHP 493
Understanding AJAX 493
A Brief Introduction to jQuery 494
Using jQuery in Web Applications 494
Using jQuery and AJAX with PHP 504
The AJAX-Enabled Chat Script/Server 504
The jQuery AJAX Methods 507
The Chat Client/jQuery Application 510
Further Reading 517
Next 517
24 Other Useful Features 519
Evaluating Strings: eval ( ) 519
Terminating Execution: die ( ) and exit ( ) 520
Serializing Variables and Objects 521
Getting Information About the PHP Environment 522
Finding Out What Extensions Are Loaded 522
xxiv Contents
Identifying the Script Owner 523
Finding Out When the Script Was Modified 523
Temporarily Altering the Runtime Environment 524
Highlighting Source Code 525
Using PHP on the Command Line 526
Next 527
V: Building Practical PHP and MySQL Projects
25 Using PHP and MySQL for Large Projects 529
Applying Software Engineering to Web Development 530
Planning and Running a Web Application Project 530
Reusing Code 531
Writing Maintainable Code 532
Coding Standards 532
Breaking Up Code 535
Using a Standard Directory Structure 536
Documenting and Sharing In-House Functions 536
Implementing Version Control 536
Choosing a Development Environment 537
Documenting Your Projects 538
Prototyping 538
Separating Logic and Content 539
Optimizing Code 540
Using Simple Optimizations 540
Testing 541
Further Reading 542
Next 542
26 Debugging and Logging 543
Programming Errors 543
Syntax Errors 543
Runtime Errors 544
Logic Errors 549
Variable Debugging Aid 551
Error Reporting Levels 553
Altering the Error Reporting Settings 554
Triggering Your Own Errors 556
Contents xxv
Logging Errors Gracefully 557
Logging Errors to a Log File 560
Next 560
27 Building User Authentication and Personalization 561
Solution Components 561
User Identification and Personalization 562
Storing Bookmarks 563
Recommending Bookmarks 563
Solution Overview 563
Implementing the Database 565
Implementing the Basic Site 566
Implementing User Authentication 569
Registering Users 569
Logging In 575
Logging Out 579
Changing Passwords 580
Resetting Forgotten Passwords 582
Implementing Bookmark Storage and Retrieval 587
Adding Bookmarks 588
Displaying Bookmarks 590
Deleting Bookmarks 591
Implementing Recommendations 594
Considering Possible Extensions 598
28 Building a Web-Based Email Service with Laravel Part I Web Edition
29 Building a Web-Based Email Service with Laravel Part II Web Edition
30 Social Media Integration Sharing and Authentication Web Edition
31 Building a Shopping Cart Web Edition
VI: Appendix
A Installing Apache, PHP, and MySQL 599
Installing Apache, PHP, and MySQL Under UNIX 600
Binary Installation 600
Source Installation 601
Basic Apache Configuration Modifications 608
xxvi Contents
Is PHP Support Working? 610
Is SSL Working? 610
Installing Apache, PHP, and MySQL for Windows and Mac OS X
Using All-in-One Installation Packages 612
Installing PEAR 613
Installing PHP with Other Web Servers 614
Index 615
|
| any_adam_object | 1 |
| author | Welling, Luke 1972- Thomson, Laura 1972- |
| author_GND | (DE-588)129184942 (DE-588)139272186 |
| author_facet | Welling, Luke 1972- Thomson, Laura 1972- |
| author_role | aut aut |
| author_sort | Welling, Luke 1972- |
| author_variant | l w lw l t lt |
| building | Verbundindex |
| bvnumber | BV043563925 |
| classification_rvk | ST 250 |
| classification_tum | DAT 663f DAT 675f DAT 366f |
| ctrlnum | (OCoLC)967869884 (DE-599)BVBBV043563925 |
| discipline | Informatik |
| edition | Fifth edition |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03308nam a2200781 c 4500</leader><controlfield tag="001">BV043563925</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20170908 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">160520s2017 a||| |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB2A9066</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780321833891</subfield><subfield code="c">pbk.</subfield><subfield code="9">978-0-321-83389-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0321833899</subfield><subfield code="c">pbk.</subfield><subfield code="9">0-321-83389-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)967869884</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043563925</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91G</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-1050</subfield><subfield code="a">DE-739</subfield><subfield code="a">DE-B768</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 250</subfield><subfield code="0">(DE-625)143626:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 663f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 675f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 366f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Welling, Luke</subfield><subfield code="d">1972-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)129184942</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PHP and MySQL web development</subfield><subfield code="c">Luke Welling, Laura Thomson</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Fifth edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, NJ ; Boston ; Indianapolis ; San Francisco ; New York ; Toronto ; Montreal ; London ; Munich ; Paris ; Madrid ; Cape Town ; Sydney ; Tokyo ; Singapore ; Mexico City</subfield><subfield code="b">Addison-Wesley</subfield><subfield code="c">[2017]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">© 2017</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xxvi, 652 Seiten</subfield><subfield code="b">Illustrationen</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">PHP (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Web site development</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">PHP (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Web site development</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">PHP 5.3</subfield><subfield code="0">(DE-588)7638375-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">PHP 7.0</subfield><subfield code="0">(DE-588)1082352969</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">PHP</subfield><subfield code="0">(DE-588)4546126-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MySQL 5.0</subfield><subfield code="0">(DE-588)4792791-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">PHP 4.0</subfield><subfield code="0">(DE-588)4584299-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">PHP 5.0</subfield><subfield code="0">(DE-588)4763174-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MySQL 5.1</subfield><subfield code="0">(DE-588)7574874-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">PHP 7.0</subfield><subfield code="0">(DE-588)1082352969</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">PHP 4.0</subfield><subfield code="0">(DE-588)4584299-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">PHP 5.0</subfield><subfield code="0">(DE-588)4763174-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="3" ind2="0"><subfield code="a">MySQL 5.0</subfield><subfield code="0">(DE-588)4792791-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="3" ind2=" "><subfield code="8">3\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="4" ind2="0"><subfield code="a">PHP 5.3</subfield><subfield code="0">(DE-588)7638375-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="4" ind2=" "><subfield code="8">4\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="5" ind2="0"><subfield code="a">MySQL 5.1</subfield><subfield code="0">(DE-588)7574874-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="5" ind2=" "><subfield code="8">5\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="6" ind2="0"><subfield code="a">PHP</subfield><subfield code="0">(DE-588)4546126-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="6" ind2=" "><subfield code="8">6\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Thomson, Laura</subfield><subfield code="d">1972-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)139272186</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028978954&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028978954</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">3\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">4\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">5\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">6\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection> |
| id | DE-604.BV043563925 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T07:28:58Z |
| institution | BVB |
| isbn | 9780321833891 0321833899 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028978954 |
| oclc_num | 967869884 |
| open_access_boolean | |
| owner | DE-91G DE-BY-TUM DE-11 DE-1050 DE-739 DE-B768 |
| owner_facet | DE-91G DE-BY-TUM DE-11 DE-1050 DE-739 DE-B768 |
| physical | xxvi, 652 Seiten Illustrationen |
| publishDate | 2017 |
| publishDateSearch | 2017 |
| publishDateSort | 2017 |
| publisher | Addison-Wesley |
| record_format | marc |
| spelling | Welling, Luke 1972- Verfasser (DE-588)129184942 aut PHP and MySQL web development Luke Welling, Laura Thomson Fifth edition Hoboken, NJ ; Boston ; Indianapolis ; San Francisco ; New York ; Toronto ; Montreal ; London ; Munich ; Paris ; Madrid ; Cape Town ; Sydney ; Tokyo ; Singapore ; Mexico City Addison-Wesley [2017] © 2017 xxvi, 652 Seiten Illustrationen txt rdacontent n rdamedia nc rdacarrier PHP (Computer program language) Web site development PHP (Computer program language) fast Web site development fast PHP 5.3 (DE-588)7638375-1 gnd rswk-swf PHP 7.0 (DE-588)1082352969 gnd rswk-swf PHP (DE-588)4546126-0 gnd rswk-swf MySQL (DE-588)4559381-4 gnd rswk-swf MySQL 5.0 (DE-588)4792791-4 gnd rswk-swf PHP 4.0 (DE-588)4584299-1 gnd rswk-swf PHP 5.0 (DE-588)4763174-0 gnd rswk-swf MySQL 5.1 (DE-588)7574874-5 gnd rswk-swf MySQL (DE-588)4559381-4 s PHP 7.0 (DE-588)1082352969 s DE-604 PHP 4.0 (DE-588)4584299-1 s 1\p DE-604 PHP 5.0 (DE-588)4763174-0 s 2\p DE-604 MySQL 5.0 (DE-588)4792791-4 s 3\p DE-604 PHP 5.3 (DE-588)7638375-1 s 4\p DE-604 MySQL 5.1 (DE-588)7574874-5 s 5\p DE-604 PHP (DE-588)4546126-0 s 6\p DE-604 Thomson, Laura 1972- Verfasser (DE-588)139272186 aut HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028978954&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 3\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 4\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 5\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 6\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Welling, Luke 1972- Thomson, Laura 1972- PHP and MySQL web development PHP (Computer program language) Web site development PHP (Computer program language) fast Web site development fast PHP 5.3 (DE-588)7638375-1 gnd PHP 7.0 (DE-588)1082352969 gnd PHP (DE-588)4546126-0 gnd MySQL (DE-588)4559381-4 gnd MySQL 5.0 (DE-588)4792791-4 gnd PHP 4.0 (DE-588)4584299-1 gnd PHP 5.0 (DE-588)4763174-0 gnd MySQL 5.1 (DE-588)7574874-5 gnd |
| subject_GND | (DE-588)7638375-1 (DE-588)1082352969 (DE-588)4546126-0 (DE-588)4559381-4 (DE-588)4792791-4 (DE-588)4584299-1 (DE-588)4763174-0 (DE-588)7574874-5 |
| title | PHP and MySQL web development |
| title_auth | PHP and MySQL web development |
| title_exact_search | PHP and MySQL web development |
| title_full | PHP and MySQL web development Luke Welling, Laura Thomson |
| title_fullStr | PHP and MySQL web development Luke Welling, Laura Thomson |
| title_full_unstemmed | PHP and MySQL web development Luke Welling, Laura Thomson |
| title_short | PHP and MySQL web development |
| title_sort | php and mysql web development |
| topic | PHP (Computer program language) Web site development PHP (Computer program language) fast Web site development fast PHP 5.3 (DE-588)7638375-1 gnd PHP 7.0 (DE-588)1082352969 gnd PHP (DE-588)4546126-0 gnd MySQL (DE-588)4559381-4 gnd MySQL 5.0 (DE-588)4792791-4 gnd PHP 4.0 (DE-588)4584299-1 gnd PHP 5.0 (DE-588)4763174-0 gnd MySQL 5.1 (DE-588)7574874-5 gnd |
| topic_facet | PHP (Computer program language) Web site development PHP 5.3 PHP 7.0 PHP MySQL MySQL 5.0 PHP 4.0 PHP 5.0 MySQL 5.1 |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028978954&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT wellingluke phpandmysqlwebdevelopment AT thomsonlaura phpandmysqlwebdevelopment |