كورس برمجة المواقع PHP& MySQL

ستتعلم في هذا الكورس مع شركة عرب نيوتك لغة برمجة PHP مع لغة قواعد البيانات MySQl هذا الكورس تفاعلي ستتعلم معنا بطريقة محترفه مهنية وتفاعلية وتم إعداد هذا المنهج التعليمي ليتناسب مع الدارس المبتدأ الذي ليس لديه أي خلفيه عن لغة البرمجة PHP سنؤهلك في هذا الكورس إلي أن تقوم ببرمجة المواقع التفاعلية بكل دقه وبأفضل المعايير.

 

1800ج

سعر الكورس

مواعيد الدراسة

صباحية ومسائية

مواد علمية

ورش عمل بعد الدراسة

8

دارسين علي الأكثر

14

محاضرة

56

ساعة

ماذا ستتعلم في كورس برمجة المواقع  PHP& MySQL

  • Overview!
  • What is PHP?
  • The history of PHP
  • Why choose PHP?
  • Installation overview
  • Text editor
  • Installing WampServer
  • Finding the document root
  • Configuring PHP
  • Configuring MySQL
  • Text editor
  • 4. First Steps
  • Embedding PHP code on a page
  • Outputting dynamic text
  • The operational trail
  • Inserting code comments
  • 5. Exploring Data Types
  • Variables
  • Strings
  • String functions
  • Numbers part one: Integers
  • Numbers part two: Floating points
  • Arrays
  • Associative arrays
  • Booleans
  • NULL and empty
  • Type juggling and casting
  • Constants
  • 6. Control Structures: Logical Expressions
  • If statements
  • Else and elseif statements
  • Logical operators
  • Switch statements
  • 7. Control Structures: Loops
  • While loops
  • For loops
  • Continue
  • Continue
  • Understanding array pointers
  • 8. User-Defined Functions
  • Defining functions
  • Function arguments
  • Returning values from a function
  • Multiple return values
  • Scope and global variables
  • Setting default argument values
  • 9. Debugging
  • Common problems
  • Warnings and errors
  • Debugging and troubleshooting
  • 10. Building Web Pages with PHP
  • Links and URLs
  • Using GET values
  • Encoding GET values
  • Encoding for HTML
  • Including and requiring files
  • Modifying headers
  • Page redirection
  • Output buffering
  • 11. Working with Forms and Form Data
  • Building forms
  • Detecting form submissions
  • Single-page form processing
  • Validating form values
  • Problems with validation logic
  • Displaying validation errors
  • Custom validation functions
  • Single-page form with validations
  • 12. Working with Cookies and Sessions
  • Working with cookies
  • Setting cookie values
  • Reading cookie values
  • Unsetting cookie values
  • Working with sessions
  • 13. MySQL Basics
  • MySQL introduction
  • Creating a database table
  • CRUD in MySQL
  • Populating a MySQL database
  • Relational database tables
  • Populating the relational table
  • 14. Using PHP to Access MySQL
  • Database APIs in PHP
  • Connecting to MySQL with PHP
  • Retrieving data from MySQL
  • Working with retrieved data
  • Creating records with PHP
  • Creating records with PHP
  • Updating and deleting records with PHP
  • SQL injection
  • Escaping strings for MySQL
  • Introducing prepared statements
  • 15. Building a Content Management System (CMS)
  • Blueprinting the application
  • Building the CMS database
  • Establishing your work area
  • Creating and styling the first page
  • Making page assets reusable
  • Connecting the application to the database
  • 16. Using Site Navigation to Choose Content
  • Adding pages to the navigation subjects
  • Refactoring the navigation
  • Selecting pages from the navigation
  • Highlighting the current page
  • Moving the navigation to a function
  • 17. Application CRUD
  • Finding a subject in the database
  • Refactoring the page selection
  • Creating a new subject form
  • Processing form values and adding subjects
  • Passing data in the session
  • Validating form values
  • Creating an edit subject form
  • Using single-page submission
  • Deleting a subject
  • Cleaning up
  • Assignment: Pages CRUD
  • Assignment results: Pages CRUD
  • 18. Building the Public Area
  • The public appearance
  • Using a context for conditional code
  • Adding a default subject behavior
  • The public content area
  • Protecting page visibility
  • 19. Regulating Page Access
  • User authentication overview
  • Admin CRUD
  • Encrypting passwords
  • Adding password encryption to CMS
  • New PHP password functions
  • Creating a login system
  • Checking for authorization
  • Creating a logout page
  • Conclusion
  • Next Step