Download Open Source Programming BCA BSc and more Lecture notes Computer Science in PDF only on Docsity! Open Source Programming (Learning HTML, HTML5,CSS, JavaScript, Linux, MySQL & PHP ) Dr.P.Rizwan Ahmed, Ph.D Professor In-Charge- Shift –II & HOD Department of Computer Applications & Post Graduate Department of Information Technology Mazharul Uloom College, Ambur – 635 802, Tamil Nadu, INDIA. Contents Chapter -1 Introduction to Open Source 1.1 Introduction 1.2 How Did Open Source Get Started? 1.3 What is Open Source Software? 1.4 Advantages of Open Sources 1.5 Applications of Open Source Softwares 1.6 Need of Open Sources 1.7 Open Source vs Proprietary Software 1.8 Examples of Open Source Software Summary Review Questions Chapter 2 HTML 2.1 History of HTML 2.2 Introduction 2.3 HTML Tags 2.3.1 Paired Tags or Container Tags 2.3.2 Singular Tags or Empty Tags 2.4 Advantages of HTML 2.5 Disadvantages of HTML 2.6 Structure of HTML document 2.6.1 Head Section 2.6.2 Body Section 2.7 Basic Commands or Tags in HTML 2.7.1 Bold 2.7.2 Italic 2.7.3 Underline 2.7.4 BODY Tag <BODY> 2.7.5 Center : <center>---</center> 2.7.6 Line Break : <br 2.7.7 Paragraph : <p> --- </p> 2.7.8 Heading Styles 2.7.9 Horizontal: <hr> tag 2.7.10 Font: <Font>---</Font> 2.8 Lists 2.8.1 Ordered List 2.8.2 Unordered List 2.8.3. Definition List 5.15.6 Echo Command 5.15.7 Variables in shell script 5.15.8 Arithmetic Operations / Expressions 5.15.9 Quotes 5.15.10 Control Structures 5.15.10.1 Selection Structure 5.15.10.2 Repetition or iteration structure 5.16 String processing 5.16.1 String processing commands 5.17 Investigation and Managing Processes 5.18 Network Clients 5.18.1 Web Clients 5.19 Installing Applications 5.20 Sample Programs Summary Review Questions Chapter 6 JavaScript 6.1 Introduction 6.2 History of JavaScript 6.3 What is JavaScript? 6.4 Are Java and JavaScript the same? 6.5 JavaScript in Web Pages 6.6 What can a JavaScript do? 6.7 Limitations of JavaScript 6.8 Uses of JavaScript 6.9 Advantages of JavaScript 6.10 Java Script Syntax 6.11 Embedding JavaScript in HTML file 6.12 Using External JavaScript in HTML file 6.13 Data Type 6.14 Variable 6.14.1 Rules for variable names 6.14.2 Declaring JavaScript variables 6.14.3 JavaScript Variable Scope 6.15 Operators 6.15.1 Arithmetic Operators 6.15.2 Comparison Operators 6.15.3 Logical Operators 6.15.4 Bitwise Operators 6.15.5 Assignment Operators 6.15.6 Conditional Operator (? :) 6.16 Expressions 6.17 Array 6.18 Conditional Statements 6.19 Functions 6.19.1 Defining functions 6.19.2 Calling Function 6.19.3 return statement 6.20 Recursive function 6.21 Dialog Box 6.21.1 alert( ) 6.21.2 confirm ( ) 6.21.3 prompt( ) 6.22 Sample Applications Summary Review Questions Chapter 7 Setting Up a Development Server 7.1 What is a WAMP, LAMP, XAMP and MAMP? 7.2 Installing a WAMP on Windows 7.3 Installing a XAMPP on Windows 7.4 Installing a XAMPP on Linux 7.5 Installing a XAMPP on Ubuntu 7.6 Difference between WAMP, LAMP, MAMP and XAMP. 7.7PHP with XAMPP 7.8 PHP with WAMP Summary Review Questions Chapter 8 Open Source Data Base: MySQL 8.1 Introduction 8.2 What is MySQL? 8.3 MySQL Features 8.4 Advantages of MySQL 8.5 Benefits of MySQL 8.6 Using the MySQL Command-Line client 8.7 Basic Database Terminology 8.7.1 Database 8.7.2 Tables 8.7.3 Field names 8.7.4 Field 8.7.5 Records 8.7.6 Cells 8.7.7 Data 8.7.8 Database Tables 8.7.9 RDBMS 8.8 Data Types in MySQL 8.8.1 Text Data Types 8.8.2 Number Data Types 8.8.3 Date Data Types 8.9 Working with Databases and Tables 8.9.1 Creating a Database and Tables 8.9.2 Show Databases and Tables 8.9.3 The USE Command 8.9.4 Deleting a Database 8.9.5 Describe Table 8.10 Classification of SQL statements 8.10.1 DDL Commands 8.10.2 DML Commands 8.10.3 TCL Commands 8.11 Administrative details 8.12 Table Joins 8.13 Loading and Dumping a Database Summary Review Questions Chapter 9 Open Source Programming Language: PHP 9.1 Introduction 9.2 History of PHP 9.3 What is PHP? 9.4 Uses of PHP 9.5 General Syntactic Characteristics 9.5.1 PHP Syntax 9.5.2 Inserting External Files 9.5.3 Keywords 9.6 Commenting your code 8.6.1 Single line comments 8.6.2 Multiline comments 9.7 Creating your first PHP Script 9.8Output Statements in PHP 9.8.1 echo Statement 9.8.2 Print Statement 9.9 Primitives, Operations and Expressions 9.9.1 Data Types 9.9.1.1 Scalar Data Types 9.9.1.2 Compound Data Types 9.10 Variable 9.10.1 PHP Variable Naming Conventions 9.11 Constants 9 PHP Operators 8.13 Expression 8.14 Control Statement