public function updatePhoneOp() {		set_time_limit(0);		$link=mysql_connect("localhost","root","root") or exit("数据库连接失败！");		$db=mysql_select_db("shop");		mysql_set_charset("utf8");		$select = "select member_id,member_mobile,member_email from 33hao_member where member_id < 5";		$result = mysql_query($select);		while($arr=mysql_fetch_assoc($result)) {			if(!empty($arr)){									if(!empty($arr['member_mobile'])){										if(preg_match("/^13[0-9]{1}[0-9]{8}$|15[0189]{1}[0-9]{8}$|189[0-9]{8}$/",$arr['member_mobile'])){						//验证通过												$update1="update 33hao_member set member_mobile_bind=1 where member_id = {$arr['member_id']} ";						mysql_query($update1);						//print_r($update1);						//exit();					}				}				if(!empty($arr['member_email'])){					//if (preg_match("/^[a-z]([a-z0-9]*[-_\.]?[a-z0-9]+)*@([a-z0-9]*[-_]?[a-z0-9]+)+[\.][a-z]{2,3}([\.][a-z]{2})?$/i; ",$arr['member_email'])){						$update2="update 33hao_member set member_email_bind=1 where member_id = {$arr['member_id']}";						 mysql_query($update2);					//}				}				//$update1="update br_goods_common set goods_costprice={$arr['goods_price']} where goods_commonid={$arr['goods_commonid']} ";				//mysql_query($update1);				//$update2="update br_goods set goods_promotion_price={$arr['goods_price']} where goods_commonid={$arr['goods_commonid']}";				//mysql_query($update2);				$str="用户名id：{$arr['member_id']},修改成功";				file_put_contents("log.txt",$str.PHP_EOL,FILE_APPEND);				//echo $str;			}		}		}

修改表数据