Matthew M.

Matthew M.

SQL Command: INSERT

Slide Duration:

Table of Contents

Section 1: Advanced PHP with MySQL
Course Introduction

13m 36s

Intro
0:00
Advanced PHP w/ MySQL
0:13
Course Introduction
0:14
Course Content
0:59
Web Application: Educator Store
1:45
Web Application: Educator Store
1:46
Object-Oriented Programming
6:09
Object-Oriented Programming Overview
6:10
MySQL
6:50
MySQL Overview
6:51
Example: Command Prompt & MySQL
8:34
What You Will Learn
9:34
What You Will Learn
9:35
Course Prerequisites
11:52
Course Prerequisites
11:53
Advanced Course Development Environment

18m 46s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
Development Environment Setup
1:36
Firefox Web Browser, XAMPP, and PSPad Text Editor
1:37
Course Directory Structure
4:36
Course Directory Structure
4:37
phpDocumentor
7:23
phpDocumentor Overview
7:24
Parsing Source Code
7:44
docs Subdirectory
9:06
Asvanced PHP Course Documentation Example
10:21
Previous Educator PHP Students
14:14
Lib Directory Changes
14:38
Images Directory Changes
14:57
VERSION Constant
15:40
Comments Noting a Specific Version Number
17:04
Homework Challenge
17:30
Homework Challenge
17:31
Introduction to File I/O

35m 37s

Intro
0:00
Lesson Overview
0:10
Lesson Overview
0:11
File I/O
1:34
File I/O Overview
1:35
Performing file I/O: 3 Steps
1:52
File Permissions
2:28
Read Permission & Write Permission
2:29
fopen()
4:47
fopen()
4:48
Two Required Parameters
5:01
Successful fopen(): File Handle and Resource
5:21
FALSE and E_WARNING Error
6:00
Example
6:39
File Paths
7:10
File Paths
7:11
File Access Modes
9:18
File Access Modes
9:19
Coding Example: fopen()
10:31
Using Relative and Absolute Path & Non-Existent File
10:32
File Pointers
15:55
File Pointers
15:56
Example File
16:11
Opening a File with fopen() Using 'r' as the Access Mode
16:22
fgets()
17:55
fgets() Overview
17:56
Coding Example: fgets() - Reading a Line at a Time
18:26
feof()
20:10
feof() Overview
20:09
Coding Example: feof()
20:50
fclose()
23:43
fclose() Overview
23:44
Coding Example: fclose()
25:02
Coding Example: Current Stock
26:10
Coding Example: Current Stock
26:11
trim ()
31:39
trim () Overview and Example
31:40
Homework Challenge
33:35
Homework Challenge
33:36
Web Application Development

36m 36s

Intro
0:00
Lesson Overview
0:16
Lesson Overview
0:17
Version 1.0 Changelog
0:31
catalog.php
0:32
Function Library: fileLIB.php
5:00
Version 1.1 Changelog
27:12
createItemDataArray() and createDeptDataArray()
27:13
outputSimpleItemLink() and outputSimpleDeptLink()
32:06
HTTP & the POST Method

34m 36s

Intro
0:00
Lesson Overview
0:10
Lesson Overview
0:11
HTTP Model
1:28
HTTP Model
1:29
Client-Server Model 2 Steps Process
2:00
HTTP Messages
2:23
HTTP Messages
2:24
HTTP Requests
3:09
HTTP Requests
3:10
Example: HTTP Request Header
3:17
Coding Example: HTTP Requests
4:29
HTTP Responses
7:15
HTTP Responses
7:16
Example: HTTP Response (Header & Body)
8:00
header()
11:47
header() Overview
11:48
Coding Example: header
14:02
Coding Example: header() Error
14:52
GET Method
18:55
GET Method
18:56
Coding Example: GET Method
20:13
POST Method
21:09
POST Method
21:10
Coding Example: Sample Form Using the POST Method
23:50
Accessing POST Data in PHP
26:38
Accessing POST Data in PHP
26:39
Coding Example: Accessing POST Data via $_POST
28:15
GET vs. POST
29:54
GET vs. POST
29:55
Example: Accessing POST Data via $_POST
31:20
Example: Accessing POST Data via $_POST
31:21
Homework Challenge
33:00
Homework Challenge
33:01
Web Application Development

14m 11s

Intro
0:00
Version 2.0 Changelog
0:09
Updating the Site's Current Form to Use the POST Method
0:10
Creating Admin Website
2:55
Dynamically Generated Department List
12:40
Writing to Files

17m 38s

Intro
0:00
Lesson Overview
0:09
Lesson Overview
0:10
Review of File I/O
0:40
Review of File I/O
0:41
fwrite()
1:38
fwrite()
1:39
fputs()
2:20
'r+'
2:31
Coding Example: fwrite()
2:59
fopen() Access Modes
8:41
'a' and 'a+'
8:42
'w' and 'w+'
11:34
Homework Challenge
14:47
Homework Challenge
14:48
Web Application Development

28m 14s

Intro
0:00
Lesson Overview
0:08
Lesson Overview
0:09
Updated Open File Functions
0:19
openItemsDataFile ( ), openDeptsDataFile ( ), and openLastAddedFile ( )
0:20
insertItem()
6:25
insertItem() Overview
6:26
Functions: createItemDataString ( ) and updateLastItemAdded ( )
7:07
addItemToDepartment ()
16:03
addItemToDepartment () Overview
16:04
Functions: createDeptDataString ( ) and updateDepartment ( )
17:55
HTTP POST: File Uploads

22m 51s

Intro
0:00
Lesson Overview
0:10
Lesson Overview
0:11
POST Data Encoding
1:13
POST Data Encoding
1:14
When Data is Included in the Body of the HTTP POST Request and is of the Content Type
1:31
When Uploading Files Using HTTP POST
3:17
Uploading Files
6:22
Uploading Files
6:23
If Encoding Type is Not Set to Multipart/Formdata
9:27
$_FILES Superglobal
10:59
$_FILES Superglobal
11:00
Structure of $_FILES
12:15
Structure of $_FILES: Name, Type, tmp_name, Error, and Size
12:16
Coding Example: $_FILES Superglobal
13:34
Moving an Uploaded File
15:39
Introduction to Moving an Uploaded File
15:40
move_uploaded_file ( ): Definition and Example
16:40
Homework Challenge
21:19
Homework Challenge
21:20
Web Application Development

15m 30s

Intro
0:00
Lesson Overview
0:09
Lesson Overview
0:10
Uploading Item Image File
1:22
Uploading Item Image File
1:23
Uploading Item Image File (cont.)
2:43
Altering insertItem ( )
2:44
Helpfer Functions: getFileExtension ( ) and moveUploadedFile ( )
4:30
isValidItem ( )
13:03
Introduction to Object-Oriented Programming

