PHP dbOperation 예제들

<?php

include "db.php";
$db = new dbOperation();
$loginError = false;
if (strlen(session_id()) < 1) {
    session_start();
}
if (isset($_SESSION['user'])) {
    include "home.php";
} else {
    $username = null;
    $password = null;
    if (isset($_POST['name'])) {
        $username = $_POST['name'];
    }
    if (isset($_POST['pw'])) {
        $password = $_POST['pw'];
    }
    if ($username != null && $password != null) {
        $res = $db->validateUser($username, $password);
        if (count($res) != 0) {
            $_SESSION['user'] = $res[0];
            include "home.php";
        } else {
            $loginError = true;
            include "login.php";
        }
    } else {
        include "login.php";
    }

예제 #2

파일 보기

파일: rest.php 프로젝트: rayagera/nfc_deltaweb

<?php

header('Content-Type:application/json');
include "security/session_filter.php";
include 'db.php';
$firstName;
$lastName;
$email;
$password;
$login;
$company;
$type;
$userType;
$pageNum;
$num = 20;
$db = new dbOperation();
$user = $_SESSION['user'];
$res = array('status' => 'ok');
$data = json_decode(file_get_contents('php://input'), true);
if (isset($_POST['type'])) {
    $type = $_POST['type'];
} else {
    $type = $data['type'];
}
if (isset($_POST['firstName'])) {
    $firstName = $_POST['firstName'];
}
if (isset($_POST['lastName'])) {
    $lastName = $_POST['lastName'];
}
if (isset($_POST['email'])) {

예제 #3

파일 보기

파일: restm.php 프로젝트: rayagera/nfc_deltaweb

header('Content-Type:application/json');
header('Access-Control-Allow-Origin:*');
date_default_timezone_set("PRC");
//header('Access-Control-Allow-Headers:*');
include 'db.php';
include 'logger.php';
$firstName;
$lastName;
$email;
$password;
$login;
$company;
$type;
$userType;
$pageNum;
$db = new dbOperation();
$logger = new logger();
$data = json_decode(file_get_contents('php://input'), true);
$res = array('status' => 'ok', 'data' => file_get_contents('php://input'), 'formatdata' => $data, 'post' => $_POST);
if (isset($_POST['type'])) {
    $type = $_POST['type'];
} else {
    $type = $data['type'];
}
if (isset($_POST['firstName'])) {
    $firstName = $_POST['firstName'];
}
if (isset($_POST['lastName'])) {
    $lastName = $_POST['lastName'];
}
if (isset($_POST['email'])) {

예제 #4

파일 보기

파일: step4.php 프로젝트: rayagera/nfc_deltaweb

<?php

require "../db.php";
$db = new dbOperation();
$invalidAccount = false;
$username = null;
$password = null;
if (isset($_POST['name'])) {
    $username = $_POST['name'];
} else {
    if (isset($_SESSION['name'])) {
        $username = $_SESSION['name'];
    }
}
if (isset($_POST['password'])) {
    $password = $_POST['password'];
}
if ($username != null && $password != null) {
    $res = $db->resetPassword($username, $password);
}
$db->closeConn();
session_destroy();
?>

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">

예제 #5

파일 보기

파일: step2.php 프로젝트: rayagera/nfc_deltaweb

<?php

require "../db.php";
$db = new dbOperation();
$invalidAccount = false;
//session_start();
//include "step1.php";
// header('Location:step1.php');
$username = null;
$email = null;
if (isset($_POST['name'])) {
    $username = $_POST['name'];
} else {
    if (isset($_SESSION['name'])) {
        $username = $_SESSION['name'];
    }
}
if ($username != null) {
    $res = $db->findAccount($username, $username);
    if (count($res) != 0 && $res[0]) {
        $_SESSION['name'] = $res[0]->login;
        $_SESSION['email'] = $res[0]->email;
    } else {
        $invalidAccount = true;
    }
} else {
    $invalidAccount = true;
}
$db->closeConn();
if ($invalidAccount) {
    include "step1.php";

예제 #6

파일 보기

파일: restp.php 프로젝트: rayagera/nfc_deltaweb

<?php

header('Content-Type:application/json');
header('Access-Control-Allow-Origin:*');
date_default_timezone_set("PRC");
//header('Access-Control-Allow-Headers:*');
include 'db.php';
include 'logger.php';
$email;
$type;
$db = new dbOperation();
$logger = new logger();
$data = json_decode(file_get_contents('php://input'), true);
$res = array('status' => 'ok', 'data' => file_get_contents('php://input'), 'formatdata' => $data, 'post' => $_POST);
$logger->info(" ----- get request -----");
if (isset($_POST['type'])) {
    $type = $_POST['type'];
} else {
    $type = $data['type'];
}
if (isset($_POST['email'])) {
    $email = $_POST['email'];
} else {
    $email = $data['email'];
}
$logger->info(" -- request type = " . $type . "  email=" . $email);
if (isset($type)) {
    if ($type == "findAccount") {
        if (isset($email)) {
            $logger->info("request type: " . $type . " -- email : " . $email);
            echo json_encode($db->findAccount($email, $email));

예제 #7

파일 보기

파일: mindex.php 프로젝트: rayagera/nfc_deltaweb

<?php

include "db.php";
$db = new dbOperation();
$loginError = false;
$url = "home.php";
if (strlen(session_id()) < 1) {
    session_start();
}
if (isset($_SESSION['user'])) {
    echo "<script>window.location =\"{$url}\";</script>";
} else {
    $userId = null;
    if (isset($_GET['userId'])) {
        $userId = $_GET['userId'];
    }
    if ($userId != null) {
        $res = $db->getUserById($userId);
        if (count($res) != 0) {
            $_SESSION['user'] = $res[0];
            echo "<script>window.location =\"{$url}\";</script>";
        } else {
            $loginError = true;
            include "login.php";
        }
    } else {
        include "login.php";
    }
}
$db->closeConn();