PHP PDO

// Database credential
$dsn      = 'mysql:dbname=XXXX;host=127.0.0.1;port:3306';
$username = 'XXX';
$password = 'XXX';

// Create connection
$conn = new PDO($dsn, $username, $password);
$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

// SQL
$table_name = 'table1';
$stmt = $conn->prepare(sprintf('SELECT id, name FROM %s',$table_name));
$stmt->execute();

// Get results
$results = [];
while($row = $stmt->fetch(\PDO::FETCH_OBJ)) {
    $result = new stdClass();
    $result->id = $row->id;
    $result->name = $row->name;
    $results[] = $result;
}

// Return results as json
echo json_encode($results);