Building A Custom Dynamic Blog Website with PHP, MySql and Jquery | Parth Modi | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Building A Custom Dynamic Blog Website with PHP, MySql and Jquery

teacher avatar Parth Modi, A passionate student, programmer & tutor

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

29 Lessons (6h 6m)
    • 1. A Warm Welcome

      1:51
    • 2. Windows - Environment Setup

      4:42
    • 3. Mac - Environment Setup

      3:35
    • 4. Installing the Templates

      13:51
    • 5. Customizing the Templates

      9:54
    • 6. Creating the Admin Interface

      25:39
    • 7. Building the Database

      13:00
    • 8. Establishing a connection between the database and website

      4:59
    • 9. Add Category Functionality P1

      17:14
    • 10. Add Category Functionality P2

      20:00
    • 11. Write A Blog Page

      26:16
    • 12. Adding Images to the Blog

      17:51
    • 13. Blog Admin Sessions

      17:26
    • 14. Blogs Management

      15:10
    • 15. Edit Blog Post Page P1

      17:43
    • 16. Edit Blog Post Page P2

      17:58
    • 17. Tags and More Sessions

      7:30
    • 18. Summernote - API Integration

      7:28
    • 19. Blog Website Home Page P1

      12:47
    • 20. Blog Website Home Page P2

      6:03
    • 21. The Blog Header

      5:42
    • 22. The Blog Categories

      6:17
    • 23. Single Blog Page

      21:53
    • 24. Displaying all Comments

      16:25
    • 25. Add Comments Functionality

      24:09
    • 26. Reply To Comments Functionality

      14:01
    • 27. Search Blogs Functionality

      6:33
    • 28. Deploying the Website

      9:20
    • 29. Conclusion

      0:35
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

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.

57

Students

--

Projects

About This Class

Build your very own beautiful dynamic blog website with an admin panel customized to your needs.

Blogging is one of the most common ways to generate passive income while doing something you enjoy - writing. You will be guided step by step in the creation of your own custom blog website, which you can either use for your blog or outsource to friends, family, and anyone else. Furthermore, the skills you learn in the course will enable you to build platforms such as e-commerce stores, complex web applications and much more. 

In my opinion, learning happens best by building something, so I have designed and structured this course where you'll build something fun while learning new skills. 

We'll take a look at:

  • Installing templates
  • Customizing the templates according to our requirements
  • Developing our database based on industry standards
  • Connecting the web project with the database
  • Adding admin functionality and creating the interface
  • Linking the admin panel with the front-end blog pages
  • Debugging code when errors are encountered
  • Adding extra functionality and features as finishing touches

It is not necessary to have a background in web development to take this course, but programming experience is recommended. In this class, I have attempted to explain the steps and processes as clearly and thoroughly as possible.

Link to Class Resources

Please feel free to contact me if you have any questions or concerns, I'd be delighted to help. Looking forward to having you along for the ride.

Meet Your Teacher

Teacher Profile Image

Parth Modi

A passionate student, programmer & tutor

Teacher

Hello, I'm Parth. I’m a passionate student, web developer, and a tutor. I’m a self-taught programmer primarily focused in web development. I have over 5 years of experience in web development and would love to share some of the knowledge and experience gained with you.

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

