Sunday, March 31, 2013

Used for Retrieving Data, Query Languages

A computer language that's often used on Database Management System (DBMS) and by other artificial language for querying a database or information system, is not a programming language but a query language. A query language is important to a server-side programmer, such as PHP(: Hypertext Preprocessor) developers, because it is a way to get the information that intended for a specific user, into a database. There are classifications of query languages like other computer language, and the popular three for the Web, of them are listed below, base on their popularity:

  1. SQL, pronounced not as a word on My Sequel (MySQL) but as just exact as its letter names "S-Q-L", which is short for Structured Query Language and sometimes mistakenly referred as a programming language, instead of a well known class of a database query language for accessing and manipulating relational databases that items are organized in a set of tables, in which item can have relation to another item that's into another table.
    Let Say We've Relational Database Tables:
    - Customers - Orders
    ID Name
    01 Mark
    02 Anthony
    ID No
    01 18495
    02 82796
    Sample of SQL Queries on Database:
    SELECT Customers . Name AS `Customer` , Orders . No AS `Order No.`
    FROM Customers
    INNER JOIN Orders ON Customers . ID = Orders . ID
    ORDER BY Customers . Name
    SQL Queries' Sample Result:
    Customer Order No.
    Anthony 82796
    Mark 18495
    • MySQL is the most used brand of a free Relational Database Management System (RDBMS) which administering by phpMyAdmin a free web database management for RDBMS. A relational database can be called as a server for storing sensitive data items. Most relational databases are administers by database managements.
      • Generally, a relational database is administering by a database management such phpMyAdmin for MySQL, which can perform various tasks like creating, modifying or deleting a database, table, field or a row, browsing, exporting or operating a table, running SQL query or searching data and more!
  2. XPath, the XML Path Language, is a declarative language which is one of the 3 parts of Extensible Stylesheet Language (XSL), used to select nodes from an XML document, and also used by XML Pointer Language (XPointer) to link hyperlinks in XML document to the specific parts of another XML document, and used by XQuery which is built on XPath expressions.

Monday, March 18, 2013

Forms and Meanings, Programming Languages

A web programming language is used for computer programming (often shortened to programming, scripting or coding) that have relation on the World Wide Web. The programming languages have many different types as other artificial languages, and the two types of these that's used for the Web, are listed below:
  1. A scripting is the number one type of programming language that's often used for web development, and this kind of type is divided into two different classes which are nested here:
    1. A client-side scripting, sometimes called as browser-side scripting, is an act to program the web browser of the viewer of a client-side scripted web page or site. In other words, all of client-side scripts are executable on a web browser that supported it.
      • JavaScript is the world's most popular programming language as it's for the websites, servers, PCs, laptops, tablets, smart phones, and more! An external JavaScript file have .js extension. JavaScript is the only client-side scripting language that supported by all major web browsers, unlike VBScript (Visual Basic Scripting Edition) a Microsoft scripting language which only supported by Internet Explorer.
      JavaScript Input's Sample:
      <p id="fnmpl"></p>

      <script>
      setInterval(function() {
          timer()
      }, 1000);

      function timer() {
          var d = new Date();

          var t = d.toLocaleTimeString();

          var weekday = new Array(7);
          weekday[0] = "Sunday";
          weekday[1] = "Monday";
          weekday[2] = "Tuesday";
          weekday[3] = "Wednesday";
          weekday[4] = "Thursday";
          weekday[5] = "Friday";
          weekday[6] = "Saturday";

          var day = weekday[d.getDay()];

          var date = d.getDate();

          var month = new Array();
          month[0] = "January";
          month[1] = "February";
          month[2] = "March";
          month[3] = "April";
          month[4] = "May";
          month[5] = "June";
          month[6] = "July";
          month[7] = "August";
          month[8] = "September";
          month[9] = "October";
          month[10] = "November";
          month[11] = "December";

          var m = month[d.getMonth()];

          var y = d.getFullYear();

          document.getElementById("fnmpl").innerHTML = t + ', ' + day + ', ' + date + ' ' + m + ', ' + y;
      }
      </script>

      Sample's Page Output:

    2. A server-side scripting is an act to program the server of a web document or site, such what content will the web server deliver to a specific user. In other view, a server-side script will first executes on the web server before the server deliver it to a web browser.
      • “PHP: Hypertext Preprocessor” or PHP is the most used server-side scripting language and was designed for web development. One of the reasons why this language was often used by web developers is because almost all web hosting companies and even a free host have supported this computer language.