<?php /** * Created by PhpStorm. * User: JongYoon * Date: 2015-07-16 * Time: 오후 6:30 */ include "/conf/DB_CON.php"; $pid = isset($_GET['pid']) ? $_GET['pid'] : null; $page = isset($_GET['page']) ? $_GET['page'] : null; $conn = DB_conn(DB_NAME); $sql = "select * from " . TABLE_NAME . " where board_id = " . "{$pid}"; $result = transmit_query($sql); $row = mysql_fetch_array($result); $info['mode'] = isset($_POST['mode']) ? $_POST['mode'] : null; $info['subject'] = isset($row['subject']) ? $row['subject'] : null; $info['contents'] = isset($row['contents']) ? $row['contents'] : null; $url = "view.php?page=" . $page . "&pid=" . $pid; if ($info['mode'] === "modify") { $info['id'] = isset($row['user_id']) ? $row['user_id'] : null; $info['name'] = isset($row['user_name']) ? $row['user_name'] : null; $info['subject'] = isset($_POST['subject']) ? $_POST['subject'] : null; $info['contents'] = isset($_POST['contents']) ? $_POST['contents'] : null; $info['date'] = date("Y-m-d H:i:s"); //var_dump($info); if (!strlen($info['subject']) == 0) { $ddl = "update " . TABLE_NAME . " set subject ='" . $info['subject'] . "' , contents = '" . $info['contents'] . "', reg_date = '" . $info['date'] . "' where board_id = " . $pid; //echo $ddl."<br>"; $result = transmit_query($ddl); echo "<script> alert('수정 했어양!')</script>";
$visited = isset($_SESSION['visited']) ? $_SESSION['visited'] : null; if (isset($_SESSION['login']) && $_SESSION['login'] == true) { echo "<script>alert('Already 로그인 되있어양!!')</script>"; echo "<script>location.replace('list.php?page=1')</script>"; } /*else{ session_unset(); //echo "<script>location.replace('login.php')</script>"; }*/ $ID = isset($_POST['ID']) ? $_POST['ID'] : null; $PASSWD = isset($_POST['PASSWD']) ? $_POST['PASSWD'] : null; //var_dump($ID); //echo "<BR>"; //var_dump($PASSWD); if ($ID && $PASSWD) { $conn = DB_conn("login"); $sql = "select ID from login where ID = '" . $ID . "'"; //echo "ID:".$sql."<br>"; $result = transmit_query($sql); $id_search = mysql_num_rows($result); //var_dump($id_search); if ($id_search != 0) { $sql = "select PASSWD from login where ID = '" . $ID . "'"; //echo "PD:".$sql."<br>"; $result = transmit_query($sql); $row = mysql_fetch_array($result); if ($row['PASSWD'] === $PASSWD) { $_SESSION['login'] = true; echo "<script>alert('Login에 성공 했어양!')</script>"; //세션으로 ID값 전송 $_SESSION['ID'] = $ID;