Debian服务器设置入门教程之一

<?php      $dbname='mytest';      $tablename='user';      $page=0;      $rowperpage=20;            mysql_connect("localhost", "root", "您的密码");            //下面这个viewData函数，是自己编的，用来显示数据      //从某种程度上讲，本程序起关键作用的就这么一句：      viewData($dbname,$tablename,$page,$rowperpage);                  ////////////////////////////////////////////////      //      // 往下仅仅是定义了两个函数而已，你可以不去看他      //      ////////////////////////////////////////////////                  //定义一个函数，用来返回查询状态      function echoQueryResult() {	global $queryStr, $errMsg;                     	if( $errMsg == "" ) $errMsg = "成功";	if( $queryStr != "" ) {     		echo "<table cellpadding=5>";		echo "<tr><td>查询:</td><td>$queryStr</td></tr>";		echo "<tr><td>结果:</td><td>$errMsg</td></tr>";		echo "</table><p>";	}      }         //定义一个函数，用来显示数据      function viewData($dbname,$tablename,$page,$rowperpage) {	global $mysqlHandle, $PHP_SELF, $errMsg,  $orderby;                     	echo "<h2>下面是您所查的数据：</h2>";      	$queryStr = stripslashes( $queryStr );	if( $queryStr == "" ) {		$queryStr = "SELECT * FROM $tablename";		if( $orderby != "" )			$queryStr .= " ORDER BY $orderby";	}      	$pResult = mysql_db_query( $dbname, $queryStr ); 	$errMsg = mysql_error();      	$GLOBALS[queryStr] = $queryStr;        	if( $pResult == false ) {		echoQueryResult();		return;	}	if( $pResult == 1 ) {		$errMsg = "成功";		echoQueryResult();		return;	}      	echo "<hr>";      	$row = mysql_num_rows( $pResult );	$col = mysql_num_fields( $pResult );      	if( $row == 0 ) {		echo "没有数据！表格是空的。";		return;	}      	if( $rowperpage == "" ) $rowperpage = 20;	if( $page == "" ) $page = 0;	else $page--;	mysql_data_seek( $pResult, $page * $rowperpage );      	echo "<table cellspacing=1 cellpadding=2>";	echo "<tr>";		echo '<th bgcolor="#FFCC66">';		echo "用户名";		echo "</th>";		echo '<th bgcolor="#FFCC66">';		echo "口令";		echo "</th>";		echo '<th bgcolor="#FFCC66">';		echo "出生日期";		echo "</th>";		echo '<th bgcolor="#FFCC66">';		echo "是否激活";		echo "</th>";	echo "</tr>";              	for( $i = 0; $i < $rowperpage; $i++ ) {		$rowArray = mysql_fetch_row( $pResult );		if( $rowArray == false ) break;		echo "<tr>";		$key = "";		for( $j = 0; $j < $col; $j++ ) {			$data = $rowArray[$j];      			$field = mysql_fetch_field( $pResult, $j );			if( $field->primary_key == 1 )				$key .= "&" . $field->name . "=" . $data;      			if( strlen( $data ) > 30 )				$data = substr( $data, 0, 30 ) . "...";			$data = htmlspecialchars( $data );			echo '<td bgcolor="#99CCCC">';			echo "$data";			echo "</td>";		}      		echo "</tr>";	}	echo "</table>";	echo "<hr>";      //$PHP_SELF      	echo "<font size=2>";	echo "<form action='$PHP_SELF?action=viewData&dbname=$dbname&	       tablename=$tablename&page=$page&rowperpage=$rowperpage'	        method=post>";	echo "<font color=green>";	echo "第".($page+1)."页/共".(int)($row/$rowperpage+1)."页";	echo "</font>";	echo " | ";	if( $page > 0 ) {		echo "<a href='$PHP_SELF?action=viewData&dbname=$dbname&		        tablename=$tablename&page=".($page).		        '&rowperpage='.$rowperpage;		if( $orderby != "" )			echo "&orderby=$orderby";		echo "'>上一页</a>";	} else		echo "上一页";	echo " | ";	if( $page < ($row/$rowperpage)-1 ) {		echo "<a href='$PHP_SELF?action=viewData&dbname=$dbname&		    tablename=$tablename&page=".($page+2).		    '&rowperpage='.$rowperpage;		if( $orderby != "" )			echo "&orderby=$orderby";		echo "'>下一页</a>";	} else		echo "下一页";	echo " | ";	if( $row > $rowperpage ) {		echo "<input type=submit value='跳到第'>";		echo "<input type=text size=4 name=page>页";	}	echo "</form>";            	echo "<form action='$PHP_SELF?action=viewData&dbname=$dbname&	           tablename=$tablename&page=$page&rowperpage=$rowperpage'	           method=post>"; 		echo "	目前每页显示记录数为".$rowperpage."条，您可以";		echo "<input type=submit value='改为'>";		echo "<input type=text size=4 name=rowperpage>条/页";      	echo "</form>";	echo "</font>";      }             ?>