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>";
      }
       
      ?>