去掉字符串中的中文
$a = "河蟹社会afeowahgieawhjozf候蛇fawgwea维稳aghoiawghowi我日";
$result = preg_replace('/([\x80-\xff]*)/i','',$a);
var_dump($result);
[PHP]代码
try
{
$hostname = "localhost";
$dbname = "xxxx";
$username = "root";
$pw = "xxxx";
$pdo = new PDO ("mysql:host=$hostname;dbname=$dbname", "$username", "$pw");
$db->query("set names utf-8");
}
catch (PDOException $e)
{
echo "Failed to get DB handle: " . $e -> getMessage() . "\n";
exit;
}
$query = $pdo -> prepare("select id,store_image FROM store");
$query -> execute();
for($i = 0; $row = $query -> fetch(); $i++)
{
$new_file = preg_replace('/([\x80-\xff]*)/i', '',$row['store_image']);
$id=$row['id'];
$sql="update store set store_image='$new_file' where id=$id";
$pdo->exec($sql);
}
版权申明:本站文章部分自网络,如有侵权,请联系:[email protected]
特别注意:本站所有转载文章言论不代表本站观点!
本站所提供的图片等素材,版权归原作者所有,如需使用,请与原作者联系。