<?php
require_once "../lib/config.php";
require_once "../lib/dbclass.php";
require_once "../lib/JSON.php";
$json = new Services_JSON();
$dir = isset($_POST['dir']) && $_POST['dir'] != 0 ? $_POST['dir'] : 0;
$start = $_POST['start'];
$limit = $_POST['limit'];
$search = $_POST['search'];
if (empty($search)) {
$count_sql = "select * from file_data\n\t\t\t\t WHERE file_dir = " . $dir;
$sql = "SELECT file . * , user.user_name\n\t\t\tFROM `file_data` file , `user_data` user\n\t\t\tWHERE file.file_dir = " . $dir . "\n\t\t\tand file.file_owner_id = user.user_id\n\t\t\torder by file.file_id DESC\n\t\t\tLIMIT " . $start . " , " . $limit;
} else {
$count_sql = "select * from file_data\n\t\t\t\t WHERE `file_name` LIKE '%" . $search . "%'";
$sql = "SELECT file . * , user.user_name\n\t\t\tFROM `file_data` file , `user_data` user\n\t\t\tWHERE file.file_owner_id = user.user_id\n\t\t\tAND `file_name` LIKE '%" . $search . "%'\n\t\t\torder by file.file_id DESC\n\t\t\tLIMIT " . $start . " , " . $limit;
}
$db = new dbClass($db_username, $db_password, $db_database, $db_hostname);
$db->start();
$count = $db->getcount($count_sql);
$result = $db->query($sql);
while ($arr = $db->getarray($result)) {
$array[] = $arr;
}
if ($count) {
echo $_GET['callback'] . '({"totalCount":"' . $count . '","data":' . $json->encode($array) . '})';
} else {
echo $_GET['callback'] . '({"totalCount":"' . $count . '","data":""})';
}
<?php
require_once "../../lib/config.php";
require_once "../../lib/dbclass.php";
$dirID = $_GET['dirId'];
//判斷該資料夾下有無檔案
$sql = "SELECT *\n\t\tFROM `file_data`\n\t\tWHERE `file_dir` = " . $dirID;
$db = new dbClass($db_username, $db_password, $db_database, $db_hostname);
$db->start();
if ($db->getcount($sql)) {
echo "haveItem";
exit;
}
//判斷該資料夾下有無子資料夾
$sql = "SELECT *\n\t\tFROM `dir_data`\n\t\tWHERE `dir_parent` = " . $dirID;
if ($db->getcount($sql)) {
echo "haveItem";
exit;
}
echo "ok";
$db->close();