32m 44s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
Object-Oriented Programming
0:56
Introduction to Object-Oriented Programming
0:57
Associative Arrays
5:27
Associative Arrays
5:28
Classes
7:27
Classes Overview
7:28
Defining Classes
8:24
Defining Classes
8:25
Declaring Class Properties
9:25
Coding Example: Classes
10:11
Objects
12:18
Objects Overview
12:19
Classes vs. Objects
12:49
Classes vs. Objects
12:50
Instantiating Classes
14:58
Instantiating Classes
14:59
Coding Example: Instantiate an Item Object
16:30
Object Properties
19:21
Access and Set an Object's Property
19:22
Coding Example: Set & Access the Properties of an Item Object
24:23
Homework Challenge
30:22
Homework Challenge
30:23
Web Application Development

17m 47s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
Version 5.0 Overview
0:50
Version 5.0 Overview and Examples
0:51
Outputting Object Properties
12:38
Outputting Object Properties
12:39
Array Object Properties
14:18
Access and Set Array Value
14:19
Object Methods

39m 57s

Intro
0:00
Lesson Overview
0:12
Lesson Overview
0:13
Object Methods
0:52
Definition of Object Methods
0:53
Calling Object Methods
3:25
Calling Object Methods
3:26
Coding Example: Simple Object Methods
4:44
Object Methods and Return Values
7:02
$this Variable
10:06
$this Variable: Definition and Example
10:07
$this Variable (cont.)
15:51
$this Variable (cont.)
15:52
Getters & Setters
21:21
Getters & Setters Methods
21:22
Object Methods In Strings
25:46
Object Methods In Strings
25:47
Coding Example: Outputting Method Return Values in Strings
27:41
Using $this to Call Other Methods
28:49
Using $this to Call Other Methods
28:50
Homework Challenge
34:18
Homework Challenge: 1-3
34:19
Homework Challenge (cont.)
36:20
Homework Challenge: 4-6
36:21
Homework Challenge (cont.)
37:52
Homework Challenge: 7-10
37:53
Web Application Development

17m 30s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
Version 6.0 Overview
0:40
Version 6.0 Changes & Examples
0:41
Item Methods
0:53
Item Class Definition: getImageFilename()
0:54
Coding Example: getImageFilename()
1:58
Department Methods
7:33
addItem(), removeItem(), and isItemInDept() Method
7:34
addItemtToDepartment() & buildDeptObject() Functions
11:46
A Default Value Needed to Be Set for $items
16:26
Object Constructors

22m 20s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
Object Constructors
0:32
Introduction to Object Constructors
0:33
Coding Example: Object Constructors
1:43
Defining Constructors
3:26
Defining Constructors
3:27
Coding Example: Constructors with No Arguments
4:24
Constructor Arguments
8:09
Constructor Arguments
8:10
Coding Example: Constructor Arguments
9:49
Important Notes
16:13
Important Notes
16:14
Homework Challenge
17:35
Homework Challenge: 1 - 4
17:36
Homework Challenge (cont.)
19:13
Homework Challenge: 5 - 9
19:14
Homework Challenge (cont.)
21:40
Homework Challenge: 10 and 11
21:41
Web Application Development

16m 19s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
Version 7.0 Overview
0:39
Version 7.0 Overview
0:40
Item Constructor
2:19
Item Constructor
2:20
Department Constructor
7:47
Department Constructor
7:48
Customer Constructor
12:23
Customer Constructor
12:24
More Magic Methods

53m 37s

Intro
0:00
Lesson Overview
0:13
Lesson Overview
0:14
Magic Methods
1:12
Magic Methods
1:13
Destructors
2:45
Destructors Overview
2:46
Coding Example: Calling Destructors
4:30
Coding Example: Object Destructor
9:19
_to String ()
16:12
_to String () Overview
16:13
Coding Example: _to String () Magic Method
18:10
Access Modifiers
21:23
Introduction to Access Modifiers
21:24
Access Modifiers: Public
21:39
Access Modifiers: Private
22:18
Access Modifiers: Protected
22:41
Object Properties and Methods
23:06
Coding Example: Public Access Modifiers
26:48
Coding Example: Private Access Modifiers
28:30
_get()
31:37
_get() Overview
31:38
Coding Example: _get () Magic Method
33:30
_set ()
36:23
_set () & the Magic Method
36:24
Using Getters & Setters
44:37
Coding Example: Using Getters & Setters
44:38
Homework Challenge
50:33
Homework Challenge: 1 - 6
50:34
Homework Challenge (cont.)
51:41
Homework Challenge: 7 - 12
51:42
Web Application Development

31m 12s

Intro
0:00
Version 8.0 Review
0:12
Version 8.0 Review
0:13
private Object Properties
1:15
private Object Properties
1:16
Coding Example
2:54
_toString() Methods
6:51
_toString() Methods
6:52
Coding Example
8:09
DataFile Class
13:27
DataFile Class & I/O Operations
13:28
Using DataFile Class: Instantiate a DataFile, DataFile open () Method, and DataFile close () Method
18:09
Homework Challenge
29:35
Homework Challenge
29:36
Classes vs. Objects

37m 49s

Intro
0:00
Lesson Overview
0:09
Lesson Overview
0:10
Class vs. Object Review
0:58
Class vs. Object Review
0:59
Static Properties
2:42
Static Properties
2:43
Scope Resolution Operator (::)
5:26
Scope Resolution Operator (::) & Static Property
5:27
Coding Example: Accessing a Static Property Using the Scope Resolution Operator
7:57
Coding Example: Accessing a Static Property in a Class Definition
10:33
Coding Example: Using a Static Property as an Instance Counter
14:18
Static Methods
18:51
Static Methods Overview
18:52
Coding Example: Static Methods
21:39
Classes vs. Objects
26:28
Classes vs. Objects: Diagrams
26:29
Class Constants
30:24
Class Constants Definition
30:25
Coding Example: Using Class Constants
31:55
Homework Challenge
34:01
Homework Challenge: 1 - 5
34:02
Homework Challenge (cont.)
35:25
Homework Challenge: 6 - 10
35:26
Web Application Development

21m 7s

Intro
0:00
Version 9.0 Overview
0:12
Version 9.0 Changes & Examples
0:13
Output Class
1:08
Output Class & Static Methods
1:09
outputHtmlSelector ( ) Method
2:43
outputItemSelector ( ) Method
4:53
outputDeptSelector ( ) Method
6:42
buildObject() Methods
11:54
buildObject() Methods & Examples
11:55
Exceptions

