[作品]第一个PHP程序
Submitted by Zhiqin on 2009, June 8, 8:46 AM<br /> 其实这不能说是第一个PHP程序,只能说是像点样子的PHP.可以作为计数器来使用,但是不具备防灌水功能,刷新一下,数据库就会新增一个"1",然后查询数据库,输出.<br />PHP代码<? //-----------------------------------添加数据库------------------------------------------------------- $mysql_server_name="localhost"; $mysql_username="root"; $mysql_password="admin"; $mysql_database="a"; $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); $sql="INSERT INTO `a`.`count` (`new` )VALUES ('1')"; mysql_select_db($mysql_database,$conn); $result=mysql_query($sql); mysql_close($conn); //----------------------------------查询数据库库-------------------------------------------- $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); $sql="SELECT COUNT(*)FROM `count`"; //COUNT(*)统计字段 //SELECT SUM(new) FROM count 无`` mysql_select_db($mysql_database,$conn);//连接数据库服务器后要选择一个数据库，才能执行查询 $result=mysql_db_query($mysql_database,$sql,$conn); $row=mysql_fetch_row($result); //print_r($row); mysql_free_result($result); ?> <title> <? echo '目前有'.$row.'人访问'; ?> </title> <br /><br /><br /><blockquote class="blockquote">From: http://www.niaoz.com/read-htm-tid-510.htmlPowered by PHPWind.com</blockquote>
页:
[1]