Web programming with PHP and MySQL

You would like to make your web pages more dynamic or adapt WordPress pages to your needs through specific script adaptations? PHP is used when plain HTML reaches its limits. In this seminar, my participants learn to create PHP scripts that have built-in user interactions, control databases or can be individually adapted to user behaviour. The training content and focus can be determined in the seminar and, if necessary, directly applied to concrete examples in professional practice.

• Installation of the professional working environment, XAMPP, or similar;
• PHP MyAdmin Admin interface MySQL configuration,
• Database connection, manage user rights;
• Create, delete, change databases and tables, add records via the PHP-MyAdmin interface;
• Digression MySQL data types;
• Simple SQL queries with conditions;
• Online documentation;
• Data types in PHP;
• Basic language structure of PHP;
• Changes in PHP 8.x
• Import and export data and databases;
• User administration in PHP-MyAdmin and backup;
• PHP and HTML: Output of data to the browser, syntax, comments,
• Error reporting;
• Forms (HTML) with data transfer via POST and GET;
• Fields functions associative array;
• Control structures: Loops, functions and procedures,
• Error handling;
• String processing (strchr, strpos, substr, strcmp, etc.);
• Functions: Definition, parameters, return values, validity ranges,
• Inclusion functions with include and require;
• Time functions;
• File functions (readfile, file_get_contents, file_put_contents, etc.);
• Transaction control with sessions (session_start, session_name, session_destroy, etc.);
• Introduction to object orientation in PHP;

At least 3 days

Recommended 5 days

Aspiring web designers, web developers, programmers, IT specialists and anyone who wants to dynamically design WordPress websites or Internet pages. You should have basic knowledge of HTML/CSS, general programming techniques and possibly initial experience with WordPress as an administrator.

• Open seminar
• Online seminar
• Company training
• Individually tailored seminar

Urs Scheufele: Seminar leader and lecturer Web programming with PHP and MySQL