PHP MySQL database connections Premium class

Laurence Svekis, Web technology Instructor

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

    • 1 Course introduction mysql databases and PHP

    • 2 Resources and Setup Information

    • 4 How to Create a database

    • 5 MySQLi Procedural database connection

    • 6 MySQLi Object Oriented connection

    • 7 PDO connection

    • 8 Create a SQL query to create a database

    • 10 How to create a table mysqli

    • 11 PDO create Table

    • 13 Insert into database MySQLi

    • 15 mysqli insert id return id value

    • 16 Select from database PHP query

    • 18 DELETE row from MySQL

    • 19 Update content in your database

    • 20 How to create query strings with phpmyadmin

    • 22 Insert query multi query into Mysql Object Oriented Connection

    • 24 Query Selection Object Oriented PHP connection

    • 26 Delete from mySQL database

    • 27 Update data in your database

    • 29 PDO connection insert Data

    • 30 Insert Into Database PDO connection

    • 32 Select data from database

    • 33 Delete rows using PDO connection

    • 34 Update mySQl database

    • 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.






Reviews (0)

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 experience and the more likely they are to interact again and share their experiences.

After launching my first websites I quickly realized that to get traffic on your site you need to be able to market online. Research and using personal experimentation as to what are the most successful ways to effectively drive traffic to my websites, I was able to successfully build multiple success eCommerce sites. I used my expertise to provide Search Engine Marketing Services SEO to 100's of clients.

In the advent of Social Media in 2006, I had identified it as an excellent opportunity to drive traffic and connect with users. I created many successful sites that integrated with Myspace and then later into Facebook. I was able to monitize the traffic on several platforms, driving in some cases 10K+ clicks daily to the various platforms. I continued to perfect the art of Internet marketing and adapt to new technology and changes.

In 2008 I created my first YouTube video, and channel. Realizing that there was another great opportunity with video I have been experimenting with video marketing and video monization. Youtube being the second largest search engine has a very bright future. As technology progresses the trend has always been quicker, easier means of delivering content always wins out. Images beat out text as they are easier and quicker for us to process, videos beat out images being the most efficient means of getting content to users. As bandwidth increases, and more platforms that can even easier deliver videos become available videos will be the trend for the future.

Understanding technology provides a means to better connect with users.

Applications I've created have entertained, informed and engaged tens of millions of people. I have over billions of page views on various platforms, and have sent millions of click through visitors.

I have developed hundreds of web applications, from micro sites to enterprise level platforms.