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 " > ＩＤ </ 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 >