MySQL and PHP Fundamentals
3.5 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
95 students enrolled

MySQL and PHP Fundamentals

Create a real life project using MySQL.
3.5 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
95 students enrolled
Last updated 2/2017
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • To learn the basics of MySQL
  • To create your first blog using MySQL
Course content
Expand all 20 lectures 02:31:52
+ Course Introduction
1 lecture 08:53

Hi, this is the first set of tutorials I have created so I made a few mistakes along the way. However, this type of thing happens while programming all the time, so there will be a few good lessons on debugging your code as you progress through the course.

Source code for sections 1 and 2 can be found here.

Preview 08:53
+ MySQL Basics
5 lectures 45:37
Let's get started by creating our MySQL database.
Preview 09:15
We'll insert the data we need to get started. 
Inserting Data
09:57
SQL Injection
10:15
How to use select queries


Select Queries
09:10
More on How to use select queries
Select Queries Part 2
07:00
+ How to Create a Blog with MySQL
11 lectures 01:36:27
A quick introduction to the blog project we're working on. 
Introduction to Creating a Blog
05:05
As always, we start by creating our database. 
Create Your Database
05:40
In this lecture I made an error. I forgot to add:
  • function category_exists($id) {
  • function get_categories($id = null) {

I will discuss these in further detail in the next lesson, so just know that you won't miss this part. 

Beginning to Code (config.php and init.php)
09:01
Coding the add_category.php file. 
add_category.php
10:32
Now we can add categories to our blog. 
Finishing Up Our 'Add a Category' Page
10:36
Next, we'll learn how to add a post. 
Adding a Post
10:56
Finishing up instructions on how to add a post. 
Adding a Post Part 2
07:55
Now we're going to display posts so that readers can actually view them. 
Displaying Posts
10:17
Now we're going to display posts so that readers can actually view them. 
Displaying Posts Part 2
09:37
Working with the category.php and delete.php files is essential to PHP development. 
category.php and delete.php
08:09
Just a few final items to take care of, then our blog will be fully functional. 
Completing Our Blog
08:39
+ Conclusion
2 lectures 00:41
Thanks for taking the course!
Conclusion
00:21
Request a Course
00:20
+ Bonus Material
1 lecture 00:13
Bonus Lecture: Course Discounts
00:13
Requirements
  • A computer
Description

Like us on Facebook and/or Follow us on Twitter. Message us to let us know you liked us, or Tweet us @sr_elearning.

Link to Our Facebook Page

Link to Our Twitter Profile

Stone River eLearning

_____________________________________________________________________________________

Are you interested in MySQL? If so, you're not alone. MySQL is very popular today, and learning MySQL skills will give you valuable job skills.

About This Course

This course is meant for beginners. A basic understanding of PHP and programming in general is recommended, but you certainly don't need it. You will learn how to set up a MySQL database, connect to and integrate with PHP. This MySQL / PHP combination is the foundation of most dynamics wesites these days.

The Project

After we cover some of the basics you'll need to know about MySQL, we'll learn to complete a real life project: A blog. Blogs are database driven, so after you understand how to create one, you will have a good grasp on how to use MySQL for other applications.

Who this course is for:
  • Beginning developers