Differences

This shows you the differences between two versions of the page.

--- devwiki:php [2021/06/25 18:32] – [Php Date and Time Related] ying
+++ devwiki:php [2021/12/23 17:41] – [PHP and SQL] ying
@@ Line 12: / Line 12: @@
   * select past 1 month time <code>where `time_entry`> DATE_SUB(NOW(), INTERVAL 1 MONTH)</code>
+  * array related <code>
+// sort array
+sort($my_list);
+</code>
+  * unicode data insert, make sure
+    - database table's charset is utf8mb4 in sql<code>
+CREATE TABLE info_table (
+  id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+  name varchar(50) NOT NULL,
+  edit_time DATETIME NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+</code>
+    - make sure database connect is set to utf8mb4 mode in php before query and insert<code>
+mysqli_set_charset($con, "utf8mb4");
+</code>
+    - make sure charset is declared in html <code>
+<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
+</code>
 ====== Php Date and Time Related ======
   * all time info <code>
@@ Line 32: / Line 52: @@
 </code>
+  * show during time range: https://stackoverflow.com/questions/25921296/i-would-like-to-show-messages-according-to-time-range-between-two-time-stamps/25921549
+====== Python to Php ======
+^   ^ python ^ php ^
+| string operation | word.strip() | trim($word) |
+|  | word[1:5] | substr($word, 1, 5) |
+|  | word[1:] | substr($word, 1) |
+|  | prefix+subfix | $prefix.$subfix |
+|  | text.replace('find','replace') | str_replace('find','replace',$text) |
+|  | text.lower() | strtolower($text) |
+|  | text.startswith(prefix) | ? |
+| list operation | res_list = [x.strip() for x in txt.split('\n')] | $res_list = array_map('trim', explod('\n', $txt)) |
+| | | <code>$res_list = array_map('trim', preg_split("/\r\n|\n|\r/", $selected) ); // ok for text</code> |
+| | res_list.append(tmp_img) | array_push($res_list, $tmp_img); |
+| |  | $res_list[] = $tmp_img; |
+| | for each in word_list: | foreach($word_list as $each){} |
+| | if id in check_list: | if(in_array($id, $check_list)){} |
+| logic | if mark == '#': pass; elif mark == '*' | if($mark==="#"){} elseif($mark==="*"){} |
+<code>
+php:
+$tmp_path = $path.strtolower(str_replace(' ','_', trim(substr($each,1)))).'.jpg';
+$tmp_img = sprintf('<br><img src="%s">', $tmp_path);
+array_push($res_list, $tmp_img);
+join("\n",$res_list);
+python: (human logic writing)
+tmp_path = path + each[1:].strip().replace(' ','_').lower()+ '.jpg'
+tmp_img = '<br><img src="{0}">'.format(tmp_path)
+res_list.append(tmp_img)
+'\n'.join(res_list)
+</code>