مطالب پیشنهادی از سراسر وب

آموزش پیشرفته PHP و MySQL همراه با پروژه

دسته بندی ها: آموزش مای اس کیو ال (MySQL) ، آموزش پی اچ پی (PHP) ، آموزش طراحی وب ، آموزش های یودمی (Udemy) ، آموزش پایگاه داده

این آموزش تصویری مباحث پیشرفته در PHP و MYSQL را همراه با چند پروژه به شما آموزش می دهد.

این دوره آموزشی محصول موسسه Udemy می باشد.

سرفصل های دوره:

  • آغاز به کار PHP
  • مبانی 
  • ایجاد پایگاه داده
  • کار با PHP Quizzer
  • اتصال به پایگاه داده
  • واکشی داده ها از پایگاه داده
  • ایجاد کلاس پایگاه داده
  • مدیریت UI
  • به روز رسانی و حذف وبلاگ
  • صفحه داخلی HTML
  • اضافه کردن CSS
  • ایجاد کلاس کاربر
  • نصب و پیکربندی Codeigniter
  • راه اندازی بانک اطلاعاتی
  • کار با HTML داخلی و CSS
  • معرفی Paypal
  • نصب وردپرس
  • کار با ساختار پلاگین وردپرس
  • ارسال با JQuery و Ajax
  • پیکربندی پایگاه داده
  • و...

عنوان دوره: Udemy Projects in PHP and MySQL

توضیحات:

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 88 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

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 Get and Display Products 23:36 Learn to query for categories and popular products from the database. 42 Get categories and popular products 13:35 This module allows adding of categories and popular products to the website. 43 Cart & Payment 20:22 Learn to implement the shopping cart and payment class. 44 Users 21:02 Learn to implement the user management module with this lecture. 45 User Login and Logout 15:08 Learn to do the session management and login-logout feature for your website. 46 Paypal Checkout 28:00 Implementing paypal checkout in our website SECTION 7: Project 6 - Wordpress Contact Widget 47 Install Wordpress 06:45 Learn to install WordPress locally in your server 48 Wordpress Plugin Structure 14:39 Understand the Plugin structure with this comprehensive lecture. 49 Create Widget Class 22:22 Learn to build the Widget class for our project 50 Post with JQuery and Ajax 14:11 Learn to add Post with JQuery and Ajax 51 Build PHP Mailer 11:18 Learn to implement PHP mailer in our widget. SECTION 8: Project 7 - Addressbook 52 Create Structure 07:05 The lecture describes the structure for the address book website 53 Address book foundation UI 17:15 This lectures teaches the creation of UI for our application 54 Database and Config 20:46 Design the database and configure it as per the project specifications. 55 Select and Add contacts 17:41 Implement Selection and Addtion of contacts to the address book 56 Edit and Delete Contacts 21:26 Implement the editing and deletion of contacts using a panel 57 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 58 HTML Layout 15:54 This lecture deals with UI building and HTML creation of the Jobs Board project 59 Part 2 CSS 13:02 Implement the CSS of the project 60 Inner page HTML 09:52 Learn to build the Inner page HTML of the site 61 Database Installation and Config 14:38 Create the config file for your database 62 Jobs Display 13:29 Learn to display the Job entries. The lecture shows the Controller and Views 63 Layouts and Elements 19:22

Add layouts and elements to the Job Post page. 64 Browse Controller and View 19:34 This lecture shows the implementation of the browse controller and views 65 Search and Filter 21:52 Search and Filter implementation. 66 Add, Edit and Delete Jobs 18:00 Addition, Editing and Deletion of Jobs from the website 67 Update and Delete Jobs 10:29 Update and Deletion of Jobs 68 User Aunthentication 18:31 Learn to Implement the User Aunthentication 69 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 70 Code Igniter Install and configure 13:37 Code Igniter installation and configuration for the project 71 Kewl CMS UI 12:09 Building the UI for our CMS. 72 Inner page and Login UI 09:38 Implement the inner page HTML and Login UI 73 Create Kewl Database 08:11 Learn to implement the database of the project 74 Frontend Articles and Views 20:27 Frontend Articles and view implementation for the CMS 75 Front end Inner pages 06:33 Front end and inner pages creation for the website. 76 Admin Dashboard and Layout 19:43 Learn to create the admin dashboard panel for the CMS. 77 Admin Articles and categories 14:01 Learn to add articles and categories to your Admin panel. 78 Articles Update , Publish and Delete 06:37 Articles update, publish and delete through admin panel. 79 Categories 10:11 Learn to add categories logic to the CMS 80 Search and Filter 04:21 Learn to implement search and filter option to your site. 81 Users and Groups 16:03 Build the user and groups inside the user management module. 82 Aunthentication 14:51 User authentication module creation. 83 Access Control 04:10 The final lecture to handle access rights of various users. SECTION 11: Project 10 - TGP Wordpress Plugin 84 Create Plugin File & Menu item 10:44 Lecture teaching the creation of Plugin file and Menu item. 85 Create Plugin Options Form 12:23 Learn plugin options form creation. 86 Storing Options value 11:53 The lecture explains the option handling for the plugin 87 Display Plugin Data 17:01 learn to display Plugin data to user. SECTION 12: Course Summary 88 Summary 04:29 The complete course summary.

حجم فایل: 3.8GB

آیا این نوشته را دوست داشتید؟
Udemy Projects in PHP and MySQL

پیشنهاد آموزش مرتبط در فرادرس


بهنام 3 سال و 4 ماه قبل

سلام چرا هر چهار پارت یک چیز رو میده موقع اکسترکت کردن

مدیر 3 سال و 4 ماه قبل

فایل اصلی به چند قسمت تقسیم شده و بعد از اکسترکت قسمت اول تمام پارت ها باهم اکسترکت میشه.

مجتبی 4 سال و 6 ماه قبل

شما فوق العاده این

ایمل 5 سال و 9 ماه قبل

با عرض سلام خدمت شما لطفآ فایلها تمرین exercise files این آموزش را به تنهایی آپلود کنید.

مرتضی 6 سال و 1 ماه قبل

سلام خسته نباشید این آموزش آیا فارسی هست!

احسان 6 سال و 3 ماه قبل

این بهترین آموزش php بود که تا حالا دیدم. تشکر از شما که این آموزش رو آپلود کردید.

saeed 6 سال و 3 ماه قبل

با سلام
این آموزش فرقش با این پایینی چیه ؟ البته حجم گیگابایت انها هم یه ذره فرق میکند
http://git.ir/12323/web-development/css/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%DA%A9%D8%A7%D9%85%D9%84-%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87-%D9%86%D9%88%DB%8C%D8%B3%DB%8C-%D9%88%D8%A8-%D8%A8%D8%A7-php-%D9%88-mysql/

مدیر 6 سال و 3 ماه قبل

برخی از مباحث در دوتا دوره مشترک هستند اما این آموزش نسبت به قبلی جدیدتر و پروژه های آن نیز متفاوت است.