Php tutorial to convert Chinese Pinyin code The original realization of this program is to convert the Chinese characters into the corresponding machine code, and then define the relative Pinyin, Chinese Pinyin conversion is just a matter of inquiry. $ d = array ("a", - 20319), array ("ai", - 20317), array ("an", - 20304), array ("ang", - 20295), ...
sql query special does not include the date of the data sql = "select * from test where dates not in (# 2010-05-03 #, # 2010-05-12 #)" date format before and after plus plus # Can be found not include # 2010-05-03 #, # 2010-05-12 # all the data, look at a more stupid way 'sql = "select * fro ...
SQL two field subtraction statements This article searches for a large number of SQL two field subtraction statements and function codes from the network, illustrating two field subtraction practices. Select a. field 1, Field 2=a. Field 2-isnull ((select field 2 from Table 2 where a. Field 1 = Field 1), 0) from table 1 a method two CREATE table 1 (field 1 varchar (50), Word ...
Obtain php tutorial configuration option value. Syntax: string get_cfg_var (string varname); Return Value: String Function Type: php System Function Description If the current php configuration options varname, it returns the value of the variable. If it fails, it returns false. * / echo "php set the maximum execution time: n"; print_r (get_cfg_var (& q ...
Provide two php tutorial interception string function, they can automatically identify the Chinese Oh, if you are intercepting the article this is very good, like to come in and see it. <? php header ("content-type: text / html; charset = utf-8"); function strcut ($ string, $ length, $ dot = '...', $ chars ...
php tutorial to read the contents of the text file Reading the file in the php language many ways, today we talk about three examples of php read text file content, it is mainly used fopen, file, file_get_contents function to achieve. * / / fopen read the file instance $ path = 'a.txt'; $ fp = fopen ($ file, "r"); // Open the file while (! (feof ($ fp) ) {& n ...
/ php tutorial Chinese characters interception function // string to be intercepted, $ num to intercept the length of return truncated string public function substrgb ($ in, $ num) {// $ num = 16; $ pos = 0; & ...
Simple mysql tutorial grouping statistics statement instance code / id name code_id code_name is_true score 1 Zhang San 1 handsome is 5 2 Zhang San 2 lavish is 4 3 Zhang San 1 handsome is 4 4 Zhang San 2 lavish no 3 5 Li Si 1 handsome Is 5 6 Li Si 2 lavish is 3 to see an instance mysql grouped by name statistics: [handsome] how many ...
Finding and matching php strings The functions used to find or match or locate in php are numerous and all have different meanings. Here only about the more strstr, stristr. The latter and the former function, the return value is the same, but not case-sensitive. strstr ("parent string", "substring") is used to find the first occurrence of a substring in the parent string and returns the part of the parent string that begins with the substring and ends with the parent string . Such as ec ...
We will use the regular replacement function preg_replace, the following example is the text has a The following tag <img style src = "<? = $ Url?> / Images / styleno.jpg" width = "30" height = "30 & ...
MySQL Chinese wrong order solution / * The method has been changed to the character set of the field gbk, and then the order by order can be used directly. For example, change "name char (10)" to "name char (10) binary" by adding the "binary" attribute to the field containing Chinese and setting it as binary. ". If you make ...
SQL statement Import Excel to DB2 database Tutorial//method One SQL statement import Excel to DB2 database import from "C:booknow.csv" of del messages "D:msg.out" &n ...
Another case of the strtr function <? php tutorial echo strtr ("i love you", "love", "lovea");?> The result is i loves you Note that looking at the third argument a, Appear 4. I do not recommend using strtr less change ok, since this strtr function is very troublesome why ...
php tutorial to get the native mac address three ways getmacaddr {var $ return_array = array (); / / return string array with mac address var $ mac_addr; ...
Several guidelines on the establishment of the index: 1, a reasonable indexing can speed up the efficiency of data reading, but unreasonable indexing will slow down the database response speed. 2, the more the index, the slower the update data. 3, try to use the index when using MyIsam as an engine (because MySQL uses BTree to store indexes), not InnoDB. But MyISAM does not support Transcation. 4, when your program and database structure / SQL statement has been optimized to the extent that can not be optimized, and the program bottleneck can not be successfully resolved, then ...
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.