VI 연습하기(PHP 코드 만들기)

Posted on: 2018년 11월 08일 2018년 11월 08일
Categories: 강의자료, 리눅스

데이터베이스 생성

sudo mysql -u root -p create database mydb; use mydb;

1
2
3

sudo mysql -u root -p
create database mydb;
use mydb;
테이블 만들기

create table myt( no int not null auto_increment, id varchar(20) not null, name varchar(20), primary key(no) );

1
2
3
4
5
6

create table myt(
no int not null auto_increment,
id varchar(20) not null,
name varchar(20),
primary key(no)
);

테이블에 값 입력하기

insert into myt(id, name) values ('201812345', 'gildong1');
insert into myt(id, name) values ('201812346', 'gildong2');
insert into myt(id, name) values ('201812347', 'gildong3');

insert into myt(id, name) values ('201812345', 'gildong1');

insert into myt(id, name) values ('201812346', 'gildong2');

insert into myt(id, name) values ('201812347', 'gildong3');

입력 값 확인하기

select * from myt;

1

select * from myt;

사용자 지정하기

create user wp@localhost identified by 'wp123';
create user wp@'%' identified by 'wp123';
grant all privileges on mydb.* to wp@localhost;
grant all privileges on mydb.* to wp@'%';

create user wp@localhost identified by 'wp123';

create user wp@'%' identified by 'wp123';

grant all privileges on mydb.* to wp@localhost;

grant all privileges on mydb.* to wp@'%';

read.php 만들기

cd /var/www/html

sudo vi read.php

<?php
	header("Content-Type: text/html; charset=UTF-8");

	$connect = mysqli_connect("localhost", "wp", "wp123", "mydb");
	if(mysqli_connect_errno()){
		echo "MySQL 연결 실패 : ". mysqli_connect_error();
	}

	$sql = "SELECT * FROM myt;";

	$result = mysqli_query($connect, $sql);

	while( $row = mysqli_fetch_array($result) ){
		echo $row['no'] . " ";
		echo $row['id'] . " ";
		echo $row['name'];
		echo "<br>";
	}

	mysqli_close($connect);
?>

<?php

header("Content-Type: text/html; charset=UTF-8");

$connect = mysqli_connect("localhost", "wp", "wp123", "mydb");

if(mysqli_connect_errno()){

echo "MySQL 연결 실패 : ". mysqli_connect_error();

}

$sql = "SELECT * FROM myt;";

$result = mysqli_query($connect, $sql);

while( $row = mysqli_fetch_array($result) ){

echo $row['no'] . " ";

echo $row['id'] . " ";

echo $row['name'];

echo "<br>";

}

mysqli_close($connect);

whan0623

517