행복한 삶으로의 초대 (유니시티)

After we discuss array in PHP, today we’ll discuss some array functions that we need to know. It will help us a lot to quickly find a solution when we face the same problem. As we already know, there are a lot of functions related to the array and of course not all of them will be used, therefore, in this short tutorial we’ll only discuss some of them are frequently used (f..

This time, we’ll discuss array in PHP. Array is a kind of data type that will almost certainly be used by the PHP programmers as its flexibility to accommodate data. The array can also hold dozens or even hundreds of data. The topic about array is very very wide, so it is not possible to discuss all of those in this short article. So, in this short article, we’ll discuss th..

Previously, we have discussed how to create a table using HTML 5 and how to style a table with CSS 3, to complete the table design series. This time, I’ll show you 10 table design using CSS 3 that I have made a while back, hope it will give you a fresh idea in designing HTML table. DEMOThere are several things to be considered when designing a table, so it will gain the visi..

Table is one important element for displaying data. Important data become unattractive if the table is not interesting. So, this time, we will discuss styling table using CSS 3, so that out table becomes more beautiful. So, what is an interesting table? in a simple word: it’s convenient to see both for the neatness of the layout and the color combination being used. The color..

Table is one important element for displaying data. Although relatively easy to create a table, there are important things that need to be known, so this time, we will discuss how to create table using HTML 5 and CSS 3. Actually, to create a table, we only need to code HTML, while CSS is used to design the table so it looks more neat and beautiful. In this tutorial we’ll crea..

Continuing learning about PHP and MySQL, this time, we’ll discuss how to display MySQL data in HTML Table With PHP. When retrieving data from a MySQL table, generally we’ll display it in a table form, by displaying data in a table form, will make it more attractive and easier to read. In this tutorial, we’ll learn how to do it. The final result will look like the followin..

How to Connect MySQL Database Using PHP – Safe to PHP 7 In order to be able to interact with a database, especially MySQL database, the first thing we need to do is connecting to the database, there are many ways to do it, so this time, we’ll discuss how to connect MySQL Database using PHP PHP is growing, its built-in functions are continuously developed and maintained. For..

LOAD DATA LOCAL INFILE [CSV화일] INTO TABLE [테이블이름] FIELDS TERMINATED BY ",";

▶ '김' 으로 시작하는 사람을 모두 조회 - SELECT id,name FROM member WHERE name LIKE '김%' ID NAME 1 김건모 2 김유리 ▶ '진'으로 끝나는 사람을 모두 조회 - SELECT id,name FROM member WHERE name LIKE '%김' ID NAME 1 김진 2 고유진 ▶ '프린터' 가 들어가는 제품을 모두 조회 - SELECT id,p_name FROM member WHERE p_name LIKE '%프..

ALTER TABLE [테이블명] AUTO_INCREMENT=1;