} ?> </table> <br> <input type="submit" onClick="dumpDB();" value="<?php echo '匯出資料結構'; ?> "> </form> <?php //print_r($res_object); exit; break; case 'dump_schema': $POSTS_STRING = "selectAll"; $POSTS = getGET_POST($POSTS_STRING, 'POST'); $data_base_tmp_data = ""; $try_value = @implode("", $POSTS['selectAll']); if ($try_value == "") { ?> <script language="javascript"> alert("<?php echo __('沒有資料表被選到'); ?> ..."); history.go(-1); </script> <?php exit; } for ($i = 0; $i < count($POSTS['selectAll']); $i++) {
<?php require 'inc/config.php'; $include_mode = "jquery-form"; $GETS_STRING = "mode,filename"; $GETS = getGET_POST($GETS_STRING, 'GET'); switch ($GETS['mode']) { case 'upload': @mkdir("upload", 0777); //pre_print_r($_FILES); $ok_file = "doc,docx,ppt,pptx,pdf"; $m_ok_file = explode(',', $ok_file); for ($i = 0, $max_i = count($_FILES['upfile']['name']); $i < $max_i; $i++) { $sn = strtolower(subname($_FILES['upfile']['name'][$i])); if (!in_array($sn, $m_ok_file)) { continue; } if ($_FILES['upfile']['size'][$i] == 0) { continue; } $nfilename = sprintf("%s_%s.%s", time(), $i, subname($_FILES['upfile']['name'][$i])); copy($_FILES['upfile']['tmp_name'][$i], "{$base_dir}/upload/{$nfilename}"); $m = array(); $m['orin_filename'] = $_FILES['upfile']['name'][$i]; $m['filename'] = $nfilename; $m['kind'] = $sn; $m['create_datetime'] = date('Y-m-d H:i:s', filectime($_FILES['upfile']['tmp_name'][$i])); $m['upload_datetime'] = date('Y-m-d H:i:s'); $m['title'] = ""; $m['keyword'] = ""; $m['author'] = "";
<?php require '../inc/config.php'; $GETS_STRING = "id"; $GETS = getGET_POST($GETS_STRING, "GET"); $FIELDS = "id,kind,title,計畫名稱,年度,簡報人,簡報類別,報告書類型,是否有拿到計畫,競爭對手,委員名單,評選心得,是否延續型計畫,orin_filename,filename,keyword,create_datetime,upload_datetime,author,pdf_status,png_status,text_status,has_single_page,download_counter,grades"; $mFIELDS = explode(",", $FIELDS); $SQL = "SELECT * FROM `ppt` WHERE `id` = ? LIMIT 1"; $ra = selectSQL_SAFE($SQL, array($GETS['id'])); $edit_title = ""; if (mb_strlen($ra[0]['orin_filename']) >= 15) { $edit_title = mb_substr($ra[0]['orin_filename'], 0, 10) . "..."; } else { $edit_title = $ra[0]['orin_filename']; } ?> <script language="javascript"> $(document).ready(function(){ <?php foreach ($mFIELDS as $v) { ?> $("#<?php echo $v; ?> ").val("<?php echo jsAddSlashes($ra[0][$v]); ?> "); $("#<?php echo $v; ?>
<?php require 'inc/config.php'; $include_mode = "jquery-lazy"; $GETS_STRING = "mode"; $GETS = getGET_POST($GETS_STRING, 'GET'); switch ($GETS['mode']) { case 'searchcode': $POSTS_STRING = "searchcode,kind,年度,計畫名稱,簡報人,author,是否延續型計畫"; $POSTS = getGET_POST($POSTS_STRING, 'REQUEST'); $mSEARCHCODES = explode(",", $POSTS['searchcode']); $SQL_KIND = ""; $SQL_APPEND = ""; $SQL_SEARCH_CODE_APPEND = ""; $PA = array(); switch (strtolower($POSTS['kind'])) { case '': break; case 'ppt': $SQL_KIND = " AND `A`.`kind` like ? "; array_push($PA, "%ppt%"); break; case 'doc': $SQL_KIND = " AND `A`.`kind` like ? "; array_push($PA, "%doc%"); break; case 'pdf': $SQL_KIND = " AND `A`.`kind` = ? "; array_push($PA, "%pdf%"); break; }