/**
* 获取表的字段
* @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;
}
}
