Final Exam x Tumblr Quotes

ALL THE BEST AND GOODLUCK FOR FINAL EXAM!!

here are some random quotes in case u guys have no motivation to study - its actually for me cause i am so lazyyyyy to study rn 

*sighhh

Hope this quotes gonna give some motivation to u. Stay positive, keep struggling. Insya allah one day we will achieve what we wants. See u later xoxo 

Goodbye 2017 *waving hands

CSS Template Online : where to find?

I already search for css template online and found several websites that provide a lot of  CSS Template. Let me share it here.

I will put the link here, so check it out if u interested to use it for your final project :) 

1. W3 SCHOOLS

https://www.w3schools.com/w3css/w3css_templates.asp

They provide a demo and we can try to create it. The design is so simple and neat. I love it!

2. TEMPLATED

https://templated.co/

This website also provide demo and the user can download it for free. 

But, some of the templates are premium (means user need to buy it)

3. TOOPLATE

http://www.tooplate.com/

4. TEMPLATEMO

http://www.templatemo.com/

Thats all for now. Hope it is useful for u guys. Write to u guys soon. Bye! 

PHP vs MYSQL

1. PHP 

PHP is a server-side scripting language that has its main implementation in web development. However, it can be used as a general-purpose programming language. PHP was originally created by Rasmus Lerdorf in 1995 and it is currently managed by The PHP Group. PHP originally stood for Personal Home Page, however it was later renamed. It now stands for PHP: Hypertext Preprocessor, a recursive acronym. PHP is free software released under the PHP License, as is incompatible with the GNU General Public License (GPL) due to restrictions on the usage of the term PHP.

PHP is an open source, server-side, HTML embedded scripting language. It can basically perform any task that other CGI programs can, but it is mainly used to create dynamic Web pages. Its main advantage is that it is compatible with many types of databases. Furthermore, PHP can talk across networks using IMAP, SNMP, NNTP, POP3, or HTTP.

PHP includes a command-line interface capability and can be used in standalone graphical applications. PHP commands can be embedded directly into an HTML source document rather than calling an external file to process data. In the HTML document, the PHP script is enclosed within special PHP tags. Due to these tags, the programmer can alternate between HTML and PHP instead of having to rely on heavy amounts of code to output HTML. Also, as PHP is executed on the server, the client cannot view the PHP code.

2. MYSQL

MySQL, on the other hand, is an open source relational database management system (RDBMS). MySQL is officially pronounced as "My S-Q-L", but it is also called "My Sequel". It is named after co-founder Michael Widenius' daughter, My. SQL stands for Structured Query Language. MySQL is the world's most used RDBMS, and runs as a server providing multi-user access to a number of databases. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which is now owned by Oracle Corporation.

MySQL is a popular choice of database for use in web applications. It is a central component of the widely used ‘LAMP’ open source web application software stack, as well as other AMP stacks. LAMP stands for "Linux, Apache, MySQL, Perl/PHP/Python." MySQL is often used by free-software-open source projects that require a full-featured database management system, such as TYPO3, Joomla, WordPress, phpBB, MyBB, Drupal, etc. MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google, Facebook, Twitter, Flickr, Nokia.com, and YouTube.

3. DIFFERENCES 

The main difference between PHP and MySQL is that PHP is a scripting language, whereas MySQL is a relational database management system. They are two completely different things and hence are used for two different purposes.

As stated, PHP is a server-side scripting language. A server-side scripting language allows the user to embed little programs or scripts into the HTML of a Web page. In executing, such scripts allow the user to control what will actually appear in the browser window. These scripts more flexible than what is possible using straight HTML.

MySQL, on other hand, is a RDBMS, which allows the integration of a database either on the web or on a server. It can often be used in collaboration with PHP or other scripting languages such as JavaScript.

SQL DML

1. What does Data Manipulation Language(DML) Mean?

A data manipulation language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data. DML is mostly incorporated in SQL databases.

2. The functional capability of DML is organized in manipulation commands:

• SELECT: This command is used to retrieve rows from a table. The syntax is SELECT [column name(s)] from [table name] where [conditions]. SELECT is the most widely used DML command in SQL.


• UPDATE: This command modifies data of one or more records. An update command syntax is UPDATE [table name] SET [column name = value] where [condition].


• INSERT: This command adds one or more records to a database table. The insert command syntax is INSERT INTO [table name] [column(s)] VALUES [value(s)].


• DELETE: This command removes one or more records from a table according to specified conditions. Delete command syntax is DELETE FROM [table name] where [condition].