22m 43s

Intro
0:00
Lesson Overview
0:12
Lesson Overview
0:13
try Blocks
0:44
try Blocks Definition
0:45
catch Blocks
2:03
catch Blocks: Definition and Syntax
2:04
Coding Example: try/catch Blocks
3:48
When an Exception Object is Caught & Error Handling
5:59
Exception Class
7:02
Exception Class
7:03
Coding Example: Using try/catch to Catch an Exception Thrown from a Method
8:04
Re-Throwing Exceptions
16:39
Re-Throwing Exceptions
16:40
Coding Example: Re-throwing an Exception
17:21
Homework Challenge
20:40
Homework Challenge: 1 - 5
20:41
Homework Challenge (cont.)
22:17
Homework Challenge: 6
22:18
Web Application Development

22m

Intro
0:00
Version 10.0 Overview
0:11
Updating addItem.php, addItemToDept.php, and error.php
0:12
Updating DataFile Class: open ( ) Method & try/catch blocks
7:45
Version 10.1 Overview
13:37
Version 10.1 Changes & Examples
13:38
Updating DataFile Class: close ( ) Method & logWarning ( )
20:17
Cookies

39m 47s

Intro
0:00
Lesson Overview
0:09
Lesson Overview
0:10
What is a Cookie?
1:15
Definition of Cookie
1:16
HTTP - A Stateless Protocol
2:17
HTTP - A Stateless Protocol
2:18
Purpose of Cookies
4:10
Set - Cookie Header
6:21
Introduction to Set - Cookie Header
6:22
Coding Example: Set - Cookie Header
7:38
Cookie Header
9:45
Introduction to Cookie Header
9:46
Example: Cookie Header
10:27
setcookie()
12:33
Introduction to setcookie()
12:34
Example: Using setcookie
13:54
Cookies Attributes
15:48
Cookies Attributes Overview
15:49
Common Cookies Attributes: Domain
16:24
Common Cookies Attributes: Path
17:04
Common Cookies Attributes: Expires
19:34
Coding Example: Setting Cookie Attributes
20:58
$_COOKIE Superglobal
27:03
$_COOKIE Superglobal
27:04
Coding Example: Accessing Cookies from PHP Using $_COOKIE
29:45
Security Implications
34:44
Security Implications
34:45
Homework Challenge
36:10
Homework Challenge: 1 - 4
36:11
Homework Challenge (cont.)
37:47
Homework Challenge: 5 - 7
37:48
Web Application Development

39m 11s

Intro
0:00
Lesson Overview
0:17
Lesson Overview
0:18
instanceof Operator
1:34
instanceof Operator
1:35
Objects with Object Properties
2:53
Objects with Object Properties
2:54
Version 11.0 Overview
6:41
Version 11.0 Changes: Cart and CartItem Classes
6:42
Version 11.0 Coding Example
10:40
Version 11.1 Overview
31:03
Version 11.1 Changes & Examples
31:04
Introduction to Sessions

46m 8s

Intro
0:00
Lesson Overview
0:08
Lesson Overview
0:09
What is a Session?
0:53
What is a Session?
0:54
Client-Side Sessions
3:51
Client-Side Sessions
3:52
Server-Side Sessions
5:04
Server-Side Sessions
5:05
Session IDs
6:26
Session IDs
6:27
The SID is Used by the Server to:
7:08
A Client Passes an SID to the Server with Each HTTP Request Via:
8:15
Sessions in PHP
12:19
Sessions in PHP
12:20
session_start()
14:40
session_start() Overview
14:41
Coding Example: Using session_start () to Continue a Session
18:03
$_SESSION Superglobal
22:06
$_SESSION Superglobal Overview
22:07
Coding Example: Setting a Session Variable via $_SESSION
25:22
Accessing Session Data
28:08
Accessing Session Data
28:09
Deleting Session Data
31:43
Deleting Session Data
31:44
Coding Example: Deleting Session Data
32:16
Configuring PHP Sessions
36:14
session.cookie_lifetime, session.cookie_domain, and session.cookie_path
36:15
Coding Example: Configuring PHP Sessions
37:28
Configuring PHP Sessions (cont.)
40:56
session.use_cookies, session.use_trans_sid, and session.use_only_cookies
40:57
Coding Example: Configuring PHP Sessions
42:25
Homework Challenge
42:55
Homework Challenge: 1 - 5
42:56
Homework Challenge (cont.)
44:10
Homework Challenge: 6 - 10
44:11
Homework Challenge (cont.)
45:27
Homework Challenge: 11 - 13
45:28
Web Application Development

11m

Intro
0:00
Version 12.0 Overview
0:12
Version 12.0 Changes Part I: Updating 'viewCart.php' & 'checkout.php'
0:13
Version 12.0 Changes Part II
5:03
Destroying Sessions

29m 59s

Intro
0:00
Lesson Overview
0:12
Lesson Overview
0:13
Destroying Sessions
1:02
Destroying Sessions
1:03
session_destroy()
2:10
session_destroy() Overview
2:11
Coding Example: Setting a Session Variable and Destroying a Session
3:18
Deleting Session Cookies
8:38
Deleting Session Cookies
8:39
Coding example: Deleting Session Cookies
9:17
Review of Steps
21:07
Review of Steps
21:08
Garbage Collection
21:50
Garbage Collection Overview
21:51
Coding Example: Garbage Collection
24:30
Homework Challenge
26:28
Homework Challenge: 1 - 4
26:29
Homework Challenge (cont.)
28:16
Homework Challenge: 5 - 9
28:17
Web Application Development

19m 14s

Intro
0:00
Lesson Overview
0:13
Lesson Overview
0:14
_autoload()
0:46
Introduction to _autoload ()
0:47
Version 13.0 Overview
4:06
_autoload () and SessionManager Class
4:07
Updating 'viewCart.php' & 'checkout.php'
11:16
Introduction to Databases

21m 24s

Intro
0:00
Lesson Overview
0:16
Lesson Overview
0:17
Flat Files
1:09
Flat Files: Definition and Example
1:10
Problems Associated with Using Flat Files as a Database
2:15
Relational Databases
3:29
Relational Databases
3:30
Relational Database Management System (RDBMS)
3:50
Tables
7:43
Tables
7:44
Columns
9:24
Columns
9:25
What is SQL?
10:45
Introduction to Structured Query Language
10:46
Standard Data Types of SQL
12:23
Primary Keys
13:19
Primary Keys
13:20
Primary Key Examples
16:36
Primary Key Examples
16:37
Introduction to MySQL

