<?php print("<html><head><meta http-equiv='Content-Type' content='text/html; charset=utf-8'/>/n"); print("<title>员工信息查询</title></head>/n"); print("<body>"); print("<font size=4 color='ff0000'>查询结果</font>"); //hostname:port ,username,password $comm=mysql_connect("localhost:3306","root","111111"); //连接数据库,test为数据库名 mysql_select_db("test",$comm); //设置字符集,使查询结果不为乱码 mysql_query("SET NAMES 'UTF8'"); //mysql_query("SET CHARACTER SET UTF8"); //mysql_query("SET CHARACTER_SET_RESULTS=UTF8'"); //查询sql语句 $str="select company_code,company_name,fax,address,manager_mail From company Where status=1 order by company_code"; //查询结果 $result=mysql_query($str,$comm); print("<table align=center border='1'>"); print("<tr bgcolor='#dffdff'><td>companyCode</td><td>companyName</td><td>fax</td><td>address</td><td>email</td></tr>"); //查询结果处理 while($sqlrow=mysql_fetch_row($result)) { print("<tr><td>"); echo $sqlrow[0]; //打印查询结果 print("</td><td>"); echo $sqlrow[1]; print("</td><td>"); echo $sqlrow[2]; print("</td><td>"); echo $sqlrow[3]; print("</td><td>"); echo $sqlrow[4]; print("</td></tr>"); } print ( "</table></body></html>"); ?>