01.
$servername
=
"localhost"
;
02.
$username
=
"username"
;
03.
$password
=
"password"
;
04.
$dbname
=
"database"
;
05.
06.
07.
$conn
=
new
mysqli(
$servername
,
$username
,
$password
,
$dbname
);
08.
09.
if
(
$conn
->connect_error) {
10.
die
(
"Connection failed: "
.
$conn
->connect_error);
11.
}
12.
13.
$sql
=
"SELECT ชื่อ FROM database"
;
14.
$result
=
$conn
->query(
$sql
);
15.
16.
if
(
$result
->num_rows > 0) {
17.
18.
while
(
$row
=
$result
->fetch_assoc()) {
19.
echo
"ชื่อ: "
.
$row
[
"ชื่อ"
].
"<br>"
;
20.
}
21.
}
else
{
22.
echo
"0 results"
;
23.
}
24.
$conn
->close();