28m 11s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
What is MySQL?
1:33
MySQL
1:34
MySQL Monitor
5:16
MySQL Monitor Overview
5:17
XAMPP & MySQL
5:58
In the MySQL Command: hostname, username and -p
7:05
Connecting to a MySQl Server
9:52
Connecting to a MySQl Server
9:53
Using MySQl Monitor
13:48
Using MySQl Monitor
13:49
GRANT Command
15:10
GRANT SQL Command
15:11
Privileges & Objects
18:18
Username, Hostname, and Password
19:37
Specifying Objects
20:05
Creating a PHP User Account
21:41
Creating a PHP User Account Overview
21:42
Meaning of all & *.*
23:35
Example: Creating a PHP User Account
23:48
Required Homework
26:27
Required Homework: 1 - 5
26:28
Required Homework (cont.)
27:28
Required Homework: 6
27:29
Creating Databases & Tables

23m 1s

Intro
0:00
Lesson Overview
0:08
Lesson Overview
0:09
Creating a Database
1:40
Introduction to Creating a Database
1:41
Example: Creating a Database
3:33
CREATE TABLE Command
6:43
CREATE TABLE Command
6:44
Data Types
7:39
Numeric Data Types: INT, INT UNSIGNED, and DECIMAL
7:40
String Data Types: CHAR (M), VARCHAR (M), and TEXT
9:23
Colum Attributes
11:00
PRIMARY KEY Attribute
11:01
AUTO INCREMENT Attribute
11:35
Items Table
13:07
Items Table
13:08
Useful Commands
17:04
SHOW TABLES Command & DESCRIBE Utility Statement
17:05
Example: Creating an Items Table
17:58
Required Homework
20:51
Required Homework: 1 - 6
20:52
Required Homework (cont.)
21:55
Required Homework: 7 - 9
21:56
SQL Command: INSERT

27m 11s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
INSERT Command
1:20
SQL INSERT Command
1:21
Specifying Values
3:16
Columns with Numeric Data Types
3:17
Columns with String Data Types
3:34
Columns with AUTO INCREMENT
4:07
Inserting Items
5:21
Inserting Items
5:22
Example: Inserting Items
7:03
SQL Text Files
14:04
SQL Monitor Client
14:05
MySQL Monitor & the < Operator
15:15
Example
17:35
Required Homework
22:32
Required Homework: 1 - 6
22:33
Required Homework (cont.)
24:19
Required Homework: 7 - 10
24:20
SQL Command: SELECT

24m 57s

Intro
0:00
Lesson Overview
0:10
Lesson Overview
0:11
SELECT Command
0:42
SELECT Command: Definition and Syntax
0:43
Results of a SELECT Query
1:53
To Specify the Retrieval of All Columns from a Table
3:06
Example: SELECT Command
4:18
WHERE Clause
7:11
WHERE Clause
7:12
A SELECT Query with WHERE Clause has the Following Syntax
8:10
A Where Condition can Contain both Logical and Comparison Operators
9:44
Literal Values
13:24
Literal Values
13:25
Example: Literal Values
14:18
ORDER BY Clause
15:31
ORDER BY Clause & SELECT Query
15:32
Ascending and Descending Order
17:30
An ORDER BY Clause can Specify Multiple Columns to Order the Rows by
18:01
Example: SELECT Query with WHERE and ORDER BY Clause
20:32
Homework Challenge
21:59
Homework Challenge
22:00
Homework Challenge (cont.)
23:54
Homework Challenge
23:55
Using PHP from MySQL

32m 43s

Intro
0:00
Lesson Overview
0:10
Lesson Overview
0:11
PHP/MySQL Architecture
0:56
PHP/MySQL Architecture
0:57
MySQLi Extension
3:05
MySQLi Extension
3:06
Steps to Using MySQL from PHP
5:53
Four Steps to Using MySQL from PHP
5:54
Step # 3
7:18
Connecting to a Database
8:12
To Connect to a MySQL Database
8:13
To Test for Connection Errors
10:20
Running an SQL Statement
11:54
Running an SQL Statement
11:55
Example
13:30
Processing the Results
15:58
For non-SELECT Queries
15:59
MySQLi Object Property: affected_rows
16:19
For INSERT Statements on Tables with an AUTO_INCREMENT Column
18:07
Closing the Connection
19:45
Closing the Connection
19:46
Coding Example
21:24
Coding Example: Using MySQL from PHP
21:25
Homework Challenge
29:00
Homework Challenge: 1 - 4
29:01
Homework Challenge (cont.)
31:10
Homework Challenge: 5 - 9
31:11
Web Application Development

30m 30s

Intro
0:00
Lesson Overview
0:14
Lesson Overview
0:15
sprintf()
1:28
sprintf() Overview
1:29
Example
1:56
INSERT Statements with sprintf()
5:15
INSERT Statements with sprintf()
5:16
Version 14.0 Overview
10:00
Version 14.0 Changes & Examples Part 1
10:01
Version 14.0 Changes & Examples Part 2
21:58
SELECT QUERIES from PHP

24m 22s

Intro
0:00
Lesson Overview
0:14
Lesson Overview
0:15
SELECT Queries
1:21
SELECT Queries
1:22
MySQLi_Result Class
3:17
MySQLi_Result Class: num_rows
3:18
MySQLi_Result Class: fetch_assoc ( ) and fetch_object ( )
3:59
fetch_assoc()
5:17
fetch_assoc() Overview
5:18
Coding Example: Using fetch_assoc()
9:00
stdClass Objects
12:46
stdClass Objects
12:47
fetch_object()
14:19
fetch_object() Overview
14:20
Coding Example: Using fetch_object()
16:45
Freeing Result Set Memory
18:42
Freeing Result Set Memory
18:43
Coding Example: Using free ( )
20:01
Homework Challenge
22:07
Homework Challenge: 1 - 5
22:08
Web Application Development

17m 6s

Intro
0:00
Version 15.0 Overview
0:13
Version 15.0 Changes & Examples Part 1
0:14
Version 15.0 Changes & Examples Part 2
8:43
Linking Tables

24m 32s

Intro
0:00
Lesson Overview
0:16
Lesson Overview
0:17
A Departments Table
1:08
Departments Table
1:09
How Could We Model This in a Table: Option 1
1:26
How Could We Model This in a Table: Option 2
3:12
Database Normalization
4:37
Database Normalization
4:38
Foreign Keys
8:47
Foreign Keys
8:48
Linking Table
11:26
Linking Table
11:27
Multiple Column Primary Keys
15:30
Multiple Column Primary Keys
15:31
Example
18:51
Required Homework
22:34
Required Homework: 1 - 3
22:35
Required Homework (cont.)
24:10
Required Homework: 4
24:11
Web Application Development

