Exercise PHP - MySql - 1

PHP & MySql

Back again.

I suggest you learn about creating database and DML first , before take step in this post.

First you need to make connection to database and php file. The code is below :

<?php

$conn = mysql_connect("localhost","root","") or die("server down");

$db = mysql_select_db("inventory",$conn) or die("database dont exist");

?>

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 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.