|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-web-development-course-learn-by-building-apps/
课程评论：没有评论
Coursera PHP 与 MySQL 项目课程总结： 本课程旨在教授 Web 开发人员使用 PHP 和 MySQL 构建实用的 Web 项目，涵盖 PHP 基础、MySQL 数据库操作、JavaScript、jQuery、Ajax、Web 框架、WordPress 等多种流行技术。课程内容可以按顺序学习，也可以选择独立的项目进行实践。提供的项目源码可用于个人项目。 **项目详情：** * **Shoutit Shoutbox (Shoutit]):** 使用 PHP 和 MySQL 构建的基本 shoutbox。 **技术：** PHP 语法，PHPMyAdmin，MySQL Select，MySQL Insert，循环，Superglobals (GET, POST)，关联数组，HTML/CSS。 * **PHP Quizzer (PHP 测验):** 基于 PHP 和 MySQL 的简单测验引擎，支持多项选择，并允许管理员在浏览器中创建测验。 **技术：** PHP 语法，PHPMyAdmin，MySQL Select，MySQL Insert，循环，Superglobals (GET, POST)，关联数组，HTML/CSS，Includes，数学函数。 * **PHP Lovers Blog (PHP 爱博):** 更为高级的博客系统，包含添加、删除和更新文章的管理后台。学习使用库和类进行 OOP 编程，并创建自定义 MySQLi 数据库类和辅助函数。 **技术：** PHP OOP，PHPMyAdmin，MySQL CRUD，循环，Superglobals (GET, POST)，关联数组，Bootstrap 框架。 * **TalkingSpace Form:** 提高编码标准，实现逻辑与显示的完全分离。创建 PDO 数据库类及 Topics、Users 和 Validator 等类，用于表单验证。 **技术：** 分离逻辑与显示，PHP OOP，PHPMyAdmin，PDO & Prepared Statements，MySQL CRUD，循环，Superglobals (GET, POST)，关联数组，自定义模板，用户与话题库，Sessions，Bootstrap 框架。 * **The GamingPlace Shopping Cart (游戏之地购物车):** 基于 Codeigniter 框架的电子商务 MVC Web 应用。实现用户注册、购物车功能及 PayPal 支付。 **技术：** Codeigniter，MVC，PHP OOP，PHPMyAdmin，PDO & Prepared Statements，MySQL CRUD，Sessions，PayPal Express Checkout API。 * **Wordpress Contact Widget (WordPress 联系小部件):** 为 WordPress 创建一个插件/小部件，允许用户将联系表单添加到任何小部件位置。支持后端选项设置，如收件人和主题。 **技术：** WordPress 平台，WordPress Plugin API，WordPress Widget API，PHP OOP，PHPMyAdmin。 * **AJAX Address Book (AJAX 地址簿):** 使用 jQuery 和 Ajax 全自定义的 PHP 地址簿应用。Ajax 用于获取、添加和编辑联系人。用户界面使用 "Foundation" HTML5 框架。 **技术：** Foundation 框架，Ajax，jQuery，PHP OOP，PHPMyAdmin，PDO & Prepared Statements，MySQL CRUD，Superglobals (GET, POST)，关联数组。 * **JobFinds Job Board (求职招聘):** 使用 CakePHP 框架构建的大型求职信息发布板。支持用户注册登录发布职位，以及通过关键词、地点和类别进行搜索和筛选。UI 使用 Kickstart HTML5 框架。 **技术：** CakePHP，MVC，Kickstart，PHP OOP，PHPMyAdmin，PDO & Prepared Statements，MySQL CRUD，Superglobals (GET, POST)，关联数组。 * **Kewl CMS Content Management System (Kewl CMS 内容管理系统):** 基于 Codeigniter 的内容管理应用程序，涵盖前端和后端开发。UI 使用 Bootstrap。 **技术：** Codeigniter，Bootstrap，MVC，PHP OOP，PHPMyAdmin，PDO & Prepared Statements，MySQL CRUD，Superglobals (GET, POST)，关联数组。 * **Wordpress Bridge Plugin for TGP (TGP 的 WordPress 桥接插件):** 创建一个 WordPress 插件，允许连接 "TheGamingPlace" 数据库，并通过自定义短代码在 WordPress 页面中显示一定数量的产品。 **技术：** WordPress 平台，WordPress Plugin API，WordPress Widget API，PHP OOP，PHPMyAdmin。
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
