پیشنهاد فرادرس

آموزش کامل برنامه نویسی وب با PHP و MySQL

دسته بندی ها: آموزش CSS ، آموزش طراحی وب ، آموزش پی اچ پی (PHP) ، آموزش HTML ، آموزش جی کوئری (JQuery) ، آموزش وردپرس (Wordpress) ، آموزش های یودمی (Udemy)

PHP و MYSQL متداول ترین روش برنامه نویسی تحت وب می باشد.

در این دوره آموزشی از موسسه Udemy نحوه طراحی وب سایت با PHP و MYSQL همراه با پروژه های عملی آموزش داده می شود.

سرفصل های دوره آموزشی:

  • مبانی  PHP
  • ساخت رابط کاربری
  • ایجاد پایگاه داده
  • اتصال و واکشی نوشته ها
  • اعتبار و درج نوشته ها
  • پروژه PHP Quizzer
  • Quizzer UI - قسمت 1
  • Quizzer UI - قسمت 2
  • اتصال به پایگاه داده
  • دریافت داده ها از پایگاه داده
  • آموزش PHP
  • ظاهر رابط کاربری 
  • ایجاد کلاس پایگاه داده
  • مدیریت رابط کاربری
  • مدیریت پایگاه داده 
  • درج ارسال و دسته بندی
  • به روز رسانی و حذف
  • کار با HTML
  • کار با CSS
  • اعتبار سنجی کلاس
  • نصب و پیکربندی Codeigniter
  • راه اندازی پایگاه داده
  • کار با HTML داخلی و CSS
  • کار با Wordpress
  • نصب Wordpress
  • ساختار Wordpress
  • ایجاد کلاس Widget
  • کار با JQuery و Ajax
  • ساخت PHP Mailer
  • پایگاه داده و پیکربندی
  • طرح بندی HTML
  • پیاده سازی CSS
  • صفحات داخلی HTML
  • نصب و راه اندازی پایگاه داده و پیکربندی
  • پیاده سازی User Aunthentication
  • ساخت رابط کاربری برای CMS ها
  • ایجاد پایگاه داده Kewl

لیست سرفصل های دوره آموزشی:

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

Category: Development / Web Development What are the requirements? Basic knowledge of HTML and PHP What am I going to get from this course? Over 89 lectures and 23.5 hours of content! 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 What is the target audience? 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 CURRICULUM SECTION 1: Getting Started with PHP 1 Course Intro 08:49 Preview Introduction to the Course

2 Environment Setup 08:41 The lecture describe in detail the process of setting up the PHP environment for development

3 PHP Basics 18:28 A quick refresher course in PHP for beginners.

SECTION 2: Project 1 - Shoutit Shoutbox 4 Building the UI 22:23 The lecture describes the process of building the UI for our App

5 Create Database 05:34 Basic Database creation process

6 Connect and Fetch Shouts 13:13 Learn the database connectivity feature for the project

7 Validate and Insert Shouts 16:33 Learn to put databse validations

SECTION 3: Project 2 - PHP Quizzer 8 Quizzer UI - Part 1 22:31 Learn to make the UI for the Quiz app.

9 Quizzer UI - Part 2 13:19 Complete UI for the Quiz App.

10 Connect to database 08:21 learn to use MySQLi to connect to the database.

11 Fetch data from database 21:10 Learn the CRUD operations for the database. Connect and fetch your quiz data from the database

12 Process Answers 25:15 Learn to write the answer processing engine for our application.

13 Add Question Form 23:26 Adding question forms to populate our database.

SECTION 4: Project 3 - PHP Lovers Blog 14 Folder Structure 12:37 This is the first lesson identifying the structure of our Blog App. It will focus on how the app will look like.

15 Frontend UI 22:34 Learn to build the UI of the Blog application. It will focus on twitter bootstrap.

16 Create Database class 33:50 Learn to create the database class for all database operations.

17 Frontend database fetch 32:15 Learn to write the operations for front end database queries.

18 Admin UI 22:51 Learn to create an Admin area for your site.

19 Admin Database fetch 22:49 This module handles the database for your Admin panel.

20 Insert Post and Categories 17:11 Adding Posts and Categories

21 Update and Delete 15:43 Update and Deletion of blogs

SECTION 5: Project 4 - Talking Space Forum 22 The File Structure 18:33 Learn to create a forum in this project. This lecture talks about the internal file structure of the project

23 The UI 17:03 Learn to build the UI of the forum application.

24 Inner page HTML 15:37 Writing the inner page HTML of our project.

25 Adding the CSS 15:56 This lecture add the look and feel to the project using CSS.

26 The Database 16:03 Learn all about the database management for the forum app in this lecture.

27 The Template Class 16:44 Learn to build the template class for the home page.

28 Inner Page Templates 16:20 This lecture teaches the creation of inner page template for the forum

29 The Topic Class 19:35 Learn to write the logic for handling various topics in the forum.

30 Topic with Category Filters 20:47 Adding the categories to the topics. Adding more layers to our app.

31 Single Topic Pages 11:06 Learn to create the single topic pages.

32 The User Class 19:44 This class teaches you the user handling of the your app

