PHP+MYSQL-操作数据库案例1

<?php
/*
 * Created on 2011-3-30
 *
 * 吕老师教学视频-http://www.tudou.com/home/xuexi158 * 知识改变命运QQ:544745880
 */
 //1.建立连接
$conn =  mysql_connect("localhost","root","123456") or die("连接失败");
//2.指定数据库
mysql_select_db("think_frank",$conn) or die("失败");
//3.指定编码
mysql_query("set names 'gbk'");

 

?>
<?php
/*  吕老师教学视频-http://www.tudou.com/home/xuexi158
 * * 知识改变命运QQ:544745880
 */
//导入数据库连接
include("conn.php");
//向cl_user添加记录
$addSQL = "insert into cl_user(cl_name,cl_addr) values('08移动','毕业了真高兴')";
$res1 = mysql_query($addSQL,$conn) or die(mysql_error());

if($res1>0){
 echo "添加成功";
}else{
 echo "添加失败";
}
//删除
$delSQL = "delete from cl_user where id=2";
$res2 = mysql_query($delSQL,$conn) or die(mysql_error());
if($res2>0){
 echo "删除成功";
}else{
 echo "删除失败";
}
//修改
$upSQL = "update cl_user set cl_name='通信' ,cl_addr='毕业了真麻烦' where id=4";
$res3 = mysql_query($upSQL,$conn) or die(mysql_error());
if($res3>0){
 echo "修改成功";
}else{
 echo "修改失败";
}
echo "<br/><font color=red size=28>==========吕老师教学视频-http://www.tudou.com/home/xuexi158=======</font><br/>";
//查询单条记录
$findById = "select * from cl_user where id =1";
$result = mysql_query($findById,$conn) or die(mysql_error());
if($row = mysql_fetch_array($result)){
 echo $row[0].",".$row[1].",".$row[2];
}
echo "<br/><font color=red size=28>==========吕老师教学视频-http://www.tudou.com/home/xuexi158=======</font><br/>";
//查询所有记录
$findAll = "select * from cl_user";
$resAll = mysql_query($findAll,$conn) or die(mysql_error());
while($row = mysql_fetch_array($resAll)){
 echo $row[id]."/t".$row[cl_name]."/t".$row[cl_addr]."<br/>";
}
//分页查询指定记录
echo "<br/><font color=red size=28>==========吕老师教学视频-http://www.tudou.com/home/xuexi158=======</font><br/>";
$findByPage = "select * from cl_user limit 0,2";
//第一个参数：从哪里开始 第二个参数：每页显示的记录数
$resPage = mysql_query($findByPage,$conn) or die(mysql_error());
while($row = mysql_fetch_array($resPage)){
 echo $row[id]."/t".$row[cl_name]."/t".$row[cl_addr]."<br/>";
}

?>