تبلیغات

آموزش طراحی وب سایت داینامیک با PHP و MySQL و JavaScript

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

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

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

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

  • ساخت یک وب سایت با MySQL, PHP
  • نصب و پیکربندی دیتابیس MySQL, PHP
  • جفت کردن PHP / MySQL در بخش مدیریت وب سایت با CSS, AJAX, و JavaScript code
  • اصول اولیه و بهترین شیوه از MySQL, PHP
  • PHP چیست؟
  • راه اندازی PHP و MySQL
  • نصب WAMP برای ویندوز
  • نصب MAMP در Macintosh - قسمت 1
  • نصب MAMP در Macintosh - قسمت 2
  • نمایش HTML در پنجره مرورگر
  • فرم HTML
  • استفاده از تگ SELECT
  • استفاده از تگ TEXTAREA
  • استفاده از تگ RADIOBUTTON
  • تعیین مقادیر به متغیر ها
  • تکنیک های اشکال زدایی - قسمت 1
  • اصول برنامه نویسی PHP
  • جداول در HTML
  • کد قالب بندی و ویرایش
  • عملگرهای مقایسه
  • استفاده از AND
  • استفاده از OR
  • استفاده از NOT
  • تکنیک های اشکال زدایی - قسمت 2
  • حلقه FOR 
  • خواندن فایل
  • نوشتن فایل
  • نمایش اطلاعات از فایل به جدول HTML
  • تکنیک های اشکال زدایی - قسمت 3
  • توابع، آرایه ها، و رشته ها
  • مبانی آرایه ها
  • مرتب سازی آرایه ها
  • برنامه نویسی بازگشتی
  • پیدا کردن متن با عبارات منظم
  • تکنیک های اشکال زدایی - قسمت 4
  • آشنایی با SQL
  • دستور SELECT
  • عملگرهای مقایسه
  • تکنیک های اشکال زدایی SQL - قسمت 5
  • اتصال به خروجی در برنامه PHP
  • افزودن رکورد به جدول
  • ایجاد جدول با phpMyAdmin
  • تکنیک های اشکال زدایی - قسمت 6
  • توابع عضویت

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

A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Dynamic Web Design with PHP and MySQL training course will give you a working understanding of these important technologies and show you how to use them to create your own impressive websites. When used in combination, there simply isn't a better way to construct sites that involve complexity, large volumes of data, and the flexibility to make adjustments and changes over time. This course goes step by step through the basics of each technology, and then gradually shows you how to build the necessary components and underlying framework of your site. It goes through installation of PHP and MySQL technologies on your local machine as well as hosted servers, explains basic tags, commands and constructs, and helps you build and work within a solid back-end database. One you have the basics of PHP and MySQL covered, you'll also learn how to use CSS, JavaScript and AJAX to create the visual style and added functionality your pages deserve.

What You Will Learn

- How to build functional, full-featured websites that utilize MySQL, PHP and other current web development technologies.

- How to install, configure and modify functional PHP constructs and MySQL databases for the web.

- How to pair a secure PHP / MySQL backend of a website with a compelling visual interface made with CSS, AJAX, and JavaScript code.

- The basic principles and best practices of PHP and MySQL in a relevant, real world project.

Who Should Take This Course

- Individuals and small business owners interested in creating their own fully featured websites with total control over data management, functionality and visual appearance.

- Web developers and programmers looking to learn a new language and set of standards.

- Anyone who has used basic CMS or templates to create basic websites in the past but want much more control.

- Anyone who has tried to learn PHP or MySQL in the past but found it difficult due to a lack of practical examples.

What People Are Saying

"Have to say I was nervous at first, but the authors explanations were very well laid out and crystal clear. The site is coming together nicely."

-Ben Jeffries

"A PHP tutorial that is up to date with current standards...very easy to follow."

-Breck Defontes

"I come from a design background but I wanted to beef up my knowledge of basic code. This was a nice and easy primer, thanks."

-Angela Redberg

