; } echo ; echo nums= . $dd->fetchrownums($handle); ?> php class lampdb { private $conn; //连接数据库 function __construct($host,$user,$pass,$dbname,$charset) { $this->conn = mysql_connect($host,$user,$pass); mysql_query('set names $charset'); $db = mysql_select_db($dbname,$this->conn); } //查询语句 function query($sql) { $handle = mysql_query($sql,$this->conn); return $handle; } //查询一条记录 function fetchonerow($handle) { $aa = mysql_fetch_assoc($handle); return $aa; } //查询多条记录 function fetchrows($handle,$i=0) { while($bb = mysql_fetch_assoc($handle)){ $bbb[$i] = $bb; $i++; } return $bbb; } //获取一个查询语句返回的记录数 function fetchrownums($handle) { //$handle = $this->query($sql); $num = mysql_num_rows($handle); return $num; } } ?>
