Lessons: 33Length: 4.8 hours
- Overview
- Transcript
10.3 Updating Data
Next, we need the ability to update a post. We'll read an existing post from the database and use it to populate an edit form. Then we'll validate the form input before updating the post in the database. In this lesson, I'll also introduce you to the concept of SQL injection attacks, and you'll learn how to avoid them to make your applications more secure.
1.Introduction
1.1Introduction01:51
1.1
Introduction
01:51
1.2What You Need04:34
1.2
What You Need
04:34
2.How the Web Works
2.1Networks and DNS09:20
2.1
Networks and DNS
09:20
2.2HTTP and the Web Server06:43
2.2
HTTP and the Web Server
06:43
3.Creating Documents
3.1Marking Up a Document09:38
3.1
Marking Up a Document
09:38
3.2Making Our Document Valid06:22
3.2
Making Our Document Valid
06:22
3.3Semantic and Generic Elements11:13
3.3
Semantic and Generic Elements
11:13
4.Styling Documents
4.1Adding Style08:17
4.1
Adding Style
08:17
4.2CSS Selectors16:15
4.2
CSS Selectors
16:15
4.3Modifying Layout09:35
4.3
Modifying Layout
09:35
5.Scripting Documents
5.1Variables and Functions09:06
5.1
Variables and Functions
09:06
5.2Writing Your Own Functions05:34
5.2
Writing Your Own Functions
05:34
5.3Objects07:56
5.3
Objects
07:56
6.The Document Object Model
6.1DOM Basics08:58
6.1
DOM Basics
08:58
6.2Finding Elements07:40
6.2
Finding Elements
07:40
6.3Working With `NodeLists`04:30
6.3
Working With `NodeLists`
04:30
6.4Manipulating an Element's CSS Classes04:29
6.4
Manipulating an Element's CSS Classes
04:29
6.5Listening for Events08:42
6.5
Listening for Events
08:42
6.6Practicing the Concepts08:26
6.6
Practicing the Concepts
08:26
7.HTTP Requests With JavaScript
7.1The fetch() API09:16
7.1
The fetch() API
09:16
8.Introduction to Server-Side Development
8.1Introduction to Server-Side Development10:31
8.1
Introduction to Server-Side Development
10:31
8.2Your First Line of PHP Code06:57
8.2
Your First Line of PHP Code
06:57
8.3Functions and Variables08:00
8.3
Functions and Variables
08:00
8.4Parameters and Decisions08:13
8.4
Parameters and Decisions
08:13
8.5Getting Data From the User09:43
8.5
Getting Data From the User
09:43
9.Getting Started With Databases
9.1Create a Users Table12:00
9.1
Create a Users Table
12:00
9.2Create a Posts Table10:20
9.2
Create a Posts Table
10:20
9.3Inserting Data08:41
9.3
Inserting Data
08:41
10.Using PHP to Interact With MySQL
10.1Reading and Displaying Data12:34
10.1
Reading and Displaying Data
12:34
10.2Passing and Validating Data11:58
10.2
Passing and Validating Data
11:58
10.3Updating Data14:52
10.3
Updating Data
14:52
10.4Joining Data (And Deleting Posts)12:35
10.4
Joining Data (And Deleting Posts)
12:35
11.Conclusion
11.1Conclusion01:47
11.1
Conclusion
01:47
