function index() { $db = MySQLPDO::getInstance(); if (isset($_COOKIE['name']) && isset($_COOKIE['pwd'])) { $name = $_COOKIE['name']; $pwd = $_COOKIE['pwd']; $row = $db->fetch("select `id`,`pwd` from `user` where `name`='{$name}'"); if ($pwd == $row['pwd']) { $_SESSION['name'] = $name; $_SESSION['id'] = $row['id']; } } if (isset($_SESSION['id'])) { $user_id = $_SESSION['id']; $folder_id = isset($_GET['folder']) ? $_GET['folder'] : 0; if ($folder_id != 0) { $sql = "select `folder_name`,`folder_path` from `folder` where `folder_id`={$folder_id} and `user_id`={$user_id}"; $current_folder = $db->fetch($sql); $file_ids = $current_folder['folder_path']; $sql = "select `folder_id`,`folder_name` from `folder` where `folder_id` in ({$file_ids}) and `user_id`={$user_id}"; $path = $db->fetchAll($sql); $path[] = array('folder_id' => $folder_id, 'folder_name' => $current_folder['folder_name']); } if (empty($_POST)) { $folder = $db->fetchAll("select * from `folder` where `user_id`={$user_id} and `folder_pid`={$folder_id}"); $file = $db->fetchAll("select * from `file` where `user_id`={$user_id} and `folder_id`={$folder_id}"); require 'index.html'; } else { if (!empty($_POST['newdir'])) { $newdir = $_POST['newdir']; $sql = "select * from `folder` where `folder_pid`={$folder_id} and `folder_name`='{$newdir}' and `user_id`={$user_id}"; if ($db->fetch($sql)) { echo 1; } else { $sql = "select `folder_path` from `folder` where `folder_id`={$folder_id} and `user_id`={$user_id}"; if ($db->fetch($sql)) { $parent_path = $db->fetch($sql)[0]; $parent_path = "{$parent_path},{$folder_id}"; } else { $parent_path = 0; } $sql = "insert into `folder` (`user_id`,`folder_name`,`folder_time`,`folder_path`,`folder_pid`) values (?,?,now(),?,?)"; if ($db->data(array($user_id, $newdir, $parent_path, $folder_id))->query($sql) != false) { echo 2; } } } if (!empty($_POST['del_id'])) { $del_id = $_POST['del_id']; $sql = "delete from `folder` where `user_id`={$user_id} and `folder_id`={$del_id}"; if ($db->query($sql) != false) { echo 1; } } } } else { echo '<a href="/netdisk/index.php/user/login">登陆</a><br>'; echo '<a href="/netdisk/index.php/user/register">注册</a>'; } }
function checkName() { $name = $_POST['name']; $db = MySQLPDO::getInstance(); if ($db->fetch("select * from `user` where `name`='{$name}'")) { echo 0; } else { echo 1; } }