<?php session_start(); ?> <!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <title>examSQL-19.php</title> </head> <body> <?php require ‘./dbConn.php’; $link = mysqli_connect($dbHost, $dbUser, $dbPass); // MySQL 서버 연결 if (!$link) { // DB연결에 실패한 경우 ($!link, $link!=true, $link==false 모두 동일) echo “DB 연결에 실패했습니다.”; exit(); // 프로그램 종료 } $db = mysqli_select_db($link, $dbName); // Database 선택 if (!$db) {… Read More »
<?php session_start(); ?> <!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <title>SetSession</title> </head> <body> 세션ID : <?= session_id() ?><br/> <?php $_SESSION[“session1”] = “세션1”; $_SESSION[“session2”] = “세션2”; $_SESSION[“session3”] = “세션3″; ?> <a href=”./showSession.php”>세션확인</a> </body> </html> <?php session_start(); ?> <!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <title>ShowSession</title> </head> <body> 세션ID : <?= session_id() ?><br/> session1 : <?= $_SESSION[“session1”] ?><br/> session2… Read More »
참조 : http://blog.ysoh.pe.kr/entry/쿠키 <!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <title>SetCookies</title> </head> <body> 쿠키설정시각 : <?= date(“Y-m-d H:i:s”) ?><br/> <?php setcookie(“cookie1”, “쿠키#1”, 0, “/”); // 브라우저 종료 전까지 유지 setcookie(“cookie2”, “쿠키#2”, time() + 60, “/”); // 설정 후 1분 동안 유지 setcookie(“cookie3”, “쿠키#3”, mktime(16, 0, 0, 10, 17, 2014), “/”); // 2014년10월17일 16시00분00초 까지 유지 ?>… Read More »
<!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <title>examSQL-18.php</title> <style> .field-name {float:left; width:100px;text-align:right;} .field-input input {margin-left: 10px;} </style> </head> <body> <h1>로그인</h1> <form method=”post” action=”examSQL-19.php”> <div class=”field-name”>아이디 : </div> <div class=”field-input”><input type=”text” name=”a” /></div> <div class=”field-name”>비밀번호 : </div> <div class=”field-input”><input type=”password” name=”b” /></div> <div class=”field-name”> </div> <div class=”field-input”><input type=”submit” value=”로그인” /></div> </form> </body> </html> <!DOCTYPE html> <html> <head> <meta… Read More »
<?php require ‘./dbConn.php’; $link = mysqli_connect($dbHost, $dbUser, $dbPass); // MySQL 서버 연결 if (!$link) { // DB연결에 실패한 경우 ($!link, $link!=true, $link==false 모두 동일) echo “DB 연결에 실패했습니다.<br/>”; exit(); // 프로그램 종료 } $db = mysqli_select_db($link, $dbName); // Database 선택 if (!$db) { // DB선택에 실패한 경우 ($!$db, $db!=true, $db==false 모두 동일) echo “{$dbName} 이름의… Read More »
<!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <title>examSQL-14.php</title> </head> <body> <?php require ‘./dbConn.php’; $link = mysqli_connect($dbHost, $dbUser, $dbPass); // MySQL 서버 연결 if (!$link) { // DB연결에 실패한 경우 ($!link, $link!=true, $link==false 모두 동일) echo “DB 연결에 실패했습니다.”; exit(); // 프로그램 종료 } $db = mysqli_select_db($link, $dbName); // Database 선택 if (!$db) { // DB선택에 실패한… Read More »
<!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <style> h1 {text-align: center;} table {margin: 0 auto;} </style> <title>examSQL-10.php</title> </head> <body> <h1>회원목록</h1> <table> <thead> <tr> <th>순번</th> <th>아이디</th> <th>성명</th> <th>비밀번호</th> <th>이메일</th> <th>동작</th> </tr> </thead> <tbody> <tr> <td>1</td> <td>hong</td> <td>홍길동</td> <td>hong</td> <td>hong@nomail.plz</td> <td> <a href=”./examSQL-14.php”>삭제</a> <a href=”./examSQL-15.php”>수정</a> </td> </tr> <tr> <td>2</td> <td>yskim</td> <td>김영삼</td> <td>yskim</td> <td>yskim@nomail.plz</td> <td> <a href=”examSQL-14.php”>삭제</a> <a href=”examSQL-15.php”>수정</a>… Read More »
<?php require ‘./dbConn.php’; $link = mysqli_connect($dbHost, $dbUser, $dbPass); // MySQL 서버 연결 mysqli_select_db($link, $dbName); // Database 선택 mysqli_set_charset($link, “utf8”); // DB 문자셋 설정 $sql = “SELECT `userid`, `passwd`, `name`, `email` FROM `user`”; echo $sql; mysqli_query($link, $sql); // SQL 실행 mysqli_close($link); // MySQL 연결 종료 ?> <?php require ‘./dbConn.php’; $link = mysqli_connect($dbHost, $dbUser, $dbPass); // MySQL… Read More »
<?php // examSQL-01.php?a=test01&c=이순신&b=1234&d=sslee@daum.net require ‘./dbConn.php’; $link = mysqli_connect($dbHost, $dbUser, $dbPass); // MySQL 서버 연결 mysqli_select_db($link, $dbName); // Database 선택 mysqli_set_charset($link, “utf8”); // DB 문자셋 설정 $sql = “INSERT INTO `user` VALUES (‘{$_GET[“a”]}’, ‘{$_GET[“b”]}’, ‘{$_GET[“c”]}’, ‘{$_GET[“d”]}’)”; echo $sql; mysqli_query($link, $sql); // SQL 실행 mysqli_close($link); // MySQL 연결 종료 ?> <!DOCTYPE html> <html> <head> <meta charset=”UTF-8″/> <title>입력폼</title>… Read More »
WebDB(II) 시간에 입력한 예제프로그램들 입니다. <?php $link = mysqli_connect(“localhost”, “i0058001”, “yourPassword”); // MySQL 서버 연결 mysqli_select_db($link, “db0058001”); // Database 선택 mysqli_set_charset($link, “utf8”); // DB 문자셋 설정 $sql = “”; mysqli_query($link, $sql); // SQL 실행 mysqli_close($link); // MySQL 연결 종료 ?> <?php $dbHost = “localhost”; $dbName = “db0058001”; $dbUser = “i0058001”; $dbPass = “yourPassword” ?> <?php… Read More »