mysql utf8 汉字转拼音_php mysql中utf8编码汉字转换成拼音

$db = mysql_connect("127.0.0.1:3307", "root","123");

if(!$db) {

// Show error if we cannot connect.

echo 'ERROR: Could not connect to the database.';

} else {

// Is there a posted query string?

if(isset($_POST['queryString'])) {

$queryString = $_POST['queryString'];

$length=strlen($queryString);

mysql_select_db("qq",$db);

$result = mysql_query("set names utf8");

// Is the string length greater than 0?

if($length>0) { (程序员之家 bbs.it-home.org 编辑整理)

$sql="";

if(!ereg("^[A-Za-z0-9_.-]+$",$queryString))//如果有汉字的话

{$sql="SELECT title FROM groups WHERE title LIKE '$queryString%' LIMIT 10";

}else{//英文数字符号

$sql="SELECT title FROM groups WHERE titlepinyin LIKE '$queryString%' LIMIT 10";

}

$query = mysql_query($sql);

// Run the query: We use LIKE ‘$queryString%’

if($query) {

while ($myrow = mysql_fetch_array($query)) {

// Format the results, im using

for the list, you can change it.

// The onClick function fills the textbox with the result.

echo '

'.$myrow[0].'';

}

} else {

echo "ERROR: There was a problem with the query $sql.";

}

} else {

}

} else {

echo 'There should be no direct access to this script!';

}

}

?>