Mysql DB 생성, TABLE 생성, INSERT / PHP 출력

Mysql DB 생성, TABLE 생성, INSERT

#DB 생성
CREATE DATABASE test_db default CHARACTER SET UTF8; 
SHOW DATABASES;

#TABLE 생성
CREATE TABLE mem
(
     id INT PRIMARY KEY AUTO_INCREMENT,
     name VARCHAR(32) NOT NULL,
     phone VARCHAR(12)
);

#TABLE에 데이터 삽입
INSERT INTO mem
(id, name, phone)
VALUES(1, '홍길동', '01134343222');

INSERT INTO mem
(id, name, phone)
VALUES(2, '이순신', '11134448787');

INSERT INTO mem
(id, name, phone)
VALUES(3, 'mike', '15164788987');

#TABLE 조회
desc mem;

 

PHP 출력 예제

<?php
    $host = 'localhost';
    $user = 'root';
    $pw = '1111';
    $dbName = 'test_db';
    $mysqli = new mysqli($host, $user, $pw, $dbName);

    if($mysqli){
        echo "MySQL 접속 성공";
    }else{
        echo "MySQL 접속 실패";
    }

    $sql = "SELECT * FROM mem;";
    $result = mysqli_query( $mysqli, $sql );

    while( $row = mysqli_fetch_array( $result ) ) {
        echo
          '<p>'
          ."ID:". $row[ 'id' ]."<br>"
          ."NAME:". $row[ 'name' ]."<br>"
          ."PHONE:". $row[ 'phone' ]."<br>"
          . '</p>'
        ;
      }
?>