Showing posts with label Define. Show all posts
Showing posts with label Define. Show all posts
MySQL is the world's most popular open source free database management system and is popular among developers during application development. Because MySQL is a high-speed, stable, and easy-to-use database, it is portable, works on multiple operating systems that provide a large system of very powerful utility functions. With high speed and security, MySQL is suitable for applications that access databases on the internet.

What is the database?

A Database is a separate application that stores a data set. Each database has one or more separate APIs to create, access, manage, search, and replicate the data it holds.
Some other types of data stores can be used, such as files on file systems or large Hash Tables, but data capture and recording cannot be quick and easy with these types of data stores. systems.
So, today, we use Relational Database Management Systems (RDBMS) to store and manage large amounts of data. It is called a relational database, because all data is stored in different data tables and relationships established by using Primary Key and some other keys. known as Foreign Key.
relational database management system (RDBMS) is a software that:
  • Gives you the ability to deploy a Database with data tables, columns (columns), and indexes (Index).
  • Ensure that the Referential Integrity (can translate as relationship integrity) between the various rows and tables.
  • Automatically update the index.
  • Interpret an SQL query and combine information from different tables.


Before going into the MySQL database system concept, let's review some database related definitions:
  • Database: A database is a collection of data tables, with related data.
  • Data table: A table is a data matrix. A table in a database looks like a simple spreadsheet.
  • Column: A column contains the same data type, such as a customer name.
  • Item: A row (row, entry, record) is a group of related data.
  • Redundancy: (can be interpreted as redundant data) Data is stored twice, to make the system faster.
  • Primary Key: A Primary Key is unique. A key value cannot appear twice in a table. With a key, you can find the majority on a row.
  • Foreign Key: You imagine Foreign Key as a pin between two tables.
  • Compound Key: A Compound Key (or composite key) is a key that consists of multiple columns, because a column is not unique.
  • Index: An index in a database similar to the index in a book.
  • Referential Integrity: Make sure that a Foreign Key value always points to an existing row.

What is MySQL?

MySQL is a fast and easy to use RDBMS. MySQL is being used for many large and small businesses. MySQL developed, published, supported by MySQL AB, is a Swedish company. MySQL has become quite popular for many reasons:
  • MySQL is open code. So, to use it, you don't have to spend a penny.
  • MySQL is a very powerful program.
  • MySQL uses a standard form of well-known data language that is SQL.
  • MySQL works on many operating systems and in many languages ​​such as PHP, PERL, C, C ++, Java, ...
  • MySQL works fast and healthy even with large data sets.
  • MySQL is very friendly with PHP, a very valuable language to learn about Web development.
  • MySQL supports large databases, up to 50 million rows or more in a table. The default file size is limited to 4 GB, but you can increase this size (if your operating system can handle it) to reach the theoretical limit of 8 TB.
  • MySQL is adjustable. Open source GPL licenses allow programmers to modify MySQL software to suit their specific environment.
MMO stands for "Make Money Online", also known as making money online. This is the job you use a computer or phone (mostly computer) with an Internet connection to do the work in the end to earn money.
Make Money Online

Is MMO real?

You are puzzled, doubts about working online can you get money?
Making money at home is absolutely true, many large and small companies will pay you if you do something that benefits their online marketing or become partners with them, no matter who you are. What level, just you can afford it. Here are 2 very simple examples of MMO:
  • When you place Google ads on your website and have readers click on ads, Google Adsense will pay you.
  • You can find and sell products in the form of affiliate marketing on Clickbank, when someone buys through your separate link, you will get very high commission.
These are just 2 of many different MMO forms. And the example below is the payment result of - an advertising network Popunder .
There are many forms of reputable MMO, but there are no lacking forms, and you make very little, even cheating. Make the right choice when deciding to make money online.

MMO forms should be involved

There are many different forms of MMO, so you should consider carefully the ability, credibility and long-term of these forms, below I will introduce you to some forms to participate:

1. Make money by developing websites

This is the most popular form of making money online, with website development you can get many different ways of MMO such as:
  • Place ads from networks:  Example Google Adsense, Chitika, PropellerAds ... or contract ads between you and the ad buyer. If you have good visits, many people will contact you.
  • Sell ​​your own products:  You can make websites, relevant content about products you have and navigate readers to buy your own products.
  • Selling other people's products for affiliate marketing:  This is an MMO form that is very HOT because you do not need to create products to sell but just promote other people's products with a very high commission rate. High, even 100% commission.

2. Make money with Affiliate Marketing

