<?php

class DatabaseConnection {

private $host = "localhost";

private $db_name = "hc_smart_school"; //ชื่อฐานข้อมูล

private $username = "root"; //username ของ database

private $password = "root1234"; // รหัสผ่านของ database

public $conn;

public function getConnection(){

$this->conn = null;

try {

$this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);

$this->conn->exec("set names utf8");

}catch(PDOException $exception){

echo "Connection error: " . $exception->getMessage();

}

return $this->conn;

}

}

?>

<?php

class HCExec {

private $conn;

public function __construct($db){

$this->conn = $db;

}

public function dataTransection( $query ){

try {

$stmt = $this->conn->prepare( $query );

if($stmt->execute()){

return 1;

} else {

return 0;

}

} catch (PDOException $e) {

return false;

}

}

public function read( $query ){

try {

$stmt = $this->conn->prepare( $query );

if($stmt->execute()){

return $stmt;

}

} catch (PDOException $e) {

return false;

}

}

}

?>

<?php

date_default_timezone_set("Asia/Bangkok");

header("Access-Control-Allow-Origin: *");

header("Content-Type: application/json; charset=UTF-8");

header("Access-Control-Allow-Methods: GET, POST, PATCH, PUT, DELETE, OPTIONS");

header("Access-Control-Allow-Max-Age: 3600");

header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");

include "../config/DbConnect.php";

include "../config/HCExec.php";

$db = new DatabaseConnection();

$strConn = $db->getConnection();

$strExe = new HCExec($strConn);

$sql = " SELECT * FROM student ";

$stmt = $strExe->read($sql);

$rowCount = $stmt->rowCount();

if ($rowCount > 0) {

$data_arr['rs'] = array();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

extract($row);

array_push($data_arr["rs"], $row);

}

echo json_encode($data_arr);

} else {

echo json_encode(array("message" => "No data found","row"=> $rowCount));

}

?>