Ejemplos de DB_conn en PHP

Ejemplo n.º 1

Archivo: modify.php Proyecto: jongyoonB/PHP

<?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>";

Ejemplo n.º 2

Archivo: login.php Proyecto: jongyoonB/PHP

$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;