This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:web_development:databases:php [2021/12/24 12:54] mag |
en:web_development:databases:php [2023/08/16 09:33] (current) |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| include(' | include(' | ||
| ?></ | ?></ | ||
| + | |||
| + | ==== Objects ==== | ||
| + | * Objects are an advanced data structure and we won't go into it too much here, but you'll need to understand a little bit to use the PHP database connection in this actviity. | ||
| + | * An object is like a named array where you can access each element by name. | ||
| + | * But an object also has functions built into. Recall that in Javascript, < | ||
| + | * Similarly, in PHP, an object can have both data and functions. For example, a database connection object can have information about the connection and also have functions to extract data. | ||
| + | * Whereas you access the information in an array using < | ||
| + | * To use an abstract example, we could create an object called $table. | ||
| + | * We could set the number of legs on the table as follows. | ||
| + | < | ||
| + | * We could also move the table to another location as follows. | ||
| + | < | ||
| + | * There is a whole school of programming based on objects (Object-oriented programming) and objects could be the subject of many classes, but this is all you need to know to use the database connection. | ||
| ==== PDO Connection ==== | ==== PDO Connection ==== | ||
| Line 22: | Line 35: | ||
| * Copy the following code at the top of the first PHP block. | * Copy the following code at the top of the first PHP block. | ||
| < | < | ||
| - | define (' | + | define (' |
| include_once DBCONNECT; | include_once DBCONNECT; | ||
| - | $db = 'webdev'; | + | $db = 'techschoolwebdev'; |
| $dsn = " | $dsn = " | ||
| try | try | ||