-
- //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
|