<?php
header("Content-Type: text/html; charset=GBK");
echo "你好<br>";
$conn = @mysql_connect("localhost","root","hjq");//连接
数据库 mysql_select_db("friends",$conn);//选择数据库
if($conn){
echo "连接成功<br>";
mysql_query("SET NAMES GBK"); //处理乱码
print"<hr>";
print("遍历表格,读取数据<br>");
$recode="select * from friends";
$result=mysql_query($recode,$conn);
while ($row = mysql_fetch_array($result, MYSQL_BOTH))
{
printf("ID: %s 姓名: %s 性别: %s 电话:%s", $row[0], $row[1],$row[2],$row[3]);
print "<br>";
}
mysql_free_result($result);
print"<hr>";
print("向表格插入记录<br>");
$sql="insert into friends(name,sex,telno) values ('hjq','girl','01082432323')";
$result=mysql_query($sql);
print("插入成功");
print"<hr>";
print("更新表格记录<br>");
$sql="update friends set sex='女' where id<3";
$result=mysql_query($sql);
print("更新成功");
print"<hr>";
print("删除表格记录<br>");
$sql="delete from friends where id=5";
$result=mysql_query($sql);
print("删除成功");
mysql_close($conn);
}else{
echo "连接失败";
}
?>
-[?-i:CN`W/n0
附加:
phpdesigner2008破解码:
Name:www.okeydown.com
Od]LX*J%z0Email:www@okeydown.com
U:Sie}B-Ls\N0Comp:www.okeydown.com 51Testing软件测试网No3hE n
Code:F6CB0A83AAA18408408408408401E01E01E0EE0EE02E0AE0520A40480900