Microsoft Visual Studio Code

One of the most common requirements in software development is building applications and services that run on multiple systems and devices. Developers have many options, from languages to development platforms and tools. However, in most cases such tools rely on proprietary systems. Moreover, most development tools target specific platforms and development scenarios. MVSC provides a fully featured development environment for Windows that not only offers advanced coding features but also integrated tools that span across the entire application lifecycle from coding to debugging to team collaboration.

MVSC is a very powerful code-focused environment expressly designed to make it easier to write web, mobile, and cloud applications using languages that are available to different development platforms, with a built-in debugger and integrated support to the popular Git version control engine. It is free, open source (https://github.com/Microsoft/vscode), and makes it easier to edit code files and folder-based project systems as well as writing applications over the most popular platforms, such as Node.js, with rich editing features such as IntelliSense.

MVSC is based on Electron, a framework for creating cross-platform applications with native technologies. In order to properly combine all these features into one tool, MVSC provides a coding environment based on folders, making it easy to work with code files not organized within projects, offering a unified way to work with different languages. It offers an advanced editing experience with features common to any supported languages, plus some features available to specific languages.

MVSC also makes it easy to extend its built-in features by supplying custom languages, syntax coloring, automatic indentation, and much more via a number of extensibility points. It is a general purpose tool.¹⁶

PHP

The millions of websites powered by PHP, an open source scripting language primarily designed for generating HTML content, are a testament to its popularity and ease of use. Everyday people can learn PHP and build powerful dynamic websites with it. Since its inception in 1994, PHP has swept the web and continues its phenomenal growth today.¹⁷

PHP, usually installed as a module inside the web server, is a language in which applications are written to communicate with database systems on the backend and browsers on the frontend. The acronym has evolved from Personal Home Page to Professional Home Page to its current recursive definition, PHP: Hypertext Preprocessor. It powers famous sites such as Facebook and it is one of the most popular languages used for web application development, which has evolved to allow to quickly developing well-formed error-free programs. It provides the ability to use many preexisting libraries. The ease with which additional libraries can be added to the environment is one of the many driving forces in its popularity. With the release of the PHP 7 environment, great improvements took place, including major security upgrades and major performance improvements.¹⁸

PHP7 is the only PHP currently supported version. One of its great advantages, apart from greatly improved speed, is that it is almost completely backward compatible with PHP5. It is deployed on more than four in every five web sites that use a server-side language. ^₁₉₎ PHP is by far the most ubiquitous and accessible mature web language. With PHP7+ came some improvements that make it harder to make mistakes, and 7.2 is making things even safer, even more structured. ^₂₀₎ A dynamic website is linked with at least one database. User interface is another essential part of a dynamic website.²¹

MySQL

Many of the world's largest and fastest-growing organizations, including Google, rely on MySQL. MySQL is the most popular, trusted and widely used open source database management system (DBMS). MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL database server. It is developed, distributed, and supported by Oracle Corporation.²²

MySQL is a combination of a proper name and an acronym. SQL is structured query language. My part is not a possessive form, it is a name. In this case, My is the name of the founder’s daughter. Online reference manual can be consulted for a complete list of the new, updated, and removed features.²³

After MySQL was acquired by Oracle, a “fork” named MariaDB was created. It is very compatible with the original product and offers better performance in some cases. ^₂₄₎ The newest version, MySQL 8, includes features dedicated to high availability, greater reliability, and sophistication as well as a completely new user experience and revolutionary way to work with data.²⁵

Apache

Web servers are powerful computers that run special programs and are permanently connected to the Internet. ^₂₆₎ There are many choices of web servers that will work with PHP and MySQL/MariaDB databases. Apache is the most commonly used to host and handle PHP web page requests. It can be hosted on both UNIX and Windows. Apache can also accept and return requests for other types of files, including HTML and JavaScript. It is an open source product. ¹⁸ Apache is the web server used by the great majority of hosts and for web development on local hosts.²⁷

By the end of February 1995, the foundation of the original Apache Group was formed. In April, the first official public release of the Apache server was made. Apache 1.0 was released in December, 1995. Less than a year after the group was formed, the Apache server passed NCSA's httpd as the #1 server on the Internet, currently holding that position.²⁸

PHP, Apache, and MySQL/MariaDB

PHP can access information from many types of DBMS systems, including Oracle and SQL Server. However, the most popular combination is to pair PHP with MySQL or MariaDB. Both have free versions and are also one of the easier DBMS to use. PHP, Apache, and MySQL/MariaDB need to run seamlessly together to successfully create dynamic web pages. That combination is the most convenient approach to dynamic, database-driven web design. And, combined with JavaScript, CSS, and HTML5, any developer would be able to create websites like Facebook and Twitter.²⁹

Well supported by their respective home sites http://www.php.net and http://www.mysql.com, PHP/MySQL combination has enabled developers to build a lot of ready-made open source web applications, and most importantly, enabled in-house developers to quickly put in place solid web solutions.¹⁸

XAMPP

There are numerous server stack packages available that provide a combination of these products, along with other tools such as phpMyAdmin. There are lots of choices when selecting a package. Some work only on a particular operating system while some have lots of additional tools one can add, when chosen. These open source packages allow for easy installation of multiple products at the same time.¹⁸

Graphical user interfaces (GUIs) have been developed to facilitate the task of developing and maintaining databases. These administration tools are part of development packages. One of the most popular packages is XAMPP. Databases need a server, a DBMS, and a PHP processor. These can be downloaded as an all-in-one, already configured package. XAMPP includes packages for Windows (WAMP). Its most recent version is version 7.2.4. It has component versions as follows: Apache 2.4.33, MariaDB 10.1.25, PHP 7.2.4, and phpMyAdmin 4.8.0, along with other tools. XAMPP needs minimal configuring ^_27). It uses MariaDB instead of MySQL. The basics of MariaDB and MySQL are very similar. In some settings it still refers to MySQL when it is actually MariaDB.¹⁸

