Complete Website & CMS in PHP & MySQL From Scratch!

A Web Development Project (CMS) Using PHP, MySQLi with Admin Panel, Commenting System & Dynamic Website from Scratch.
4.2 (77 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,314 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 48
  • Length 12.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

Course Description

Learn to create a beautiful dynamic website with content management system (CMS) in PHP & MySQLi from absolutely scratch, this course covers both back-end and front-end web development.

Building a Website & CMS in PHP & MySQLi:

If you want to create a category based news website or any kind of blog website in PHP & MySQLi which can be dynamically updated from Admin Panel then this course is for you, it will show you step by step how to create such system using simple PHP functions.

Some of the Important Topics We'll Cover in This Course:

  • Creating the Website Layout in CSS3 & HTML5
  • Creating the Admin Panel
  • Inserting & Displaying the Posts & Categories
  • Creating the Commenting System
  • Uploading the Whole CMS to Online Server


Overview & Summary:

With over 12 hours of content and 50+ lectures, this course proudly teaches you creating a complete website and content management system in PHP & MySQL from scratch, the course is for absolute beginners who want to create a big project in PHP & MySQLi in order to take their web development skills to the next level. This course gives you step by step environment to create a dynamic website in PHP, after completing the course, you'll be able to remember every code that was written during the course. And the source code is also attached to the last lecture of the course.

If you are looking for a course which can teach you a perfect website in simple PHP functions then don't waste your time and money on the internet, just join the course and you'll be amazed. Furthermore, this course will be updated with more features.

What are the requirements?

  • XAMPP (PHP,MySQL, Apache)
  • Web Server
  • Dreamweaver CS5 or Notepad++
  • A browser (Chrome or Mozilla)

What am I going to get from this course?

  • Create a Dynamic Category Based Website & CMS From Scratch Using PHP & MySQLi
  • Learn to Create an Admin Panel from Scratch in PHP & MySQL
  • Build a Custom News Portal with Custom Commenting System in PHP & MySQL

What is the target audience?

  • If you want to create a dynamic website using PHP & MySQL from scratch then you should buy this course.
  • This course teaches everything from scratch about creating a dynamic website & CMS in PHP/MySQL

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome to the Course!
04:55

in this introductory lecture, I'll tell you about the project that we are going to create using PHP & MySQLi from absolutely scratch.

03:23
In this welcome note, please note few things before going to start learning this course.
Section 2: Setting up Folders & Creating the Layout
06:15

In this lecture, we'll learn about installing the XAMPP package for this project which allows you to use PHP, MySQL and some other web development tools altogether.

Article

Download the XAMPP & notepad++ from the links given in this text lecture.

06:31

In this lecture, we'll create the necessary folders for this project.

Article

Create the project folders as mentioned in this text lecture.

07:37

In this lecture, we'll learn to create the main index page for the website to be displayed to the visitors.

31:44

In this video we'll learn about creating the main website layout for this project using HTML & CSS.

09:34

In this lecture, we'll learn to create the navigation bar for this project using CSS & HTML..

26:40

In this lecture, we'll learn to add the categories from database table to the menu bar as links, and we'll first time use PHP & MySQL in this video.

05:35

In this lecture, we'll create a search box or search engine and will display that at the right side of the navagation bar.

06:55
This is the updated lecture for using MySQLi Connection API in PHP.
4 questions

Answer some of the questions you know from the section 2.

Section 3: Displaying the Content on the Website
06:37

In this lecture, we'll create a table inside the mysql database in order to save the posts which we can later on display on the home page of the website.

31:22

In this lecture, we'll learn to create the post editor for this project using PHP, we'll do the HTML work in this lecture and the PHP work in the next lecture.

28:09

In this lecture, we'll learn to insert the posts into the table using PHP & MySQL via the text editor we created in the previous lecture.

31:15

In this lecture, we'll learn displaying the posts on the home page of the website using PHP & mySQL.

37:18

In this lecture, we'll learn to display the posts on the home page and also design the post_content area in order to make it perfect & beautiful.

09:53

In this lecture, we'll learn to separate the sections of the home page into pages and then include them using PHP "include" command.

23:23

In this lecture, we'll start working on the sidebar of the main website.

13:55

In this lecture, we'll add content to the sidebar using PHP and will also style it up using CSS.

13:50

In this lecture, we'll learn to create the details.php page for displaying the single posts when visitors click it from the home page of the website.

12:28

In this lecture, we'll learn to get the posts for specific category using PHP & MySQL.

02:52

In this short lecture, we'll work on the footer of the home page to make it looking attractive.

17:06

In this important lecture, we'll create the comment form for the commenting system to receive comments by the visitors.

30:07

In this important lecture, we'll learn to insert the comments into the database which we can later on display on the associated posts after approval.

22:26

In this last part of the commenting system, we'll display the approved comments on the posts where they were posted by the visitors.

10:33

In this lecture, we'll learn to create the custom search engine for this project in PHP.

8 questions

Please Answer some questions related to section 3.

Section 4: Creating The Admin Panel
18:19

In this lecture, we'll learn to create the main layout for the Admin Panel using HTML & CSS.

16:48

In this lecture, we'll learn to add links & different content to the admin panel.

11:49

In this lecture, we'll learn publishing new posts directly from the Admin Panel using the same post editor we created earlier.

28:21

In this lecture, we'll display all the posts we have in the table in Database to view them in the Admin panel using PHP & MySQL.

13:45

In this lecture, we'll learn to delete the posts from the Admin Panel using General User Interface we created using PHP & MySQL.

17:57

In this lecture, we'll work on editing & updating the existing posts in our table using the Admin Panel general user interface we created in PHP.

21:31

In this lecture, we'll learn how to edit & update the posts using Admin Panel GUI, we'll use PHP script to do all the tasks.

09:29

This is the last part of editing & updating posts using the Admin Panel General User Interface in PHP.

12:04

In this lecture, we'll learn to add new categories using admin panel general user interface in PHP.

26:15

In this lecture, we'll learn to delete categories using the GUI Admin Panel, and we'll do it in simple PHP.

14:56

In this lecture, we'll learn to edit categories using the Admin Panel general user interface we created in PHP.

17:01

In this lecture, we'll learn about viewing comments in the Admin Panel which are posted by the visitors on different posts, we can approve comments & also un-approve the comments.

15:28

In this part, we'll particularly work on approving and un-approving comments concept using PHP.

11:59

In this lecture, we'll use Admin Panel (GUI) to delete comments if we want.

26:14

In this lecture, we'll learn to create the login system for this Admin panel so only the person who has a password and user name can access this admin panel. We'll create it in PHP.

25:50

In this important lecture, we'll create the login & logout systems for this admin panel in PHP.

18:33

In this lecture, we'll learn how to secure the admin panel so hackers can't access it.

10:12

In this lecture, we'll create & add a counter to the home page of the website so it can count the visitors & page viewews.

7 questions

Please answer these questions related to sectoin 4.

Section 5: Uploading the CMS to online web server
25:58

In this lecture, we'll finally upload the whole created CMS from Local host to online web server using Cpanel.

Please find the Source code for the whole project attached to this lecture, click the downloadable files.

01:38
Thank you very much for joining this course, feel free to write your review after completing the course!
5 questions

Please answer some questions related to section 5.

2 pages

Find a quick and win-win bonus for yourself in this special lecture.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Abdul Wali, SEO Marketer & Top Udemy Instructor

Abdul has successfully ranked hundreds of keywords in Google without any backlinking strategy. He is in the SEO and online marketing industry since 2009. Apart from SEO and marketing, he loves web development. WordPress is the core platform which Abdul has been using for creating top notch websites over the years. 

Abdul has established several successful startups such as OnlineTuting (An elearning system), OnlineUstaad (The largest hub of Urdu courses), Wali Solutions (Provides A to Z web solutions).

He is one of the top Udemy Instructors with 45,000+ students and 1900+ reviews. He engages with students on Udemy in real time and answers questions within minutes. If you have any question in mind then don't hesitate to ask Abdul via private message. 

Ready to start learning?
Take This Course