Differences

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

--- devwiki:php [2021/12/14 17:40] – [Python to Php] ying
+++ devwiki:php [2022/11/16 16:16] (current) – [Python to Php] ying
@@ Line 16: / Line 16: @@
 // 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 ======
@@ Line 53: / Line 68: @@
 | | res_list.append(tmp_img) | array_push($res_list, $tmp_img); |
 | |  | $res_list[] = $tmp_img; |
-| logic | for each in word_list: | foreach($word_list as $each){} |
+| | for each in word_list: | foreach($word_list as $each){} |
-|  | if mark == '#': pass; elif mark == '*' | if($mark==="#"){} elseif($mark==="*"){} |
+| | if id in check_list: | if(in_array($id, $check_list)){} |
+| logic | if mark == '#': pass; elif mark == '*' | if($mark==="#"){} elseif($mark==="*"){} |
 <code>
@@ Line 69: / Line 85: @@
 '\n'.join(res_list)
 </code>
+====== Use PHP as HTML File output process ======
+  * other than serve php page through apache server, php in commandline also can be used to create html local page.
+  * cmd code for render php to html file<code>
+cd php_root_path
+php.exe D:\path_to_php_web_page\test.php D:\path_to_php_web_page\test_out.html
+</code>