Example #1
0
        }
        ?>
          </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++) {
Example #2
0
<?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'] = "";
Example #3
0
<?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;
    ?>
Example #4
0
<?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;
        }