01.
<?php
02.
class
database
03.
{
04.
var
$host
=
"..."
;
05.
var
$user
=
"..."
;
06.
var
$pass
=
"..."
;
07.
var
$db
=
"..."
;
08.
var
$con
;
09.
10.
function
con_db()
11.
{
12.
$this
->con = mysql_connect(
$this
->host,
$this
->user,
$this
->pass)
or
die
(
"Error : ไม่สามารถเชื่อมต่อฐานข้อมูลได้"
);
13.
mysql_select_db(
$this
->db,
$this
->con)
or
die
(
"Error : ไม่สามารถเลือกฐานข้อมูลได้"
);
14.
}
15.
16.
function
sql_cmd(
$sqlCmd
)
17.
{
18.
mysql_query(
"set character_set_results='utf8'"
);
19.
mysql_query(
"set character_set_client='utf8'"
);
20.
mysql_query(
"set character_set_connection='utf8'"
);
21.
return
$result
= mysql_query(
$sqlCmd
,
$this
->con)
or
die
(
"Error : เกิดข้อผิดพลาด"
);
22.
}
23.
24.
function
sql_cmd_select(
$sqlCmd
)
25.
{
26.
mysql_query(
"set character_set_results='utf8'"
);
27.
mysql_query(
"set character_set_client='utf8'"
);
28.
mysql_query(
"set character_set_connection='utf8'"
);
29.
$result
= mysql_query(
$sqlCmd
,
$this
->con)
or
die
(
"Error : เกิดข้อผิดพลาด ไม่เจอข้อมูลที่ต้องการ"
);
30.
$rs
= mysql_fetch_array(
$result
);
31.
return
$rs
;
32.
}
33.
34.
function
close_db()
35.
{
36.
mysql_close(
$this
->con);
37.
}
38.
39.
function
get_count(
$table
)
40.
{
41.
$this
->con_db();
42.
$count
=
$this
->sql_cmd_select(
"select count(*) from "
.
$table
);
43.
return
$count
[0];
44.
$this
->close_db();
45.
}
46.
47.
function
get_pk(
$count
,
$key
)
48.
{
49.
if
(
$count
<=9)
50.
{
51.
return
$key
.
"00"
.
$count
;
52.
}
53.
else
if
(
$count
<=99)
54.
{
55.
return
$key
.
"0"
.
$count
;
56.
}
57.
else
58.
{
59.
return
$key
.
$count
;
60.
}
61.
}
62.
}
63.
?>