Tujuan

Memberikan konsep dasar pemrograman web dengan menggunakan PHP sehingga peserta dapat membangun sebuah aplikasi web dinamis dengan menggunakan PHP dan database MySQL

 

Keterangan

  • Jumlah pertemuan : 12x
  • Total waktu training : 30 jam
  • Jumlah jam per pertemuan : 2,5 jam
  • Jadwal pertemuan dapat diatur kemudian bisa 2x atau 3x seminggu, hari dan jam disesuaikan dengan peserta kelas dan pengajar.
  • Alternatif lain adalah dengan workshop model yaitu memadatkan pertemuan menjadi 4x pertemuan, per petemuan 7,5 jam selama 2 minggu (hari sabtu dan minggu)
  • Peserta dapat membawa notebook sendiri atau menggunakan komputer yang disediakan.

 

Hands-On Modul

  • Setiap peserta akan mendapatkan modul pelatihan

 

Software Requirement

  • Windows XP SP2 atau Vista
  • XAMPP (Apache,PHP,MySQL)
  • Editor

 

Materi Training

  • PHP Basics
    • How PHP Works
    • The php.ini File
    • Basic PHP Syntax
      • PHP Tags
      • PHP Statements and Whitespace
      • Comments
      • PHP Functions
      • Hello World!
    • PHP Tags
    • PHP Statements and Whitespace
    • Comments
    • PHP Functions
    • Hello World!
    • Variables
      • Variable Types
      • Variable Names (Identifiers)
      • Type Strength
      • Hello Variables!
      • Variable Scope
      • Superglobals
      • Constants
      • Variable-Testing and Manipulation Functions
    • Variable Types
    • Variable Names (Identifiers)
    • Type Strength
    • Hello Variables!
    • Variable Scope
    • Superglobals
    • Constants
    • Variable-Testing and Manipulation Functions
    • PHP Operators
    • Creating Dynamic Pages
      • Single Quotes vs. Double Quotes
      • Howdy World!
    • Single Quotes vs. Double Quotes
    • Howdy World!
    • Conclusion
  • Flow Control
    • Conditional Processing
      • If Conditions
    • If Conditions
    • Loops
      • while
      • do…while
      • for
      • break and continue
    • while
    • do…while
    • for
    • break and continue
    • Conclusion
  • Arrays
    • Enumerated Arrays
      • Initializing Arrays
      • Appending to an Array
      • Reading from Arrays
      • Looping through Arrays
    • Initializing Arrays
    • Appending to an Array
    • Reading from Arrays
    • Looping through Arrays
    • Associative Arrays
      • Initializing Associative Arrays
      • Reading from Associative Arrays
      • Looping through Associative Arrays
      • Superglobal Arrays
    • Initializing Associative Arrays
    • Reading from Associative Arrays
    • Looping through Associative Arrays
    • Superglobal Arrays
    • Two-dimensional Arrays
      • Reading from Two-dimensional Arrays
      • Looping through Two-dimensional Arrays
    • Reading from Two-dimensional Arrays
    • Looping through Two-dimensional Arrays
    • Array Manipulation Functions
    • Conclusion
  • PHP and HTML Forms
    • HTML Forms
      • How HTML Forms Work
      • A Sample HTML Form
      • Form Variables
    • How HTML Forms Work
    • A Sample HTML Form
    • Form Variables
    • Conclusion
  • String Manipulation
    • Formatting Strings
      • Concatenation
      • String Manipulation Functions
      • Examples of String Functions
    • Concatenation
    • String Manipulation Functions
    • Examples of String Functions
    • Magic Quotes
      • magic_quotes_gpc
      • magic_quotes_runtime
      • Recommendation on Magic Quotes
      • Conclusion
    • magic_quotes_gpc
    • magic_quotes_runtime
    • Recommendation on Magic Quotes
    • Conclusion
  • Reusing Code and Writing Functions
    • Including Files
      • require
      • require_once
    • require
    • require_once
    • auto_prepend_file and auto_append_file
    • User Functions
      • Defining and Calling Functions
      • Default Values
      • Variable Scope
      • By Reference vs. By Value
    • Defining and Calling Functions
    • Default Values
    • Variable Scope
    • By Reference vs. By Value
    • Form Processing
      • Code Organization
    • Code Organization
    • Conclusion
  • Simple SELECTs
    • Introduction to the Northwind Database
    • Some Basics
      • Comments
      • Whitespace and Semi-colons
      • Case Sensitivity
    • Comments
    • Whitespace and Semi-colons
    • Case Sensitivity
    • SELECTing All Columns in All Rows
    • SELECTing Specific Columns
    • Sorting Records
      • Sorting By a Single Column
      • Sorting By Multiple Columns
      • Sorting By Column Position
      • Ascending and Descending Sorts
    • Sorting By a Single Column
    • Sorting By Multiple Columns
    • Sorting By Column Position
    • Ascending and Descending Sorts
    • The WHERE Clause and Operator Symbols
      • Checking for Equality
      • Checking for Inequality
      • Checking for Greater or Less Than
      • Checking for NULL
      • WHERE and ORDER BY
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • WHERE and ORDER BY
    • The WHERE Clause and Operator Words
      • The BETWEEN Operator
      • The IN Operator
      • The LIKE Operator
      • The NOT Operator
    • The BETWEEN Operator
    • The IN Operator
    • The LIKE Operator
    • The NOT Operator
    • Checking Multiple Conditions
      • AND
      • OR
      • Order of Evaluation
    • AND
    • OR
    • Order of Evaluation
    • Conclusion
  • Subqueries, Joins and Unions
    • Subqueries
    • Joins
      • Table Aliases
      • Multi-table Joins
    • Table Aliases
    • Multi-table Joins
    • Outer Joins
    • Unions
      • UNION ALL
      • UNION Rules
    • UNION ALL
    • UNION Rules
    • Conclusion
  • Inserting, Updating and Deleting Records
    • INSERT
    • UPDATE
    • DELETE
    • Conclusion
  • Managing Data
    • Querying a Database
      • mysqli() Overview
      • mysqli Methods and Properties
      • Inserting and Updating Records
      • mysqli Prepared Statements
    • mysqli() Overview
    • mysqli Methods and Properties
    • Inserting and Updating Records
    • mysqli Prepared Statements
  • Authentication with PHP and SQL
    • A Database-less Login Form
    • Conclusion
  • Regular Expressions
    • Perl-compatible Regular Expression Functions
      • preg_match()
      • preg_replace()
      • Regular Expression Tester
    • preg_match()
    • preg_replace()
    • Regular Expression Tester
    • Regular Expression Syntax
      • Start and End ( ^ $ )
      • Number of Occurrences ( ? + * {} )
      • Common Characters ( . \d \D \w \W \s \S )
      • Grouping ( [] )
      • Negation ( ^ )
      • Subpatterns ( () )
      • Alternatives ( | )
      • Escape Character ( \ )
    • Start and End ( ^ $ )
    • Number of Occurrences ( ? + * {} )
    • Common Characters ( . \d \D \w \W \s \S )
    • Grouping ( [] )
    • Negation ( ^ )
    • Subpatterns ( () )
    • Alternatives ( | )
    • Escape Character ( \ )
    • Form Validation Functions with Regular Expressions
    • Conclusion
  • Session Control and Cookies
    • Sessions
      • Configuring Sessions
      • Session Functions
    • Configuring Sessions
    • Session Functions
    • Cookies
    • Conclusion
  • Sending Email with PHP
    • mail()
      • Shortcomings of mail()
    • Shortcomings of mail()
    • PHPMailer
    • Conclusion
  • File System Management
    • Opening a File
      • fopen()
    • fopen()
    • Reading from a File
      • fgets()
    • fgets()
    • Writing to a File
      • fwrite()
    • fwrite()
    • File Locking
      • flock()
    • flock()
    • Uploading Files via an HTML Form
    • Getting File Information
    • More File Functions

    5 thoughts on “Dasar Pemrograman PHP dan MySQL (Introduction PHP and MySQL)

    1. Mas Erick Kurniawan, Saya tertarik dengan Materi training tersebut dan kalo boleh saya dikirimkan juga brosur / penawaran sekalian untuk yang advance dimana hal tersebut akan saya ajukan pada atasan saya.

      Terimakasih sebelumnya

      regards
      Rekso L. Soenaryo

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s