Gliederung des Textes:

WebDB - From Website to Database. Using HTML, PHP, and MySQL

1 Introduction

1.1 Invoices Database

1.2 Typographic Conventions for Model Elements

2 Establishing a Connection and First Queries

2.1 MySQLi vs. PDO

2.2 CustomerQueriesMySQLi_1.php

2.3 CustomerQueriesMySQLi_2.php

2.4 CustomerQueriesPDO_1.php

2.5 CustomerQueriesPDO_2.php

3 Inserting Data

3.1 InsertCustomerMySQLi

3.2 SaveInvoiceMySQLi

3.3 InsertCustomerPDO.php

3.4 SaveInvoicePDO.php

4 Deleting Data

4.1 DeleteCustomerMySQLi.php

4.2 DeleteInvoiceMySQLi.php

4.3 DeleteCustomerPDO.php

4.4 DeleteInvoicePDO.php

5 Modifying Data

5.1 UpdateCustomerMySQLi.php

5.2 UpdateCustomerPDO.php

6 Overview of CRUD Operations

6.1 CRUD Overview with PDO

6.2 CRUD Overview with MySQLi

7 Invoice Management

7.1 Main Menu

7.2 Start Page

7.3 Enter Invoices

7.4 Display Entire Database

7.5 Displaying an Invoice

7.6 Invoices.css

8 Quick Overview

8.1 MySQLi

8.2 PDO

8.3 A Direct Comparison

9 Interaction Between HTML and PHP

9.1 Tasks

9.2 Interaction

9.3 Basic Rules

10 Glossary

11 Appendix

11.1 From the Web to the Database

11.2 HTML Special Characters

11.3 Prepared Statements

11.4 Exceptions and Error Handling with PDO

11.5 Variable $con

11.6 Array of arrays

11.7 mysqli Class

11.8 Referencing

11.9 isset()

11.10 The Null Coalescing Operator

11.11 Joins