28. Deploying the Website: Hi everyone and welcome back to the course. So in the last video, we finished up making our website. And now in this video I'll be showing you how to deploy so that the world can see your beautiful creation. So the first thing that we're gonna do is open up a browser. I'm going to open up Chrome. Then I'm going to search for zeros 0000 web hosting. There it is. And this is the website that we'll be using to host for websites. And this is of course free. So as you can see, we're going to be using this option right here for you about posting. It gives us one website and 300 megabytes of space. Now of course, if you're going to be using this website professionally or are you're going to be using it as a platform, then I would recommend you to use a paid option because it offers you more features, it offers you more security and its overall better. But for the demonstration in this, radiologists be using to free web hosting. So let's go ahead and click free signup and ongoing to login with Google. And okay, so it logged in with my default Google account. Let's just wait for it to load up. Here it is. So if yours doesn't work, then I would recommend, I think you need to sign up with Google first. I'd already done this, which is why I already have my username as well. So once you're on this homepage of zeros 0000 web host, or we're gonna do is we're going to click create new site. And I'm going to call this parts blog, website. Something like that. You can give it your name. And of course this is not going to be a.com domain because we didn't buy a domain. We're just using the free web hosting domain that it's going to give us. And it's going to have this at the end. So 000 000 web host app.com. Let's leave it to create a random password. And let's click Create. There you go. So it created our website parts blog website. And if you're not on this page, you might be on the homepage again and then it shows you the website here shows you the status and we can go to the link. And there you go. So that's our domain right now. Temporarily, unless you buy one, and then you can customize it to whatever you would like. So that's going to be our website over here. And then we can go in and click Manage website. And now there's two things that we will need to do to upload our entire work on line 2, 000 000 web host. First thing we're gonna do is let's see, let's go to File Manager. I'm going to open it and let me wait for this to load up. And haired loads up. And now what we're gonna do its side public underscore HTML. You should have this folder as well. Inside this folder we have HT access file. That's okay. We can just leave it how it is. Okay, so now what I'm gonna do, I'm going to navigate to my folder where my website is stored. So that's documents exempt HT docs and blog. And now we can actually just drag our files in here, the files that we need. So let's say we need about dot PHP. I can say about up PHP and then upload it. And it should pop up here. What we can also do is bulk upload. So I'm going to select all the PHP files that I need to upload like that. Let's see, single blog dot PHP as well, and then styles.css. And now I'm going to drag all of them together. And I'm going to click Upload. And it's uploading them one by one. So that's okay. We can wait there, you know, and I see that I accidentally got styles dot HTML. I don't need it. I'm going to delete it out. So once all these files are done, I'm going to go ahead and actually upload all the folders. So I'm going to select all of them. I'm going to say Copy. And then let's go ahead and click Upload. And now this is going to take awhile because it's going to upload a lot of files and make all the folders so we can make for that. There's another way to do this. What we could do is actually make a zip out of all the files together. But that usually give sometimes an error in the fall manager of web host, which is why I try to avoid it sometimes. But of course, if you have a large number of files, then that would be more handy. So let's just wait for this to finish uploading and then I'll get back to you. Okay. So just finished uploading all the files. I think it took about four or five minutes. And that's all right. We can just go in and quickly check if the admin fellows are here. All right, It's looking good and maybe that includes folder as bulk looking good. So once we're done that, we can go in and actually check how our websites looking. So what we can do is let's go to parts blog, website, parts blog, website dot 000. Okay, there you go. So we get an error. That's because our database is not set up yet. So let's go ahead and make those changes inside the vh dot PHP, as well as we're going to create a database. So actually I'm known to open up exam first and let's just start to servers. So let's open a new tab. Let's go to localhost slash PHP, my admin. And let's wait for this to load. And here it is. And now our database is called blogs. So what I'm gonna do, I'm going to go to the dashboard of web host again. And I'm going to click Tools, and I'm going to click the database manager. So once we're at the database page in our dashboard, we can go ahead and click new database and then we can give to sw database a name. So I'm going to call them blogs. And then for its username, I'm just going to call it parts blog. And then for the password, Let's see, I'm going to say something like that. And then make sure to follow the guidelines for the password or else it's not going to work. And I'm going to click Create. So let's just wait for this to fully create up. And now we get a progress bar here and we can see our new database name and username and our host. So what I'm gonna do is actually copy the database name. Insight File Manager. I'm going to navigate to the admin folder. And inside that we have includes, and then we have DBH dot PHP. So this is the fall that's generating our connection to the database. So what we can do is, so what did I copy? I copied the database name so I can put it instead of, instead of blogs that we hear. So that's how database name is going to be. And then for the username I'm going to copy it to. And I'm going to paste it in sit instead of fruit. And for our server name we can leave it as localhost and I'm going to type in my password here. So once we are done typing our password as well, we can click Save and Close. And now it should be done. And let's see, for database has been created a small, we can visit the PHP, my admin for this. And here it is. There's our database name and we can click it. And right now we shouldn't have any tables inside could we haven't created any. And now if we go and click Refresh on our website, their ego. So our website is basically showing up right now. Of course, there's no content in the database, which is why we're getting the errors for now, that's what we're going to do. I'm going to go to my PHP, my admin for my exam, and I'm going to go into the blogs database. So over here we're going to go to the export tap and I'm going to say Custom Export. And now we can select all of the tables W when I export with their structure and data. And let's keep scrolling down. We can leave all this to their default. And actually we want to give this a name. So this is going to be called blogs, right there. Don't forget to add that. And we can keep scrolling down and we can go ahead and click Go. And there you go. It says that blogs dot SQL was downloaded. And now if we go to our PHP, my admin of far web host, inside there we can go to the import tab. And inside this tab we can choose our file. And I'm going to select blogs and SQL. And let's go ahead and click. Go. There you go. Let's wait for this to finish importing. It's going to import all the tables as well as their rows. So as you can see, it shows that it has imported many, many and it's still importing, I think. So let's just wait for it a little more. And now once we're done, all the import, as you can see that we have our tables right here. So if I click blog category, There you go. All our rows are in here. If we click blog comments, we should also have all the rows. Here it is, and our blog posts, Let's check it out. There you go. All their blog posts are here as well. And of course our blog tags should also be there. Here it is. Perfect. So once we're done importing it now we can go ahead and click Refresh again on our website. And there you go. It's working as it was, but now it's live on the web for anyone to look at. And we can also go ahead and actually try out some functions if everything's working fine, we can click a blog post, nice and snappy. We have all the comments. So that's awesome. We are done deploying our website online. And that's how you basically do it with any hosting providers that you may use. It's pretty similar process. So that's it for this video and see you soon.