changing field char set to store Emoji Character in MySQL
michael https://stackoverflow.com/questions/39463134/how-to-store-emoji-character-in-mysql-database php $this->pdo = new PDO(“mysql:host=$ip;port=$port;dbname=$db;charset=utf8mb4”
find replace update mysql table field
UPDATE db_name SET filename = REPLACE(filename, ’_JPG’, ’.JPG’) WHERE 1;
re-arrange array key order by another array
SOF https://stackoverflow.com/questions/348410/sort-an-array-by-keys-based-on-another-array
python serial
import serial import time, sys, math #s = serial.Serial(port=’COM6’, baudrate=9600) s = serial.Serial(port=’/dev/ttyACM1’, baudrate=9600) print s #s.write(’text’) c=2000 print c s.write("one") while c>0: res= s.read() if (c % 20 ==…
cakephp save to single field single row
from http://stackoverflow.com/questions/3615827/how-do-i-update-1-field-in-cakephp $this->Event->id = $id; $this->Event->saveField(’is_featured’, true);
cakephp fast find field
$this->loadModel(’Company’); $this->Company->id = $company_id; $company_name = $this->Company->field(’name’);
Python readline like function
raw_input() If the prompt argument is present, it is written to standard output without a trailing newline. The function then reads a line from input, converts it to a string…
Delete duplicate db records
DELETE n1 FROM `memehk_scan` n1, `memehk_scan` n2 WHERE n1.id > n2.id AND n1.youtube_code = n2.youtube_code learn from SOF
AppleScript and Text Encodings
learned from applescript_and_text_encodings my usage write this_data to the open_target_file as «class utf8» starting at eof “as «class utf8»” is the code to made it export as unicode text file…
download big file with file_put_contents
$dl_res= file_put_contents( $savetoDir.$lk , fopen(“http://www.mediacast.com.hk/hkdigitallife/”.$lk, ’r’));