| <!-- MVP.css quickstart template: https://github.com/andybrewer/mvp/ --> | |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <link rel="icon" href="https://via.placeholder.com/70x70"> | |
| <link rel="stylesheet" href="https://unpkg.com/mvp.css"> | |
| <meta charset="utf-8"> |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <title>Demo drag & drop over PDF</title> | |
| <script src="https://unpkg.com/interactjs/dist/interact.min.js"></script> | |
| </head> | |
| <body> | |
| <main style="margin:auto;padding:1rem;min-width:600px;max-width:1000px;background:grey"> | |
| <h1>test pdf pdf</h1> |
I've encoutered the needs for this technique multiple times. Mostly when the data is generated from other applications, and my only access to the database is via web-based SQL interface such as Adminer or PHPMyAdmin. It seems that currently there are no comprehensive article outlining how to achieve this. So I'll just write my findings here.
as this version doesn't support VALUES clause yet, our only choice is to use the ugly CASE-WHEN syntax:
Last week at my dayjob, I was exploring options for implementing a proxy endpoint for one our external service. One of the stack used in our application is Laravel, so naturally I investigated how to implement a proxy endpoint using it. Turns out its pretty simple a Laravel already included most of the stuff required to built it. This approach should be suitable for many simple use case to avoid overhead of adding new dedicated proxy service such as a full blown API gateway like Traefik or Kong, or if you need custom logic which may be hard to achieve using on-the-shelf solutions.
When building application using microservice/service oriented architecture, its common to require connection to external services. This services may be some vendor API such as email provider, payment gateway, or simply internal service that one way or another happen to be in a different networks. Some common use cases:
| <?php | |
| /* | |
| PHP PDO is mostly based on tutorials in https://phpdelusions.net/pdo. | |
| */ | |
| // connection configs | |
| $DB_TYPE = getenv('DB_TYPE'); | |
| $DB_HOST = getenv('DB_HOST'); | |
| $DB_USER = getenv('DB_USER'); | |
| $DB_PASS = getenv('DB_PASS'); |
| # this base image already contains webserver & php runtime | |
| FROM php:8.1-apache | |
| # setup composer & php extension installer | |
| COPY --from=composer:latest /usr/bin/composer /usr/bin/composer | |
| COPY --from=mlocati/php-extension-installer /usr/bin/install-php-extensions /usr/bin/ | |
| # install your PHP extension here | |
| RUN install-php-extensions zip pdo_pgsql |
What need to be configured:
config/database.php:
redis_url -> could also be setup using env var REDIS_URLconfig/session.php:
driver -> set to redis. or use env var SESSION_DRIVERconnection -> set to default. or use env var SESSION_CONNECTION
| <?php | |
| namespace App\Http\Controllers; | |
| use App\Models\User; | |
| use Illuminate\Support\Facades\Auth; | |
| use Laravel\Socialite\Facades\Socialite; | |
| class AuthController extends Controller |
| #!/bin.sh | |
| # keycloak-setup.sh | |
| # Adapted from : https://keycloak.ch/keycloak-tutorials/tutorial-1-installing-and-running-keycloak/ | |
| # basic variables. edit as needed | |
| KCADM="/opt/keycloak/bin/kcadm.sh" | |
| REALM_NAME=test_realm | |
| CLIENT_ID=test_client | |
| USER_NAME=username | |
| USER_PASSWORD=password |
| # docker-compose.yml | |
| services: | |
| keycloak: | |
| image: quay.io/keycloak/keycloak:17.0 | |
| ports: | |
| - 8080:8080 | |
| command: start-dev | |
| volumes: | |
| - .:/app |