phpMyAdmin

phpMyAdmin is a GUI-based administration tool for creating and maintaining databases and their tables. If XAMPP is installed and the servers have been started, phpMyAdmin can be accessed directly by entering the following URL in any browser: http://localhost/phpMyAdmin/ or http://127.0.0.1/phpMyAdmin/.²⁷ A web-based MySQL administration application, phpMyAdmin has been actively developed since 1998. It offers a number of compelling features: it is browser-based, allowing to easily manage remote MySQL databases from anywhere you have access to the Web; administrators can exercise complete control over user privileges, passwords, and resource usage, as well as create, delete, and even copy user accounts.²⁴

phpMyAdmin is a free software tool written in PHP. It supports a wide range of operations on MySQL and MariaDB. Frequently used operations can be performed via the user interface, while still having the ability to directly execute any SQL statement.³⁰

HTML

Although HTML was intended to be used strictly for meaning and structure since its creation, that mission was somewhat thwarted in the early years of the web. With no style sheet system in place, HTML was extended to give authors ways to change the appearance of fonts, colors, and alignment using markup alone.³¹

Markup languages provide instructions to specify how data should be rendered for a particular document or purpose. The appearance of Web pages is also defined by markup instructions. The standard markup language used is HTML, or Hypertext Markup Language. Now that the Web is being used as an interface for an increasing range of software applications, programmers are learning to combine HTML instructions (to render the interface) with programming language instructions (to process the data)³².A markup language “marks up” a document by surrounding parts of its content with tags. The “hyper” in “Hypertext” refers to HTML’s ability to implement hyperlinks. So HTML is a language that supports markup tags for formatting and the ability to jump to other web pages. With HTML5’s approval as a “stable recommendation” in 2014, web programmers and browsers appear to have embraced it fully. HTML5, CSS, and JavaScript are the technologies known to be the pillars of client-side web programming.¹⁵

