[php]글쓰기,글수정,리스트,삭제,디테일..

<SQL 설정>

# site3 데이터베이스가 이미 존재한다면 삭제
DROP DATABASE IF EXISTS site3;

# site3 데이터베이스 생성
CREATE DATABASE site3;

# site3 데이터베이스 선택
USE site3;

# 게시판 테이블(폴더) 생성
CREATE TABLE article (
    id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    regDate DATETIME NOT NULL,
    title CHAR(100) NOT NULL,
    `body` TEXT NOT NULL
);

# 1번 게시물 추가(1.txt 생성)
INSERT INTO article
SET regDate = NOW(),
title = '제목1',
`body` = '내용1';

# 2번 게시물 추가(2.txt 생성)
INSERT INTO article
SET regDate = NOW(),
title = '제목2',
`body` = '내용2';

# 존재하는 모든 게시물 불러오기
SELECT id, regDate, title, `body`
FROM article;

# 존재하는 모든 게시물 불러오기(id 빼고)
SELECT regDate, title, `body`
FROM article;

# 존재하는 모든 게시물 불러오기
SELECT *
FROM article;

# 테이블 초기화
TRUNCATE article;

 

<로그인설정confing.php>

<?php
$dbConn = mysqli_connect("127.0.0.1", "sbsst", "sbs123414", "site7", 3306) or die('DB CONNECTION ERROR');

 

<리스트(list)>

<meta charset = "UTP-8">

<?php

$dbHost = '127.0.0.1';
$dbLoginId = 'sbsst';
$dbLoginPw = 'sbs123414';
$dbName = 'site5';

$conn = mysqli_connect($dbHost, $dbLoginId, $dbLoginPw, $dbName);

$sql="
SELECT *
FROM article

ORDER BY id DESC
";
$rs = mysqli_query($conn, $sql);
$rows = []; //배열 생성

while( $row = mysqli_fetch_assoc($rs)) {
    $rows[] = $row;
    //배열rows 생성해서 row에 계속 넣는다
}
?>
<h1 style = "color:blue" >텍스트 <span style = "color:green">게시판</span></h1>
    <table border="1"; width="500px";>
        <thead style = "background-color:green; color:white"> 
            <tr>
                <th width="50px">번호</th>            
                <th width="170px" >날짜</th>
                <th >제목</th> 
                <th width="50px">조회수</th>          
            </tr>        
        </thead>
        <tbody>        
        <?php foreach ($rows as $row) { ?>
            <tr>
            
                <td><?=$row['id']?></td>
                <td><?=$row['regDate']?></td>
                <td><?=$row['title']?></td>
                <td><?=$row['hit']?></td>
               
            </tr>
            <?php } ?>
        </tbody>
        
    </table>

 

<글상세(detail)>

<meta charset = "UTP-8">

<?php

$dbHost = '127.0.0.1';
$dbLoginId = 'sbsst';
$dbLoginPw = 'sbs123414';
$dbName = 'site5';

$conn = mysqli_connect($dbHost, $dbLoginId, $dbLoginPw, $dbName);

$id = $_GET['id'];

mysqli_query($conn, "UPDATE article SET hit = hit + 1 WHERE id = '{$id}'");

$sql="
SELECT * 
FROM article 
WHERE id ='{$id}'
";

$rs = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($rs);
?>
<h1 style = "color:blue"; >게시물 상세페이지</h1>

<?php if  ( $row == null)  { ?>
<h2>게시물이 존재하지 않습니다.</h2>

<?php } else { ?>
    <table border="1">
        <tbody> 
      
        <tr>
                <th>번호</th>      
                <td><?=$row['id']?></td>  
            </tr> 
            <tr>
                <th>조회수</th>      
                <td><?=$row['hit']?></td>  
            </tr>
            <tr>
                <th>날짜</th>
                <td><?=$row['regDate']?></td>
            </tr>
            <tr>
                <th>제목</th> 
             <td> <?=$row['title']?></td>  
            </tr>   
            <tr>
            <th>내용</th>
            <td> <?=$row['body']?></td> 
            </tr>     
    

        </tbody>
        
    </table>
    <?php  }?>

<글삭제(doDelete)>

<meta charset = "UTP-8">

<?php

$dbHost = '127.0.0.1';
$dbLoginId = 'sbsst';
$dbLoginPw = 'sbs123414';
$dbName = 'site5';

$conn = mysqli_connect($dbHost, $dbLoginId, $dbLoginPw, $dbName);


$id = $_GET['id'];
$sql="
delete from article where id ='{$id}';
";
mysqli_query($conn, $sql);

echo $id, '번 게시물이  삭제되었습니다.';
?>

<글수정(doModify)>

<?php

$dbHost = '127.0.0.1';
$dbLoginId = 'sbsst';
$dbLoginPw = 'sbs123414';
$dbName = 'site5';

$conn = mysqli_connect($dbHost, $dbLoginId, $dbLoginPw,$dbName);

$title = $_GET['title'];
$body = $_GET['body'];
$id = $_GET['id'];



$sql="
update article set 
title = '$title',
body='$body'
where id = '$id';
";


mysqli_query($conn,$sql);

echo '제목 : ',$title,'<br>내용 : ',$body;




?>

 

<글쓰기(doWrite)>

<?php


$title = $_GET['title'];
$body = $_GET['body'];

$sql = "
INSERT INTO article
SET regDate = NOW(),
title = '{$title}',
`body` = '{$body}'
";

$dbHost = '127.0.0.1';
$dbLoginId = 'sbsst';
$dbLoginPw = 'sbs123414';
$dbName = 'site5';

$conn = mysqli_connect($dbHost, $dbLoginId, $dbLoginPw,$dbName);
mysqli_query($conn,$sql);

echo '제목 : ',$title,'<br>내용 : ',$body;
?>