
Create a PHP and MySQL project by configuring config.php for database connection, handling errors with try/catch, and creating the short URLs database in phpMyAdmin, then include config in index.
Learn to build a PHP with MySQL URL shortener: insert URLs via a post form using PDO, store in a URLs table, display original and short URLs, and track clicks.
Learn how to send emails from a PHP app using the PHP Mailer library with Gmail SMTP, including setup, configuration, and debugging.
Follow along as we create an authentication system using PHP and MySQL, with bootstrap tips to get you started.
Build a simple blog post system with comments on top of the authentication system, using Ajax and jQuery for form submissions, turning it into a basic CMS.
Build a post creation form with title, body, and a hidden user name from the session; submit to create a post stored with timestamp and viewable on the index page.
Delete a comment with Ajax and jQuery by sending the comment id to a delete comments endpoint. Implement a button that passes the id and shows a success message.
Fixes a bug that showed the delete button for comments to other users by comparing the session username to the comment author and displaying the delete option for the creator.
Insert post ratings into a MySQL database using PHP and Ajax, storing post_id and rating in a ratings table with a timestamp via a jQuery form submission.
Build a live search feature in a PHP and MySQL project using ajax. Use a header search form and a footer script for real-time results with like and wildcards.
Do you want to develop your skills further as a developer? Did you build a couple of projects with PHP and MySQL, but you still think you are inexperienced and you are missing out on a lot of things when coming to developing bigger projects? If yes, then this course is the right resource for you. This course is very digestible and informative and it was created specifically to enhance your coding skills and knowledge not just in PHP and MySQL, but overall in developing web projects.
Here is what we are going to do in this course. Naturally, we are going to get started by setting up the right tools for our projects. And after that, we are going to build our first simple yet very interesting project and that's a URL shortening service. The second project will be about sending emails in PHP and that's very important because it's a feature that almost every website has. The next project will be the starting of something big because it's an authentication system where I am going to teach you how to develop a login and a register page, how to hash and de-hash passwords, how to do validation and so much more. After this, we are going to build a comments system and this will be the biggest project in this course. We will begin first by doing a post system and then we will grab comments for every post that we have of course we will use Ajax-JQuery for inserting, deleting, and showing comments. after that, we will integrate a rating system into the previous two projects to make a bigger project. So, I will show how to download a JQuery plugin, how to integrate it and how to use it to do the rating system for every post, and so on. And the rating system is going to be implemented of course using Ajax-JQuery. The upcoming project is going to be also created with Ajax and JQuery and that's a live search system and we will combine it with our big project. The last project will be about building a weather app. All we are going to do is set up a form, allow the user to enter a city, and then give him the current degree of this city. So we will use an API to grab the current degree for this city. If that sounds like something that you are interested in, go ahead and get the course now. see you inside!!