php+mysql案例2

<?php
/*
 * 吕老师教学视频-http://www.tudou.com/home/xuexi158
 * *知识改变命运QQ:544745880
 */
include("08MySQL.php");
//创建mysql对象
$mysql = new MySQL("localhost","root","123456","think_frank","gbk");
//添加
$addSQL = "insert into think_blog(title,content) values('08网络','马上毕业了')";
$mysql->myUpdate($addSQL);


//删除
//$delSQL = "delete from  think_blog where id=19";
//$result = $mysql->myUpdate($delSQL);
//echo $result;
//修改
//$upSQL = "update think_blog set title='网络信息' ,content='毕业了真高兴' where id=24";
//$r = $mysql->myUpdate($upSQL);
//echo $r;
//查询单条记录
$sql="select * from think_blog where id=16";
$res = $mysql->myUpdate($sql);
//需要对结果做遍历
if($row = $mysql->myFetch($res)){
    echo $row[0].",".$row[1].",".$row[2]."<br/>";
}
////查询所有记录
$allSQL = "select * from think_blog";
$resall = $mysql->myUpdate($allSQL);
while($row = $mysql->myFetch($resall)){
    echo $row[id].",".$row[title].",".$row[content]."<br/>";
}



?>