Two ways to connect php to mysql. Mysql garbled problem
Release: 2016-07-25 08:53:57
Original
895 people have browsed it
-
- //In conf/php.ini, use "/php_mysql" in vim to search extension=php_mysql.dll, remove the ";" in front, and add extension=php_mysqli.dll;
- $mysqli below = new mysqli("127.0.0.1","Username", Password","Library name");
- $query="select * from table order by theindex desc";
- $mysqli->query("set names gb2312");//Be careful not to add garbled characters here
- $result = $mysqli->query($query);
- //printf() function outputs a formatted string
- while(list($name, $ theindex) = $result->fetch_row())
- echo("
".$name.$theindex);
- $con = mysql_connect("localhost", "username", "password") ;
- if ($con) {
- mysql_query("set names 'gb2312'");
- mysql_select_db("library name", $con);//Be careful not to add garbled characters here
- $rs = mysql_query("select * from table order by theindex desc;", $con);
- if ($rs) {
- echo ("
");
- while($row = mysql_fetch_assoc($rs))
- {
- echo "
" .
- "
$row[theindex] | " .
- "
$row[name] | " .
- "
";
- }
- mysql_free_result($rs);
- }
- echo ("
");
- mysql_close($con);
- }
Copy code
|
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
Latest Articles by Author
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31