PHP & MySQL
If you can build websites with CSS and JavaScript, this book takes you to the next level-creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world e...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly Media
2011.
|
| Edición: | 1st ed |
| Colección: | Missing manual.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628225506719 |
Tabla de Contenidos:
- The Missing Credits; Introduction; Part One:PHP and MySQL Basics; Chapter 1:PHP: What, Why, and Where?; Gathering Your Tools; Writing Your First Program; Running Your First Program; Writing Your Second Program; Upload Your HTML, CSS, and PHP; Running Your Second Program; Chapter 2:PHP Syntax: Weird and Wonderful; Get Information from a Web Form; Working with Text in PHP; The _REQUEST Variable; What Do You Do with User Information?; Chapter 3:MySQL and SQL: Database and Language; What Is a Database?; Installing MySQL; SQL Is a Language for Talking to Databases; Part Two:Dynamic Web Pages
- Chapter 4:Connecting PHP to MySQLWriting a Simple PHP Connection Script; Cleaning Up Your Code with Multiple Files; Building a Basic SQL Query Runner; Chapter 5:Better Searching with Regular Expressions; String Matching, Double-Time; Chapter 6:Generating Dynamic Web Pages; Revisiting a User's Information; Planning Your Database Tables; Saving a User's Information; Show Me the User; Redirection and Revisitation of Creating Users; Part Three:From Web Pages to Web Applications; Chapter 7:When Things Go Wrong (and They Will); Planning Your Error Pages
- Finding a Middle Ground for Error Pages with PHPAdd Debugging to Your Application; Redirecting on Error; Chapter 8:Handling Images and Complexity; Images Are Just Files; Images Are For Viewing; And Now for Something Completely Different; Chapter 9:Binary Objects and Image Loading; Storing Different Objects in Different Tables; Inserting a Raw Image into a Table; Your Binary Data Isn't Safe to Insert...Yet; Connecting Users and Images; Show Me the Image; Embedding an Image Is Just Viewing an Image; So Which Approach is Best?; Chapter 10:Listing, Iterating, and Administrating
- Some Things Never ChangeListing All Your Users; Deleting a User; Talking Back To Your Users; Standardizing on Messaging; Integrating Utilities, Views, and Messages; Part Four:Security and the Real World; Chapter 11:Authentication and Authorization; Start with Basic Authentication; Abstracting What's the Same; Passwords Don't Belong in PHP Scripts; Passwords Create Security, But Should Be Secure; Chapter 12:Cookies, Sign-ins, and Ditching Crummy Pop-ups; Going Beyond Basic Authentication; Logging In with Cookies; Adding Context-Specific Menus; Chapter 13:Authorization and Sessions
- Modeling Groups in Your DatabaseChecking for Group Membership; Group-Specific Menus; Entering Browser Sessions; Memory Lane: Remember that Phishing Problem?; So Why Ever Use Cookies?; Index
