Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development PHP

PHP with PDO: Build a Basic Task List with PHP, PDO & MySQL

Learn and Understand PHP Database Objects (PDO), Build a Basic Task List with PHP, PDO, MYSQL and JQuery Ajax
Rating: 4.5 out of 54.5 (183 ratings)
3,549 students
Created by Terry Ogbemudia Osayawe
Last updated 12/2017
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Build a Basic Task List with PDO, PHP and MySQL
  • Perform CRUD (Create, Read, Update and Delete) Operations with PHP Data Object (PDO)
  • Protect any web application against SQL Injection
  • In depth understanding of PHP Data Object (PDO)
  • Dealing with Errors in PHP Data Object (PDO)
  • Send Request via Ajax without page Refresh
  • Prompt support and value for your money
  • Access to my Introduction to Programming in PHP Course on Devscreencast dot com

Course content

6 sections • 31 lectures • 2h 54m total length

  • Preview02:54
  • Preview04:46
  • Connecting to MySQL Database with PDO
    06:52
  • Dealing with Errors in PDO
    07:15
  • Creating a table with PDO
    07:16
  • Section 1 - Quiz
    5 questions

  • Create
    03:57
  • Read
    03:41
  • Update
    02:12
  • Delete
    01:42
  • How to Review This Course
    00:07
  • Section 2 - Quiz
    3 questions

  • Parameters and Prepared Statements
    08:17
  • Binding Parameters to Prepared Statements
    04:30
  • Section 3 - Quiz
    3 questions

  • Getting the last Inserted ID
    02:17
  • Number of Affected rows
    03:06

  • Transactions
    09:34
  • PDO Data Fetching Modes
    07:59
  • Further Reading
    00:00

  • Preview07:25
  • Prepping The Database
    01:30
  • Building the Interface
    06:29
  • Creating a Task with JQuery and PHP
    14:24
  • Displaying Existing Tasks with JQuery and PHP
    07:16
  • Updating a Task with JQuery and PHP (With In-place Edit)
    18:21
  • Deleting a Task with JQuery and PHP
    07:02
  • Wrapping up
    02:38
  • Source Code
    00:00
  • Validating Create Task Form
    12:34
  • Optimizing Update Task Code
    05:26
  • Pagination
    12:44
  • Updated Source Code
    00:01
  • Bonus Lecture
    02:01

Requirements

  • Already Setup PHP Development Environment running PHP 5.1 with a basic understanding of PHP Programming Language
  • Basic understanding of SQL Language (Every Query is well explained)
  • Little OOP knowledge will be nice but not required to follow along

Description

This course teaches PHP Data Objects (PDO), one of the available API for connecting to databases within PHP. PDO is an object oriented extension which was introduced with PHP 5.1, taking advantage of several features introduced into PHP at that time.

In this step by step course both beginners and experienced web developers will gain a comprehensive understanding of the modern PDO extension and how it can be used to create scalable database driven application. 

This PHP with PDO course uses MySQL database to teach PDO concept and finally you learn how to build a basic task list using the concepts that has been taught in the course.

My Approach

In this course I use simple examples that can be easily understood to illustrate concepts and build upon it.

See What Students are saying

"This was perfect for my skill level as an advanced beginner to lower intermediate PHP developer. Terry wastes no time, and the whole course is packed with great information. I also really like the Material Design CSS and JS used in the course, since I had never used it before. I am very appreciative of this knowledge I gained, and plan to go through the whole thing again, and use it as a reference later." - Collin Stubblefield

"Managed to complete making a PDO tasklist! very helpful! the content is well put together! understood some core concept of PHP PDO! overall highly recommended! keep making more videos! If you can make a shopping cart! for tutorial basis! thanks!" -Brian Gichohi

"The instructor is clear and engaging also knowledgeable and passionate about the course. The course is well taught by the instructor" - Abimbola Makinwa

"Terry is a great teacher. He goes the extra mile to ensure student satisfaction. He even offers to remotely connect to your machine to help out if your code is not working the way it should. Thanks ever so much." - Sahid Camara

Timely Support!

If you ever encounter any problem why taking this course, don't worry I am always here to help and guide you through. Enroll today and get the skills and knowledge you need to succeed as a PHP developer. Every minute you let by is money and opportunity that are passing you by.

Who this course is for:

  • This PDO course is for anyone who is not familiar with PHP Data Objects database API and/or students looking for a quick refresher on PDO.
  • Want to learn and understand a multi platform database API
  • You want to migrate from MySQLi or MySQL to PDO
  • PHP Developers who want to learn how to use PDO for database driven application.

Instructor

Terry Ogbemudia Osayawe
Web Developer and Teacher
Terry Ogbemudia Osayawe
  • 4.4 Instructor Rating
  • 1,631 Reviews
  • 43,956 Students
  • 9 Courses

My passion is inspiring people through online courses. Since 2015, over 30,000 students have taken my online courses - and I'm so grateful to every single one of you                 

I graduated with a bachelor's degree in Software  Engineering from University of East London, and I'm also a certified  Oracle  Database Professional (OCP). I'm passionate about  teaching and sharing my knowledge on various platforms.                     

I facilitated high-end trainings in Web and Software  Development, Oracle Database, Linux Operating System, and Oracle Financial 11i.                 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.