About Courses Programs Contact Log in Sign up

Home›PHP›7 - Preparing our database

🎬

Video not available

7 - Preparing our database

Back End DevelopmentLesson⏱ 2m16

Next chapter →☰ Syllabus ← Previous

Chapters

88 lessons

00 - Introduction

00 - PHP syntax

01 - Output statements

03 - PHP & HTML

05 - Concatenation

06 - Single vs double quotes

08 - Arithmetic operators

09 - Comparison operators

10 - Logical operators

11 - IF - ELSE IF - ELSE conditions

12 - Ternary conditions

13 - The SWITCH condition

14 - The FOR loop

15 - The WHILE loop

16 - Practical exercise - building an HTML table using loops

18 - The foreach loop

19 - Customizing array indexes

20 - Multidimensional arrays

21 - Built-in functions

22 - User-defined functions

23 - Exercise - mixing HTML & PHP - introduction

23 - Exercise - mixing HTML & PHP - solution

24 - File inclusions

1 - Creating classes

2 - Creating an object from a class

3 - Creating several objects of the same type

4 - The this operator

Practical exercise - Managing a site's structure with file inclusions

1 - Adding and understanding the role of URL parameters

2 - Passing data from page A to page B

3 - Understanding the HTML attributes - method - action - in a form

4 - Practical exercise

1 - Introduction

2 - Working with the $_POST superglobal

3 - Inserting submitted data into a text file

4 - Validating fields with $_POST

1 - Validating all the fields of a form the simple way

2 - Handling file uploads with $_FILES

3 - Handling error and validation messages

4 - Making the file upload optional

1 - Understanding cookies

2 - Choosing a language on a website and saving preferences in a cookie

3 - Creating - deleting - updating

1 - Understanding the role of a session

2 - Creating a login form with session creation and population

3 - Creating a logout link that deletes the session

4 - Finishing touches

1 - Introduction to the PDO object

2 - Instantiating a PDO object

3 - Creating our database with PhpMyAdmin

4 - Testing the database connection

5 - Discovering the methods of the PDO object

6 - Understanding the database configuration

7 - Preparing our database

1 - Our first SQL query

2 - Fixing the connection problem

3 - Inspecting the PDOSTATEMENT object

4 - Other useful methods

5 - The FETCH method for retrieving data

6 - Configuring the FETCH method

7 - Going further with the FETCH method

8 - Looping through all the data with the FETCH method

9 - Introduction to the FETCHALL method

10 - Dynamically displaying the columns of the employees table in an HTML table

11 - Dynamically populating an HTML table

12 - Looping through data with FETCHALL

1 - Introduction to the exec() method

2 - Inserting data with the exec() method

3 - Updating data with the exec() method

4 - Handling an SQL syntax error

1 - Introduction to the prepare() and execute() methods

2 - Retrieving employees with conditions

3 - The benefit of prepare() and execute() in action

4 - Optimizing my query parameters

5 - Binding a PHP variable to a named or question-mark placeholder

1 - Introduction to transactions

2 - Understanding transactions and their benefits

1 - Introduction to the exercise

2 - Solution and explanation

1 - Retrieving errors through a PDOSTATEMENT object

2 - Retrieving errors through a PDO object