홈페이지 및 다운로드
라이브러리 3-1
라이브러리 3-2
라이브러리 3-3
라이브러리 3-4
라이브러리 3-5
소스코드
index.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 | <?php require ( "config/config.php" ); require ( "lib/db.php" ); $conn = db_init( $config [ "host" ], $config [ "duser" ], $config [ "dpw" ], $config [ "dname" ]); $result = mysqli_query( $conn , "SELECT * FROM topic" ); ?> <!DOCTYPE html> <html> <head> <meta charset= "utf-8" > <meta http-equiv= "X-UA-Compatible" content= "IE=edge" > <meta name= "viewport" content= "width=device-width, initial-scale=1" > <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> </head> <body id= "target" > <div class = "container" > <header class = "jumbotron text-center" > <img src= "https://s3.ap-northeast-2.amazonaws.com/opentutorials-user-file/course/94.png" alt= "생활코딩" class = "img-circle" id= "logo" > </header> <div class = "row" > <nav class = "col-md-3" > <ol class = "nav nav-pills nav-stacked" > <?php while ( $row = mysqli_fetch_assoc( $result )){ echo '<li><a href="http://localhost/index.php?id=' . $row [ 'id' ]. '">' .htmlspecialchars( $row [ 'title' ]). '</a></li>' . "\n" ; } ?> </ ol> </nav> <div class = "col-md-9" > <article> <?php if ( empty ( $_GET [ 'id' ]) === false ) { $sql = "SELECT topic.id,title,name,description FROM topic LEFT JOIN user ON topic.author = user.id WHERE topic.id=" . $_GET [ 'id' ]; $result = mysqli_query( $conn , $sql ); $row = mysqli_fetch_assoc( $result ); echo '<h2>' .htmlspecialchars( $row [ 'title' ]). '</h2>' ; echo '<p>' .htmlspecialchars( $row [ 'name' ]). '</p>' ; echo strip_tags ( $row [ 'description' ], '<a><h1><h2><h3><h4><h5><ul><ol><li>' ); } ?> </article> <hr> <div id= "control" > <div class = "btn-group" role= "group" aria-label= "..." > <input type= "button" value= "white" onclick= "document.getElementById('target').className='white'" class = "btn btn-default btn-lg" /> <input type= "button" value= "black" onclick= "document.getElementById('target').className='black'" class = "btn btn-default btn-lg" /> </div> </div> </div> </div> </div> <!-- jQuery (necessary for Bootstrap's JavaScript plugins) --> <!-- Include all compiled plugins (below), or include individual files as needed --> </body> </html> |
write.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 | <?php require ( "config/config.php" ); require ( "lib/db.php" ); $conn = db_init( $config [ "host" ], $config [ "duser" ], $config [ "dpw" ], $config [ "dname" ]); $result = mysqli_query( $conn , "SELECT * FROM topic" ); ?> <!DOCTYPE html> <html> <head> <meta charset= "utf-8" > <meta http-equiv= "X-UA-Compatible" content= "IE=edge" > <meta name= "viewport" content= "width=device-width, initial-scale=1" > <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> </head> <body id= "target" > <div class = "container" > <header class = "jumbotron text-center" > <img src= "https://s3.ap-northeast-2.amazonaws.com/opentutorials-user-file/course/94.png" alt= "생활코딩" class = "img-circle" id= "logo" > </header> <div class = "row" > <nav class = "col-md-3" > <ol class = "nav nav-pills nav-stacked" > <?php while ( $row = mysqli_fetch_assoc( $result )){ echo '<li><a href="http://localhost/index.php?id=' . $row [ 'id' ]. '">' .htmlspecialchars( $row [ 'title' ]). '</a></li>' . "\n" ; } ?> </ ol> </nav> <div class = "col-md-9" > <article> <form action= "process.php" method= "post" > <div class = "form-group" > <label for = "form-title" >제목</label> <input type= "text" class = "form-control" name= "title" id= "form-title" placeholder= "제목을 적어주세요." > </div> <div class = "form-group" > <label for = "form-author" >작성자</label> <input type= "text" class = "form-control" name= "author" id= "form-author" placeholder= "작성자를 적어주세요." > </div> <div class = "form-group" > <label for = "form-description" >본문</label> <textarea class = "form-control" rows= "10" name= "description" id= "form-description" placeholder= "본문을 적어주세요." ></textarea> </div> <input type= "submit" name= "name" class = "btn btn-default btn-lg" > </form> </article> <hr> <div id= "control" > <div class = "btn-group" role= "group" aria-label= "..." > <input type= "button" value= "white" onclick= "document.getElementById('target').className='white'" class = "btn btn-default btn-lg" /> <input type= "button" value= "black" onclick= "document.getElementById('target').className='black'" class = "btn btn-default btn-lg" /> </div> </div> </div> </div> </div> <!-- jQuery (necessary for Bootstrap's JavaScript plugins) --> <!-- Include all compiled plugins (below), or include individual files as needed --> </body> </html> |
process.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | <?php require ( "config/config.php" ); require ( "lib/db.php" ); $conn = db_init( $config [ "host" ], $config [ "duser" ], $config [ "dpw" ], $config [ "dname" ]); $sql = "SELECT * FROM user WHERE name='" . $_POST ['author ']."' "; $result = mysqli_query( $conn , $sql ); if ( $result ->num_rows == 0){ $sql = "INSERT INTO user (name, password) VALUES('" . $_POST ['author ']."' , '111111' )"; mysqli_query( $conn , $sql ); $user_id = mysqli_insert_id( $conn ); } else { $row = mysqli_fetch_assoc( $result ); $user_id = $row [ 'id' ]; } $sql = "INSERT INTO topic (title,description,author,created) VALUES('" . $_POST ['title ']."' , '".$_POST[' description ']."' , '".$user_id."' , now())"; $result = mysqli_query( $conn , $sql ); ?> |
style.css
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | body. white { background-color : white ; color : black ; } body. black { background-color : black ; color : white ; } #logo { width : 100px ; } .container{ padding-top : 20px ; } #control{ margin-bottom : 40px ; } |