< ? Class MySQL { var $host ; var $user ; var $passwd ; var $database ; |
function MySQL() |
//利用构造函数实现变量初始化 |
{ $host = "" ; |
$user = "" ; |
$passwd = "" ; |
$database = "" ; |
} |
function Connect() |
{ $conn = MySQL_connect( $this ->host, $this ->user, $this ->passwd) |
or die ( "Could not connect to $this->host" ); |
MySQL_select_db( $this ->database, $conn ) or die ( "Could not switch to database $this->database;" ); |
return $conn ; |
} |
function Close( $conn ) { |
MySQL_close( $conn ); |
} |
function Query( $queryStr , $conn ) |
{ |
$res =MySQL_query( $queryStr , $conn ) or die ( "Could not query database" ); |
return $res ; |
} |
function getRows( $res ) |
{ |
$rowno = 0; |
$rowno = MySQL_num_rows( $res ); |
if ( $rowno >0) |
{ |
for ( $row =0; $row < $rowno ; $row ++) |
{ |
$rows [ $row ]=MySQL_fetch_row( $res ); |
} |
return $rows ; |
} |
} |
function getRowsNum( $res ) |
{ |
$rowno = 0; |
$rowno = mysql_num_rows( $res ); return $rowno ; |
} } ? > |