List Tutorial
Data Encryption Standard (DES)
11 tahun yang lalu
28 Okt 2010
Learn MySQL
MySQL is an open source database server that seems most popular existence. MySQL is generally used in conjunction with PHP scripts to create an application server that is dynamic and powerful.
Database, is?A database is a structure that is generally categorized in 2 ways: A flat database and a relational database. Relational database is preferred because it makes more sense than a flat database. Well, MySQL is a relational database.In a relational database structure. There are tables that store data. Each table consists of columns and rows. A column defines what type of information will be stored. You need a special column for each type of information you want to keep (such as age, height, weight, address)If the column defines what type of information will be stored, then a row is the actual data stored. Each row of the table is input from the table and contains the values for each column of the table. (Inputs is Bambang example: age of 40 years, 65 kg and 160cm). If discussion of this database is confusing to you, do not despair, we will discuss and demonstrate some examples of tables in the next tutorial.
Why use a Database?
The database will be very useful when you need to store information that is categorized logically. For example, let's say you want to store information about all employees in a company. With the database, you can group together things in business into several tables. Example table could have a table sales, employees, accounts receivable, performance, etc..SQL?
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. In accordance with ANSI, SQL is a standard language for relational database management system. SQL statements used to perform tasks such as updating a database, or retrieve data from a database. Some relational databases using SQL and quite popular are: MySQL, Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, but most of them also have a special extension that can only be used in each system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to do almost anything that needs to be done against a database. This tutorial will introduce you to basic use of the command. You can practice with installing MySQL or other database on your computer.
Ok, next we'll get to know the terms that are very important in the Introduction SQL Query.In previous MySQL tutorial, you learned about databases dah right? Well in the world of daily practice you are rarely going tuh make database theory. You will be a lot to do with the name query. Remember, the Query is your main weapon in the daily working with databases. If you want to learn MySQL, Query tuh learn first. Ready to learn Query? Keep reading guys ...
Query is the term used to express a variety of SQL commands. Each command to do some things against the database. For example, the CREATE will create tables and databases, while the SELECT will select the rows that you've inserted in the database. We will explore in detail later, but for the initial stage, we will try to review some of the structure of queries.
Query Construction begins with one of the following commands:
* ADD
* DROP
* CREATE
* INSERT
* SELECT
* UPDATE
* REPLACE
* DELETE
Query has a lot of leeway in writing. Enter a space and not so diperhatiken in writing. This means that if by chance any spaces mostly write, no problem. Gitu.Nah, Now we already understand that the query was preceded by the command. What should you write after that depending on what commands you use.
Or way of writing query syntax is loose, it means you are free to type enter anywhere without disturbing the code written. Some commands require curly braces ({}), like insert commands below. Writing these brackets will be discussed also in the discussion of the function. Just make sure to end each command that you create with a semicolon (;).
To give an idea for you I'll write some sample queries and note the simplicity yes, let the spirit!
SQL Code:
SELECT * FROM table_name;
The above code selects all rows and columns of the table table_name and display it on us. Here are a few more queries which will very often you wear with the passing of our tutorial.
Database, is?A database is a structure that is generally categorized in 2 ways: A flat database and a relational database. Relational database is preferred because it makes more sense than a flat database. Well, MySQL is a relational database.In a relational database structure. There are tables that store data. Each table consists of columns and rows. A column defines what type of information will be stored. You need a special column for each type of information you want to keep (such as age, height, weight, address)If the column defines what type of information will be stored, then a row is the actual data stored. Each row of the table is input from the table and contains the values for each column of the table. (Inputs is Bambang example: age of 40 years, 65 kg and 160cm). If discussion of this database is confusing to you, do not despair, we will discuss and demonstrate some examples of tables in the next tutorial.
Why use a Database?
The database will be very useful when you need to store information that is categorized logically. For example, let's say you want to store information about all employees in a company. With the database, you can group together things in business into several tables. Example table could have a table sales, employees, accounts receivable, performance, etc..SQL?
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. In accordance with ANSI, SQL is a standard language for relational database management system. SQL statements used to perform tasks such as updating a database, or retrieve data from a database. Some relational databases using SQL and quite popular are: MySQL, Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, but most of them also have a special extension that can only be used in each system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to do almost anything that needs to be done against a database. This tutorial will introduce you to basic use of the command. You can practice with installing MySQL or other database on your computer.
Ok, next we'll get to know the terms that are very important in the Introduction SQL Query.In previous MySQL tutorial, you learned about databases dah right? Well in the world of daily practice you are rarely going tuh make database theory. You will be a lot to do with the name query. Remember, the Query is your main weapon in the daily working with databases. If you want to learn MySQL, Query tuh learn first. Ready to learn Query? Keep reading guys ...
Query is the term used to express a variety of SQL commands. Each command to do some things against the database. For example, the CREATE will create tables and databases, while the SELECT will select the rows that you've inserted in the database. We will explore in detail later, but for the initial stage, we will try to review some of the structure of queries.
Query Construction begins with one of the following commands:
* ADD
* DROP
* CREATE
* INSERT
* SELECT
* UPDATE
* REPLACE
* DELETE
Query has a lot of leeway in writing. Enter a space and not so diperhatiken in writing. This means that if by chance any spaces mostly write, no problem. Gitu.Nah, Now we already understand that the query was preceded by the command. What should you write after that depending on what commands you use.
Or way of writing query syntax is loose, it means you are free to type enter anywhere without disturbing the code written. Some commands require curly braces ({}), like insert commands below. Writing these brackets will be discussed also in the discussion of the function. Just make sure to end each command that you create with a semicolon (;).
To give an idea for you I'll write some sample queries and note the simplicity yes, let the spirit!
SQL Code:
SELECT * FROM table_name;
The above code selects all rows and columns of the table table_name and display it on us. Here are a few more queries which will very often you wear with the passing of our tutorial.
LEARNING HTML
HTML is required primarily to make the web interface, PHP to add the ability to interact with visitors and the ability to store data will be supported by MySQL. Complete has everything. But of course, web programming is not just limited to these. In addition to learning HTML, PHP and MySQL, of course you can also learn another scripting language which will further beautify the look of your website and facilitate the process of web design you like CSS and Javascript. You also may need to increase your skills in creating web design web maker view a variety of applications such as Dreamweaver and FrontPage as well as learning image processing applications such as Fireworks and Adobe.Tetapi for now we will concentrate on learning material on which all their HTML web programming.Although you have mastered a variety of applications that simplify web design, but however in the end you still will need the ability to perform hands-on programming manual alias to perform various tuning in your program.
Introduction to HTML
What is HTML file?
- HTML is short for Hyper Text Markup Language
- An HTML file is a text file containing markup tags
- Markup tags tell the browser how to display a page
- HTML file must have the extension htm or html
- HTML files can be created using a plain text editor you use.
Want to Make tried it?Begin by opening Notepad (on Windows XP for those who have never click on Start, Programs, Accessories, Notepad).Type the following text:
<html><head><title> Title Page </ title></ Head><body>This is my first page. <b> text is bold </ b></ Body></ Html>
Save with the name "halamanku.htm" (do not forget to add double quotes in the name of the file. If you forget the name of the file will use the default extension. Txt to become halamanku.htm.txt).Open your browser (eg Internet Explorer). Kilk File, Open, Browse and select the search that had halamanku.htm files you make. Click OK, and the browser will display the page you created earlier.
Each tag flanked by sign smaller and larger. You can see that the first tag is <html>. HTML tags are usually always have a partner who has the same tag with a little extra slash "/", and you can see a couple of <html> at the end of the script tag is </ html>.<html> Tag tells the browser that this is the beginning of an HTML document. Tag a partner that is </ html> states that this is the end of the HTML document.The text between <head> and </ head> is the text of the header information. Header information is not displayed on the browser window.The text between <title> is the title of your document. This title will be displayed in the caption browser (see at the top right of your browser.)The text between the tags <body> is the text that will appear in your browser window.And lastly, the text between <b> and </ b> will be shown in bold.Now, with this explanation you have started mustinya nodded and felt, was to learn HTML easily ko yah gini J. Hopefully.Now we'll see about the extension. As already submitted in the beginning, we can create an HTML file with 2 extensions ie. Htm and. Html. Now extensions. Htm is intended for the operating system of the past which only supports 3-letter extension. While the extension. Html would be safer to use if the OS and application support as more clearly shown that this is an HTML file.For the record, each one of you make changes to your HTML file, then you must refresh your browser to see changes in how it looks.
Remember this important clue: The HTML document is a text file consisting of HTML elements. Well, the HTML element that is defined using the so-called HTML tags.
The following points will help you remember and understand definition HTML tags:- HTML tag used to mark (a mark-up) HTML elements- HTML tags are in the two characters <and>- The surrounding characters are called angle brackets- HTML tags are usually always in pairs like <b> and </ b>- The first tag is the opening tag, and the second tag is a closing tag- The text between these two tags is the element content- HTML tags are not case sensitive, <b> have the same meaning as <B>HTML Elements
Remember the HTML example from the previous page:
<html><head><title> Title Page </ title></ Head><body>This is my first page. <b> text is bold </ b></ Body></ Html>
This is an HTML element:
<b> text is bold </ b>
This HTML element starts with the opening tag: <b>The contents of the HTML element is: This text is boldThe HTML element ends with a closing tag: </ b>The function tag <b> is to define an HTML element that should be shown in bold.
Well, this is also an HTML element:
<body>This is my first page. <b> text is bold </ b></ Body>
This HTML element starts with the tag <body>, and ends with the closing </ body>The function of the tag <body> is to define the HTML element that contains the body (content) of an HTML document.Why do we use the tags in lowercase?
We have just said that HTML tags are not case sensitive: <B> have the same meaning with <b>. If you surf the Web, you'll see that many web sites use uppercase HTML tags in the source code. But in the example above, we use lowercase letters. Know why?
If you follow the latest web standards, you should always use lowercase tags. World Wide Web Consortium (W3C) recommends the use of lowercase letters in their HTML 4 recommendation, and XHTML (the next generation of HTML) require a tag in lowercase.
Ok, you've just learned about HTML elements. And mustinya now you've got used to the term tag. If you do not familiarize yourself with this term, because in the process of learning HTML, you must be familiar with word tags. Lha wong HTML tags so that ko.Next, we will discuss about some basic HTML TAG especially interesting to change the look of paragraphs, headings, etc..
The most important HTML tags are the tags that define headings, paragraphs and change the line.Like most other programming languages, the best way to learn HTML is to a lot of practice. Exercise, of course, require a tool. Well, basically you can make an HTML file using notepad, but of course a lot of software to write with various facilities that make it easy. Googling aja or search on download.com with keyword HTML Editor..
Introduction to HTML
What is HTML file?
- HTML is short for Hyper Text Markup Language
- An HTML file is a text file containing markup tags
- Markup tags tell the browser how to display a page
- HTML file must have the extension htm or html
- HTML files can be created using a plain text editor you use.
Want to Make tried it?Begin by opening Notepad (on Windows XP for those who have never click on Start, Programs, Accessories, Notepad).Type the following text:
<html><head><title> Title Page </ title></ Head><body>This is my first page. <b> text is bold </ b></ Body></ Html>
Save with the name "halamanku.htm" (do not forget to add double quotes in the name of the file. If you forget the name of the file will use the default extension. Txt to become halamanku.htm.txt).Open your browser (eg Internet Explorer). Kilk File, Open, Browse and select the search that had halamanku.htm files you make. Click OK, and the browser will display the page you created earlier.
Each tag flanked by sign smaller and larger. You can see that the first tag is <html>. HTML tags are usually always have a partner who has the same tag with a little extra slash "/", and you can see a couple of <html> at the end of the script tag is </ html>.<html> Tag tells the browser that this is the beginning of an HTML document. Tag a partner that is </ html> states that this is the end of the HTML document.The text between <head> and </ head> is the text of the header information. Header information is not displayed on the browser window.The text between <title> is the title of your document. This title will be displayed in the caption browser (see at the top right of your browser.)The text between the tags <body> is the text that will appear in your browser window.And lastly, the text between <b> and </ b> will be shown in bold.Now, with this explanation you have started mustinya nodded and felt, was to learn HTML easily ko yah gini J. Hopefully.Now we'll see about the extension. As already submitted in the beginning, we can create an HTML file with 2 extensions ie. Htm and. Html. Now extensions. Htm is intended for the operating system of the past which only supports 3-letter extension. While the extension. Html would be safer to use if the OS and application support as more clearly shown that this is an HTML file.For the record, each one of you make changes to your HTML file, then you must refresh your browser to see changes in how it looks.
Remember this important clue: The HTML document is a text file consisting of HTML elements. Well, the HTML element that is defined using the so-called HTML tags.
The following points will help you remember and understand definition HTML tags:- HTML tag used to mark (a mark-up) HTML elements- HTML tags are in the two characters <and>- The surrounding characters are called angle brackets- HTML tags are usually always in pairs like <b> and </ b>- The first tag is the opening tag, and the second tag is a closing tag- The text between these two tags is the element content- HTML tags are not case sensitive, <b> have the same meaning as <B>HTML Elements
Remember the HTML example from the previous page:
<html><head><title> Title Page </ title></ Head><body>This is my first page. <b> text is bold </ b></ Body></ Html>
This is an HTML element:
<b> text is bold </ b>
This HTML element starts with the opening tag: <b>The contents of the HTML element is: This text is boldThe HTML element ends with a closing tag: </ b>The function tag <b> is to define an HTML element that should be shown in bold.
Well, this is also an HTML element:
<body>This is my first page. <b> text is bold </ b></ Body>
This HTML element starts with the tag <body>, and ends with the closing </ body>The function of the tag <body> is to define the HTML element that contains the body (content) of an HTML document.Why do we use the tags in lowercase?
We have just said that HTML tags are not case sensitive: <B> have the same meaning with <b>. If you surf the Web, you'll see that many web sites use uppercase HTML tags in the source code. But in the example above, we use lowercase letters. Know why?
If you follow the latest web standards, you should always use lowercase tags. World Wide Web Consortium (W3C) recommends the use of lowercase letters in their HTML 4 recommendation, and XHTML (the next generation of HTML) require a tag in lowercase.
Ok, you've just learned about HTML elements. And mustinya now you've got used to the term tag. If you do not familiarize yourself with this term, because in the process of learning HTML, you must be familiar with word tags. Lha wong HTML tags so that ko.Next, we will discuss about some basic HTML TAG especially interesting to change the look of paragraphs, headings, etc..
The most important HTML tags are the tags that define headings, paragraphs and change the line.Like most other programming languages, the best way to learn HTML is to a lot of practice. Exercise, of course, require a tool. Well, basically you can make an HTML file using notepad, but of course a lot of software to write with various facilities that make it easy. Googling aja or search on download.com with keyword HTML Editor..
Learn PHP
Learning PHP, what and why we need to learn PHP?
Anyone who has never learned to design web sites will come to a point where we begin to realize the limitations of HTML and client-side scripting languages such as CSS and Javascript. Although programming languages are at the core of web development, but their main function is to control the display of text and graphics only. Because they do not have the ability to manipulate information as needed, or to communicate with web servers, so that can only produce static Web pages.
Well this is where the need for dynamic web pages began to appear. Let's say you want to create a survey to collect information from your web visitors. You could easily create a form with HTML that contains all your questions, and ask your visitors to send the results via email. But to turn raw information into a form that has meaning, then you have to process them manually. The process is very time-consuming.
Fortunately, by using scrip, there is an easier way to gather and evaluate the survey results, or any form. Instead of sending information via email, a script can be designed to capture and store information into a database. Another script will communicate with the database, collecting and classifying information, then display it when there are guests who need a web site. Of course, the script can also display graphs, a percentage to the total, or display the information in any other way you can imagine, automatically, and on demand.
Well, today, more and more web developers are using PHP. That means, you must follow with the main stream with PHP learn how to follow it.
What Is PHP
PHP (PHP Hypertext Preprocessor) is an embedded scripting language on the server side. If we use the colloquial term, perhaps like this: Processor PHP is running on the server (Windows or Linux). When a page that contains PHP, the processor translates and executes all the commands in the page, and then displays the results to the browser as HTML pages biasa.karena this translation occurs on the server, a page written with PHP can be seen with the use of all kinds browser, on any operating system
Like most other scripting languages, PHP can be embedded directly into HTML.
PHP code separated from HTML by Start and End. When a document is parsed, the PHP processor only interprets the marked area only, and displays the results in the same place.
Ironically, PHP also has the ability to almost completely separate code from HTML.
For projects with a larger, this method is ideal because it allows designers to work on the layout of a page without affecting the code PHP.
Anyone who has never learned to design web sites will come to a point where we begin to realize the limitations of HTML and client-side scripting languages such as CSS and Javascript. Although programming languages are at the core of web development, but their main function is to control the display of text and graphics only. Because they do not have the ability to manipulate information as needed, or to communicate with web servers, so that can only produce static Web pages.
Well this is where the need for dynamic web pages began to appear. Let's say you want to create a survey to collect information from your web visitors. You could easily create a form with HTML that contains all your questions, and ask your visitors to send the results via email. But to turn raw information into a form that has meaning, then you have to process them manually. The process is very time-consuming.
Fortunately, by using scrip, there is an easier way to gather and evaluate the survey results, or any form. Instead of sending information via email, a script can be designed to capture and store information into a database. Another script will communicate with the database, collecting and classifying information, then display it when there are guests who need a web site. Of course, the script can also display graphs, a percentage to the total, or display the information in any other way you can imagine, automatically, and on demand.
Well, today, more and more web developers are using PHP. That means, you must follow with the main stream with PHP learn how to follow it.
What Is PHP
PHP (PHP Hypertext Preprocessor) is an embedded scripting language on the server side. If we use the colloquial term, perhaps like this: Processor PHP is running on the server (Windows or Linux). When a page that contains PHP, the processor translates and executes all the commands in the page, and then displays the results to the browser as HTML pages biasa.karena this translation occurs on the server, a page written with PHP can be seen with the use of all kinds browser, on any operating system
Like most other scripting languages, PHP can be embedded directly into HTML.
PHP code separated from HTML by Start and End. When a document is parsed, the PHP processor only interprets the marked area only, and displays the results in the same place.
Ironically, PHP also has the ability to almost completely separate code from HTML.
For projects with a larger, this method is ideal because it allows designers to work on the layout of a page without affecting the code PHP.
