1.編碼 JSON 時保留 key 值
$post_data = json_encode(array('aaa'), JSON_FORCE_OBJECT);
// 輸出 {"0":"aaa"}
2.解碼時用陣列
$array = json_decode($json, true);
echo $array['foo'] . PHP_EOL; //"bar"
echo $array['number'] . PHP_EOL; //42
3.陣列轉換成物件 {}
$obj = (object) array('1' => 'foo');
$a = new stdclass; $a->id = 11;
4.sublime prettify 的快捷鍵是 Ctrl + Alt + J (要先安裝)
2018年5月29日 星期二
【PHP】型態轉成object
有時要把型態轉成object可用
方法一: $obj = (object) array('1' => 'foo');
方法二:$a = new stdclass; $a->abc = 'abc';
目前有用到的時機
1.轉json時,為了符合別人定的API的JSON規則,需要轉成object
2.建立一個空的類只是為了傳遞或儲存參數時
方法一: $obj = (object) array('1' => 'foo');
方法二:$a = new stdclass; $a->abc = 'abc';
目前有用到的時機
1.轉json時,為了符合別人定的API的JSON規則,需要轉成object
2.建立一個空的類只是為了傳遞或儲存參數時
2018年5月28日 星期一
【PHP】XML to array
/** * xml2array() will convert the given XML text to an array in the XML structure. * Link: http://www.bin-co.com/php/scripts/xml2array/ * Arguments : $contents - The XML text * $get_attributes - 1 or 0. If this is 1 the function will get the attributes as well as the tag values - this results in a different array structure in the return value. * $priority - Can be 'tag' or 'attribute'. This will change the way the resulting array sturcture. For 'tag', the tags are given more importance. * Return: The parsed XML in an array form. Use print_r() to see the resulting array structure. * Examples: $array = xml2array(file_get_contents('feed.xml')); * $array = xml2array(file_get_contents('feed.xml', 1, 'attribute')); */ function xml2array($contents, $get_attributes=1, $priority = 'tag') { if(!$contents) return array(); if(!function_exists('xml_parser_create')) { //print "'xml_parser_create()' function not found!"; return array(); } //Get the XML parser of PHP - PHP must have this module for the parser to work $parser = xml_parser_create(''); xml_parser_set_option($parser, XML_OPTION_TARGET_ENCODING, "UTF-8"); # http://minutillo.com/steve/weblog/2004/6/17/php-xml-and-character-encodings-a-tale-of-sadness-rage-and-data-loss xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0); xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1); xml_parse_into_struct($parser, trim($contents), $xml_values); xml_parser_free($parser); if(!$xml_values) return;//Hmm... //Initializations $xml_array = array(); $parents = array(); $opened_tags = array(); $arr = array(); $current = &$xml_array; //Refference //Go through the tags. $repeated_tag_index = array();//Multiple tags with same name will be turned into an array foreach($xml_values as $data) { unset($attributes,$value);//Remove existing values, or there will be trouble //This command will extract these variables into the foreach scope // tag(string), type(string), level(int), attributes(array). extract($data);//We could use the array by itself, but this cooler. $result = array(); $attributes_data = array(); if(isset($value)) { if($priority == 'tag') $result = $value; else $result['value'] = $value; //Put the value in a assoc array if we are in the 'Attribute' mode } //Set the attributes too. if(isset($attributes) and $get_attributes) { foreach($attributes as $attr => $val) { if($priority == 'tag') $attributes_data[$attr] = $val; else $result['attr'][$attr] = $val; //Set all the attributes in a array called 'attr' } } //See tag status and do the needed. if($type == "open") {//The starting of the tag '' $parent[$level-1] = &$current; if(!is_array($current) or (!in_array($tag, array_keys($current)))) { //Insert New tag $current[$tag] = $result; if($attributes_data) $current[$tag. '_attr'] = $attributes_data; $repeated_tag_index[$tag.'_'.$level] = 1; $current = &$current[$tag]; } else { //There was another element with the same tag name if(isset($current[$tag][0])) {//If there is a 0th element it is already an array $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result; $repeated_tag_index[$tag.'_'.$level]++; } else {//This section will make the value an array if multiple tags with the same name appear together $current[$tag] = array($current[$tag],$result);//This will combine the existing item and the new item together to make an array $repeated_tag_index[$tag.'_'.$level] = 2; if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well $current[$tag]['0_attr'] = $current[$tag.'_attr']; unset($current[$tag.'_attr']); } } $last_item_index = $repeated_tag_index[$tag.'_'.$level]-1; $current = &$current[$tag][$last_item_index]; } } elseif($type == "complete") { //Tags that ends in 1 line ' ' //See if the key is already taken. if(!isset($current[$tag])) { //New Key $current[$tag] = $result; $repeated_tag_index[$tag.'_'.$level] = 1; if($priority == 'tag' and $attributes_data) $current[$tag. '_attr'] = $attributes_data; } else { //If taken, put all things inside a list(array) if(isset($current[$tag][0]) and is_array($current[$tag])) {//If it is already an array... // ...push the new element into that array. $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result; if($priority == 'tag' and $get_attributes and $attributes_data) { $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data; } $repeated_tag_index[$tag.'_'.$level]++; } else { //If it is not an array... $current[$tag] = array($current[$tag],$result); //...Make it an array using using the existing value and the new value $repeated_tag_index[$tag.'_'.$level] = 1; if($priority == 'tag' and $get_attributes) { if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well $current[$tag]['0_attr'] = $current[$tag.'_attr']; unset($current[$tag.'_attr']); } if($attributes_data) { $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data; } } $repeated_tag_index[$tag.'_'.$level]++; //0 and 1 index is already taken } } } elseif($type == 'close') { //End of tag ' ' $current = &$parent[$level-1]; } } return($xml_array); }
2018年5月25日 星期五
【PHP】UUID
串接API時常常會發現很多亂碼,
類似:570e8400-e29b-41d4-a716-44b6594400a0
以為是每個廠商為了辨別所創立的亂數,
原來它有一定的格式及名稱
通用唯一識別碼(英語:Universally Unique Identifier,簡稱UUID)
形式為8-4-4-4-12的32個字元,重複率超低,
所以每次產生都能當作此筆交易或是交換的唯一值
類似:570e8400-e29b-41d4-a716-44b6594400a0
以為是每個廠商為了辨別所創立的亂數,
原來它有一定的格式及名稱
通用唯一識別碼(英語:Universally Unique Identifier,簡稱UUID)
形式為8-4-4-4-12的32個字元,重複率超低,
所以每次產生都能當作此筆交易或是交換的唯一值
function create_uuid($prefix = ""){ $str = md5(uniqid(mt_rand(), true)); $uuid = substr($str,0,8) . '-'; $uuid .= substr($str,8,4) . '-'; $uuid .= substr($str,12,4) . '-'; $uuid .= substr($str,16,4) . '-'; $uuid .= substr($str,20,12); return $prefix . $uuid; }
【PHP】php實現 AES/CBC/PKCS5Padding 加密解密
最近在做一個API串接,對方是用JAVA寫的,
中間有要編碼的片段,編碼方式是AES (CBC模式) 轉 Base64,
我上網找了用下面方法加解密,
$encrypt = mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $app_cc_aes_key, $data, MCRYPT_MODE_CBC, $app_cc_aes_iv);
用此方法可以順利解密,但是編碼後對方怎麼樣都解不開,
來回溝通搞了好久,上網爬文好久終於才找到解決方法,
原來是補碼的方式不同PHP是用ZeroPadding,JAVA是用PKCS5Padding,
※ 在PHP官網寫說關於mcrypt的function,PHP7.1之後不能使用!!
中間有要編碼的片段,編碼方式是AES (CBC模式) 轉 Base64,
我上網找了用下面方法加解密,
$encrypt = mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $app_cc_aes_key, $data, MCRYPT_MODE_CBC, $app_cc_aes_iv);
用此方法可以順利解密,但是編碼後對方怎麼樣都解不開,
來回溝通搞了好久,上網爬文好久終於才找到解決方法,
原來是補碼的方式不同PHP是用ZeroPadding,JAVA是用PKCS5Padding,
※ 在PHP官網寫說關於mcrypt的function,PHP7.1之後不能使用!!
class AES { public $iv; public $encryptKey; //加密 public function encrypt($encryptStr) { $localIV = $this->iv; $encryptKey = $this->encryptKey; $module = mcrypt_module_open(MCRYPT_RIJNDAEL_128, '', MCRYPT_MODE_CBC, $localIV); mcrypt_generic_init($module, $encryptKey, $localIV); $block = mcrypt_get_block_size(MCRYPT_RIJNDAEL_128, MCRYPT_MODE_CBC); $pad = $block - (strlen($encryptStr) % $block); $encryptStr .= str_repeat(chr($pad), $pad); $encrypted = mcrypt_generic($module, $encryptStr); mcrypt_generic_deinit($module); mcrypt_module_close($module); return base64_encode($encrypted); } //解密 public function decrypt($encryptStr) { $localIV = $this->iv; $encryptKey = $this->encryptKey; $module = mcrypt_module_open(MCRYPT_RIJNDAEL_128, '', MCRYPT_MODE_CBC, $localIV); mcrypt_generic_init($module, $encryptKey, $localIV); $encryptedData = base64_decode($encryptStr); $encryptedData = mdecrypt_generic($module, $encryptedData); return $encryptedData; } }
2017年11月21日 星期二
【PHP】用UTF8將文字一個一個放在陣列中
$a = '每天都要快樂 HAPPY'; $arr = utf8_str_split($a); print_r($arr); function utf8_str_split($str, $split_len = 1){ if (!preg_match('/^[0-9]+$/', $split_len) || $split_len < 1) return FALSE; $len = mb_strlen($str, 'UTF-8'); if ($len <= $split_len) return array($str); preg_match_all('/.{'.$split_len.'}|[^\x00]{1,'.$split_len.'}$/us', $str, $ar); return $ar[0]; } // 結果 Array ( [0] => 每 [1] => 天 [2] => 都 [3] => 要 [4] => 快 [5] => 樂 [6] => [7] => H [8] => A [9] => P [10] => P [11] => Y )
2017年9月6日 星期三
【jquery】keypress 按鈕對應
在表單中,按enter送出表單的方法:
$("#myform input").keypress(function (e){
$code = (e.keyCode ? e.keyCode : e.which);
if ($code == 13)
{
$("#myform").submit();
}
});
其中的 code 代碼要在下面查詢
event.keycode值大全
keycode 8 = BackSpace BackSpace
keycode 9 = Tab Tab
keycode 12 = Clear
keycode 13 = Enter
keycode 16 = Shift_L
keycode 17 = Control_L
keycode 18 = Alt_L
keycode 19 = Pause keycode 20 = Caps_Lock
keycode 27 = Escape Escape
keycode 32 = space space
keycode 33 = Prior
keycode 34 = Next
keycode 35 = End
keycode 36 = Home
keycode 37 = Left
keycode 38 = Up
keycode 39 = Right
keycode 40 = Down
keycode 41 = Select
keycode 42 = Print
keycode 43 = Execute
keycode 45 = Insert
keycode 46 = Delete
keycode 47 = Help
keycode 48 = 0 equal braceright
keycode 49 = 1 exclam onesuperior
keycode 50 = 2 quotedbl twosuperior
keycode 51 = 3 section threesuperior
keycode 52 = 4 dollar
keycode 53 = 5 percent
keycode 54 = 6 ampersand
keycode 55 = 7 slash braceleft
keycode 56 = 8 parenleft bracketleft
keycode 57 = 9 parenright bracketright
keycode 65 = a A
keycode 66 = b B
keycode 67 = c C
keycode 68 = d D
keycode 69 = e E EuroSign
keycode 70 = f F
keycode 71 = g G
keycode 72 = h H
keycode 73 = i I
keycode 74 = j J
keycode 75 = k K
keycode 76 = l L
keycode 77 = m M mu
keycode 78 = n N
keycode 79 = o O
keycode 80 = p P
keycode 81 = q Q at
keycode 82 = r R
keycode 83 = s S
keycode 84 = t T
keycode 85 = u U
keycode 86 = v V
keycode 87 = w W
keycode 88 = x X
keycode 89 = y Y
keycode 90 = z Z
keycode 96 = KP_0 KP_0
keycode 97 = KP_1 KP_1
keycode 98 = KP_2 KP_2
keycode 99 = KP_3 KP_3
keycode 100 = KP_4 KP_4
keycode 101 = KP_5 KP_5
keycode 102 = KP_6 KP_6
keycode 103 = KP_7 KP_7
keycode 104 = KP_8 KP_8
keycode 105 = KP_9 KP_9
keycode 106 = KP_Multiply KP_Multiply
keycode 107 = KP_Add KP_Add
keycode 108 = KP_Separator KP_Separator
keycode 109 = KP_Subtract KP_Subtract
keycode 110 = KP_Decimal KP_Decimal
keycode 111 = KP_Divide KP_Divide
keycode 112 = F1
keycode 113 = F2
keycode 114 = F3
keycode 115 = F4
keycode 116 = F5
keycode 117 = F6
keycode 118 = F7
keycode 119 = F8
keycode 120 = F9
keycode 121 = F10
keycode 122 = F11
keycode 123 = F12
keycode 124 = F13
keycode 125 = F14
keycode 126 = F15
keycode 127 = F16
keycode 128 = F17
keycode 129 = F18
keycode 130 = F19
keycode 131 = F20
keycode 132 = F21
keycode 133 = F22
keycode 134 = F23
keycode 135 = F24
keycode 136 = Num_Lock
keycode 137 = Scroll_Lock
keycode 187 = acute grave
keycode 188 = comma semicolon
keycode 189 = minus underscore
keycode 190 = period colon
keycode 192 = numbersign apostrophe
keycode 210 = plusminus hyphen macron
keycode 211 =
keycode 212 = copyright registered
keycode 213 = guillemotleft guillemotright
keycode 214 = masculine ordfeminine
keycode 215 = ae AE
keycode 216 = cent yen
keycode 217 = questiondown exclamdown
keycode 218 = onequarter onehalf threequarters
keycode 220 = less greater bar
keycode 221 = plus asterisk asciitilde
keycode 227 = multiply division
keycode 228 = acircumflex Acircumflex
keycode 229 = ecircumflex Ecircumflex
keycode 230 = icircumflex Icircumflex
keycode 231 = ocircumflex Ocircumflex
keycode 232 = ucircumflex Ucircumflex
keycode 233 = ntilde Ntilde
keycode 234 = yacute Yacute
keycode 235 = oslash Ooblique
keycode 236 = aring Aring
keycode 237 = ccedilla Ccedilla
keycode 238 = thorn THORN
keycode 239 = eth ETH
keycode 240 = diaeresis cedilla currency
keycode 241 = agrave Agrave atilde Atilde
keycode 242 = egrave Egrave
keycode 243 = igrave Igrave
keycode 244 = ograve Ograve otilde Otilde
keycode 245 = ugrave Ugrave
keycode 246 = adiaeresis Adiaeresis
keycode 247 = ediaeresis Ediaeresis
keycode 248 = idiaeresis Idiaeresis
keycode 249 = odiaeresis Odiaeresis
keycode 250 = udiaeresis Udiaeresis
keycode 251 = ssharp question backslash
keycode 252 = asciicircum degree
keycode 253 = 3 sterling
keycode 254 = Mode_switch
2017年9月5日 星期二
【Jquery】reset
jquery 並沒有提供 html 的 reset 功能
要使用 javascript 的寫法:
document.getElementById("myform").reset();
要使用 javascript 的寫法:
document.getElementById("myform").reset();
2017年6月13日 星期二
【mysql】預設編碼
常常在新增資料庫或資料庫欄位時,
預設編碼都變成 latin1_general_ci,
這時可以改 my.ini (windows) my.cnf (linux),
開啟或加上以下設定:
延伸:utf8mb4_general_ci V.S. utf8mb4_unicode_ci
預設編碼都變成 latin1_general_ci,
這時可以改 my.ini (windows) my.cnf (linux),
開啟或加上以下設定:
延伸:utf8mb4_general_ci V.S. utf8mb4_unicode_ci
2017年2月20日 星期一
【MSSQL】為查詢加上排序序號 ROW_NUMBER(), RANK(), DENSE_RNAK()
在 MSSQL 中有個好用的函數,能為查詢加上序號,
其中又分為
1.ROW_NUMBER() :能將指定欄位做排序,並加上排序序號
2.RANK():能將指定欄位做排序,相同資料排序相同
3.DENSE_RNAK():能將指定欄位做排序,相同資料排序相同,但序號會延續
4.ROW_NUMBER 加上 PARTITION 能將順序重新排序
5.MySQL 要呈現相同結果可以用IF加上變數去+1
if(@_type_id=type_id,@rank:=@rank+1,@rank:=1)
訂閱:
文章 (Atom)