Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 2 Minute(s)
Language
English
Taught by
Laurence Svekis
Rating
2 views
Course Overview
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 queries 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.
Course Content
- 7 section(s)
- 39 lecture(s)
- Section 1 Learn how to connect and use mysql database from PHP
- Section 2 PHP and Database access
- Section 3 PHP MySQL working with Databases MySQLi Procedural
- Section 4 PHP MySQL working with Databases MySQLi Object Oriented connection
- Section 5 PHP MySQL working with Databases PDO connection
- Section 6 PHP MySQL connection Resources
- Section 7 Bonus Section
What You’ll Learn
- connect web pages to a mysql database, update insert delete and use mysql database content, connect to MySQL using procedural methods, connect to MySQL using mysqli object methods, connect to MySQL using PDO methods
Skills covered in this course
Reviews
-
RRob Nieves
Very clear and to the point. It's an easy-to-follow, and well-organized course. I appreciate shorter courses.
-
DDevasena Radhakrishnan
Provides basic understanding to use Database from PHP
-
AAnonymized User
So far, the instructor has been able to keep me in the "happy mode". His tutorial instructions are straight-forward, easy to follow, and in keeping with my well aged, slow learner disadvantage. :)
-
GGary L. Whitney
The course ended abruptly almost like it was unfinished. Pros: Course provided procedural, object, and PDO examples. It included some help on getting XAMPP installed. Lessons are short and without homework. Cons: There weren't many questions even though the course is several years old. I usually learn almost as much from the Q&A as the content.
