PHP Easy Tutorial to Database Connections using a PDO class
PHP Easy Tutorial to Database Connections using a PDO class, available at Free, has an average rating of 4.55, with 54 lectures, based on 57 reviews, and has 1267 subscribers.
You will learn about UNDERSTAND what VANILLA PDO functions already do and stop using legacy code that is confusing you. Gain a SOLID FOUNDATION to take other courses involving PHP and database connections. Learn how to practice new code concepts in the world of code automation The minimalist presentation facilitates your reviewing over time This course is ideal for individuals who are Students of other PHP courses who may still want further explanation on using PDO or Beginner PHP developers with some previous knowledge of syntax or Intermediate web developers wanting to learn more about the PHP 7 PDO class or Database SQL users who want to learn how to connect by using modern PHP techniques or Researchers who are interested in PHP database connectivity or Anyone who wants to know how to connect a MYSQL database to HTML It is particularly useful for Students of other PHP courses who may still want further explanation on using PDO or Beginner PHP developers with some previous knowledge of syntax or Intermediate web developers wanting to learn more about the PHP 7 PDO class or Database SQL users who want to learn how to connect by using modern PHP techniques or Researchers who are interested in PHP database connectivity or Anyone who wants to know how to connect a MYSQL database to HTML.
Enroll now: PHP Easy Tutorial to Database Connections using a PDO class
Summary
Title: PHP Easy Tutorial to Database Connections using a PDO class
Price: Free
Average Rating: 4.55
Number of Lectures: 54
Number of Published Lectures: 53
Number of Curriculum Items: 54
Number of Published Curriculum Objects: 53
Original Price: Free
Quality Status: approved
Status: Live
What You Will Learn
- UNDERSTAND what VANILLA PDO functions already do and stop using legacy code that is confusing you.
- Gain a SOLID FOUNDATION to take other courses involving PHP and database connections.
- Learn how to practice new code concepts in the world of code automation
- The minimalist presentation facilitates your reviewing over time
Who Should Attend
- Students of other PHP courses who may still want further explanation on using PDO
- Beginner PHP developers with some previous knowledge of syntax
- Intermediate web developers wanting to learn more about the PHP 7 PDO class
- Database SQL users who want to learn how to connect by using modern PHP techniques
- Researchers who are interested in PHP database connectivity
- Anyone who wants to know how to connect a MYSQL database to HTML
Target Audiences
- Students of other PHP courses who may still want further explanation on using PDO
- Beginner PHP developers with some previous knowledge of syntax
- Intermediate web developers wanting to learn more about the PHP 7 PDO class
- Database SQL users who want to learn how to connect by using modern PHP techniques
- Researchers who are interested in PHP database connectivity
- Anyone who wants to know how to connect a MYSQL database to HTML
Why is PDO important?
PDO provides a data-access abstraction layer in PHP, which means that, regardless of what database you’re using, you write the same functions to issue queries and fetch data. It’s that simple! However, you still need to set a database-specific PDO driver in your php.ini to access the correct database server.
How is this course different?
-
This is a hands-on project; no fluff or history lessons that you can always search if you’re interested.
-
This updated course was originally written in 2019 using PHP 7.3,
but it has been reviewed in 2023 using PHP 8.2 to assure its integrity.
-
Each section starts with independent code after a brief review of concepts.
Wash, Rinse, and Repeat.
Upon completion of this project, you should be able to:
-
Summarize and remember the steps involved in using PHP to accomplish a basic database connection and CRUD.
-
Have a solid foundation to take other courses involving PHP and database connections, like using Symfony components, for example.
-
Your PDO training starts here.
The purpose of this short course is to empoweryou by giving you the basics before you tackle a framework where everything is more abstract. It’s a short study project designed to go slow by repeating core exercises.
Why PHP?
In 2024, PHP still powers 76% of websites around the world. PHP has evolved into a powerful, object oriented language. We are not in 2005 anymore. The job market is wide open for good PHP developers that take time to study fundamentals.
This project informs and teaches; and that is great for reviewing concepts as well.
Add it to your collection of periodic drills you must do to stay current with the basics.
Subscribe today, even if you want to start at a later date.
Course Curriculum
Chapter 1: Create a MySQL database for testing
Lecture 1: How to do the exercises (use 1.25x speed)
Lecture 2: What is PDO? (use 1.25x speed)
Lecture 3: About your development environment
Lecture 4: Alternative database creation using the terminal
Lecture 5: Creating a database with phpMyAdmin
Lecture 6: Practicing exercise 1 – New database
Chapter 2: Connect to a database using the PHP PDO class
Lecture 1: Making a database connection using PDO
Lecture 2: Using individual variables to hold credential values
Lecture 3: Practicing exercise 2 – Connecting to the blogs database
Lecture 4: Result for exercise 2
Lecture 5: Using a try catch statement to handle PDO connection errors
Lecture 6: Discussed code and resources
Chapter 3: Basic database querying and browser displaying using PHP
Lecture 1: Creating a new database connection
Lecture 2: Note about the next video
Lecture 3: The two PDO methods for querying a database
Lecture 4: Extracting data from the POD Statement
Lecture 5: Discussed code and resources
Lecture 6: Converting special characters to HTML entities
Lecture 7: Review – Things to know
Lecture 8: Moving SQL statements to variables
Lecture 9: Discussed code and resources
Chapter 4: Prepare and execute a MySQL Statement using a PHP PDO object
Lecture 1: Creating a new connection for prepared statements
Lecture 2: Stage 1: Preparing the query
Lecture 3: Stage 2: Executing the query – rowCount
Lecture 4: Discussed code and resources
Lecture 5: Named placeholders
Lecture 6: Submitting the execute function without any arguments. Running multiple queries
Lecture 7: Discussed code and resources
Chapter 5: The insert into statement
Lecture 1: Create a new connection file named dbinsert
Lecture 2: Initial Code
Lecture 3: Inserting a new record with Prepared Statements
Lecture 4: Discussed code and resources
Lecture 5: Displaying the number of affected rows
Lecture 6: Displaying content from the last inserted id
Lecture 7: Preparing output with HTML entities
Lecture 8: Discussed code and resources
Chapter 6: The SQL update statement via a PDO object
Lecture 1: Initial code for this session
Lecture 2: SQL UPDATE with Prepared Statements
Lecture 3: Final code for this session
Chapter 7: The delete statement
Lecture 1: Initial Code
Lecture 2: Deleting a record with Prepared Statements
Lecture 3: Final code for this session
Chapter 8: Odds & ends
Lecture 1: Including a single database credential for multiples files
Lecture 2: Hiding a folder from the browser using htaccess
Lecture 3: Resources for this section
Lecture 4: Fetch arguments
Lecture 5: Final code and resources
Lecture 6: Enabling or disabling emulation of prepared statements (part 1)
Lecture 7: Initial code
Lecture 8: Enabling or disabling emulation of prepared statements (part 2)
Lecture 9: Final code and resources
Lecture 10: Bibliography
Chapter 9: Thank you
Lecture 1: Thank you
Instructors
-
Tony de Araujo
Tech Writer – Published Author on Programming [Amazon]
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 1 votes
- 3 stars: 3 votes
- 4 stars: 15 votes
- 5 stars: 38 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024