mysql_test.php

test.php

<?php


$conn = mysqli_connect('localhost', 'root', '12345678', 'test');
mysqli_set_charset($conn, 'utf8');

$result = mysqli_query($conn, 'SELECT * FROM province;');

if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo $row['PROVINCE_NAME'].'<br>';
    }
}