} deleteSQL("ppt_items", "`ppt_id`='{$POSTS['id']}'"); deleteSQL("ppt", "`id`='{$POSTS['id']}'"); exit; break; case 'download': $GETS_STRING = "ppt_id,id"; $GETS = getGET_POST($GETS_STRING, 'GET'); $SQL = "SELECT * FROM `ppt` WHERE `id`=? LIMIT 1"; $ra = selectSQL_SAFE($SQL, array($GETS['ppt_id'])); download_file("{$base_dir}/upload/{$ra[0]['filename']}", "{$ra[0]['orin_filename']}"); $ppt_info = pdo_get_assoc_from_id('ppt', $GETS['ppt_id']); $m = array(); $m['grades'] = $ppt_info['grades'] + 1; updateSQL('ppt', $m, "`id`='{$GETS['ppt_id']}'"); $ppt_items_info = pdo_get_assoc_from_id('ppt_items', $GETS['id']); $m = array(); $m['grades'] = $ppt_info['grades'] + 1; updateSQL('ppt_items', $m, "`id`='{$GETS['id']}'"); exit; break; case 'searchcode': $POSTS_STRING = "searchcode,kind"; $POSTS = getGET_POST($POSTS_STRING, 'POST'); $mSEARCHCODES = explode(",", $POSTS['searchcode']); $SQL_APPEND = ""; $SQL_KIND = ""; $PA = array(); switch (strtolower($POSTS['kind'])) { case '': break;
echo $ppt_info["upload_datetime"]; ?> <br> 作者:<?php echo $ppt_info["author"]; ?> <br> </fieldset> </li> <?php } ?> </ul> <?php foreach ($OUTPUT['Gdata'] as $k => $v) { $ppt_info = pdo_get_assoc_from_id('ppt', $k); $mn = $ppt_info['orin_filename']; $ppt_id = $ppt_info['ppt_id']; echo "<div id='ppt_id_{$k}'><h2>{$mn}</h2>"; echo print_table($v, "f_id,f_png,contents", "序號,圖片,內容", "search_table"); echo "</div>"; } echo "<br>"; //echo $OUTPUT['page']; } ?> </div> </center> <!--end-->