PHP调用数据库

一个简单的例子。

<?php
	include "./mobile/sql.php";
	$con = mysql_connect($domain,$usrnm,$password);
	mysql_select_db($usrnm) or die('Could not select database'); 
	mysql_query("set character set 'utf8'");
	$page = $_GET['page'];
	if(!$con){
		
		echo("can not connect");
	}
	else{
		echo("connecting<br/>");	
		//1.登陆授权
		if($page=='login'){
			//1.读取用户数据，并进行匹配
			
			$sql = "select * from mb_usr";
			$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
			
			echo "login";
			while( $row = mysql_fetch_array($result) ){
 			   	echo "usrid:".$row['usrid']."<br />";
    		   	echo "mail:".$row['mail']."<br />";
				echo "1";
				}
			}
			
	}


?>