php字符串去掉中文

去掉字符串中的中文    

$a = "<a>河蟹社会afeowahgieawhjozf候蛇fawgwea维稳aghoiawghowi我日</a>";
$result = preg_replace('/([\x80-\xff]*)/i','',$a);
var_dump($result);

[PHP]代码    

<?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);    
} 

/*
$it = new RecursiveDirectoryIterator("./avatar");
foreach(new RecursiveIteratorIterator($it) as $file)
{
    echo $file . "\n";
    $new_file = preg_replace('/([\x80-\xff]*)/i', '', $file);
    rename($file, $new_file);
} 
*/

标签： Mysql 代码

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点！
本站所提供的图片等素材，版权归原作者所有，如需使用，请与原作者联系。