FACE OF WEB PROGRAMMING COURSE (PHP-MYSQL)

Stakeholders can leave a comment.

Description of web programming workshop

Using PHP, one of the major web programming languages, we can develop simple web pages with dynamic content, to complex web applications accessible from the Internet intranet.

This classroom course and practical web programming in PHP, you will learn to use this programming language in conjunction with other languages such as HTML, CSS, JavaScript, ... through a very practical approach so that upon completion, will have the skills to cope with any project assurance web programming to be addressed.

Intended for graphic designers, computer science students, web developers from other languages, and all those interested in web projects, will also address important issues in the development of web pages or applications such as accessibility, standardization of code, security and optimization.

Methodology

All residential course will be taught with a practical methodology, a training room transferred by a partner company. Students must bring their own laptop to do case studies on your own computer, and thus take home.

We begin the course with each individual PC installation Apache server, PHP, Mysql database, and a manager for the database (mysqladmin).

All the theoretical part, be issued to start the course in the same manual, so that in class we will focus on explaining the theory be working directly with code and case studies done.

Objectives

Learn to make a simple project from a dynamic web page to complex web applications e-commerce payment gateways on-line as well as applications or websites accessible.

Requirements

You only need a minimum prior knowledge of HTML and Web browsing.

Venue and duration

The classroom courses are held in Zaragoza (Av.Navarra-against Augusta Mall). A partner company has transferred its facilities ready to connect computers to the Internet, where the teacher can, through your computer, to comment the code for all practical cases to be studied.

There are different groups and schedules to choose, consult availability.

Occasionally, depending on demand, courses can be arranged on weekdays.

The course duration is 30 hours.

Prices

The total price of attendance course practical web programming in PHP is 650.00 euros + VAT.

Those companies that wish to register more than one employee may request a discount.

Possibility of discounting the price by the annual training concepts offered by Social Security.

Agenda (approximate, may be negotiated with the students attending Conen)

1. INTRODUCTION, DEFINITIONS AND FACILITIES.

1.1 Brief introduction of technologies and languages to use.
1.2 Explanation and installation server on Windows machine.
1.3 Explanation and installation of php server on windows machine.
1.4 Explanation and installation of Mysql on server on Windows machine.
1.5 Explanation and installation of phpMyAdmin on server.
Html 1.6, standardization, validation and accessibility of language.
CSS 1.7, the graphic style of web projects.
JavaScript 1.8, advantages, disadvantages and proper use.
1.9 Correct domain registration.
1.10 Different browsers, different screen resolutions.

2. FIRST STEPS IN PHP
2.1 Introduction to php (explanation, uses, potential)
02.02 Hello World .... Creating a page combining php, html and css.
2.3 Separation of code: function, structure, design.
2.4 Introduction, explanation and practical use of variables and constants in php

3. EXPLANATION OF ACCELERATED PHP
3.1 Definition, types, uses of variables.
3.2 Definition, types, uses constant.
3.3 Arrays and handling.
3.4 Operators
3.5 Control Structures.
3.6 Functions (code reuse).

4. PRACTICAL CASE STUDY NO. 1 "Raising the structure of a project
4.1 presents a simple project which aims to create an appropriate structure of programming for use in all future projects. Involves making a small website in multiple languages so as to separate the content, functionality and style. The result will be an initial file structure of any project, so as to optimize the development of future projects.

5. PRACTICAL CASE STUDY NO. 2 "Treatment of Forms
5.1 This case study will learn to create forms, send data to server, check that the information is correct, display error messages if they are not going to show the correct form, or display messages when data are incorrect. You will learn to save form data in files, or send by e-mail. This will be supplemented with explanations and examples of security: both files, such as forms, and shipping functions using e-mail. Also taught to use forms to upload files to server (upload files).

6. PRACTICAL CASE STUDY No. 3 "Use MySQL database"
6.1 Through a complex scenario, you will learn to program web pages or applications that use databases. You will learn to create databases and users for the same, enter data into them, query data, modify, and delete them. Explaining security policies, and tricks to create a solid foundation that will allow for any desired operation in the future with databases.

7. PRACTICAL CASE STUDY No. 4 "Dynamic Content Manager"
7.1 In this case study you will learn to use what was learned in all previous cases separately with the aim of creating a web application that allows us to use as dynamic content management. It will create an administration area with access restricted by password from which you can manage the content to display on the site (news, photo galleries, upload files, ...).

8. PRACTICAL CASE STUDY NUM.5 "Electronic Commerce, Sales On-line
8.1 By a simple online store powered by databases, you will learn to conduct financial transactions over the Internet. You will learn how to program the pages to receive online payments via credit card and for this we use two examples of payment gateways: PayPal and bank payment gateway. Similarly, you will learn to manage orders placed by customers.

9. OpenSource projects (open source)
9.1 Definitions, characteristics, advantages and disadvantages.
9.2 Updates, bugs, changes.

10. PRACTICAL CASE STUDY NUM.7 "Online Store Oscommerce opensource"
10.1 Installation, explanation, modification and maintenance of an Oscommerce online store. In this case study learn how to set up shop online, and to modify parts of the code to customize both design and functionality level.

11. PRACTICAL CASE STUDY NUM.8 "Portal opensource Joomla"
11.1 Installation, explanation, modification and maintenance of complex Joomla site. In this case study learn how to install Joomla opensource portal and modify parts of the code to customize both design and functionality level.

Related articles:

1. Intensive php-mysql for the first time in Zaragoza