01.
<?php
02.
03.
$con
= mysqli_connect(
"$serverName"
,
"$userName"
,
"$userPassword"
,
"$dbName"
);
04.
$con
->set_charset(
"utf8"
);
05.
?>
06.
<select name=
"province"
id=
"province"
>
07.
<?php
08.
$q
=
"select * from province"
;
09.
$qr
=mysqli_query(
$con
,
$q
);
10.
while
(
$rs
=mysqli_fetch_array(
$qr
)){
11.
?>
12.
<option value=
"<?=$rs['id_province'];?>"
><?=
$rs
[
'name_province'
];?></option>
13.
<?php } ?>
14.
</select>