Learning PHP - Basic 2

Now part 2 of Learning PHP is about Operator in PHP and Parsing Variable. We will discuss more the theory in this post and the excercise in another post.

Operator
Operator is object between two variable in PHP or it can be in one variable, that will change another variable's value, or the variable's value itself. Hmm maybe you still hard to understand this, look at this example :
$x = 1 + 2;
x is variable
1 and 2 is value
and + is the operator

Learning MySql - DML

Data Manipulation Language (DML) is used to manipulate the database or we call it database maintenance. There are many syntax include, but we will discuss the most used syntax, SELECT, UPDATE, DELETE, INSERT, TRUNCATE.

• INSERT

It's used to insert the data into the table. There are 2 variant to write the insert syntax, with type the column name, and without type the column name.

Learning PHP - Basic 1

Welcome back! In last posts we have learned how to create database in MySql, now we will learn about PHP, the code on server-side. PHP (PHP Hypertext Preprocessor) is code/script that running on server-side, the script will create an application that can be integrated with HTML, so the web will work dynamic, not static.

PHP Rule

Learning MySql - Creating Database

Today we will learn how to create database in MySql. First i will give you an example of ERD. You can learn about ERD in previous lesson. I will make the database called 'inventory'.

ERD Inventory

Learning MySql - DDL

Code of DDL

Hello again, today we are gonna learn about DDL. Data Definition Language (DDL) is used to define the structure of database and table. The syntaxt contain four kind : CREATE, DROP, ALTER. The syntaks will be written in Sql tab, besides Structure tab, in MySql. Actually we can write the code in this section, but MySql has give us an easy way to create, delete, the database or table, but sometimes,  we still need to write the code and run it, because not all function of Sql is provided by MySql. We will learn it one by one.

• CREATE

To make a new database, table, index, or procedure, for example :

Learning MySql - Entity Relationship Diagram (ERD)

Back again!
You have learned the lesson before about overview of mysql. Now do you have any idea what ERD is??Maybe some of you have known this before.
Entity Relationship Diagram is a diagram that show the connection of the database that we are gonna use. It contains many tables and the relationship between tables. Inside the tables there are some attributes within it. These attributes shows the character of each table. For example, we have Table Student and Table School

Table Student and Table School

Learning MySql - Overview

MySql

Hello again!
In other post you can learn about Xampp and How to install Xampp, you can check it guys :) . Now i want to give some explanation about MySql. One of many DBMS that exists in this website world.

MySql is a DBMS (Database Management System) that is free-distributed by General Public License (GPL), whereas anybody can use it but not for commercial benefit. MySql is a derivative of Structured Query Language (SQL). SQL is a concept of managing database, which is used to create, change, delete, query of data, that can be done easily and automatically.

What is Apache Web Server? MySql ? Php ?

XAMPP

Look at that pic above? What logo is that?

Okay first i wanna tell you my story. So when i was on my first semester on college, well i'm on Informatics Engineering, i got task to make a blog in wordpress offline, then we should make it online, so anybody can access it. My lecturer said that we should install XAMPP. Okay, so what is XAMPP anyway? what it's function eh?
So based on [wiki] :

XAMPP is a free and open source cross-platform web server solution stack package, consisting mainly of the Apache HTTP Server, MySQL database, and interpreters for scripts written in the PHP and Perl programming languages.

Well, the point is, that we can make a localhost in our computer, so we can access the wordpress that we have build, without connecting to the internet. Three main components in XAMPP is Apache Web Server, MySQL Database, and PHP. Well the details will be explained below.


Web Server Apache
The Web Server is like the environment to contain many application that exist in the internet. So without the web server, no application can running on the internet. Web Server Apache is one of many Web Server that exists, but Web Server Apache is the most popular and most used in this website world. Well if you know Joomla, they recommend to use this web server. If you want to download it, Click Here!


PHP
Next what is PHP?
Again , based on [wiki],

PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. PHP is now installed on more than 244 million websites and 2.1 million web servers

Okay, so if we want to make website on server side, use this. Well i we want to display "i am cool" in the browser with using PHP code, the code are like this :

<?php
          echo("<b>i am cool</b>");
?>

Well, if you try it, maybe you failed to show "i am cool" in the browser. It is because you haven't installed the Web Server completely. Well we will learn about installing and learning PHP in another post ok? so stay tuned in my blog :)
By the way, if you want to know more about PHP you can Click Here!


MySQL
Last is MySQL. MySQL is correspond with the data in a website. It is a server database that is used to save the data in a website, the data here can be many things, table, id, content of posting, and many more. MySQL has its own language, SQL, that is used to make a database, CRUD the data, to query the data, altering, and many things. We can learn about MySQL in this Website. We will learn about the SQL syntaks in another post, so again, wait for it.. :)

Well that's the 3 component of XAMPP. You don't have to download it one by one, you can download it here, on XAMPP website. XAMPP is like a packaging of that 3 components.

Well there are so many other web server, for example :
WampServer
It's just like the XAMPP web server, but i think there is some missing functionality in WAMP server, so i think XAMPP is better. But if you want to download it go click here!

Okay thanks for reading! See you again in another post!

SAP Analyst - Learn

SAP Corp.

the task relevant to an sap systems analyst usually is to subsume business primarily based software that functions upon the netweaver program. sap stands for your own abbreviated version of systems applications and merchandise. the task relevant to an sap job usually is to purpose with knowledge systems also as business functions which can be found used by your companies all over the globe, and create use as to the systems analyst, a large number of whom are needed for the duty.

How to install XAMPP?

XAMPP Look

Hello everybody, welcome to my blog again. This time, i will tell you how to install XAMPP and run it, so you can run a localhost web server on your browser.

If you want a little explanation about XAMPP, you can read it here, on my other post.