设为首页 收藏本站 订阅本站

blogger

MYSQL数据库电话号码表记录处理代码片段

cache 发布于 技术文档 2013-05-19 [ 913 ] 次浏览 [ 0 ] 条评论

标签: 手机号 电话 正则

MYSQL数据库电话号码表记录处理代码片段

自己给朋友做的一个处理,临时用的一个代码片段,记录一下,以备不时之需。其中用到了几个正则表达式和部分foreach循环。

 

<?php

ignore_user_abort (true);
set_time_limit (0);

class mysql
{

				public $fetch_mode = MYSQL_BOTH;
				public $record = array( );
				public $count = NULL;

				public function __construct( )
				{
								$this->connect( );
				}

				public function connect( )
				{
								if ( !( $this->link = mysql_connect( "localhost", "root", "" ) ) )
								{
												exit( mysql_error( ) );
								}
								mysql_query( "SET NAMES UTF8" );
								if ( !mysql_select_db( "two", $this->link ) )
								{
												exit( "未能找到数据库:" );
								}
				}

				public function ping( )
				{
								if ( !mysql_ping( $this->link ) )
								{
												mysql_close( $this->link );
												$this->connect( );
								}
				}

				public function query( $sql )
				{
								mysql_query( "SET NAMES UTF8" );
								return mysql_query( $sql );
				}

				public function num_rows( $result )
				{
								return mysql_num_rows( $result );
				}

				public function affected_rows( )
				{
								return mysql_affected_rows( );
				}

				public function num_fields( $result )
				{
								return mysql_num_fields( $result );
				}

				public function free_result( $result )
				{
								return mysql_free_result( $result );
				}

				public function insert_id( )
				{
								return mysql_insert_id( );
				}

				public function close( )
				{
								return mysql_close( );
				}

				public function fetch_array( $result )
				{
								if ( $result )
								{
												return mysql_fetch_array( $result, $this->fetch_mode );
								}
				}

				public function fetch_row( $rs )
				{
								$this->record = mysql_fetch_array( $rs, $this->fetch_mode );
								return $this->record;
				}

				public function fetch_all( $rs )
				{
								$arr = array( );
								while ( $this->record = mysql_fetch_array( $rs, $this->fetch_mode ) )
								{
												$arr[] = $this->record;
								}
								return $arr;
				}

}
$db = new mysql();

				$sql = "select * from reg where 1";
				if ( !( $rs = $db->query( $sql ) ) )
				{
								exit( mysql_error( ) );
				}
				while ( $row = $db->fetch_array( $rs ) )
				{
					$arr = array();$i =0;
					$row['email']=trim($row['email']);
					$b=explode(" ",$row['email']);
					foreach($b as $key){
						if(strlen($key)==11){
												 $regex = "/13\d{9}|15\d{9}|18\d{9}|14\d{9}/";
					 preg_match_all($regex,$key, $phones);
					 if($phones[0][0]){$arr[]= $key;}else{$i++;}
						}else{ $i++;}
						
						
					}if($i > 0){continue;}
						$row['content'] = trim($row['content']);
						foreach ($arr as $key)
						{
							
					 	$sqls = "insert into phone (name,phone,content) values ('".$row['name']."','".$key."','".$row['content']."')";
					 	if (!(  $rss = $db->query( $sqls ) ) )
						{
								exit( mysql_error( ) );
						}
							
						}
						$sqlss = "delete from reg where id = '".$row['id']."'";
								if ( !( $rssss = $db->query( $sqlss ) ) ){exit( mysql_error( ) );}

//										$row['email']=trim($row['email']);
//					
//					 if(strlen($row['email'])==12)
//					 {
//					 $regex = "/021-[0-9]{8}/";
//					 preg_match_all($regex,$row['email'], $phones);
//					 if($phones[0][0])
//					 {
//					 	$row['email'] = str_replace("021-","",$phones[0][0]);
//					 	$row['content'] = trim($row['content']);
//					 	$sqls = "insert into phone (name,phone,content) values ('".$row['name']."','".$row['email']."','".$row['content']."')";
//					 	if (  $rss = $db->query( $sqls ) ) 
//						{
//								$sqlss = "delete from reg where id = '".$row['id']."'";
//								if ( !( $rssss = $db->query( $sqlss ) ) ){exit( mysql_error( ) );}
//						}
//					 	
//					}
//				}

//
//										$row['email']=trim($row['email']);
//					
//					 if(strlen($row['email'])==10)
//					 {
//					 $regex = "/800[0-9]{7}/";
//					 preg_match_all($regex,$row['email'], $phones);
//					 if($phones[0][0])
//					 {
//					 	$row['email'] = str_replace("-","",$phones[0][0]);
//					 	$row['content'] = trim($row['content']);
//					 	$sqls = "insert into phone (name,phone,content) values ('".$row['name']."','".$row['email']."','".$row['content']."')";
//					 	if (  $rss = $db->query( $sqls ) ) 
//						{
//								$sqlss = "delete from reg where id = '".$row['id']."'";
//								if ( !( $rssss = $db->query( $sqlss ) ) ){exit( mysql_error( ) );}
//						}
//					 	
//					}
//				}
			}
?>

MYSQL数据库电话号码表记录处理代码片段:等您坐沙发呢!

发表评论