PHP---MySQL快速入门使用

<?php

//连接数据库
//alter database test character set utf8;
$conn=mysql_connect("localhost","root","");  

//选择数据库
$sql=mysql_query("use test",$conn);

//设置字符集
$sql=mysql_query("set names utf8",$conn);

//清空表单
$sql=mysql_query('truncate proc',$conn);

//插入数据库数据
$sql=mysql_query("insert into proc(id,name) values(1,'张三')",$conn);
 echo mysql_affected_rows(),'<br />';
$sql=mysql_query("insert into proc(id,name) values(2,'李四')",$conn);
 echo mysql_affected_rows(),'<br />';
$sql=mysql_query("insert into proc(id,name) values('王五')",$conn);
 echo mysql_affected_rows(),'<br />';

//语句查询
$sql=mysql_query("set names utf8",$conn);
$sql=mysql_query("select * from proc",$conn);

//从数据库中取数据
$arr=array();
while($row=mysql_fetch_assoc($sql)){

   $arr[]=$row;
} 

//遍历数组
foreach($arr as $v){

 echo $v['id'].' '.$v['name'].'<br />';
}


//关闭数据库
mysql_close();
?>