Search This Blog

2016/12/12

Window Startup setting

Set the startup application.

Use key [Win+R]
Input [msconfig] and press Enter key or click OK button.

Select tab [startup]
Uncheck/check the app and Apply or OK.
Unchecked app means it wantn't startup with Windows, and when it been uncheck is recorded.

2016/12/08

Page Redirect/画面遷移/页面跳转

By meta tag:
<meta http-equiv="refresh" content="seconds;URL=url">

Example:
<meta http-equiv="refresh" content="0;URL=https://randinblogger.blogspot.com">

By JavaScript:
window.location = "url";
window.location.href = "url";
window.location.assign = "url";
window.location.replace = "url";

By .htaccess file:
mod_rewrite need be actived.
Redirect 301 / url 

How to set PHPExcel header

Code:
//.xls file
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=download.xls");

//.xlsx file
header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header("Content-Disposition: attachment; filename=download.xlsx");

//Same part:
header("Cache-Control: max-age=0");

// Sample
header('Pragma: public');
header('Expires: 0');
header('Cache-Control: must-ravalidate, post-check=0, pre-check=0');
header('Content-Type: application/force-download');
header('Content-Type: application/octet-stream');
header('Content-Type: application/download');
header("Content-disposition: attachment; filename=sample.xls");

References:
https://support.microsoft.com/en-us/kb/936496

2016/12/06

SQL Developer "Enter the full pathname for java.exe"

When start Oracle SQL Developer first time, it will ask for full pathname for the "java.exe".

SQL Developer path:
...\sqldeveloper\sqldeveloper\bin
java.exe path:
...\jdk
"..." means "C:\\app\[user]\product\[Oracle version number]\client_1
For example:
SQL Developer path:
C:\\app\administrator\product\11.2.0\client_1\sqldeveloper\sqldeveloper\bin
java.exe path:
C:\\app\administrator\product\11.2.0\client_1\jdk
Or modify
...\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

Add "SetJavaHome ..\..\..\jdk, then no need to input java.exe pathname anymore.