The term HTML5 encompasses a broad spectrum of technologies that together provide a compelling platform for building great web applications. These can be organized into three areas: HTML, CSS and JavaScript. HTML5 is a relatively mature standard, or more accurately, a set of standards that is managed by the World Wide Web Consortium (W3C)³³.The HTML5 standard includes quite a few new constructs. Some of them are: structural organization elements; web storage functionality; and geolocation functionality.¹⁵

Cascading Style Sheets Language

CSS (Cascading Style Sheets) is a stylistic language that defines how web pages are presented. It complements HTML, the language used for describing the structure of web site content. One of its main features is that it enables the complete separation of a web site’s presentation from its content. Furthermore, it makes it easy to enforce site-wide consistency in the presentation of a web site because the entire look and feel of a site can be controlled from a single style sheet document (SSD). CSS is used today by almost all web sites to enhance the web experience.

The CSS language is under ongoing development by the W3C, the international standards organization for the Internet. The W3C writes the specifications web browsers implement to display web pages consistently in compliance with those specifications. Since 1998, W3C has been working on CSS 3. CSS is commonly used within a SSD, which consists of a list of rules. There are three ways to insert CSS into an HTML document: by using an internal style sheet, inline styles, or an external style sheet. ^₃₄₎ CSS has grown from a language for formatting documents into a robust language for designing web applications. Its syntax is easy to learn. Indeed, it’s often the second language developers learn, right behind HTML. ^₃₅₎ CSS was proposed in 1994 and first implemented by Internet Explorer 3 in 1996. It is not a programming language and it is not purely a design tool. ^₃₆₎

JavaScript

JavaScript is considered the most crucial part of a website. It is the most popular language of 2019. Most visited websites are created using JavaScript. It is used on client-side as well as server-side. Earlier, it could only run in a browser, but with the introduction of Node.js, it can run outside, too. Web frameworks and libraries such as Angular are built using it. It plays a vital role in developing dynamic websites. It is used for user interaction, content management, manipulating databases, etc.²¹

User interfaces are increasingly web-based, and JavaScript is the lingua franca of the web browser. There are multiple solutions for producing mobile JavaScript app. JavaScript has shown itself to be well-suited for user-interface programming and many server-side tasks³⁷.JavaScript is the primary programming language used to deliver user experiences on the most ubiquitous platform that exists: the web. JavaScript has had to grow up very quickly in a period of shifting demands. Nowadays, the sheer number of frameworks and libraries available is overwhelming.³⁸

The overwhelming majority of modern websites use JavaScript, and all modern web browsers include JavaScript interpreters, making it the most ubiquitous programming language in history. It is now also the most-used programming language among software developers. It is a high-level, dynamic, interpreted programming language, well-suited to object-oriented and functional programming styles.³⁹

There is a JavaScript library for just about anything to build. JavaScript lives both on the client and the server, on the desktop and on mobile devices. JavaScript is essential in modern web development; single page applications make up the majority of sites being created. Understanding JavaScript lets you add interactivity to your website and lowers the learning curve for things like frameworks. It is an interpreted scripting language. The interpreter is embedded into a web browser which has made JavaScript a language easily accessible. This makes the demand for JavaScript developers very high.⁴⁰

JavaScript has grown into an important feature of every major web browser on the market. No longer bound to simple data validation, it now interacts with nearly all aspects of the browser window and its contents. It is recognized as a full programming language, capable of complex calculations and interactions, including closures, and even metaprogramming. Even alternative browsers, including those on mobile phones and those designed for users with disabilities, support it. Even Microsoft ended up including its own JavaScript implementation in Internet Explorer from its earliest version. JavaScript is made up of three distinct parts: ECMAScript; the Document Object Model; and the Browser Object Model. ^₄₁₎ What we think of as “JavaScript” is standardized as “ECMAScript” by Ecma International, a standards organization responsible for multiple computing standards. The ECMAScript standard is ECMA-262. ^₄₂₎ The organization’s former name was the European Computer Manufacturers Association (ECMA), but they changed their name to Ecma International (with Ecma no longer being an acronym). JavaScript is just one of several ECMAScript implementations. JavaScript is the implementation used in Mozilla’s Firefox.W3C, the Web Hypertext Application Technology Working Group (WHATWG) are the standards organizations for HTML5, CSS, and the DOM. Ecma International is the standards organization for JavaScript.¹⁵