24m

Intro
0:00
Version 16.0 Overview
0:11
Version 16.0 Changes
0:12
Version 16.0 Coding Examples
4:12
Version 16.0 (cont.)
18:30
Version 16.0 Changes & Examples Part 2
18:31
SQL Command: DELETE

10m 33s

Intro
0:00
Lesson Overview
0:12
Lesson Overview
0:13
DELETE Statement
0:30
DELETE Statement & Its WHERE Clause
0:31
Delete All Rows From a Table
2:57
Using DELETE from PHP
4:04
Using DELETE from PHP Overview
4:05
Coding Example: Using DELETE from PHP
6:37
Homework Challenge
8:53
Homework Challenge: 1 - 4
8:54
Web Application Development

16m 2s

Intro
0:00
Version 17.0 Overview
0:11
Version 17.0 Changes
0:12
Version 17.0 Coding Example
2:51
Transactions
12:50
Database Transaction
12:51
Steps in Using Transactions
14:00
SQL Command: UPDATE

32m 14s

Intro
0:00
Lesson Overview
0:10
Lesson Overview
0:11
UPDATE Statement
0:54
UPDATE Statement & Its WHERE Clause
0:55
Example: UPDATE Statement
3:32
Using UPDATE from PHP
5:21
Using UPDATE from PHP Overview
5:22
Coding Example: Using UPDATE from PHP
6:53
htmlspecialchars()
9:04
htmlspecialchars()
9:05
Encoding Special Characters
9:23
Coding Example: htmlspecialchars()
13:41
addslashes()
20:40
addslashes()
20:41
Coding Example: addslashes()
22:52
Homework Challenge
27:55
Homework Challenge: 1 - 2
27:56
Homework Challenge (cont.)
30:14
Homework Challenge: 3 - 5
30:15
Homework Challenge (cont.)
30:41
Homework Challenge: 6 - 9
30:42
Web Application Development

12m 33s

Intro
0:00
Version 18.0 Overview
0:12
Version 18.0 Changes
0:13
Version 18.0 Coding Example
1:24
SQL: Joins

42m 16s

Intro
0:00
Lesson Overview
0:11
Lesson Overview
0:12
DATETIME Data Type
1:52
DATETIME Data Type
1:53
Modeling Orders
5:12
Modeling Orders
5:13
Customers Table
10:46
Customers Table
10:47
Example
16:18
Example: Order Table in MySQL
16:19
Joins
22:26
Joins Overview
22:27
Inner Join
23:09
Example: Joins
24:11
Join Conditions
28:14
Join Conditions
28:15
Example
28:32
Join Queries
30:00
Example: Join Conditions in MySQL
30:36
Implicit Joins
34:42
Implicit Joins
34:43
Example: Implicit Joins
35:57
Aliases
37:28
Introduction to Aliases
37:29
Example: Aliases
38:55
Required Homework
40:32
Problem 1
40:33
Problem 2
41:01
Problem 3
41:17
Web Application Development

29m 34s

Intro
0:00
Lesson Overview
0:12
Lesson Overview
0:13
Inserting Orders
0:44
Inserting Orders
0:45
Version 19.0 Overview
3:45
Version 19.0 Changes & Example Part 1
3:46
Version 19.0 Changes & Example Part 2
13:18
Version 19.1 Overview
21:10
Version 19.1 Changes
21:11
Version 19.1 Coding Example
22:18
User Authentication

26m 13s

Intro
0:00
Lesson Overview
0:10
Lesson Overview
0:11
User Authentication
1:31
User Authentication
1:32
Authentication with Sessions
2:34
Authentication with Sessions
2:35
Four Steps in Authentication via Sessions
2:50
Using Sessions to Restrict Access
3:58
Using Sessions to Restrict Access
3:59
Coding Example: Restricted Access Area
4:47
Authentication Methods
5:54
Authentication Methods Overview
5:55
Coding Example: Authentication Methods
7:31
Logging Out
9:57
Logging Out
9:58
Coding Example: Log Out
10:47
Users Table
13:50
Users Table
13:51
Example: Creating a Users Table
15:08
Password Hashing
17:30
Password Hashing
17:31
PHP and MySQL Built-in Hash Functions: sha1 ( ) and md5 ( )
18:43
Coding Example: Password Hashing
19:27
Required Homework
24:41
Required Homework: 1 - 4
24:42
Web Application Development

14m 36s

Intro
0:00
Version 20.0 Overview
0:13
Version 20.0 Changes & Examples Part 1
0:14
Version 20.0 Changes & Examples Part 2
5:05
Version 20.0 Changes & Examples Part 3
7:29
Version 20.0 (cont.)
8:31
Version 20.0 Changes & Examples Part 4
8:32
Loading...
This is a quick preview of the lesson. For full access, please Log In or Sign up.
For more information, please see full course syllabus of Advanced PHP
Bookmark & Share Embed

Share this knowledge with your friends!

Copy & Paste this embed code into your website’s HTML

Please ensure that your website editor is in text mode when you paste the code.
(In Wordpress, the mode button is on the top right corner.)
  ×
  • - Allow users to view the embedded video in full-size.
Since this lesson is not free, only the preview will appear on your website.
  • Discussion

  • Study Guides

  • Download Lecture Slides

  • Table of Contents

  • Transcription

  • Related Services

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Sign up for Educator.com

Membership Overview

  • Unlimited access to our entire library of courses.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lesson files for programming and software training practice.
  • Track your course viewing progress.
  • Download lecture slides for taking notes.
  • Learn at your own pace... anytime, anywhere!

SQL Command: INSERT

  • The SQL INSERT command is used to insert rows into tables in a database. It has the following syntax:
    INSERT INTO tblName (col1Name, col2Name, col3Name) VALUES (col1Val, col2Val, col3Val);
  • The column names can be left out and values just provided as long as the values are specified according to the order in which the columns are defined in the table.
  • For columns with numeric data types, values are specified with no surrounding quotation marks.
  • For columns with string data types, values should be specified by surrounding them by single or double quotes.
    • If a string contains a quote character, it must be escaped using the \’ or \” escape sequence.
  • When inserting rows into a table with an AUTO_INCREMENT column, the value NULL or 0 should be provided in order to trigger MySQL to automatically generate the ‘next’ value for the new row.
  • The MySQL Monitor client can be used to run multiple SQL commands contained in a text file all at once, allowing commands to be authored ‘offline’ in a text editor.
  • The < operator is used in the following manner to run the commands in a text file:
    mysql –u phpuser –p advanced_php < commands.sql
  • Note: after the '-p' command switch, you can specify the database to use when processing the commands in the text file.
  • Note: after the '<' operator a relative or absolute path must be provided to the .sql file.
  • Additional Resources:

