Need mysql->http(s) module under apache. Where to find?

Question

MySQL

I am looking for a module for the Apache web server to make direct queries to the mysql database from the front via ajax/fetch WITHOUT INTERMEDIARIES!
Let me know if anyone has found it.
Thanks in advance!

Answer 1

mod_dbd + mod_rewrite

<VirtualHost *:80>
        DBDriver mysql
        DBDParams "dbname=test user=root pass=xxxxxx"

        RewriteMap user2id "dbd:select id from users where name = %s "

        RewriteEngine On

        RewriteRule ^/user2id/([^/]+) http://domain.com/id/${user2id:$1} [R,L]

Answer 2

what happens if someone adds to the request. Maybe that's why it's better to use php

Answer 3

If you had written the task in more detail, then you would have been answered in more detail, however, based on
something like this, probably.
at the moment there is the most standard way is to use PHP
it is the most reasonable and easiest, there is no need to turn the wheel for this.
Please describe the task in more detail and why it is impossible to use the usual methods and look for the mythical module on Apache?