Master the PDO library to efficiently access and manage databases using PHP. Ideal for both beginners and seasoned developers.
This course is all about using PHP Data Objects (PDO) for connecting and interacting with databases. It covers essential skills to build secure, efficient applications while ensuring you grasp the basics and best practices of database management.
Learn to use the PDO library to access databases using PHP
The course teaches PHP Data Objects (PDO), the preferred way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.
While a basic knowledge of PHP is recommended for this course, both beginners and experienced web developers will gain a complete understanding of how PHP Data Objects work.
A basic knowledge of PHP is recommended for this course. You will need to be able to open and write to a basic PHP file and be able to have a server and database installed. This course will use MySQL server.
Exactly What Is PDO?
The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP. Each database driver that implements the PDO interface can expose database-specific features as regular extension functions. Note that you cannot perform any database functions using the PDO extension by itself; you must use a database-specific PDO driver to access a database server.
PDO provides a data-access abstraction layer, which means that, regardless of which database you're using, you use the same functions to issue queries and fetch data. PDO does not provide a database abstraction; it doesn't rewrite SQL or emulate missing features. You should use a full-blown abstraction layer if you need that facility.
Work with MySQL and other database software from PHP including connecting, inserting, updating records, displaying database records in lists within HTML and database security.
1 Lectures
1 Lectures
2 Lectures
2 Lectures
1 Lectures
At Stone River eLearning, technology is all we teach. If you're interested in IT, programming, development, business or soft skills - we have it covered. Check out our huge catalog of courses and join the over 3.2M students currently taking Stone River eLearning courses. We can provide all or part of this catalog to any business via API connection, or...
Great content - very efficient use of time.
All of these courses seem to do the same thing, and I'm not sure I understand PDO any better now than before. How about an explanation of the $this-> stuff instead of just saying to do it?
Instructor gives plenty of examples and seems knowledgeable
I really liked this course, it was taught well and despite the fact that I've been using PDO for years I'd never taken the time to read through the documentation and just relied on what I'd learnt from examples in online articles / tutorials as a result I learnt a few useful bits from this course.
Started to get lost at prepare statements and course finishes at 87% after lecture 15. Where is the rest if there is more?
Easy to understand and good examples.
Exactly what I needed, great pace, great explanation! I went from knowing nothing about PDO (and very little mysql) to now using it as my normal process for working with databases.
Learned a lot from the PDO course. Can't wait to start using it.
Good course clear and easy to follow. If like me you have been using PDO for years. This course refreshes you memory. If you are still using mysqli_query or worse mysql_query to connect to your database. Take this course and improve your code as well as security.
Your email address will not be published. Required fields are marked *
Andrew D.
The course is fast paced which is great, but some parts could be explained a bit more thoroughly.