Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Life Purpose Personal Transformation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Web Development MySQL

Projects in PHP and MySQL

Master PHP-MySQL by Building 10 Projects
Rating: 4.7 out of 54.7 (946 ratings)
12,281 students
Created by Eduonix Learning Solutions, Eduonix-Tech .
Last updated 12/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • To Learn Web Programming Technologies such as PHP, MYSQL, JavaScript and JQuery
  • Build Practical projects during the course
  • Learn about popular web frameworks
  • Learn the software development process

Course content

11 sections • 78 lectures • 19h 48m total length

  • Preview08:49
  • Preview08:41
  • PHP Basics
    18:28

  • Building the UI
    22:23
  • Create Database
    05:34
  • Connect and Fetch Shouts
    13:13
  • Validate and Insert Shouts
    16:33

  • Quizzer UI - Part 1
    22:31
  • Quizzer UI - Part 2
    13:19
  • Connect to database
    08:21
  • Fetch data from database
    21:10
  • Process Answers
    25:15
  • Add Question Form
    23:26

  • Folder Structure
    12:37
  • Frontend UI
    22:34
  • Create Database class
    33:50
  • Frontend database fetch
    32:15
  • Admin UI
    22:51
  • Admin Database fetch
    22:49
  • Insert Post and Categories
    17:11
  • Update and Delete
    15:43

  • The File Structure
    18:33
  • The UI
    17:03
  • Inner page HTML
    15:37
  • Adding the CSS
    15:56
  • The Database
    16:03
  • The Template Class
    16:44
  • Inner Page Templates
    16:20
  • The Topic Class
    19:35
  • Topic with Category Filters
    20:47
  • Single Topic Pages
    11:06
  • The User Class
    19:44
  • Validator class
    11:26
  • Login and Logout
    16:04
  • Adding Topics
    19:48

  • Install Wordpress
    06:45
  • Wordpress Plugin Structure
    14:39
  • Create Widget Class
    22:22
  • Post with JQuery and Ajax
    14:11
  • Build PHP Mailer
    11:18

  • Create Structure
    07:05
  • Address book foundation UI
    17:15
  • Database and Config
    20:46
  • Select and Add contacts
    17:41
  • Edit and Delete Contacts
    21:26
  • Edit and Delete Contacts - part 2
    07:56

  • HTML Layout
    15:54
  • Part 2 CSS
    13:02
  • Inner page HTML
    09:52
  • Database Installation and Config
    14:38
  • Jobs Display
    13:29
  • Layouts and Elements
    19:22
  • Browse Controller and View
    19:34
  • Search and Filter
    21:52
  • Add, Edit and Delete Jobs
    18:00
  • Update and Delete Jobs
    10:29
  • User Aunthentication
    18:31
  • Login and Access Control
    12:45

  • Code Igniter Install and configure
    13:37
  • Kewl CMS UI
    12:09
  • Inner page and Login UI
    09:38
  • Create Kewl Database
    08:11
  • Frontend Articles and Views
    20:27
  • Front end Inner pages
    06:33
  • Admin Dashboard and Layout
    19:43
  • Admin Articles and categories
    14:01
  • Articles Update , Publish and Delete
    06:37
  • Categories
    10:11
  • Search and Filter
    04:21
  • Users and Groups
    16:03
  • Aunthentication
    14:51
  • Access Control
    04:10

  • Create Plugin File & Menu item
    10:44
  • Create Plugin Options Form
    12:23
  • Storing Options value
    11:53
  • Display Plugin Data
    17:01

Requirements

  • Basic knowledge of HTML and PHP

Description

This is the ultimate course for all web developers who want to learn web programming while building practical projects along with the instructor. This course will help both beginners and experts alike. This course will primarily teach project building using MySQL and PHP but it covers Javascript, JQuery, Ajax, web frameworks, Wordpress and various other popular technologies in great detail.

This course can be done sequentially or you can pick and select the project and start working on them directly. These projects are all independent of each other. Besides the royalty free code can be used for any of your personal projects.

Project Details:

Shoutit Shoutbox

Description: Shoutit is a PHP powered shoutbox which uses mySQL to store shouts. This is a very basic PHP/MySQL
application. It is strictly procedural coding and uses the mysqli api

