php数据库操作实例

 

<?
    
/* 本例是用PHP连接一个mysql数据库操作的演示,
实现连接打开一个库,并读取数据的基本功能。
数据库名称为:test    表名为:user
分别有7个字段:id userid sex age tel email address 
服务器;数据库编码 均采用 utf-8
mysql_query("set names 'gbk'"); // //这就是指定数据库字符集,一般放在连接数据库后(解决数据库乱码)
    
*/
?>

< HTML >
< HEAD >
< META NAME = " GENERATOR "  Content = " Microsoft Visual Studio 6.0 " >
< style type = " text/css " >
<!--
input { font
- size : 9pt;}
A
: link {text - decoration :  underline; font - size : 9pt;color : 000059 }
A
: visited {text - decoration :  underline; font - size : 9pt;color : 000059 }
A
: active {text - decoration :  none; font - size : 9pt}
A
: hover {text - decoration : underline;color : red}
body
, table {font - size :  9pt}
tr
, td{font - size : 9pt}
-->
</ style >
< title > 注册会员列表  -  读取mysql的测试 </ title >
</ HEAD >
< body alink = " #FF0000 "  link = " #000099 "  vlink = " #CC6600 "  topmargin = " 8 "  leftmargin = " 0 "  bgColor = " #FFFFFF " >
< br >< br >< center >< font color = green size = 3 >< b > 注 册 会 员 列 表 </ b ></ font ></ center >
< br >
< table cellspacing = 0  bordercolordark = # FFFFFF width="95%" bordercolorlight=#000000 border=1 align="center" cellpadding="2">
< tr bgcolor = " #6b8ba8 "  style = " color:FFFFFF " >
    
< td width = " 5% "  align = " center "  valign = " bottom "  height = " 19 " > ID </ td >
    
< td width = " 10% "  align = " center "  valign = " bottom " > 姓名 </ td >
    
< td width = " 5% "  align = " center "  valign = " bottom " > 性别 </ td >
    
< td width = " 5% "  align = " center "  valign = " bottom " > 年龄 </ td >
    
< td width = " 20% "  align = " center "  valign = " bottom " > 联系电话 </ td >
    
< td width = " 20% "  align = " center "  valign = " bottom " > 电子邮件 </ td >
    
< td width = " 20% "  align = " center "  valign = " bottom " > 家庭住址 </ td >
</ tr >
<?
    
// 连接到本地mysql数据库
     $myconn = mysql_connect ( " localhost " , " root " , " root " );
    
// 选择test为操作库
     mysql_query ( " set names 'gbk' " );  //  //这就是指定数据库字符集,一般放在连接数据库后面就系了
     mysql_select_db ( " test " , $myconn );
    
$strSql = " select * from user " ;
    
// 用mysql_query函数从user表里读取数据
     $result = mysql_query ( $strSql , $myconn );
    
while ( $row = mysql_fetch_array ( $result )) // 通过循环读取数据内容
    {
?>
< tr >
    
< td align = " center "  height = " 19 " ><? echo   $row [ " id " ] ?></ td >
    
< td align = " center " ><? echo   $row [ " userid " ] ?></ td >
    
< td align = " center " ><? echo   $row [ " sex " ] ?></ td >
    
< td align = " center " ><? echo   $row [ " age " ] ?></ td >
    
< td align = " center " ><? echo   $row [ " tel " ] ?></ td >
    
< td align = " center " ><? echo   $row [ " email " ] ?></ td >
    
< td align = " center " ><? echo   $row [ " address " ] ?></ td >
</ tr >
<?
    }
    
// 关闭对数据库的连接
     mysql_close ( $myconn );
?>
</ table >
</ BODY >
</ HTML >

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值