As mentioned above, affiliate is very potential and can give you a huge income. You don't need to have the skills to create products that you can promote other people's products. Here are some TYPES OF TYPICAL MMOs that belong to affiliate marketing that I recommend to join.
  • Make money with Product Launch: You can start with this way to get the skills to make web, choose products, promote, basic SEO at the beginning to have core knowledge, you can join Refer to the article introducing how to make money Launch Product.
  • Make Money with Nichesite: It is a difficult form but can bring a big income. That means you will make a website in a certain niche and then sell affiliate products related to that niche. Amazon is a place where many people often choose to make money with Nichesite because it is almost "all kinds of products".
  • Making money with Authority Site: As a more advanced form of Nichesite, meaning nichesite is difficult, this form is even more difficult (but depending on the niche). This is the way you make a website specializing in a certain field (eg cooking, beauty, gardening ...) and selling related products. There are many people who have successfully built the Authority Site to make money with Clickbank.

3. Make money with selling T-shirts - T-Shirt Business

This form of MMO is only for people with a lot of capital, at least $ 200 or more. Your first job is to design images that can be attached to a shirt  (this step is mostly rented if you don't know the design) . Many websites allow you to upload photos and attach them to a plain shirt, set a price, and you will wear promotional gowns, websites are companies that will take over the shirt and ship them to customers.
The market you are targeting is the US and EU countries because these countries have strong growth in payment, online shopping and when buying T-shirts, they often wear shirts that bring pride, showing affection. their charm. There are many websites that have this kind of business, most prominent are Teespring, Viralstyle, Fabrily, Sunfrogshirt ...

4. Make money by trading products you create yourself

If you have high skills, for example programming skills, writing applications, tools to support others, for example:
  • WordPress theme / plugin
  • Apps, iOS games, Android
  • Software to support Internet Marketing
  • ...
So MMO is a great opportunity for you, you can write software, applications that bring many benefits to users and then promote or cooperate with others to promote your products.
Or if you do not have high skill in programming, you can completely create other products such as Ebook, Training Video ... instructions on anything you think someone will need and start planning promotions. it. However, remember to create real value for customers.

MMO forms should not be involved

In addition to the form of prestigious MMO, so participating in the above mentioned, there are many other forms that you will meet later, but I recommend to stay away. Most of these forms do not require high skill, but the level of risk is quite large and earn very little money.
I will list the options  DO NOT  join this here so that if you meet later, please do not participate.

1. PTC (PAID TO CLICK) - Click the ad

Many websites will pay you when you click the ad. This form is very popular, you may later see a lot of people doing and inviting you to do it. Making money with it is real, but earning it with very little money ($ 0.0x for each click and one day it only gives you a few dozen clicks). If you want to earn more to upgrade your account and hire ref to click for you, pay back after a few months, sometimes lose it because many networks have a form like this scam.
In addition, you have to recruit subordinates  (such as multi-level) to  register via your link, upgrade membership and do the same as you, you will get a commission. This is the reason that you will see a lot of other people introduce about PTC only for the purpose of finding subscribers through the link. If you encounter these situations, stay away.

2. PTU (PAID TO UPLOAD) - Make money by uploading documents

This is the way you share documents on networks, when someone downloads documents you will receive money.
I used to make some money with PTU a little bit, but if I want to make a lot of money, I have to have tricks and share documents related to copyright. But when you share copyright materials, you are violating the law. And networks may also  not pay you  when your documents share copyright infringement.
I played PTU for a short time and realized this problem and I stopped. If you want to find a document sharing form to receive money, think about creating a personal product and then selling it, you can earn a lot more than PTU.

3. OFFER - Pretend to be an American in a survey

The Offer is a form of pretending to be a foreigner (usually US), with a name, age, personal information such as an address, phone number ... and you also assume an IP address from that country. You then get these FAKE information to register for incentives from websites (Many US websites reward users for registering, conducting surveys, filling out forms ...).
For me, this is no different than you are cheating on others, and if they find out, your account will be banned and they will  not pay the previous money to you .
If someone tells you to make an offer according to the instructions, you should not participate because this is a FAKE form, dishonest, you also earn very little.

4. Survey (Survey) / Read promotional emails

Survey is that you will have to sit the survey of companies to receive a few thousand dong. Reading promotional emails is almost the same, you sign up and open emails daily to read the ads, follow the instructions ...
This is also an MMO but the money you earn is  LITTLE , you shouldn't waste time doing things like this and there are also many fraudulent companies that don't pay you.

5. HYIP (Super profitable investment - there is no profit at all)

You have heard any form of money that you do not need to do, just recharge and wait for high interest rates. Secret words make many people lose this investment.
Remember the rules of a HYIP site like this: First pay for prestige => When many people join it will flare money and you lose it. This is a very dangerous form of investment, you should not participate.

6. BETTING / GAMBLING - Gambling, online betting

This is not an MMO, but many of you want to participate, Betting and Gambling are forms of gambling, playing LOTO ... If you join these forms, it is no different from bringing you money to gamble in real life. In real life, it is a fraud to just hit the online system ... So be careful, not tempted.

7. BINARY OPTION / FOREX - Securities

These forms involve securities, if you are new and uninformed, do not choose, otherwise there is a very high risk.
Good luck!
Source: Kiem Tien Center .
Localhost is a term that is mentioned a lot in web design and blogger. So what does this term mean? How does it work? How to install localhost and how to use it? This article will explain and share with you this term.

What is localhost?

Localhost is essentially a webserver including Apache, MySQL, PHP and phpMyAdmin (AMPP) installed on your computer, using your computer's hard drive as a website storage and installation space without purchasing host
Localhost is used to install and test websites on computers to help manipulate and process data faster, not lose too much work and don't worry about losing connections like online hosting.
Since it is located on your own computer, only you can view the website you have installed on localhost that others cannot view.

How does localhost work?

As mentioned above. Localhost is a collection of many software (AMPP) installed on the computer. Depending on the installation packages of different providers, the folders containing installation data may be www or htdocscreated in the localhost installation directory.
By default the path http: // localhost / will point to the www or htdocs directory. When you create a directory at www or htdocs, the path will be http: // localhost / directory-name .
For example, when creating a wordpress directory  in htdocs , the path will be http: // localhost / wordpress .

Use which software to create Localhost?

Currently there are many popular software that can help you easily create localhost. However, I recommend using XAMPP to install localhost because this software is simple and easy to use.
List of software that creates localhost:
jQuery is a new style library of JavaScript, created by John Resig in 2006 with a great motto: Write less, do more - Write less, do more.

Introducing jQuery

jQuery simplifies HTML transmission, event handling, animation and Ajax interaction. With jQuery, the Rapid Web Development concept is no longer strange.
jQuery is a set of JavaScript utility tools that simplify diverse tasks with less code writing. The following lists some of the most important features supported by jQuery:
  • Manipulating the DOM - jQuery makes it easy to select DOM elements to traverse (browse) as easily as using CSS, and edit their content by using the open source Selector media, which is called Sizzle .
  • Event handling - jQuery helps to interact with users better by handling diverse events without making HTML code messy with Event Handler.
  • AJAX support - jQuery helps you a lot to develop a feature-rich and responsive site using AJAX technology.
  • Effects - jQuery comes with a lot of beautiful and varied effects that you can use in your websites.
  • Compact - jQuery is a lightweight library - it is only about 19KB (gzipped).
  • Most supported by modern browsers - jQuery is supported mostly by modern browsers, and works well on IE 6.0+, FF 2.0+, Safari 3.0+, Chrome and Opera 9.0+.
  • Update and support the latest technologies - jQuery supports CSS3 Selector and basic XPath syntax.

How to use jQuery?

The most common way is to use Google Hosted Libraries , just insert the following code into the website:
<script src = "" > </script> 
JQuery syntax for more reference here .
JavaScript is a programming language of HTML and WEB. It is lightweight and most commonly used as part of web pages, but their implementation allows Client-Side scripts to interact with users and create dynamic websites. It is an interpreted programming language with object-oriented capabilities.

Introducing JavaScript

JavaScript was first known as Mocha, and then LiveScript, but Netscape changed its name to JavaScript, because of its popularity as a Java phenomenon at the time. JavaScript first appeared in Netscape 2.0 in 1995 with the name LiveScript. The versatile core of this language has been embedded in Netscape, IE, and other browsers.
The ECMA-262 Specification defines a standard version of the JavaScript language as follows:
  • JavaScript is a lightweight, interpreted program language.
  • Designed to create central network applications.
  • Add and integrate with Java.
  • Add and integrate with HTML.
  • Open and multi-platform.

Client-side JavaScript

Client-Side JavaScript is the most popular form of this language. The script should be included in an HTML document for coding to be interpreted by the browser.
This means that a website doesn't need to be a static HTML, but can include programs that interact with users, control the browser, and create dynamic HTML content.
Client-Side JavaScript technology provides many advantages over the CGI Server-Side Script. For example, you can use JavaScript to check if the user has entered a valid email address in a Form field.
JavaScript code is executed when the user submits a Form, and only if all inputs are valid, they will be submitted to the Web Server.
JavaScript can be used to capture user-initiated events such as clicks, link navigation, and other activities that users create.

The advantages of JavaScript

The advantages of using JavaScript are:
  • Less Server interaction: You can confirm user input before sending the page to the Server. This saves server load, meaning that your server loads less.
  • Immediate feedback to visitors: They don't have to wait for a site to reload to see if they forgot to enter something.
  • Increased interoperability: You can create interfaces that react when users hover over them or activate them via the keyboard.
  • Richer interface: You can use JavaScript to include items such as Drag and Drop components (DnD) and sliders (Slider) to provide a Rich Interface to the guest site. your access.

Limitations of JavaScript

We cannot treat JavaScript as a full-fledged program language. It lacks the following important features:
  • Client-side JavaScript does not allow reading and writing files, because of security reasons.
  • JavaScript is not used for networking applications because there are no support available.
  • JavaScript does not have any multi-threading or multi-processing capabilities.
Again, JavaScript is a lightweight, interpreted program language that allows you to build interoperability in static HTML pages.
Welcome to the HTML world, and this is also the introduction for you to know what HTML is and how it is applied, to understand why it is important whether you are a professional or amateur website maker. must know through it. Even people who are not very relevant like editors need to know HTML, why? After going clear back.

What is HTML?

HTML is the acronym of the phrase H yper T ext M arkup L anguage (More in ) translated Markup Language Hypertext , is used to create a The website, on a website may contain multiple pages and each page is referred to as an HTML document (sometimes I will write an HTML file). The father of HTML is  Tim Berners-Lee , who also gave birth to the World Wide Web and the president of the  World Wide Web Consortium(W3C - organization that sets standards on the Internet environment).
An HTML document formed by HTML elements (HTML Elements) is specified by tags (tags), these pairs are enclosed by a parenthesis (for example <html>) and will usually be declared into a pair, including opening and closing cards (for <strong>example </strong>and). Documents that want to be marked with HTML will be declared inside the tag pair (for example <strong>Đây là chữ in đậm</strong>). But some special tags do not have a closing tag and the data declared will be in attributes (such as tags <img>).
An HTML file will include HTML elements and be saved in the extension as .html or .htm .

How is HTML processed?

When an HTML file is formed, processing it will be done by the web browser. The browser will act as a reader to understand the HTML content from the internal tags and will switch to the highlighted text for reading, listening, or understanding (understood by computer bots).

What role does HTML play in the website?

As I said, HTML is a hypertext markup language, so it will play a role in building hypertext structure on a website, or declaring digital files (media) like images, videos, music.
The role of each language in the website
That doesn't mean using HTML only to create a website that HTML plays only a formative role on the website. For example, a website like will be formed by:
  • HTML - Build the structure and format of hypertext.
  • CSS - Formatting raw hypertext generated from HTML into a website layout, with colors, background images ...
  • Javascript - Create events that interact with user behavior (for example, clicking on the image on it will have a zoom effect).
  • PHP - Programming language to handle and exchange data between the server and the browser (for example, posts will be stored in the server).
  • MySQL - Structured query database management system (SQL - for example, posts will be saved with SQL data form).
But here, you only need to care about HTML temporarily. Easier to understand, think that if the website is a complete body, HTML is the skeleton of that body, it is like a frame.
So, no matter what kind of website the website is, communicating with any programming language to handle the data, you still need HTML to display the content for visitors to see.
By the way, I also say, the website has two main types:
  • Static website (static web) - A website that does not communicate with the web server to send and receive data but only the data that is declared by HTML and the browser.
  • Dynamic web site - As a website will communicate with a server to send and receive data, the data will be sent out to users in HTML documents and the browser will display it. In order for a website to be able to communicate with web servers, it will use some server-side programming languages ​​such as PHP, ASP.NET, Ruby ... to implement. For example, a website made with WordPress is a dynamic website.

HTML reference resources

In this series, I have not talked all about the tags in HTML but only through the most important tags because you will use it often. So, go to the HTML Reference page to refer to the meaning and usage of all HTML tags.
Source: Thạch Phạm Blog .
What is email marketing is the form of using email (email) with content about information / sales / marketing / introducing products to customers that they want. Each email is sent to potential customers or existing customers can be considered as email marketing.
Email Marketing

Email Marketing

When doing marketing campaigns, product advertising is definitely the first thing you think about email marketing. Simply because email marketing is a very useful advertising method for marketing campaigns. But many of you who start creating and sending email still don't understand the most general way about email marketing, and the benefits of email marketing bring to businesses. This article will give you the most complete view of email marketing.

Function of email marketing
Email list management: Email marketing will help you manage email lists clearly and specifically. Sorting by geography, origin, gender, age, job ...
Monitor and report: You will know the email rate inbox, email open rate, click rate, conversion rate. Detailed tracking of customer interaction rates.
Automate campaigns: You can go to a campaign, and set a specific email schedule, emails will be automatically sent quickly and accurately.
Various email templates: Many professional, diverse templates for you to choose, will minimize the time in writing content.
Benefits of email marketing
First, when compared with traditional advertising by designing banners, billboards, and email marketing, it will help to save design costs, transportation costs and rental costs.
Email marketing helps businesses build brands in the eyes of consumers, increase relationships, create trust with customers.
In addition, when using this method for marketing, you can statistically detail the number of people who click on the mail, click on the links from which you will be able to understand the needs of customers, determine the right gain customers' tastes to make appropriate adjustments.
In addition, you can automate your marketing campaign by setting a customer-specific email marketing marketing schedule by week or by month.
Source: .