Udaan | Workshop

XAMPP stands for Cross-Platform (X), Apache (A), MySQL (M), PHP (P) and Perl (P). It is a simple, lightweight Apache distribution that makes it extremely easy for developers to create a local web server for testing purposes. Everything you need to set up a web server – server application (Apache), database (MySQL), and scripting language (PHP) – is included in a simple extractable file.

PHP executes on the server, while a comparable alternative, JavaScript, executes on the client. PHP is an alternative to Microsoft's Active Server Page (ASP) technology. As with ASP, the PHP script is embedded within a Web page along with its HTML. Before the page is sent to a user that has requested it, the Web server calls PHP to interpret and perform the operations called for in the PHP script.

MySQL is the world's most popular open source database. With its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more.

Workshop Contents

All contents of the workshop

Xampp Server

1.1 Introduction to xampp server
1.2 Installation of xampp server
1.3 Apache and mysql & localhost
1.4 File structure in xampp (php.ini, htdocs)
1.5 Configuration file (port number and version)
1.6 phpmyadmin

PHP

2.1 Introduction of PHP
2.2 PHP opening & closing tag.
2.3 Data type
2.4 Output function in PHP
2.5 Control structure (while loop, do-while loop, for-loop & if, if-else)
2.6 External file include
2.7 PHP Errors
2.8 String Function
2.9 Array
2.10 Array function
2.11 Super Global Variable
2.12 HTML Form submit
2.13 Image File Upload

MySQL

3.1 introduction of database
3.2 What is query and query generation?
3.3 What is database and table?
3.4 Create database.
3.5 Create Table
3.6 Connection between MySQL and PHP
3.7 MySQL function
3.8 Query (Insert, Select, Delete, Update, etc.)