In the beginning, people created HTML pages by typing them in. They quickly realized that a lot of pages share a lot of content: navigation menus, and so on. The nearly universal response was to create template and embed commands to include other snippets of HTML (like headers) and loop over data structures to create lists and tables. This is called server-side page generation: the HTML is generated on the server, and it was popular because that’s where the data was, and that was the only place complex code could be run. Server-side generation can be done statically or dynamically, i.e., pages can be compiled once, stored on disk, and served thereafter, or each page can be recompiled whenever needed, which makes it easy to include dynamic elements like today’s top news story. As browsers and JavaScript became more powerful, the balance shifted toward client-side page generation. In this model, the browser fetches data from one or more servers and feeds that data to a JavaScript library that generates HTML in the browser for display. This allows the client to decide how best to render data, which is increasingly important as phones and tablets take over from desktop computers. It also moves the computational burden off the server and onto the client device, lowering the cost of providing data. Many JavaScript frameworks for client-side page generation have been created, and more are probably being developed now.⁴³

JavaScript has not only changed the way to write frontend, it has also changed the backend programming experience. Code for frontend and backend can be written in JavaScript. It has also modernized, and possibly even popularized, the event-driven system with Node.js. There is no extra runtime needed, and there is no compilation process required to run an application in JavaScript. Google's Chrome browser uses the famous V8 JavaScript runtime, which is used inside Node.js.⁴⁴

JavaScript is not robust at error handling in general. It has the Error object, which is flexible enough. But catching errors with try-catch lacks features found in other languages. ^₄₅₎ The oldest of the three core technologies, JavaScript, was created to enable scripting access to all the elements of an HTML document. It provides a means for dynamic user interaction. Combined with CSS, JavaScript is the power behind dynamic web pages. However, JavaScript can also be tricky to use, due to some major differences in the ways different browser designers have chosen to implement it. Some manufacturers tried to put additional functionality into their browsers at the expense of compatibility with their rivals. Developers have realized the need for full compatibility with one another. However, there remain legacy browsers that will be in use for many years to come. Luckily, there are solutions for the incompatibility problems, such as libraries and techniques that enable developers to safely ignore these differences.¹⁵

CodeIgniter

CodeIgniter is an Application Development Framework, a toolkit, for building web sites using PHP. It enables to develop projects much faster, by providing a rich set of libraries for commonly needed tasks, as well as a simple interface and logical structure to access these libraries. It lets a programmer creatively focus on a project by minimizing the amount of code needed for a given task⁴⁶. It is based on the Model-View-Controller (MVC) development pattern, a software approach that separates application logic from presentation, permitting web pages to contain minimal scripting.⁴⁷

Design

In object-oriented programming, design patterns are useful organizations of state and behavior that make your code more readable, testable, and extensible. MVC is possibly the most popular software design pattern. It consists of three major parts: model, data or information being shown and manipulated; view, what actually defines how the model is shown to the user; and controller, which defines how actions can manipulate the model.⁴⁸

A responsive web design (RWD)⁴⁹, built with HTML and CSS allows a website to "just work" across multiple devices and screens. It enables layout and capabilities of a website to respond to their environment (screen size, input type, and device/browser capabilities). The term was coined by Ethan Marcotte in 2010. He consolidated three existing techniques (flexible grid layout, flexible images/media, and media queries) into one unified approach and named it RWD.⁵⁰

Flexbox is a simple and powerful way to lay out web applications by dictating how space is distributed, content is aligned, and displays are visually ordered, enabling the appearance of stretching, shrinking, reversing, and even rearranging the appearance of content without altering the underlying markup. It is a declarative way to calculate and distribute space. With flexible box module layouts, elements can be made to behave predictably for different screen sizes and different display devices. Flexbox works well for responsive sites, as content can increase and decrease in size when the space provided is increased or decreased. Flexbox can be used to map out an entire document through block layouts or used inline to better position text.⁵¹