PHP and MySQL recipes: a problem-solution approach
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
New York, NY
Apress
[2016]
|
| Ausgabe: | Second edition |
| Schriftenreihe: | The expert's voice in web development
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | xxxiii, 361 Seiten Illustrationen |
| ISBN: | 9781484206065 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043665701 | ||
| 003 | DE-604 | ||
| 005 | 20161206 | ||
| 007 | t | ||
| 008 | 160712s2016 a||| |||| 00||| eng d | ||
| 020 | |a 9781484206065 |c pbk. |9 978-1-4842-0606-5 | ||
| 035 | |a (OCoLC)953815058 | ||
| 035 | |a (DE-599)BVBBV043665701 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-11 | ||
| 082 | 0 | |a 004 |2 23 | |
| 084 | |a ST 250 |0 (DE-625)143626: |2 rvk | ||
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Kromann, Frank M. |e Verfasser |0 (DE-588)110705057X |4 aut | |
| 245 | 1 | 0 | |a PHP and MySQL recipes |b a problem-solution approach |c by Frank M. Kromann |
| 250 | |a Second edition | ||
| 264 | 1 | |a New York, NY |b Apress |c [2016] | |
| 264 | 4 | |c © 2016 | |
| 300 | |a xxxiii, 361 Seiten |b Illustrationen | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a The expert's voice in web development | |
| 650 | 4 | |a Computer science | |
| 650 | 4 | |a Computer Science | |
| 650 | 4 | |a Computer Science, general | |
| 650 | 4 | |a Informatik | |
| 650 | 0 | 7 | |a MySQL |0 (DE-588)4559381-4 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a PHP |0 (DE-588)4546126-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Informatik |0 (DE-588)4026894-9 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Informatik |0 (DE-588)4026894-9 |D s |
| 689 | 0 | 1 | |a PHP |0 (DE-588)4546126-0 |D s |
| 689 | 0 | 2 | |a MySQL |0 (DE-588)4559381-4 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-4842-0605-8 |
| 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=029078964&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-029078964 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Datensatz im Suchindex
| _version_ | 1804176423225655296 |
|---|---|
| adam_text | Titel: PHP and MySQL recipes
Autor: Kromann, Frank M
Jahr: 2016
Contents
_J
About the Author..................................................................................................xxix
About the Technical Reviewer..............................................................................xxxi
Introduction........................................................................................................xxxiii
¦Chapter 1: Installation and Configuration.............................................................1
Recipe 1-1. Installing PHP................................................................................................1
Problem..................................................................................................................................................1
Solution...................................................................................................................................................1
How it Works...........................................................................................................................................2
Recipe 1-2. Configuring PHP.........................................................................................17
Problem................................................................................................................................................17
Solution.................................................................................................................................................17
How it Works.........................................................................................................................................18
Recipe 1-3. Compiling PHP............................................................................................21
Problem................................................................................................................................................21
Solution.................................................................................................................................................21
How it Works.........................................................................................................................................22
Recipe 1-4. Installing MySQL.........................................................................................26
Problem................................................................................................................................................26
Solution.................................................................................................................................................26
How it Works.........................................................................................................................................27
Recipe 1-5. Virtual Machines.........................................................................................27
Problem................................................................................................................................................27
Solution.................................................................................................................................................27
How it Works.........................................................................................................................................28
V
ÜB CONTENTS
¦Chapter 2: Classes and Objects...........................................................................29
Recipe 2-1. Writing a Simple Class................................................................................29
Problem................................................................................................................................................29
Solution.................................................................................................................................................29
How it Works.........................................................................................................................................29
Recipe 2-2. Writing a Base Class...................................................................................30
Problem................................................................................................................................................30
Solution.................................................................................................................................................30
How it Works.........................................................................................................................................30
Recipe 2-3. Writing an Abstract Class............................................................................31
Problem................................................................................................................................................31
Solution.................................................................................................................................................31
How it Works.........................................................................................................................................31
Recipe 2-4. Writing an Interface.....................................................................................33
Problem................................................................................................................................................33
Solution.................................................................................................................................................33
How it Works.........................................................................................................................................33
Recipe 2-5. Class Members as Regular Functions.........................................................35
Problem................................................................................................................................................35
Solution.................................................................................................................................................35
How it Works.........................................................................................................................................35
Recipe 2-6. Protecting Data and Methods.....................................................................36
Problem..................................................................................................................................................
Solution...................................................................................................................................................
How it Works...........................................................................................................................................
Recipe 2-7. Mixed Static and Object Context...................................................................
Problem........................................................................................................................................ 37
Solution.......................................................................................................................................... 37
How it Works.................................................................................................................................. 38
vi
¦ CONTENTS
Recipe 2-8. Referencing Class Members.......................................................................38
Problem................................................................................................................................................38
Solution.................................................................................................................................................38
How it Works.........................................................................................................................................38
Recipe 2-9. Instantiation of Classes...............................................................................39
Problem................................................................................................................................................39
Solution.................................................................................................................................................39
How it Works.........................................................................................................................................40
Recipe 2-10. Printing Objects.........................................................................................41
Problem................................................................................................................................................41
Solution.................................................................................................................................................41
How it Works.........................................................................................................................................41
Recipe 2-11. Variable Overloading.................................................................................42
Problem................................................................................................................................................42
Solution.................................................................................................................................................42
How it Works.........................................................................................................................................42
Recipe 2-12. Serializing Types and Object.....................................................................44
Problem................................................................................................................................................44
Solution.................................................................................................................................................44
How it Works.........................................................................................................................................45
Recipe 2-13. Copying an Object.....................................................................................46
Problem................................................................................................................................................46
Solution.................................................................................................................................................46
How it Works.........................................................................................................................................46
Recipe 2-14. Using Objects as Functions.......................................................................47
Problem................................................................................................................................................47
Solution.................................................................................................................................................47
How it Works.........................................................................................................................................47
vii
CONTENTS
Recipe 2-15. Overloading Methods................................................................................48
Problem................................................................................................................................................48
Solution.................................................................................................................................................48
How it Works.........................................................................................................................................48
Recipe 2-16. Debugging Objects....................................................................................49
Problem................................................................................................................................................48
Solution.................................................................................................................................................48
How it Works.........................................................................................................................................50
Recipe 2-17. Using Objects without a Class..................................................................51
Problem................................................................................................................................................51
Solution.................................................................................................................................................51
How it Works.........................................................................................................................................51
Recipe 2-18. Directory Iteration.....................................................................................52
Problem................................................................................................................................................52
Solution.................................................................................................................................................52
How it Works.........................................................................................................................................52
Recipe 2-19. Writing Reusable Code..............................................................................53
Problem................................................................................................................................................53
Solution.................................................................................................................................................53
How it Works...........................................................................................................................................
Recipe 2-20. Avoiding Name Collisions..........................................................................57
Problem..................................................................................................................................................
Solution...................................................................................................................................................
How it Works...........................................................................................................................................
Recipe 2-21. Autoloading Classes on First Use................................................................
Problem..............................................................................................................................................59
Solution......................................................................................................................................... 59
How it Works............................................................................................................................ 59
viii
¦ CONTENTS
¦Chapter 3: Performing Math Operations..............................................................61
Recipe 3-1. Changing the Base Values for Numbers......................................................62
Problem................................................................................................................................................62
Solution.................................................................................................................................................62
How it Works.........................................................................................................................................62
Recipe 3-2. Converting to a Different Base Value..........................................................63
Problem................................................................................................................................................63
Solution.................................................................................................................................................63
How it Works.........................................................................................................................................63
Recipe 3-3. Storing Binary Values in Integers................................................................64
Problem................................................................................................................................................64
Solution.................................................................................................................................................64
How it Works.........................................................................................................................................64
Recipe 3-4. Setting and Clearing Bits in Binary.............................................................65
Problem................................................................................................................................................65
Solution.................................................................................................................................................65
How it Works.........................................................................................................................................65
Recipe 3-5. Using Hexadecimal Numbers......................................................................66
Problem................................................................................................................................................66
Solution.................................................................................................................................................66
How it Works.........................................................................................................................................66
Recipe 3-6. Increasing Performance with Binary Shift..................................................67
Problem................................................................................................................................................67
Solution.................................................................................................................................................67
How it Works.........................................................................................................................................67
Recipe 3-7. Rounding Floating Point Numbers..............................................................69
Problem................................................................................................................................................69
Solution.................................................................................................................................................69
How it Works.........................................................................................................................................69
ix
¦ CONTENTS
Recipe 3-8. Generating Random Numbers.....................................................................70
Problem................................................................................................................................................70
Solution.................................................................................................................................................70
How it Works.........................................................................................................................................70
Recipe 3-9. Expressing Ratios with Logarithmic Functions...........................................71
Problem................................................................................................................................................71
Solution.................................................................................................................................................71
How it Works.........................................................................................................................................71
Recipe 3-10. Calculating Future Values.........................................................................71
Problem................................................................................................................................................71
Solution.................................................................................................................................................71
How it Works.........................................................................................................................................72
Recipe 3-11. Using Trigonometry to Calculate Distance and Direction..........................73
Problem................................................................................................................................................73
Solution.................................................................................................................................................73
How it Works.........................................................................................................................................73
Recipe 3-12. Working with Complex Numbers...............................................................74
Problem................................................................................................................................................74
Solution.................................................................................................................................................74
How it Works...........................................................................................................................................
¦Chapter 4: Working with Arrays.......................................................................... 77
Recipe 4-1. Creating Arrays.............................................................................................
Problem..................................................................................................................................................
Solution........................................................................................................................................... -¡i
How it Works............................................................................................................................. 7g
Recipe 4-2. Changing Arrays............................................................................................
Problem................................................................................................................................................................................................................................................................79
Solution..................................................................................................................................................................................................................................................................7g
How it Works......................................................................................................................................................................................................on
X
¦ CONTENTS
Recipe 4-3. Adding Arrays..............................................................................................81
Problem................................................................................................................................................81
Solution.................................................................................................................................................82
How it Works.........................................................................................................................................82
Recipe 4-4. Arrays of Arrays...........................................................................................86
Problem................................................................................................................................................86
Solution.................................................................................................................................................86
How it Works.........................................................................................................................................86
Recipe 4-5. Traversing Arrays........................................................................................88
Problem................................................................................................................................................88
Solution.................................................................................................................................................88
How it Works.........................................................................................................................................88
Recipe 4-6. Sorting Arrays.............................................................................................90
Problem................................................................................................................................................90
Solution.................................................................................................................................................90
How It Works.........................................................................................................................................90
Recipe 4-7. Using Arrays as Stacks.............................................................................100
Problem..............................................................................................................................................100
Solution...............................................................................................................................................101
How it Works.......................................................................................................................................101
Recipe 4-8. Slicing and Splicing Arrays.......................................................................102
Problem..............................................................................................................................................102
Solution...............................................................................................................................................102
How it Works.......................................................................................................................................102
Recipe 4-9. Debugging Arrays......................................................................................105
Problem..............................................................................................................................................105
Solution...............................................................................................................................................105
How it Works.......................................................................................................................................106
xi
S CONTENTS
Recipe 4-10. Storing Arrays.........................................................................................107
Problem..............................................................................................................................................107
Solution...............................................................................................................................................^®7
How it Works.......................................................................................................................................^7
¦Chapter 5: Dates and Times...............................................................................109
Recipe 5-1. Working with Time Zones..........................................................................109
Problem..............................................................................................................................................109
Solution...............................................................................................................................................103
How it Works.......................................................................................................................................110
Recipe 5-2. Creating a Timestamp...............................................................................110
Problem..............................................................................................................................................110
Solution...............................................................................................................................................110
How it Works.......................................................................................................................................111
Recipe 5-3. Working with Dates...................................................................................112
Problem..............................................................................................................................................112
Solution...............................................................................................................................................112
How it Works.......................................................................................................................................112
Recipe 5-4. Displaying Timestamps.............................................................................113
Problem..............................................................................................................................................113
Solution...............................................................................................................................................113
How it Works..........................................................................................................................................
Recipe 5-5. Using ISO Formats....................................................................................116
Problem.................................................................................................................................................
Solution..................................................................................................................................................
How it Works..........................................................................................................................................
Recipe 5-6. Working with Week Numbers.......................................................................
Problem................................................................................................................................................
Solution..................................................................................................................................................
How it Works..........................................................................................................................................
xii
¦ CONTENTS
Recipe 5-7. The DateTime Class..................................................................................118
Problem..............................................................................................................................................118
Solution...............................................................................................................................................118
How it Works.......................................................................................................................................118
Recipe 5-8. Storing Date and Time Values...................................................................122
Problem..............................................................................................................................................122
Solution...............................................................................................................................................122
How it Works.......................................................................................................................................122
Recipe 5-9. Calculating Elapsed Time..........................................................................123
Problem..............................................................................................................................................123
Solution...............................................................................................................................................123
How it Works.......................................................................................................................................123
¦Chapter 6: Strings.............................................................................................. 125
Recipe 6-1. Creating Strings........................................................................................125
Problem..............................................................................................................................................125
Solution...............................................................................................................................................125
How it Works.......................................................................................................................................125
Recipe 6-2. Working with the Characters in a String...................................................126
Problem..............................................................................................................................................126
Solution...............................................................................................................................................126
How it Works.......................................................................................................................................126
Recipe 6-3. Replacing Characters................................................................................127
Problem..............................................................................................................................................127
Solution...............................................................................................................................................127
How it Works.......................................................................................................................................127
Recipe 6-4. Creating Long Strings with Heredoc and Newdoc....................................128
Problem..............................................................................................................................................128
Solution...............................................................................................................................................128
How it Works.......................................................................................................................................128
xiii
CONTENTS
Recipe 6-5. Escaping Strings.......................................................................................130
Problem..............................................................................................................................................130
Solution...............................................................................................................................................*3^
How it Works.......................................................................................................................................131
Recipe 6-6. Reformatting Strings.................................................................................132
Problem..............................................................................................................................................132
Solution...............................................................................................................................................132
How it Works.......................................................................................................................................132
Recipe 6-7. Trimming Whitespace................................................................................133
Problem..............................................................................................................................................133
Solution...............................................................................................................................................133
How it Works.......................................................................................................................................133
Recipe 6-8. Finding Strings in Strings.........................................................................133
Problem..............................................................................................................................................133
Solution...............................................................................................................................................134
How it Works.......................................................................................................................................134
Recipe 6-9. Dividing Strings into Substrings................................................................135
Problem..............................................................................................................................................135
Solution..................................................................................................................................................
How it Works.......................................................................................................................................135
Recipe 6-10. Displaying HTML Entities...........................................................................
Problem.................................................................................................................................................
Solution...............................................................................................................................................
How it Works............................................................................................................................ 137
Recipe 6-11. Generating Hash Values for Files........................................................ 13g
Problem......................................................................................................................................................................................................................................................139
Solution......................................................................................................................................................................................................................................................139
How it Works..............................................................................................................................................................................................................................13g
xiv
* CONTENTS
Recipe 6-12. Storing Passwords..................................................................................141
Problem..............................................................................................................................................141
Solution...............................................................................................................................................141
How it Works.......................................................................................................................................141
¦Chapter 7: Files and Directories........................................................................143
Recipe 7-1. Include and Require..................................................................................143
Problem..............................................................................................................................................143
Solution...............................................................................................................................................143
How it Works.......................................................................................................................................144
Recipe 7-2. Reading Files............................................................................................145
Problem..............................................................................................................................................145
Solution...............................................................................................................................................145
How it Works.......................................................................................................................................146
Recipe 7-3. Writing Files..............................................................................................147
Problem..............................................................................................................................................147
Solution...............................................................................................................................................147
How it Works.......................................................................................................................................148
Recipe 7-4. Copy, Rename, and Remove Files.............................................................148
Problem..............................................................................................................................................148
Solution...............................................................................................................................................149
How it Works.......................................................................................................................................149
Recipe 7-5. File Properties...........................................................................................150
Problem..............................................................................................................................................150
Solution...............................................................................................................................................150
How it Works.......................................................................................................................................150
Recipe 7-6. Permissions..............................................................................................152
Problem..............................................................................................................................................152
Solution...............................................................................................................................................152
How it Works.......................................................................................................................................152
XV
CONTENTS
Recipe 7-7. Symbolic Links..........................................................................................153
Problem..............................................................................................................................................^
Solution...............................................................................................................................................153
How it Works.......................................................................................................................................^
Recipe 7-8. Directories.................................................................................................155
Problem..............................................................................................................................................
Solution...............................................................................................................................................^55
How it Works.......................................................................................................................................155
Recipe 7-9. CSV Files...................................................................................................156
Problem..............................................................................................................................................156
Solution...............................................................................................................................................156
How it Works.......................................................................................................................................156
Recipe 7-10. Streams...................................................................................................159
Problem..............................................................................................................................................159
Solution...............................................................................................................................................159
How it Works.......................................................................................................................................159
Recipe 7-11. Stream Context.......................................................................................160
Problem..............................................................................................................................................160
Solution...............................................................................................................................................160
How it Works.......................................................................................................................................160
Recipe 7-12. File Iterators............................................................................................162
Problem.................................................................................................................................................
Solution..................................................................................................................................................
How it Works..........................................................................................................................................
Recipe 7-13. Download Files...........................................................................................
Problem......................................................................................................................................... 164
Solution.......................................................................................................................................... 164
How it Works..........................................................................................................................................
xvi
¦ CONTENTS
Recipe 7-14. Upload Files............................................................................................165
Problem..............................................................................................................................................165
Solution...............................................................................................................................................165
How it Works.......................................................................................................................................165
Recipe 7-15. Zipped Files.............................................................................................166
Problem..............................................................................................................................................166
Solution...............................................................................................................................................166
How it Works.......................................................................................................................................167
¦Chapter 8: Dynamic Imaging.............................................................................169
Recipe 8-1. Creating Images........................................................................................169
Problem..............................................................................................................................................169
Solution...............................................................................................................................................169
How it Works.......................................................................................................................................170
Recipe 8-2. Image Resize.............................................................................................171
Problem..............................................................................................................................................171
Solution...............................................................................................................................................171
How it Works.......................................................................................................................................171
Recipe 8-3. Image Crop................................................................................................173
Problem..............................................................................................................................................173
Solution...............................................................................................................................................173
How it Works.......................................................................................................................................173
Recipe 8-4. Image Rotate.............................................................................................176
Problem..............................................................................................................................................176
Solution...............................................................................................................................................176
How it Works.......................................................................................................................................176
Recipe 8-5. Image Flip.................................................................................................177
Problem..............................................................................................................................................177
Solution...............................................................................................................................................177
How it Works.......................................................................................................................................177
xvii
m CONTENTS
Recipe 8-6. Adding a Watermark..................................................................................178
Problem..............................................................................................................................................I78
Solution...............................................................................................................................................178
How it Works.......................................................................................................................................I78
Recipe 8-7. Changing Colors........................................................................................180
Problem..............................................................................................................................................180
Solution...............................................................................................................................................180
How it Works.......................................................................................................................................180
Recipe 8-8. Draw on Images........................................................................................182
Problem..............................................................................................................................................182
Solution...............................................................................................................................................182
How it Works.......................................................................................................................................182
Recipe 8-9. Transparency.............................................................................................190
Problem..............................................................................................................................................190
Solution...............................................................................................................................................190
How it Works.......................................................................................................................................190
Recipe 8-10. Adding Text..............................................................................................191
Problem..............................................................................................................................................191
Solution...............................................................................................................................................191
How it Works..........................................................................................................................................
Recipe 8-11. Caching Images....................................................................................... g3
Problem.................................................................................................................................................
Solution................................................................................................................................................. 93
How it Works.................................................................................................................................. 193
¦Chapter 9: Regular Expressions........................................................................
Recipe 9-1. Format Validation.................................................................................... 200
Problem................................................................................................................................ 200
Solution.................................................................................................................................. 200
How it Works............................................................................................................................. 200
xviii
¦ CONTENTS
Recipe 9-2. Sub Patterns.............................................................................................203
Problem..............................................................................................................................................203
Solution...............................................................................................................................................203
How it Works.......................................................................................................................................203
Recipe 9-3. String Replacement..................................................................................205
Problem..............................................................................................................................................205
Solution...............................................................................................................................................205
How it Works.......................................................................................................................................206
¦Chapter 10: Variables........................................................................................209
Recipe 10-1. Converting Variable Type.........................................................................209
Problem..............................................................................................................................................209
Solution...............................................................................................................................................209
How it Works.......................................................................................................................................210
Recipe 10-2. Allocating Memory..................................................................................210
Problem..............................................................................................................................................210
Solution...............................................................................................................................................210
How it Works.......................................................................................................................................211
Recipe 10-3. Determining Memory Use.......................................................................212
Problem..............................................................................................................................................212
Solution...............................................................................................................................................212
How it Works.......................................................................................................................................212
Recipe 10-4. Taking Advantage of Variable Scope.......................................................213
Problem..............................................................................................................................................213
Solution...............................................................................................................................................213
How it Works.......................................................................................................................................213
Recipe 10-5. Avoiding Global Variable Problems with Super Globals........................214
Problem..............................................................................................................................................214
Solution...............................................................................................................................................214
How it Works.......................................................................................................................................214
xix
CONTENTS
Recipe 10-6. Determining Variable Type......................................................................215
Problem..............................................................................................................................................215
Solution...............................................................................................................................................2^
How It Works.......................................................................................................................................2^
Recipe 10-7. Reducing Memory Use with References.................................................216
Problem..............................................................................................................................................216
Solution...............................................................................................................................................216
How it Works.......................................................................................................................................216
Recipe 10-8. Using Constants......................................................................................219
Problem..............................................................................................................................................219
Solution...............................................................................................................................................219
How it Works.......................................................................................................................................219
Recipe 10-9. Variable Variables....................................................................................220
Problem..............................................................................................................................................220
Solution...............................................................................................................................................220
How it Works.......................................................................................................................................220
Recipe 10-10. Comparing Variables.............................................................................221
Problem..............................................................................................................................................221
Solution...............................................................................................................................................221
How it Works.......................................................................................................................................222
Recipe 10-11. Working with Strings.............................................................................223
Problem..............................................................................................................................................223
Solution...............................................................................................................................................223
How it Works.......................................................................................................................................223
Recipe 10-12. Handling Floating Point Numbers.........................................................224
Problem..........................................................................................................................................................................................................................................................224
Solution....................................................................................................................................................................................................................................224
How it Works................................................................................................................................................................................................224
XX
¦ CONTENTS
Recipe 10-13. Special Language Constructs...............................................................225
Problem..............................................................................................................................................225
Solution...............................................................................................................................................225
How it Works.......................................................................................................................................225
Recipe 10-14. Iterating Over Array Values....................................................................228
Problem..............................................................................................................................................228
Solution...............................................................................................................................................228
How it Works.......................................................................................................................................229
Recipe 10-15. Generating Output.................................................................................229
Problem..............................................................................................................................................229
Solution...............................................................................................................................................229
How it Works.......................................................................................................................................230
¦Chapter 11: Functions.......................................................................................231
Recipe 11-1. Calling Functions....................................................................................231
Problem..............................................................................................................................................231
Solution...............................................................................................................................................231
How it Works.......................................................................................................................................232
Recipe 11-2. Variable Scope........................................................................................232
Problem..............................................................................................................................................232
Solution...............................................................................................................................................232
How it Works.......................................................................................................................................233
Recipe 11-3. Passing Parameters................................................................................234
Problem..............................................................................................................................................234
Solution...............................................................................................................................................234
How it Works.......................................................................................................................................234
Recipe 11-4. Optional Parameters...............................................................................236
Problem..............................................................................................................................................236
Solution...............................................................................................................................................236
How it Works.......................................................................................................................................236
xxi
I CONTENTS
Recipe 11-5. Type Declarations....................................................................................238
Problem..............................................................................................................................................£J0
Solution...............................................................................................................................................238
How it Works.......................................................................................................................................238
Recipe 11-6. Return Values..........................................................................................239
Problem..............................................................................................................................................239
Solution...............................................................................................................................................239
How it Works.......................................................................................................................................239
Recipe 11-7. Check if Function Exists..........................................................................241
Problem..............................................................................................................................................241
Solution...............................................................................................................................................241
How it Works.......................................................................................................................................241
Recipe 11-8. Calculated Function Names....................................................................242
Problem..............................................................................................................................................242
Solution...............................................................................................................................................242
How it Works.......................................................................................................................................242
Recipe 11-9. Anonymous Functions.............................................................................243
Problem..............................................................................................................................................243
Solution...............................................................................................................................................243
How it Works.......................................................................................................................................243
Recipe 11-10. Variable Parameter List.........................................................................246
Problem..............................................................................................................................................246
Solution...............................................................................................................................................246
How it Works.......................................................................................................................................246
¦Chapter 12: Web Fundamentals........................................................................249
Recipe 12-1. Headers...................................................................................................249
Problem....................................................................................................................................... 249
Solution................................................................................................................................................
How it Works..........................................................................................................................................................................................................................................250
xxii
II CONTENTS
Recipe 12-2. $_GET and $_POST.................................................................................250
Problem..............................................................................................................................................250
Solution...............................................................................................................................................251
How it Works.......................................................................................................................................251
Recipe 12-3. Cookies...................................................................................................253
Problem..............................................................................................................................................253
Solution...............................................................................................................................................253
How it Works.......................................................................................................................................254
Recipe 12-4. Server Variables......................................................................................255
Problem..............................................................................................................................................255
Solution...............................................................................................................................................255
How it Works.......................................................................................................................................255
Recipe 12-5. Session Data...........................................................................................257
Problem..............................................................................................................................................257
Solution...............................................................................................................................................257
How it Works.......................................................................................................................................258
Recipe 12-6. Content Type and Disposition..................................................................259
Problem..............................................................................................................................................259
Solution...............................................................................................................................................259
How it Works.......................................................................................................................................259
Recipe 12-7. Caching...................................................................................................261
Problem..............................................................................................................................................261
Solution...............................................................................................................................................261
How it Works.......................................................................................................................................261
Recipe 12-8. Remote Content......................................................................................262
Problem..............................................................................................................................................262
Solution...............................................................................................................................................262
How it Works.......................................................................................................................................263
xxiii
a CONTENTS
Recipe 12-9. The HTTPS Protocol.................................................................................265
Problem..............................................................................................................................................265
Solution...............................................................................................................................................2®®
How it Works.......................................................................................................................................265
Recipe 12-10. AJAX Requests......................................................................................266
Problem..............................................................................................................................................2®®
Solution...............................................................................................................................................2®
How it Works.......................................................................................................................................266
Recipe 12-11. Web Sockets.........................................................................................267
Problem..............................................................................................................................................267
Solution...............................................................................................................................................267
How it Works.......................................................................................................................................267
¦Chapter 13: Creating and Using Forms..............................................................271
Recipe 13-1. Form Elements........................................................................................271
Problem..............................................................................................................................................271
Solution...............................................................................................................................................271
How it Works.......................................................................................................................................274
Recipe 13-2. Default Values.........................................................................................276
Problem..............................................................................................................................................276
Solution...............................................................................................................................................276
How it Works.......................................................................................................................................277
Recipe 13-3. Form Validation.......................................................................................280
Problem..............................................................................................................................................280
Solution...............................................................................................................................................280
How it Works.......................................................................................................................................280
Recipe 13-4. Form Generation.....................................................................................283
Problem..............................................................................................................................................283
Solution..................................................................................................................................................
How it Works.........................................................................................................................................
xxiv
• CONTENTS
Recipe 13-5. File Upload..............................................................................................288
Problem..............................................................................................................................................288
Solution...............................................................................................................................................288
How it Works.......................................................................................................................................289
Recipe 13-6. Form Data...............................................................................................290
Problem..............................................................................................................................................290
Solution...............................................................................................................................................290
How it Works.......................................................................................................................................291
¦Chapter 14: XML, RSS, WDDX, and SOAP...........................................................293
Recipe 14-1. Exchanging Data with XML.....................................................................293
Problem..............................................................................................................................................293
Solution...............................................................................................................................................293
How it Works.......................................................................................................................................294
Recipe 14-2. Generating XML Response......................................................................300
Problem..............................................................................................................................................300
Solution...............................................................................................................................................300
How it Works.......................................................................................................................................300
Recipe 14-3. Sharing Data with RSS............................................................................303
Problem..............................................................................................................................................303
Solution...............................................................................................................................................304
How it Works.......................................................................................................................................304
Recipe 14-4. Consuming RSS Feeds............................................................................306
Problem..............................................................................................................................................306
Solution...............................................................................................................................................307
How it Works.......................................................................................................................................307
Recipe 14-5. Standard Data Exchange.........................................................................308
Problem..............................................................................................................................................308
Solution...............................................................................................................................................308
How it Works.......................................................................................................................................309
XXV
m CONTENTS
Recipe 14-6. SOAP Server and Client...........................................................................311
Problem..............................................................................................................................................311
Solution...............................................................................................................................................3^
How it Works.......................................................................................................................................3^
¦Chapter 15: Data Exchange with JSON..............................................................317
Recipe 15-1. Fetching Data with AJAX.........................................................................317
Problem..............................................................................................................................................317
Solution...............................................................................................................................................317
How it Works.......................................................................................................................................317
Recipe 15-2. Returning JSON.......................................................................................319
Problem..............................................................................................................................................319
Solution...............................................................................................................................................319
How it Works.......................................................................................................................................320
Recipe 15-3. Consuming a JSON API...........................................................................321
Problem..............................................................................................................................................321
Solution...............................................................................................................................................321
How it Works.......................................................................................................................................321
Recipe 15-4. JSON API.................................................................................................324
Problem.................................................................................................................................................
Solution..................................................................................................................................................
How it Works..........................................................................................................................................
Recipe 15-5. Calling API s...............................................................................................
Problem......................................................................................................................................... 327
Solution....................................................................................................................................................................................................................................................................327
How it Works.......................................................................................................................... 327
Recipe 15-6. API Authentication.......................................................................... 330
Problem..............................................................................................................................................330
Solution...............................................................................................................................................330
How it Works................................................................................................................................................................................................................................................330
xxvi
Ii CONTENTS
¦Chapter 16: Using MySQL Databases.................................................................333
Recipe 16-1. Connecting to MySQL..............................................................................333
Problem..............................................................................................................................................333
Solution...............................................................................................................................................333
How it Works.......................................................................................................................................334
Recipe 16-2. Persistent Connections...........................................................................337
Problem..............................................................................................................................................337
Solution...............................................................................................................................................337
How it Works.......................................................................................................................................338
Recipe 16-3. Fetching Data..........................................................................................338
Problem..............................................................................................................................................338
Solution...............................................................................................................................................339
How it Works.......................................................................................................................................339
Recipe 16-4. Inserting Data..........................................................................................341
Problem..............................................................................................................................................341
Solution...............................................................................................................................................341
How it Works.......................................................................................................................................341
Recipe 16-5. Updating Data.........................................................................................348
Problem..............................................................................................................................................348
Solution...............................................................................................................................................348
How it Works.......................................................................................................................................349
Recipe 16-6. Deleting Data..........................................................................................351
Problem..............................................................................................................................................351
Solution...............................................................................................................................................351
How it Works.......................................................................................................................................351
Recipe 16-7. Schema Information................................................................................355
Problem..............................................................................................................................................355
Solution...............................................................................................................................................355
How it Works.......................................................................................................................................356
Index.....................................................................................................................357
xxvii
|
| any_adam_object | 1 |
| author | Kromann, Frank M. |
| author_GND | (DE-588)110705057X |
| author_facet | Kromann, Frank M. |
| author_role | aut |
| author_sort | Kromann, Frank M. |
| author_variant | f m k fm fmk |
| building | Verbundindex |
| bvnumber | BV043665701 |
| classification_rvk | ST 250 ST 271 |
| ctrlnum | (OCoLC)953815058 (DE-599)BVBBV043665701 |
| dewey-full | 004 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 004 - Computer science |
| dewey-raw | 004 |
| dewey-search | 004 |
| dewey-sort | 14 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | Second edition |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01859nam a2200493zc 4500</leader><controlfield tag="001">BV043665701</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20161206 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">160712s2016 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484206065</subfield><subfield code="c">pbk.</subfield><subfield code="9">978-1-4842-0606-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)953815058</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043665701</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-11</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">004</subfield><subfield code="2">23</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">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kromann, Frank M.</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)110705057X</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PHP and MySQL recipes</subfield><subfield code="b">a problem-solution approach</subfield><subfield code="c">by Frank M. Kromann</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York, NY</subfield><subfield code="b">Apress</subfield><subfield code="c">[2016]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">© 2016</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xxxiii, 361 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="490" ind1="0" ind2=" "><subfield code="a">The expert's voice in web development</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer science</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer Science</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computer Science, general</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Informatik</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">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">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">PHP</subfield><subfield code="0">(DE-588)4546126-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><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=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-4842-0605-8</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=029078964&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-029078964</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></record></collection> |
| id | DE-604.BV043665701 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T07:31:57Z |
| institution | BVB |
| isbn | 9781484206065 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-029078964 |
| oclc_num | 953815058 |
| open_access_boolean | |
| owner | DE-11 |
| owner_facet | DE-11 |
| physical | xxxiii, 361 Seiten Illustrationen |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | Apress |
| record_format | marc |
| series2 | The expert's voice in web development |
| spelling | Kromann, Frank M. Verfasser (DE-588)110705057X aut PHP and MySQL recipes a problem-solution approach by Frank M. Kromann Second edition New York, NY Apress [2016] © 2016 xxxiii, 361 Seiten Illustrationen txt rdacontent n rdamedia nc rdacarrier The expert's voice in web development Computer science Computer Science Computer Science, general Informatik MySQL (DE-588)4559381-4 gnd rswk-swf PHP (DE-588)4546126-0 gnd rswk-swf Informatik (DE-588)4026894-9 gnd rswk-swf Informatik (DE-588)4026894-9 s PHP (DE-588)4546126-0 s MySQL (DE-588)4559381-4 s 1\p DE-604 Erscheint auch als Online-Ausgabe 978-1-4842-0605-8 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029078964&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 |
| spellingShingle | Kromann, Frank M. PHP and MySQL recipes a problem-solution approach Computer science Computer Science Computer Science, general Informatik MySQL (DE-588)4559381-4 gnd PHP (DE-588)4546126-0 gnd Informatik (DE-588)4026894-9 gnd |
| subject_GND | (DE-588)4559381-4 (DE-588)4546126-0 (DE-588)4026894-9 |
| title | PHP and MySQL recipes a problem-solution approach |
| title_auth | PHP and MySQL recipes a problem-solution approach |
| title_exact_search | PHP and MySQL recipes a problem-solution approach |
| title_full | PHP and MySQL recipes a problem-solution approach by Frank M. Kromann |
| title_fullStr | PHP and MySQL recipes a problem-solution approach by Frank M. Kromann |
| title_full_unstemmed | PHP and MySQL recipes a problem-solution approach by Frank M. Kromann |
| title_short | PHP and MySQL recipes |
| title_sort | php and mysql recipes a problem solution approach |
| title_sub | a problem-solution approach |
| topic | Computer science Computer Science Computer Science, general Informatik MySQL (DE-588)4559381-4 gnd PHP (DE-588)4546126-0 gnd Informatik (DE-588)4026894-9 gnd |
| topic_facet | Computer science Computer Science Computer Science, general Informatik MySQL PHP |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=029078964&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT kromannfrankm phpandmysqlrecipesaproblemsolutionapproach |