Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revisionBoth sides next revision | ||
devwiki:php [2021/12/23 08:46] – [Python to Php] ying | devwiki:php [2021/12/23 17:41] – [PHP and SQL] ying | ||
---|---|---|---|
Line 16: | Line 16: | ||
// sort array | // sort array | ||
sort($my_list); | sort($my_list); | ||
+ | </ | ||
+ | |||
+ | * unicode data insert, make sure | ||
+ | - database table' | ||
+ | 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; | ||
+ | </ | ||
+ | - make sure database connect is set to utf8mb4 mode in php before query and insert< | ||
+ | mysqli_set_charset($con, | ||
+ | </ | ||
+ | - make sure charset is declared in html < | ||
+ | <meta http-equiv=" | ||
</ | </ | ||
====== Php Date and Time Related ====== | ====== Php Date and Time Related ====== |