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

ساخت وب سایت داینامیک با PHP و MySQL

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

ساخت-وب-سایت-داینامیک-با-php-و-mysql

این آموزش تصویری نحوه ساخت وب سایت داینامیک را با استفاده از PHP و MYSQL آموزش می دهد.

این دوره محصول Pluralsight می باشد.

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

  • ساخت LAMP Stack
  • نصب و راه اندازی
  • دسترسی به فرم داده ها با PHP
  • کار با فرم های HTML
  • ایجاد یک فرم
  • دسترسی به فرم داده ها با PHP
  • اعتبار سنجی ورودی
  • طراحی بانک اطلاعات
  • ایجاد و پر کردن پایگاه داده
  • دسترسی به یک پایگاه داده از PHP
  • معرفی PDO
  • اتصال به پایگاه داده
  • ایجاد و استفاده از Stored Procedure ها و توابع
  • استفاده از Cookie ها
  • معرفی امنیت وب سایت 
  • سطح امنیت شبکه
  • کار با پایگاه داده SQL

عنوان دوره آموزشی: Building Dynamic Websites with PHP and MySQL سطح: متوسط مدت زمان: 5 ساعت نویسنده: Chris Brownلیست سرفصل های دوره آموزشی:

In this course you will learn how to create dynamic, data driven websites using the LAMP stack. The course focuses on the integration of the LAMP components (especially MySQL and PHP) to create a complete working site. Throughout the course, a lending library that needs a web application to track its books and borrowers provides a scenario for discussion and demonstration. Attention is also paid to best practices for keeping the site secure. Students should have a basic prior knowledge of relational databases and SQL and of the PHP language (variables, operators, loops, branches, and simple string handling). Basic competence at the Linux command line (including the ability to edit text files) is also assumed. Students can follow along with all demos by pre-installing Centos 6 (or similar) into a virtual machine.

Introduction 09:11 Demonstration 01:44 Building the LAMP Stack 00:23:29 Introduction 02:58 Installation 17:04 Alternatives 03:27 Accessing Form Data with PHP 00:26:51 HTML forms 02:41 Demo: Creating a Form 12:36 Accessing Form Data with PHP 06:31 Validating User Input 01:52 Demonstration -- Input Validation 03:09 The Lending Library's Database 00:22:04 Designing the Database 08:03 Creating and Populating the Database 02:24 Querying and Updating the Database 11:36 Accessing a Database from PHP 00:27:32 Introducing PDO 01:55 Connecting to the Database 06:38 Book Search Demonstration 10:08 Quoting and Input Validation 05:26 mysqli 03:23 Doing More with the Database 00:34:15 Using Prepared Statements 12:04 Non-queries and Summary Functions 08:14 Creating and Using Stored Procedures and Functions 13:05 Lesson Summary 00:50 Maintaining State in Web Applications 00:38:47 The Problem of Maintaining State 04:35 PHP Sessions 04:05 Using Hidden Fields 04:14 Using Cookies 09:02 The Library: User Preferences and Shopping Carts 16:07 Lesson Summary 00:43 Granting Privileges in MySQL 00:20:18 Introduction to the MySQL Privilege Model 05:59 Creating Accounts and Granting Privileges 09:50 Accounts for the Library Application 03:33 Lesson Summary 00:55 Putting it all Together 00:42:10 Site page flow and Folder Layout 03:50 Demonstration of the Public Site 03:39 Public site code Walkthrough, Part 1 09:59 Public site code Walkthrough, Part 2 07:51 Demonstration of the Admin Site 03:36 Admin site code Walkthrough, Part 1 04:27 Admin site code Walkthrough, Part 2 08:44 Staying Safe 00:48:28 Introduction to Web Site Security 07:37 Network Level Security 07:53 SQL Injection Attack and Defence 05:52 Database Backup Tools 10:20 MySQL Log Files 04:31 Using Binary Logs for Data Recovery 09:01 Replication and Enterprise Backup Solutions 03:11 Going Further 00:05:29 Going Further 05:29

حجم فایل: 691MB

Pluralsight BUILDING DYNAMIC WEBSITES WITH PHP AND MYSQL TUTORIAL

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