初学 php 连接mysql数据库

来源：互联网发布：淘宝网美容泛石刮沙板编辑：程序博客网时间：2024/04/30 20:28

<?phpprint("<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>");?>