[CodeIgniter] 讀取 2 個資料庫

Reference: stack overflow https://stackoverflow.com/questions/8268853/codeigniter-multiple-database-connections#

同時連線2個資料庫

Database 1:

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "root";
$db['default']['password'] = "";
$db['default']['database'] = "database_name";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
$db['default']['swap_pre'] = "";
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

Database 2:

$db['otherdb']['hostname'] = "localhost";
$db['otherdb']['username'] = "root";
$db['otherdb']['password'] = "";
$db['otherdb']['database'] = "other_database_name";
$db['otherdb']['dbdriver'] = "mysql";
$db['otherdb']['dbprefix'] = "";
$db['otherdb']['pconnect'] = TRUE;
$db['otherdb']['db_debug'] = FALSE;
$db['otherdb']['cache_on'] = FALSE;
$db['otherdb']['cachedir'] = "";
$db['otherdb']['char_set'] = "utf8";
$db['otherdb']['dbcollat'] = "utf8_general_ci";
$db['otherdb']['swap_pre'] = "";
$db['otherdb']['autoinit'] = TRUE;
$db['otherdb']['stricton'] = FALSE;

Use it:

function my_model_method()
{
  $otherdb = $this->load->database('otherdb', TRUE); // the TRUE paramater tells CI that you'd like to return the database object.

  $query = $otherdb->select('first_name, last_name')->get('person');
  var_dump($query);
}

Linux 桌面環境安裝

KDE	minimal:	sudo apt install plasma-desktop
	full:	sudo apt install kubuntu-desktop
Gnome	minimal:	sudo apt install gnome-shell
	full:	sudo apt install ubuntu-gnome-desktop
Cinnamon		sudo add-apt-repository ppa:embrosyn/cinnamon sudo apt update && sudo apt install cinnamon
Xfce	minimal:	sudo apt install xfce4
	full:	sudo apt install xubuntu-desktop
Unity	minimal:	sudo apt install unity
	full:	sudo apt install ubuntu-desktop
MATE	minimal:	sudo apt install mate-desktop-environment
	full:	sudo apt install ubuntu-mate-desktop
LXQt		sudo apt install lxqt
LXDE	minimal:	sudo apt install lxde
	full:	sudo apt install lubuntu-desktop
Enlightenment		sudo add-apt-repository ppa:niko2040/e19 sudo apt update && sudo apt install enlightenment terminology
Budgie		sudo add-apt-repository ppa:budgie-remix/ppa sudo apt update && sudo apt install budgie-desktop

全國圖書管理系統相關小記

教育部
https://esa.ntpc.edu.tw/jsp/axis/servlet/AxisServlet
新北市
https://read.moe.edu.tw/jsp/axis/servlet/AxisServlet

說明文件v1
http://read.moe.edu.tw/jsp/national_lib/pub/nat_anto.jsp?id=197&dbschema=S000000

說明文件v2
http://read.moe.edu.tw/jsp/national_lib/pub/nat_anto.jsp?id=197&dbschema=S000000

註：截至發文日，所有的縣市，不管自管還是直接使用教育部的平台，都有支援 v2，只有新北市僅有v1，沒有支援v2，還蠻特別的。

ffmpeg 轉檔小記

把 DVD 轉成 mp4

ffmpeg -i concat:"/media/user01/MYDVD/VIDEO_TS/VTS_01_1.VOB|/media/user01/MYDVD/VIDEO_TS/VTS_01_2.VOB|/media/user01/MYDVD/VIDEO_TS/VTS_01_3.VOB|/media/user01/MYDVD/VIDEO_TS/VTS_01_4.VOB|" -acodec aac -aq 100 -ac 2 -vcodec libx264 -crf 24 -threads 0 MYDVD.mp4

※ 粗體字及紅色字不同電腦會有所不同

影片轉檔 864x480 的 mp4 格式

ffmpeg -i "media_filename" -vf scale=854:480,setsar=1:1 "new_media_filename.mp4" -hide_banner

[轉] Eric6的安裝教學 新版問題解決篇

原文網址：https://jimshow.wordpress.com/2017/01/11/eric6%E7%9A%84%E5%AE%89%E8%A3%9D%E6%95%99%E5%AD%B8/


大致整理步驟如下，環境是  Windows7 + Python3：
1. 下載並安裝 python3  (預設路徑為 C:\Users\[使用者名稱]\AppData\Local\Programs\Python\Python36
2. 更新 pip 程式： python -m pip install -U pip setuptools 
3. pip3 install QScintilla
4. pip3 install PyQt5
5. 下載  eric6 的 zip 檔並解壓縮，直接執行 install.py (or  python install.py)，執行完畢後會在 python3 的目錄下 ./Scripts/ 找到 eric6.bat 的批次執行檔
6. 下載並重新安裝 Qt https://www.qt.io/download-open-source/

[Ubuntu] 系統更新或安裝新套件時，一直提示 click 失敗無法執行

家裡的系統是 Ubuntu 14.04，前兩個禮拜開始更新檔案或安裝新套件時，一直出現要先做 「 sudo apt-get -f install 」修改未完成的安裝動作。
仔細看了之後發現是有支 package  「click」無法執行，手動執行「 click」指令時，則會出現下列的錯誤訊息：

Traceback (most recent call last):
  File "/usr/bin/click", line 37, in <module>
    import click
ImportError: No module named 'click'
dpkg: warning: subprocess old pre-removal script returned error exit status 1
dpkg: trying script from the new package instead ...
Traceback (most recent call last):
  File "/usr/bin/click", line 37, in <module>
    import click
ImportError: No module named 'click'

無法強制將它remove，用 「easy_install  click」 或 「easy_install3 click」也沒有用，雖然還是可以操作，但是整個系統就像 freeze 住了，無法更新，也無法安裝新的套件，直到前天晚上才又在 askubuntu 上看到一篇文章，雖然原PO 作者的系統是 17.04，不過，跟著步驟做了一遍，整個套件管理總算正常了。把記錄下來，免得下次遇到時又得找半天

cd /var/lib/dpkg/info/

sudo rm -r python3-apparmor-click.*
sudo rm -r click-apparmor.*
sudo rm -r click.*
sudo rm -r ubuntu-app-launch.* 

sudo apt purge python3-apparmor-click
sudo apt purge click-apparmor    
sudo apt purge click
sudo apt purge ubuntu-app-launch

sudo apt update

sudo apt-get -f install

sudo apt-get dist-upgrade

感謝網路，讚美 Google!