33 Validator class 11:26 learn to create the master validator class for your app. It will check for all user validations

34 Login and Logout 16:04 Implementing the sessions and login-logout feature in our App.

35 Adding Topics 26:03 Learn to implement Topics in our forum website

SECTION 6: Project 5 - The Gaming Place - Shopping cart 36 Install and configure Codeigniter 17:01 Learn to build a shopping cart using Code Igniter framework.

37 Database Setup 11:52 This lecture deals with the database structure of our shopping cart project

38 The Gaming Place UI 14:36 This lecture teaches you to create the UI for your shopping cart website.

39 Inner HTML and CSS 18:35 Learn to build the inner page HTML and CSS for the project

40 Views and layouts 21:04 Learn to build views and layouts for our application.

41 Products Display 23:36 This module will handle product display of our website.

42 Get and Display Products 23:36 Learn to query for categories and popular products from the database.

43 Get categories and popular products 13:35 This module allows adding of categories and popular products to the website.

44 Cart & Payment 20:22 Learn to implement the shopping cart and payment class.

45 Users 21:02 Learn to implement the user management module with this lecture.

46 User Login and Logout 15:08 Learn to do the session management and login-logout feature for your website.

47 Paypal Checkout 28:00 Implementing paypal checkout in our website

SECTION 7: Project 6 - Wordpress Contact Widget 48 Install Wordpress 06:45 Learn to install WordPress locally in your server

49 Wordpress Plugin Structure 14:39 Understand the Plugin structure with this comprehensive lecture.

50 Create Widget Class 22:22 Learn to build the Widget class for our project

51 Post with JQuery and Ajax 14:11 Learn to add Post with JQuery and Ajax

52 Build PHP Mailer 11:18 Learn to implement PHP mailer in our widget.

SECTION 8: Project 7 - Addressbook 53 Create Structure 07:05 The lecture describes the structure for the address book website

54 Address book foundation UI 17:15 This lectures teaches the creation of UI for our application

55 Database and Config 20:46 Design the database and configure it as per the project specifications.

56 Select and Add contacts 17:41 Implement Selection and Addtion of contacts to the address book

57 Edit and Delete Contacts 21:26 Implement the editing and deletion of contacts using a panel

58 Edit and Delete Contacts - part 2 07:56 Final lecture describing the addition and deletion of the contacts

SECTION 9: Project 8 - Job Find Jobs Board 59 HTML Layout 15:54 This lecture deals with UI building and HTML creation of the Jobs Board project

60 Part 2 CSS 13:02 Implement the CSS of the project

61 Inner page HTML 09:52 Learn to build the Inner page HTML of the site

62 Database Installation and Config 14:38 Create the config file for your database

63 Jobs Display 13:29 Learn to display the Job entries. The lecture shows the Controller and Views

64 Layouts and Elements 19:22 Add layouts and elements to the Job Post page.

65 Browse Controller and View 19:34 This lecture shows the implementation of the browse controller and views

66 Search and Filter 21:52 Search and Filter implementation.

67 Add, Edit and Delete Jobs 18:00 Addition, Editing and Deletion of Jobs from the website

68 Update and Delete Jobs 10:29 Update and Deletion of Jobs

69 User Aunthentication 18:31 Learn to Implement the User Aunthentication

70 Login and Access Control 12:45 The lecture teaches the proper implementation of session managment and user access control.

SECTION 10: Project 9 - Kewl CMS 71 Code Igniter Install and configure 13:37 Code Igniter installation and configuration for the project

72 Kewl CMS UI 12:09 Building the UI for our CMS.

73 Inner page and Login UI 09:38 Implement the inner page HTML and Login UI

74 Create Kewl Database 08:11 Learn to implement the database of the project

75 Frontend Articles and Views 20:27 Frontend Articles and view implementation for the CMS

76 Front end Inner pages 06:33 Front end and inner pages creation for the website.

77 Admin Dashboard and Layout 19:43 Learn to create the admin dashboard panel for the CMS.

78 Admin Articles and categories 14:01 Learn to add articles and categories to your Admin panel.

79 Articles Update , Publish and Delete 06:37 Articles update, publish and delete through admin panel.

80 Categories 10:11 Learn to add categories logic to the CMS

81 Search and Filter 04:21 Learn to implement search and filter option to your site.

82 Users and Groups 16:03 Build the user and groups inside the user management module.

83 Aunthentication 14:51 User authentication module creation.

84 Access Control 04:10 The final lecture to handle access rights of various users.

SECTION 11: Project 10 - TGP Wordpress Plugin 85 Create Plugin File & Menu item 10:44 Lecture teaching the creation of Plugin file and Menu item.

86 Create Plugin Options Form 12:23 Learn plugin options form creation.

87 Storing Options value 11:53 The lecture explains the option handling for the plugin

88 Display Plugin Data 17:01 learn to display Plugin data to user.

SECTION 12: Course Summary 89 Summary 04:29 The complete course summary.

عنوان دوره:Udemy - The Complete Web Development Course - Learn By Building Apps حجم فایل: 3.88GB

Udemy The Complete Web Development Course Learn By Building Apps

پیشنهاد فرادرس