/** * 获取表的字段 * @param $tableName * @return array */ public function getFieldsByTable($tableName) { $sql = "SHOW FULL COLUMNS FROM `{$tableName}`"; $statement = $this->pdo->prepare($sql); $statement->execute(); $data = $statement->fetchAll(); if (!$data) { return array(); } $fields = array(); foreach ($data as $v) { $f = $v["field"]; //字段名称 $type = $v["type"]; //字段类型 $varType = ""; //变量的类型 if ($this->isInt($type)) { $varType = "int"; } else { $varType = "string"; } $information = array("type" => $varType, "name" => $f, "comment" => $v['comment']); $information["ispri"] = 0; if (strcmp(strtolower($v["key"]), "pri") === 0) { $information['ispri'] = 1; } $fields[] = $information; } return $fields; }
public static function getInstance($params = array()) { if (!self::$instance instanceof self) { self::$instance = new self($params); } return self::$instance; }
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; } }