SQL Command: INSERT

Lecture Slides are screen-captured images of important points in the lecture. Students can download and print out these lecture slide images to do practice problems as well as take notes while watching the lecture.

  • Intro 0:00
  • Lesson Overview 0:11
    • Lesson Overview
  • INSERT Command 1:20
    • SQL INSERT Command
  • Specifying Values 3:16
    • Columns with Numeric Data Types
    • Columns with String Data Types
    • Columns with AUTO INCREMENT
  • Inserting Items 5:21
    • Inserting Items
    • Example: Inserting Items
  • SQL Text Files 14:04
    • SQL Monitor Client
    • MySQL Monitor & the < Operator
    • Example
  • Required Homework 22:32
    • Required Homework: 1 - 6
  • Required Homework (cont.) 24:19
    • Required Homework: 7 - 10

Transcription: SQL Command: INSERT

Hello again, and welcome back to Educator.com's Advanced PHP with MySQL course.0000

In today's lesson, we are going to be learning how we can add data to our database, using the SQL INSERT command.0005

We are going to learn about the syntax of the SQL INSERT command, which is used to add data to a database.0013

We are going to learn about how to specify values that we want to insert into a database.0020

For example, when we insert strings into a database, we have to enclose them in quotation marks.0025

We are going to learn about some rules for doing that.0029

We are going to walk through the process of populating our Items table that we created in our last lesson with the default items we had in our store.0032

In our web application, we have had 6 items that we have had through all of our web application examples that we have had in the store.0044

And we are going to go ahead and add all of those, using INSERT statements.0051

We are going to talk about how you can have a bunch of SQL commands, or SQL statements, in text files.0054

And then, you can just sort of import that text file into the MySQL Monitor, and it will run all of the commands for you.0061

And then, we are going to go over another required homework that is going to have you set up the Items table0069

by populating it with those default six items that we have had in our web store application.0074

As mentioned, the INSERT command is used to insert rows into a table in the database.0082

It has the syntax defined here: it has the two keywords INSERT INTO, followed by the table name.0089

You would say "INSERT INTO Items," for example, and that is going to say that we are going to be inserting data into the Items table.0098

And then, what you do is specify the names of the columns that you are going to be providing data for.0108

You name the different columns: for example, you might say itemID, name, and price.0114

Then, you have the keyword values, and then, within parentheses, you specify the different values0119

that you want to correspond to the different columns you have listed.0125

So, the first value would correspond to whatever column name you could find here.0128

The second would go to this name here, and then so on.0132

And you can do that for as many columns as you need to.0135

There is also a shorter syntax where you can leave out the column names (this section here),0138

and have a command that would just be INSERT INTO Items, for example.0145

And then, instead of having this column definition, you would just say values.0155

