PHP连接MySQL数据库

mysql_conncet('主机地址','用户名','密码')连接数据库

	$link = mysql_connect("localhost","root","123456")or die("连接失败！".mysql_error());
	if($link){
		echo "数据库连接成功！";
	}

mysql_select_db("数据库名",连接)选择数据库

	$select_db = mysql_select_db("db_admin",$link)or die("数据库不存在！");
	if($select_db){
		echo "选择数据库成功！";
	}

mysql_query(SQL,连接)执行SQL语句

	$result = mysql_query("insert into admin(user,pwd)values('admin','111')",$link)or die("操作失败！");
	if($result){
		echo "操作成功！";
	}

mysql_fetch_array($result);将查询结果封装为一个array数组

（row的扩展版，能作为索引储存，不明显比row慢）

	$arr = mysql_fetch_array($result);
	do{
		echo $arr[0]." ";
		echo $arr[1]." ";
		echo $arr[2]."<br>";
	}while($arr=mysql_fetch_array($result));//循环读取直到没有下一条数

mysql_fetch_object($result);将查询结果封装为一个对象

	$object = mysql_fetch_object($result);
	do{
		echo $object->id." ";
		echo $object->user." ";
		echo $object->pwd."<br>";
	}while($object=mysql_fetch_object($result));//循环读取直到没有下一条数据

mysql_fetch_row($result);将查询结果封装为一个数组

	$row = mysql_fetch_row($result);
	do{
		echo $row[0]." ";
		echo $row[1]." ";
		echo $row[2]."<br>";
	}while($row=mysql_fetch_row($result));//循环读取直到没有下一条数据

mysql_num_rows($result)；返回查询结果的条数

	$nums = mysql_num_rows($result);
	echo $nums;

将数据库连接封装成一个类

<?php
	class ConnDB{
		var $dbtype;//定义链接属性
		var $host;
		var $user;
		var $pwd;
		var $dbname;
		var $conn;
		function ConnDB($dbtype,$host,$user,$pwd,$dbname){//创建构造方法
			$this->dbtype = $dbtype;
			$this->host = $host;
			$this->user = $user;
			$this->pwd = $pwd;
			$this->dbname = $dbname;
		}
		function getConn(){//链接方法
			$this->conn = mysql_connect($this->host,$this->user,$this->pwd) or die("链接失败".mysql_error());
			mysql_select_db($this->dbname,$this->conn) or die("选择失败".mysql_error());
			mysql_query("set names utf-8");
			return $this->conn;
		}
		function closeConn(){
			mysql_close($this->conn);
		}
	}
?>

调用时：

	$conn_db = new ConnDB("mysql","localhost","root","123456","db_admin");
	$conn_db->getConn();
	
	$sql = mysql_query("insert into student(name,pro,remark)values('$name','$pro','$remark')");
	if($sql){
		echo "添加成功！";
	}
	$conn_db->closeConn();