// $servername = "localhost";
// $username = "aromaco1_wp345";
// $password = "F)N16(pSc1";
// $dbname = "aromaco1_wp345";
/** Create connection */
//$con= mysqli_connect("localhost","aromaco1_wp345","F)N16(pSc1","aromaco1_wp345") or die("Error: " . mysqli_error($con));
//mysqli_query($con, "SET NAMES "utf8" ");
// $conn = new mysqli($servername, $username, $password, $dbname);
// if ($conn->connect_error){
// die("connection failed: " .$conn->conection_error)
// }
$sql = "SELECT FROM member";
$result = $conn->query($sql);
//=========== End
// Display data in an HTML table
if ($result->num_rows >0){
echo
"
| ชื่อ-สกุล สมาชิก (ภาษาไทย) |
ชื่อ-สกุล สมาชิก (ภาษาอังกฤษ) |
เบอร์โทรศัพท์ |
วันที่สมัคร |
";
while ($row = $result->fetch_assoc()){
echo "
| " .$row["name_mb"] . " |
" .$row["name_eng"] . " |
" .$row["phone_mb"] . " |
" .$row["date_mb"] . " |
";
}
echo "
";
} else {
echo "0 results";
}
//==============================================================================
