class
mysql{
private
$db_name
;
private
$db_host
;
private
$db_user
;
private
$db_pwd
;
private
$conn
;
private
$querysql
;
private
$result
;
private
$resultarray
=
array
();
private
$row
;
function
__counstruct(
$dbname
,
$dbhost
,
$dbuser
,
$dbpwd
){
$this
->db_name=
$dbname
;
$this
->db_host=
$dbhost
;
$this
->db_pwd=
$dbpwd
;
$this
->db_user=
$dbuser
;
$this
->dbconnect();
$this
->selectdb();
}
private
function
db_connect(){
$this
->conn=mysql_connect(
$this
->db_host,
$this
->db_user,
$this
->db_pwd)
or
die
(
"Could not Connect MySql Server"
);
}
private
function
selectdb(){
mysql_select_db(
$this
->db_name)
or
die
(
"unable to select dbname"
)
}
private
function
query(){
return
$this
->result=mysql_query(
$this
->querysql);
}
private
function
get_result(
$sql
){
$this
->querysql=
$sql
;
$this
->query();
if
(
$this
->get_num()>0){
while
(
$this
->rows=mysql_fetch_array(
$this
->result)){
$this
->resultarray[]=
$this
->rows
}
return
$this
->resultarray;
}
}
private
function
get_num(){
return
$this
->num=mysql_num_rows(
$this
->result);
}
}
$m
=
new
mysql(
"testuser"
,
"localhost"
,
"root"
,
"root"
);
$arreresult
=
$m
->get_result(
"select * from userinfo"
);