Features/Technologies:
PHP Syntax, PHPMyAdmin, MySQL Select, MySQL Insert, Loops, Superglobals (GET, POST), Associative Arrays, HTML/CSS

PHP Quizzer

Description: Quizzer is a simple PHP/MySQL based quiz engine. it uses multiple choices and admins can create
new quizes from within the browser

Features/Technologies:
PHP Syntax, PHPMyAdmin, MySQL Select, MySQL Insert, Loops, Superglobals (GET, POST), Associative Arrays,
HTML/CSS, Includes, Math Functions

PHP Lovers Blog
Description: This blog project is much more advanced than the earlier projects. We create a fairly large blogging
system. We create an admin section to add posts, delete posts as well as update them. We take our first look
at using libraries and classes in OOP as we create a completely custom MySQLi Database class. We also create
custom helper functions

Features/Technologies:
PHP OOP, PHPMyAdmin, MySQL CRUD, Loops, Superglobals (GET, POST), Associative Arrays, Bootstrap Framework

TalkingSpace Form

Description: Here we step up our coding standards and completely separate logic from display. We create a PDO
database class along with 3 or 4 other classes including Topics, Users and a Validator class for form validation

Features/Technologies:
Separate Logic & Display, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Loops, Superglobals (GET, POST), Associative Arrays,
Custom Template, User & Topic Libs, Sessions, Bootstrap Framework

The GamingPlace Shopping Cart

Description: This is an ecommerce-based MVC web application written with the Codeigniter framework. We utilize many of
Codeigniters libraries, helpers and structure. Users can register, add products to their cart and checkout using PayPal

Features/Technologies:
Codeigniter, MVC, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Sessions, PayPal Express Checkout API

Wordpress Contact Widget

Description: We will create a plugin/widget for Wordpress that will allow us to put a small contact form in any widget position in the template. It
gives users an easy way to get in touch. The widget will have options in the backend like recipient and subject

Features/Technologies:
Wordpress Platform, Wordpress Plugin API, Wordpress Widget API, PHP OOP, PHPMyAdmin

AJAX Address Book

Description: A completely custom addressbook application written in PHP along with jQuery and Ajax. Ajax is used to fetch contacts as well as add and edit them.
We use the "Foundation" HTML5 framework for the application's user interface.

Features/Technologies:
Foundation Framework, Ajax, jQuery, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Superglobals (GET, POST), Associative Arrays

JobFinds Job Board

Description: This is a fairly large project in which we will be using the CakePHP framework to build a job board. Users can register and login
to add a job. We also implement search & filter to narrow down job searches by keywords, location and category. We use the Kickstart HTML5 framework for UI

Features/Technologies:
CakePHP, MVC, Kickstart, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Superglobals (GET, POST), Associative Arrays

Kewl CMS Content Management System

Description: Kewl CMS is a Codeigniter based application for managing website content. We will build both frontend and backend. Bootstrap will be used for UI

Features/Technologies:
Codeigniter, Bootstrap, MVC, PHP OOP, PHPMyAdmin, PDO & Perpared Statements, MySQL CRUD, Superglobals (GET, POST), Associative Arrays


Wordpress Bridge Plugin for TGP

Description: We will build a Wordpress plugin that will allow us to connect to the "TheGamingPlace" database and display a set number of products in
a Wordpress page using a custom shortcode

Features/Technologies:
Wordpress Platform, Wordpress Plugin API, Wordpress Widget API, PHP OOP, PHPMyAdmin

Who this course is for:

  • Developers who quickly want to pick up project building skills.
  • Expert programmers who want to use specific project code and build on top of it

Featured review

Darren Jewell
Darren Jewell
210 courses
62 reviews
Rating: 5.0 out of 52 months ago
I have worked through the tutorials on W3c and wanted to build a few projects before I take the exam and this course is great. It's hard to think of ideas sometimes so this is brilliant. Well done Brad

Instructors

Eduonix Learning Solutions
1+ Million Students Worldwide | 200+ Courses
Eduonix Learning Solutions
  • 3.9 Instructor Rating
  • 87,556 Reviews
  • 1,215,650 Students
  • 244 Courses

Eduonix creates and distributes high quality technology training content. Our team of  industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world.  We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Eduonix-Tech .
E.
  • 3.9 Instructor Rating
  • 70,825 Reviews
  • 1,191,835 Students
  • 184 Courses

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.