Home > Backend Development > PHP Tutorial > Learn the mysql() function in php_PHP tutorial

Learn the mysql() function in php_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-20 11:15:57
Original
843 people have browsed it

Connect to database server statement;

3.mysql_query(1,2): (1) sql statement, (2) connection identifier, If not, use the previous connection database server statement;

4. Set encoding statement: (1) mysql_query("set names 'utf8'"); (2) mysql_set_charset('utf8'); (garbled characters will appear when there is no setting);

5.mysql_fetch_array(1,2): (1) The specified data pointer, returned through the mysql_query() function; (2) Optional parameter, array type (MYSQL_ASSOC/MYSQL_NUM/MYSQL_BOTH), the default is MYSQL_BOTH , including associative arrays and numeric arrays; Note: After the specified data is obtained, this function will specify the next record. If you continue to request this function, the next record will be returned; the official website says that the field names returned by this function are case-sensitive , it is not sensitive after testing. Of course, it is under the Windows XP operating system. I don’t know about other systems yet;

6.mysql_free_result(data): Releases the result memory. data is the result returned from mysql_query(); it only needs to be called when considering how much memory will be occupied when returning a large result set. All associated when the script ends The memory will be released automatically (I don’t understand or understand);

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/440149.htmlTechArticleConnect to database server statement; 3.mysql_query(1,2): (1) sql statement, (2) connection Identifier, if not, use the previous connection database server statement; 4. Set the encoding language...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template