PHP MySQL database connections | Laurence Svekis | Skillshare

PHP MySQL database connections

Laurence Svekis, Web technology Instructor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
26 Lessons (1h 60m)
    • 1. MysqlDB

    • 2. 1 Course introduction mysql databases and PHP

    • 3. 2 Resources and Setup Information

    • 4. 4 How to Create a database

    • 5. 5 MySQLi Procedural database connection

    • 6. 6 MySQLi Object Oriented connection

    • 7. 7 PDO connection

    • 8. 8 Create a SQL query to create a database

    • 9. 10 How to create a table mysqli

    • 10. 11 PDO create Table

    • 11. 13 Insert into database MySQLi

    • 12. 15 mysqli insert id return id value

    • 13. 16 Select from database PHP query

    • 14. 18 DELETE row from MySQL

    • 15. 19 Update content in your database

    • 16. 20 How to create query strings with phpmyadmin

    • 17. 22 Insert query multi query into Mysql Object Oriented Connection

    • 18. 24 Query Selection Object Oriented PHP connection

    • 19. 26 Delete from mySQL database

    • 20. 27 Update data in your database

    • 21. 29 PDO connection insert Data

    • 22. 30 Insert Into Database PDO connection

    • 23. 32 Select data from database

    • 24. 33 Delete rows using PDO connection

    • 25. 34 Update mySQl database

    • 26. 35 How to use prepare statements in PHP


About This Class

Learn to connect to a MySQL database with PHP code how to select, update, delete, insert content to a MySQL database

Learn how to use a MySQL database and access data within your PHP code.  MySQL is the most popular database used by PHP.  Its works really well and smoothly with PHP code and is an ideal solution for storing information and utilising that data within your web projects. 

Do you need a database within you website? Database can help with information management and run as a the data source for dynamic websites.   MySQL is the perfect solution for any size application.   Its fast and reliable and best of all easy to use.   

This course covers multiple methods of connecting to a MySQL database.  Avoid the confusion of only one way, we show you three ways to connect to a MySQL database via PHP code.

Top resources, source code and more is provided to get you started quickly.

  • Learn how to connect to a database
  • Create databases
  • Create tables
  • Insert records into a MySQL database
  • Return ids of inserted records
  • Delete records 
  • Update records
  • Create querries to interact with database content
  • phpmyadmin and how to use it

By the end of the course we show how to use a database within your PHP code

I am here to help you learn how to create your own websites and ready to answer any questions you may have.

Want to know more, what are you waiting for take the first step.  Join now to start learning how you too can add a database to your website today.





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Laurence Svekis

Web technology Instructor

Providing Smart digital solutions online since 2001. I am considered a true web technology expert. Having professional experience in a wide range of digital areas. Everything from Search Marketing, Video Marketing, Content creation, User Experience, application architecture, and web programming.

Understanding how users flow through the web and learning what drives users to interact online has been the cornerstone of what I do. The more seamless the process the better the user experienc...

See full profile

Report class