学步园

1、连接Mysql

[php]
view plaincopyprint?

1. $con = mysql_connect("localhost","root","");  
2. if (!$con){  
3.     echo 'Could not connect: ' . mysql_error();  
4. }  

$con = mysql_connect("localhost","root","");
if (!$con){
	echo 'Could not connect: ' . mysql_error();
}

2、选择数据库

[php]
view plaincopyprint?

1. mysql_select_db("test", $con);  

mysql_select_db("test", $con);

3、数据库查询

[php]
view plaincopyprint?

1. $sql = "INSERT INTO table_name (id, name, status) VALUES('123456','me',1)";  
2.   
3. $sql = "UPDATE table_name SET `status` = 0 WHERE `id` = '123456'";  
4.   
5. $sql = "DELETE FROM table_name WHERE `id` = '123456'";  
6.   
7. $sql = "SELECT * FROM table_name WHERE `status` = 1";  
8.   
9. $result = mysql_query($sql);  

$sql = "INSERT INTO table_name (id, name, status) VALUES('123456','me',1)";

$sql = "UPDATE table_name SET `status` = 0 WHERE `id` = '123456'";

$sql = "DELETE FROM table_name WHERE `id` = '123456'";

$sql = "SELECT * FROM table_name WHERE `status` = 1";

$result = mysql_query($sql);

4、判断查询是否成功

select的时候

[php]
view plaincopyprint?

1. if(mysql_num_rows($result)>=0){  
2.     //query success   
3. }else{  
4.     //query failed   
5. }  

if(mysql_num_rows($result)>=0){
	//query success
}else{
	//query failed
}

insert、delete、update的时候

[php]
view plaincopyprint?

1. if(mysql_affected_rows($con)>0){  
2.     //query success   
3. }else{  
4.     //query failed   
5. }  

if(mysql_affected_rows($con)>0){
	//query success
}else{
	//query failed
}

5、处理select返回的数据

[php]
view plaincopyprint?

1. if((mysql_num_rows($result)>0)){  
2.     while($row = mysql_fetch_assoc($result))  
3.     {  
4.         $tmp_array[] = $row;  
5.     }  
6. }  

if((mysql_num_rows($result)>0)){
	while($row = mysql_fetch_assoc($result))
	{
		$tmp_array[] = $row;
	}
}

$temp_array中就是以数组的形式保存着返回的数据

6、关闭连接

[php]
view plaincopyprint?

1. mysql_close($con);