And here, I am just putting them on separate lines (they don't need to be), just for readability.0160

And then, you would just specify the values.0163

Now, the thing to note about that is that (and this was mentioned in the last lesson),0169

when you create a table, and you use the CREATE TABLE command, you specify columns in a particular order.0173

Well, that sets up the structure of that table and how those columns are ordered.0179

So, if you are going to be using this form of the INSERT command without specifying the column names here,0182

and you are just specifying values, you have to specify the values according to how those columns are ordered in the table definition.0190

For columns with numeric data types (for example, our price column), you simply specify0198

the literal value that you wanted to insert into the database without quotation marks.0205

If we wanted to set a price of $15, we would just type 15.00.0210

For columns with string data types, however (for example, a CHAR data type, a VARCHAR, and a TEXT data type),0216

you have to surround them by quotation marks--either single quotes or double quotes.0222

And just as in our PHP strings, if your string that you are inserting into the database contains one of those quote characters itself,0228

you must explicitly escape it, using the escape sequence: backslash, single quote to add a single quote to the string,0237

or backslash, double quote to add a double quote to your string.0244

Another important thing is: for columns that have the AUTO_INCREMENT attribute set0249

(which, for our Items table, is the itemID column, because we want it to generate a new itemID automatically0253

every time we add an item to the table), what you do is: when you provide a value in the INSERT statement for that particular column,0259

if you provided a value of null or you provided a value of 0, then MySQL is going to know0269

to go ahead and auto-generate, in this case, a new itemID to whatever the next value in the table is.0275

You specify null or 0 to do that.0286

Alternatively, you can also exclusively set the value for an auto-increment column by actually giving it a particular value.0288

You can...for example, if this was our column definition: INSERT INTO, and we had set itemID with the column values...0294

let's say we are just inserting one column; we could explicitly put 1001.0306

And that way, it wouldn't do the AUTO_INCREMENT feature; it would set it to the value explicitly specified.0314

Now, we are going to talk about how to insert items into our database, taking that command that we just learned about abstractly0323

and putting it to work in a real-world example.0329

We are going to be inserting those six default items that we have had in our web store into our database.0333

This command right here is going to be used to insert the first item in the database.0339

We are saying, "Insert into the Items table values for these columns: itemID, name, price, description, and imageFileExt."0345

We are saying, "Give them the values..." in this case, we are explicitly setting this auto-increment column to 1001.0352

And we do that just for this first item.0359

And the reason we are doing that is: AUTO_INCREMENT--the first time you insert an item into a table with it, it automatically starts at 1.0360

If you explicitly set it (in this case, to 1001), then every time we add an additional item, and we specify a null value or a 0 value,0368

as mentioned, then it is going to auto-increment it from the highest item number there in the table.0375

In this case, it will have already been set to 1001; so the second item is going to be added as 1002.0380

We are going to specify the name of the item; notice that it is in quotation marks, because it is a string.0386

We are going to set the price (which is just a number, so there are no quotation marks; it is the string 15).0391

We are going to enter a description (again, because it is a string, it is enclosed in quotation marks),0398

and then the image file extension (in this case, jpg); because it is a string, it needs to be enclosed in single quotation marks.0403

Notice that there are parentheses around the names of the different columns.0411

And then, there are parentheses that surround the different values that we are going to be providing.0417

Let's go ahead and add this first item into our table.0424

We are going to connect to the MySQL database as our phpuser, just as we have done in the past.0430

We are going to use the advanced_php database.0439

And a command that I am going to do...I am going to show the tables that we currently have (we have only created one so far--it is going to be Items).0447

We have an Items table, and I am going to issue a command now that we are going to learn about in the next lesson,0457

called the SELECT command, that lets you see what data is in that particular table.0461

Don't worry about the syntax of this right now.0467

But it is saying, "Give me all of the rows in the Items table."0468

And when we enter it, we can see that it is the empty set; so we know that our Items table is currently empty.0470

Now, we are going to go ahead and insert that first item into the table.0476

We are going to insert into the Items table, and we specify the names of the columns.0479

And then, we specify the values we want to associate with those columns.0503

And after this one, I'll have to go back to the slides; I don't remember exactly what we had.0510

The second one, the name, is a string, so we are going to enclose it in quotation marks.0516

The price was $15; the description (which is another string) is going to be enclosed in quotation marks.0527

This 100% cotton T-shirt is built for comfort.0535

If I continue it on the next line..."for comfort"...I finish the quotation marks; and then, the image file, I believe, was jpg.0548

I'm going to enter jpg, again, in quotation marks.0559

I have the closing parentheses for our list of values, and a semicolon.0563

When we hit Enter, it is going to let us know that the query was OK.0568

If I run this SELECT command (which, again, we are going to learn about in the next lesson) again,0571

to see if we have any data in our Items database, we are going to see this row.0576

We are going to see (it is kind of hard to see here, because of the size of the screen, but basically) that0584

it has the itemID we entered (1001); it has the name (100% Cotton T-Shirt);0589

it has the price ($15); it has "This 100% cotton T-shirt is built for comfort," and then it also has the file extension jpg.0593

Now, the other way that we can insert items in tables, as mentioned, is not by specifying the columns,0604

but just specifying the values in the order that the columns are defined.0609

And remember, for our auto-increment columns, we can just specify null or 0,0614

and that is going to have the database automatically generate that for us.0618

We will get to this file in a second, but I have a file that contains INSERT statements for all of the 6 default items that we have.0625

So, I am going to reference it, so that I can type these in manually.0632

We are going to enter the second item into the table; this is a 42" LCD television.0636

We are going to say INSERT (let's see if we can clear a little space here) INTO Items values...0641

And now, I have to specify these values in the way that the table was defined.0661

And let me go ahead and throw an error there to get out of that command.0667

If we describe our Items table using the DESCRIBE command, we can see that the order they were defined in0671

is itemID, name, price, description, and imageFileExt, so that is the way0678

that I am going to have to specify them in parentheses in our INSERT statement.0682

Now, the first one is itemID; because we want it to auto-increment, we are going to set it to equal the value null.0692

The name is 42" LCD Television; notice that it is in quotation marks.0698

Also, notice, however, that even though this includes a double quote, I don't have to escape it with a backslash,0706

because it is included within single quotation marks; that is similar to how PHP works.0712

I need to make sure that I have the right name for that: 42" LCD Television, $599.99.0717

The next column is price, so we are going to enter, without quotation marks, 599.99.0722

The description: With 42 inches of viewing screen, you feel like you are a part of the movie.0729

And then, the image file extension; in this case, it is a GIF, so we enter gif in quotation marks.0755

We finish it with a closing parentheses, add a semicolon, and hit Enter.0765

And it is going to let us know that the query was OK.0771

It is going to say "one row is affected," which I didn't mention before, which shows that one row was inserted.0773

Now, if we run our SELECT query again to see what is in the Items table (let's see if there is some way I can get this so it looks better),0777

we can see that it has added two items to the table.0790

I am going to do a modified SELECT statement, which you will learn more about in the next lesson.0793

I am just going to get rid of the description; I am not going to have it pull up the description value0796

in the results that it returns, just so we can see it all in one screen.0803

And again, don't worry about the syntax of this right now.0808

You can see that it has added another row to the table.0818

It gave it the itemID value 1002, so you can see that, when we specified null for itemID, it went ahead and auto-incremented it.0821

It took the greatest value that was in that column in the table (which was 1001) and incremented it by 1.0828

And then, we can see that it went ahead and set all of the different columns for the table.0833

It set the name to 42" Television, price to 599.99, and the image file equal to gif.0836

One of the things that you can do is: the MySQL Monitor client can be used to run multiple commands at the same time.0845

And what it allows you to do is: you can create a text file that contains all of these commands that we have been typing into this interactive MySQL prompt.0851

You can go ahead and edit them offline in a text file, and then import this text file into the MySQL Monitor.0859

It will go ahead and run all of the commands in that particular file.0867

And the common thing that that is used for is INSERT statements.0872

For example, if we want to insert a bunch of data into our database, here I have this text file created.0875

And as you can see, it contains a bunch of INSERT statements, all with syntax exactly as you would use if we typed it in the command prompt.0881

And it just contains a bunch of INSERT statements that insert all of our 6 default items into the database.0888

You can contain any SQL statements you want in these text files.0895

For example, one of the statements that I have at the top is to use advanced_php,0899

because that is going to let MySQL know that we are inserting these items into the Items table that is in the advanced_php database.0903

That is something that you can include.0911

The way that you have the MySQL Monitor run these commands is: you use the MySQL command;0916

but then, what you do is use a less than sign, and then the name of the file that contains all the commands you want to run.0923

Now, the commands can be held in any text file with any extension, as long as it is a text file.0930

But the convention is to end files in this .sql extension, and that is what we are going to use in this course.0935

This is saying, "I want to connect to the MySQL database on the localhost (because no host is specified) as a phpuser."0943

"I want to be prompted for the password."0951

And then, one other thing to notice here is: let's say we hadn't included that USE advanced_php statement0955

in our SQL file that I was just talking about; we can specify what database we are going to use at this MySQL command prompt,0961

by...the last thing we enter before the less than sign is the name of the database we want to use.0969

This is going to say, "Connect to the localhost MySQL database as phpuser; prompt me for the password."0974

"When I log in, I want to be using the advanced_php database, so I don't have to type the USE command."0981

"And then, I want you to run these commands contained in commands.sql."0988

Now, one thing to note is that, when you specify, after this less than sign, the name of the file0994

that contains the SQL commands that you want to run, you have to make sure that the MySQL Monitor knows where to find that file.1000

If an absolute path is not specified, it interprets it as a relative path;1014

so in this case, commands.sql would have to be in the same directory where this MySQL command is being run from.1017

So, you might have to, for example, specify an absolute path.1023

Maybe you have an SQL file called items.sql stored in the user1 directory of the Users directory on the C: drive.1031

So, you would replace this commands.sql after the less than sign with an absolute path to the file.1042

That way, that is one problem that you might encounter.1047

You need to make sure that MySQL is able to find the SQL file that you are trying to import.1049

We already know that this file was set up to insert the 6 default items into the database.1057

But we have already inserted the first two, so I am going to go ahead and delete this from this file.1067

And then, I am going to have it insert into the file the remaining four items.1073

As you can see here, what I have done is: the next two items--I have just specified the values.1078

And so, I have to specify the values in the order that the table was set up in.1084

It's itemID, followed by the name, followed by the price, description, and image file extension.1090

Then, in this last part, in the fourth and fifth one, we are going to explicitly name the columns.1096

I'll put this on a separate line.1102

We are saying the first value we are providing is the itemID; we are providing it the name, price, description, and image file extension.1104

Here, this should be null.1112

And then, one thing to note is that, if you are explicitly specifying the columns of the values that you are supplying,1116

you can actually put them in any order you want.1126

You just have to switch the order of the way you are listed in the values parentheses.1128

For example, we want to specify price first and then name; we would switch the order here, and then subsequently switch the order in the list down here.1132

What this statement is going to do is say, "Insert into Items itemID, price, name, description, and imageFileExt."1143

So, this one is going to be interpreted as itemID; this will be interpreted as price; this will be interpreted as name.1148

So, it will still work; and it just allows you to switch the order around.1153

And that is just to give you an example of the different flavors you can use for the INSERT statement.1156

Let's see this file...I'll get the address of this file.1169

I'm going to exit altogether and get a fresh command prompt.1180

I'll change to our mysql/bin directory, so we get access to that MySQL program.1191

We are going to connect to the localhost; we are going to connect to phpuser.1200

We are going to be requested for the password; we are not going to specify that we want to use the advanced_php...1205

Actually, let's go ahead and do that; let's specify that we want to use the advanced_php database.1211

And then, in our items.sql file, I am going to eliminate this line.1216

When we import this file, it is going to know that we are using that advanced_php database already.1220

And then, I'm going to specify, using the less than sign, the SQL file that I have called items.sql1227

that contains these INSERT statements for the remaining four items that we are inserting into the database.1235

And I am going to specify the absolute path to it, which is in this particular directory that I just copied from the Windows Explorer.1240

It is called items.sql.1255

And when I hit Enter, it is going to ask me for the password.1257

And then, assuming everything runs fine, it is going to run things and then return the command prompt back to the way it was before.1264

So now, to make sure that they were all added properly, I'm going to log back in as phpuser to the advanced_php database.1270

And now, let me type SELECT; again, I am not going to bring up a description, because it makes things longer.1293

Again, typically keywords (they don't have to be capitalized, but) like SELECT in this particular case, by convention, are capitalized.1309

This is going to say, "Give me all of the information about all of the items in our Items table."1315

And we can see that it was able to successfully add those other four items.1320

It added 1003, 1004, 1005, 1006, with the values that we specified.1323

We saw that you can use either the format we used to explicitly specify the column names,1329

or you can just explicitly specify the values in the order in which the columns are defined in the table.1335

Or, you can explicitly specify the columns in any order that you want, as long as the values that you supply match up to those particular columns.1340

The required homework is to get you to populate the Items table you created in the last required homework1353

with the 6 default items we have been using in our store.1359

And what you should do is log into MySQL as phpuser, using the MySQL command prompt.1363

And I'll have you experiment with a couple of different things that we did here in the lecture,1369

so you get experience with both manually typing commands, and then also using that less than sign1373

to import commands to be run by MySQL.1379

After you log in, select the advanced_php database for use (which you use the USE command to do).1384

And then, run an INSERT command that is going to insert item 1001 into the database.1390

And in this case, we are going to have you explicitly set the itemID column to 1001.1396

And what that is going to do is seed that AUTO_INCREMENT column, so that any item added after that--1401

when we specify null for itemID, it is going to add 1 to that.1406

So, the next item will be 1002, then 1003, and so forth.1409

And you can get the information to add for these particular items (the name, the price, the image file extension, the description)1413

from, for example, items.txt, which is the database file we have been using to store information about all of our items in our store.1421

That has been our database to figure out what values you need to put for each item when you enter them into the database.1428

Then, run the SELECT * FROM Items command to verify that the item was successfully added.1436

And then, exit the MySQL Monitor client.1442

Then, what I am going to have you do is create a file called items.sql in whatever directory you want1445

that is going to contain INSERT commands for each of the remaining 5 items in the store.1450

One of them you are going to answer manually; the others, you are going to use an SQL file for.1455

And I want you, for the first three items that you add, to use the INSERT syntax that includes the column name.1461

You are going to explicitly specify the column names (itemID, name, price, and so forth).1468

And then, for the last two, use the INSERT syntax that just provides the values.1473

It just has values with the parentheses containing the values you want.1477

Just remember that you have to specify those values in the order in which the columns are defined for that particular table.1483

Then, use that less than operator to input this SQL file into MySQL Monitor to run these INSERT commands.1489

And make sure that you specify the correct absolute path (or relative path, if you want--if you understand how to do that)1498

to this items.sql file that you have created, which is the name of the file that is going to contain all of these INSERT statements.1505

And so, you need to make sure to specify that it knows where to find that.1513

You can optionally, in your items.sql file, include USE advanced_php as the first line of the file1518

to make sure that these statements get evaluated on the advanced_php database,1528

because if they don't, you will get an error from MySQL.1532

Or, you could use it using the MySQL command prompt, and specifying user, p, and then specifying the name of the database,1536

in which case (and a less than, in the name of your file) you can leave this statement out here.1546

I'll let you decide whatever you want to do for that.1552

Then, log into the server as phpuser; run this SELECT * FROM Items again (which is saying,1554

"Give me all the information about all the rows in the Items table) to verify1559

that all those items that you had in your SQL file were successfully added.1563

A couple things to note: make sure that you properly enclose all of the strings in quotes.1570

All of those string data fields, we have to enclose in quotes.1575

And escape any quote characters, as needed.1578

And you will notice that, on the descriptions that we currently have for some of the items in the store,1581

there are single quotes contained within them; and so, you are going to need to escape those with backslash, single quote.1585

The alternative would be that, as in PHP strings, you could enclose the string in double quotes.1594

And therefore, for example, if you have the word you'll with the apostrophe, you don't have to escape that single quote.1600

I'll leave that up to you.1613

And then also, just make sure that mysql.exe, the MySQL Monitor, can find your MySQL file.1614

So, you are going to have to specify a correct path to that file after the less than sign after the MySQL command.1619

That ends today's lesson; thank you for watching Educator.com; I look forward to seeing you next time.1626

Educator®

Please sign in to participate in this lecture discussion.

Resetting Your Password?
OR

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Membership Overview

  • Available 24/7. Unlimited Access to Our Entire Library.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lecture slides for taking notes.
  • Track your course viewing progress.
  • Accessible anytime, anywhere with our Android and iOS apps.