CURRICULUM SECTION 1: Introduction 1 Working Files - Download These First Text 2 0101 What is PHP 04:33 Preview 3 What Is MySQL? 02:39 4 Simple PHP Program 06:27 5 The Example Web Site - King Real Estate 03:54 6 How to obtain your Certificate of Completion for this Infinite Skills course. Text Instructions on how to obtain your Certificate of Completion for this Infinite Skills course. All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken the course listed. In order to o… SECTION 2: Interface 7 Setting Up Your Computer For PHP And MySQL 04:01 8 Installing WAMP For Windows 07:03 9 Installing MAMP For Macintosh - Part 1 03:57 10 Installing MAMP For Macintosh - Part 2 02:28 11 Using A Hosting Service 06:38 SECTION 3: PHP Basics 12 Using PHP Script Tags 04:01 13 Displaying HTML To Your Browser Window 07:47 14 HTML Forms 10:13 15 Using The SELECT Tag 06:19 Preview 16 Using The TEXTAREA Tag 06:47 17 Using The RADIOBUTTON Tag 04:09 18 Using The CHECKBOX Tag 05:36 19 Assigning Values To Variables 04:49 20 Appending Text 04:12 21 Debugging Techniques - Part 1 07:21 22 Assignment 1 04:12 23 Assignment 1 - Solution 05:49 SECTION 4: PHP Programming Fundamentals 24 String Delimiters 07:47 25 Simple Math 05:29 26 HTML Tables 07:53 Preview 27 Using IF Statements 04:15 28 The ELSE Clause 04:44 29 Nested IFs 05:40 30 Code Formatting Rules 05:24 Preview 31 Comparison Operators 08:18 32 Using AND 04:38 33 Using OR 04:26 34 Using NOT 05:39 35 Field Validations 06:52 36 Using DIVs 08:31 37 Using DIVs And Forms 03:17 38 Debugging Techniques - Part 2 10:00 39 Assignment 2 04:39 40 Assignment 2 - Solution 10:16 SECTION 5: Advanced PHP Constructs 41 The FOR Loop 07:35 42 The WHILE Loop 09:02 43 Reading A File 08:29 44 Writing To A File 07:44 45 Displaying A Data From A File Into An HTML Table 12:55 Preview 46 Debugging Techniques - Part 3 07:58 47 Assignment 3 05:33 48 Assignment 3 - Solution 08:56 SECTION 6: Functions, Arrays, And Strings 49 Simple Function 02:38 50 Functions That Receives Data 03:30 Preview 51 Functions That Returns A Value 02:28 52 Functions That Receives Data And Returns A Value 06:20 53 Variable Scope 07:19 54 Functions That Returns Multiple Values 06:49 55 Using Include Files 04:16 56 Array Basics 07:52 57 Sorting Arrays 06:14 58 Loading An Array From A File 02:10 Preview 59 Loading An Array From A Directory 06:19 60 Recursive Programming 08:57 61 Finding Text 06:47 62 Finding Text With Regular Expressions 05:11 63 Finding Simple Patterns Using Regular Expressions 07:59 64 Debugging Techniques - Part 4 08:03 65 Assignment 4 05:40 66 Assignment 4 - Solution 09:18 SECTION 7: Introduction To MySQL 67 Introduction To SQL 09:46 68 The Example Database 06:50 69 Interactive MySQL 07:20 70 Creating Tables 08:19 71 Simple SELECT Statement 05:38 72 Comparison Operators 05:40 Preview 73 Logical Operators 05:56 74 Selecting Nulls 02:05 75 Sorting Results 05:46 76 Aggregate Functions 06:37 77 Pattern Matching 05:14 78 Inserting Rows 04:05 79 Updating Table Data 02:43 80 Deleting Rows 01:56 81 SQL Debugging Techniques - Part 5 05:38 82 Assignment 5 02:54 83 Assignment 5 - Solution 03:19 SECTION 8: PHP With MySQL 84 0801 Connecting To MySQL Within A PHP Program 08:29 85 0802 Pass Data To A Select 03:26 86 0803 Adding Rows To A Table 06:43 87 0804 Deleting Rows From A Table 03:55 88 0805 Updating Data In A Table 04:27 89 0806 Populating A Select-Option List 03:09 90 0807 Login Validation 04:00 91 Relative Referencing 04:38 92 Creating Tables With phpMyAdmin 07:07 93 Inserting Data With phpMyAdmin 07:46 94 0811 Common Database Functions 06:38 95 0812 Debugging Techniques - Part 6 07:24 96 Assignment 6 03:42 97 Assignment 6 - Solution - Part 1 06:33 98 Assignment 6 - Solution - Part 2 07:48 SECTION 9: PHP With Advanced MySQL 99 Date Functions 04:24 100 Using Indexes 06:58

عنوان دوره:Udemy - Learning Dynamic Website Design - PHP MySQL and JavaScript حجم فایل: 1.62GB

آیا این نوشته را دوست داشتید؟
Udemy Learning Dynamic Website Design PHP MySQL and JavaScript

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

mohsen در 1394/06/29 ساعت 07:33

عالی بود