phpとmysqlは文字列の置換関数を切り取ってメモを使います!
1019 ワード
php方式携帯電話の中間4桁を隠す3つの方式
mysql方式携帯電話の真ん中4桁を隠す
$mobile = '18812345678';
# , , ; 0 3 , 4 , 7 4 。
echo substr($mobile,0,3).'****'.substr($mobile,7,4);
# 3 4
echo substr_replace($mobile,'****',3,4);
#
echo preg_replace('/(1[0-9]{2})([0-9]{4})([0-9]{4})/i','$1****$3',$mobile);
#
#$0|$1|$2|$3 18812345678|188|1234|5678
echo preg_replace('/(1[0-9]{2})([0-9]{4})([0-9]{4})/','$0|$1|$2|$3',$mobile);
mysql方式携帯電話の真ん中4桁を隠す
# 3 , 4 , *
SELECT CONCAT(LEFT('18812345678',3),'****',RIGHT('18812345678',4)) AS mobile
#mysql 1 0
SELECT CONCAT(SUBSTRING('18812345678',1,3),'****',SUBSTRING('18812345678',7,4)) AS mobile
#replace( , , ),
select replace('18812345678','1234','****') AS mobile
#insert( , , , )
SELECT INSERT('18812345678',4,4,'****') AS mobile