Web database applications with PHP and MySQL
There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dyna...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2004.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626901006719 |
Tabla de Contenidos:
- Table of Contents; Preface; What This Book Is About; What You Need to Know; How This Book Is Organized; How to Use This Book; Conventions Used in This Book; Using Code Examples; How to Contact Us; Web Site and Code Examples; Acknowledgments; Database Applications and the Web; The Web; Three-Tier Architectures; HTTP: the Hypertext Transfer Protocol; HTTP example; State; Thickening the Client in the Three-Tier Model; The Middle Tier; Web servers; Web Scripting with PHP; Introducing PHP5; The Database Tier; Database Management Systems; SQL; Why use a database server?
- Examples of when to use a database serverExamples of when not to use a DBMS; The MySQL server; Introducing MySQL 4; The PHP Scripting Language; Introducing PHP; PHP Basics; Creating PHP scripts; Comments; Outputting data with echo and print; String Literals; Variable substitution; Character encoding; Variables; Types; Constants; Expressions, Operators, and Variable Assignment; Operator precedence; Conditions and Branches; if...else Statement; switch Statement; Conditional Expressions; Loops; while; do...while; for; Changing Loop Behavior; Functions; Working with Types; Type Conversion
- Automatic Type ConversionExamining Variable Type and Content; Is-identical and is-not-identical operators; Debugging with gettype(), print_r(), and var_dump(); Testing, setting, and unsetting variables; User-Defined Functions; Parameter Types and Return Types; Variable Scope; Global variables; Static variables; Passing Variables to Functions; Passing parameters by reference; Assigning by reference; Default parameter values; Reusing Functions with Include and Require Files; Managing include files; A Working Example; Arrays, Strings, and Advanced Data Manipulation in PHP; Arrays
- Creating ArraysAssociative arrays; Removing elements from an array; Array order; Heterogeneous arrays; Multidimensional arrays; Using foreach Loops with Arrays; Basic Array Functions; Counting elements in arrays; Functions that create arrays; Exploding and imploding strings; Finding the maximum and minimum values in an array; Finding values in arrays with in_array() and array_search(); Keys and values; Joining two or more arrays; Reordering elements with array_reverse(); Sorting Arrays; Sorting with sort() and rsort(); Sorting associative arrays; Sorting on keys
- Sorting with user-defined element comparisonStrings; Length of a String; Printing and Formatting Strings; Creating formatted output with sprintf() and printf(); Padding strings; Changing case; Trimming whitespace; Comparing Strings; Finding and Extracting Substrings; Extracting a substring from a string; Finding the position of a substring; Extracting a found portion of a string; Replacing Characters and Substrings; Replacing substrings; Translating characters and substrings; Regular Expressions; Regular Expression Syntax; Characters and wildcards; Character lists; Anchors
- Optional and repeating characters
